Independence Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

SAS Institute A00-260 SAS Data Integration Development Exam Practice Test

Demo: 10 questions
Total 70 questions

SAS Data Integration Development Questions and Answers

Question 1

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

Options:

A.

datetime values

B.

alpha-numeric values

C.

binary values

D.

integer values

Question 2

Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)

Options:

A.

Create and replace permanent tables.

B.

Maintain access privileges to permanent tables.

C.

Apply and maintain constraints on permanent tables.

D.

Delete and remove permanent tables.

Question 3

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

Options:

A.

in the source and standardization tables

B.

in the source and dimension tables

C.

in the target and fact tables

D.

in the source, dimension and standardization tables

Question 4

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

Options:

A.

the old record is deleted and the changed record is added

B.

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

C.

the old record is flagged and the changed record is added

D.

the old record is merged with the changed record

Question 5

You want to register an external file with the following structure: first line contains Customer First and Last Name second line is address1 third line is address 2 fourth line contains the phone number What action should you take to read this file?

Options:

A.

Use the New User Written External File wizard.

B.

Use the New Fixed Width External File wizard.

C.

Use the New Delimited External File wizard.

D.

Use the New COBOL Copybook wizard.

Question 6

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

Options:

A.

SCD Type 2 Loader

B.

Data Validation

C.

Lookup

D.

DataFlux IS Job

Question 7

In the following display, can status handling be enabled for the Extract transformation?

Options:

A.

No. The Extract transformation does not have a status handling tab in its Properties window, and the Return Code Check transformation can only provide status handling at the job level.

B.

Yes. The Return Code Check transformation can be added to the END of the job flow - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.

C.

No. The Extract transformation does not have a Status Handling tab in its Properties window, therefore it is not possible to establish status handling for this transformation.

D.

Yes. The Return Code Check transformation can be added to the job flow immediately following the Extract - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.

Question 8

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?

Options:

A.

Data Transfer

B.

Data Validation

C.

Data Quality

D.

Data Extract

Question 9

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?

Options:

A.

the Load Technique tab in the Table Loader transformation properties window

B.

the Indexes tab in the table properties window

C.

the Columns tab in the table properties window

D.

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

Question 10

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

Options:

A.

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

B.

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

C.

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

D.

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

Demo: 10 questions
Total 70 questions