SAS A00-260 Exam Questions Instant Access

Question 1

In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?

AData Validation

BLookup

CDataFlux lS Job

DTable Loader

Answer : B

Question 2

Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata definitions for two simple indexes. Which of the following is NOT a valid location for viewing which columns are indexed?

Athe Load Technique tab in the Table Loader transformation properties window

Bthe Indexes tab in the table properties window

Cthe Columns tab in the table properties window

Dthe Columns tab in the Details panel of the open job, with the table selected in the job flow

Answer : A

Question 3

A fact table is populated by using which transformation in SAS Data Integration Studio?

ASCDType2 Loader

BData Validation

CLookup

DDataFlux lS Job

Answer : C

Question 4

In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain which type of values?

Adatetime values

Balpha-numeric values

Cbinary values

Dinteger values

Answer : D

Question 5

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

ADefine a logfile for output.

BDefine Collect Diagnostics for the SAS Data Integration Studio job.

CDefine Collect Runtime statistics for the SAS Data Integration Studio job.

DEnable the logging facility of the SAS Workspace Server.

Answer : D

Question 6

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?

AData Transfer

BData Validation

CData Quality

DData Extract

Answer : B

Question 7

Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE?

AThe Inner Job can be successfully executed by itself, but only if the defined parameter has been assigned a valid default value.

BThe Inner Job cannot be successfully executed by itself unless it is disassociated from the loop job.

CThe Control Table column is mapped to the parameter defined for the Inner Job using the Loop transformation properties window.

DIf the server that executes the job has multiple CPUs, parallel processing can be enabled in the Loop transformation properties window.

Answer : B

SAS Certified Data Integration Developer for SAS A00-260 Exam Questions