SAS A00-260 Exam Practice Test Instant Access

Question 1

The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?

ALoads source table records into a standardization table.

BLoads dimension table records into a fact table.

CLoads source table records into a dimension table.

DLoads fact table records into a multi-threaded table.

Answer : C

Question 2

The SAS Data Integration Studio SCD Type 2 Loader transformation can do which of the following?

Agenerate cpu statistics

Bgenerate a datetime value

Cgenerates cluster numbers

Dgenerates standardization values

Answer : B

Question 3

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 4

Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding theAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding the relationship between the source table and the target table?

AFrom the source table, matching rows are updated in the target table and new rows are added.

BFrom the source table, matching rows AND new rows are added, but the original matching row in the target table is marked as inactive.

CFrom the source table, matching rows are skipped, and new rows are added.

DA or C, depending on further options chosen.

Answer : D

Question 5

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

Within SAS Data Integration Studio, which one of the following is NOT an option available from the File-> New menu choice under External File grouping?

ADelimited

BFixed Width

CUser Written

DCOBOL Copybook

Answer : D

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