SAS A00-260 Exam Practice Test Instant Access

Question 1

How do you enable performance statistics for a SAS Data Integration Studio job?

ADefine Collect Runtime Statistics on the SAS Data Integration Studio job.

BDefine Collect Table Statistics on the SAS Data Integration Studio job.

CDefine Collect Diagnostics on the SAS Data Integration Studio job.

DDefine Collect Table Statistics on the SAS Data Integration Studio options.

Answer : A

Question 2

In SAS Data Integration Studio, where must the columns included in a business key exist?

Ain the source and standardization tables

Bin the source and dimension tables

Cin the target and fact tables

Din the source, dimension and standardization tables

Answer : B

Question 3

Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?

AThe physical table(s) selected are copied to the application server specified in the library.

BThe physical table(s) selected are copied to the SAS Folders location specified in the wizard.

CMetadata for the physical table(s) selected is stored on the application server specified in the library.

DMetadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.

Answer : D

Question 4

Registering metadata for an ODBC data source involves registering:

Aa library that will use a SASIACCESS engine to a specific database

Bonly an ODBC data source definition

Ca server definition that points to the ODBC data source and a library accessing this server definition

Da table pointing directly to the ODBC data source

Answer : C

Question 5

When using the Table Loader transformation to load an existing target table that contains one or more indexes in SAS Data Integration Studio, which statement is true?

AIndexes are removed when the Table Loader executes and must be re-created using the Table Structure transformation.

BIndexes are automatically preserved when the Table Loader executes.

CIndexes are removed at the beginning of the load process and must be re-created in a subsequent job step.

DIndexes can be removed or preserved at the beginning of the process depending on options chosen. Additional table loader options specify whether to re-create the index at the end of the process.

Answer : D

Question 6

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

Athe old record is deleted and the changed record is added

Bthe old record is updated with the new values from the changed record

Cthe old record is flagged and the changed record is added

Dthe old record is merged with the changed record

Answer : C

Question 7

Which statement best describes the DataFlux Integration Server?

AAn application server that executes service requests based on Simple Object Access Protocol (SOAP) to call dfPower Architect or dfPower Profile jobs.

BA plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing operations.

CAn application interlace that allows you to build dfPower Architect and dfPower Profile jobs specialized for data cleansing operations.

DA 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.

Answer : A

SAS A00-260 SAS Certified Data Integration Developer for SAS Exam Practice Test