Online Access Free A00-260 Exam Questions

When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

• A.the old record is updated with the new values from the changed record
• B.the old record is merged with the changed record
• C.the old record is deleted and the changed record is added
• D.the old record is flagged and the changed record is added

Which statement best describes the DataFlux Integration Server?

• A.An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call dfPower Architect or dfPower Profile jobs.
• B.A third party server defined in the SAS metadata repository that allows you to build flows integrating multiple jobs and establishing job dependencies within the flow.
• C.A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing operations.
• D.An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for data cleansing operations.

Which statement regarding scheduling SAS Data Integration Studio jobs is true?

• A.Multiple job flows can be scheduled to a deployment directory.
• B.To schedule a job flow you must first use SAS Management Console to deploy the job for scheduling.
• C.To schedule a job flow in SAS Management console you must first deploy the job for scheduling using SAS Data Integration Studio.
• D.To schedule the job on the Platform Process Manager you require a dependency generator.

You want to create a job that checks conditions for your data before that data is loaded into a data warehouse. The job should be able to detect error conditions such as missing data or duplicate data and take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio transformation should you use?

• A.Data Validation
• B.Data Extract
• C.Data Transfer
• D.Data Quality

Which action is required for enabling performance statistics on the executing SAS Workspace Server?

• A.Enable the logging facility of the SAS Workspace Server.
• B.Define a logfile for output.
• C.Define Collect Runtime statistics for the SAS Data Integration Studio job.
• D.Define Collect Diagnostics for the SAS Data Integration Studio job.