SAS Data Integration Development (A00-260) Free Practice Test

Question 1

Which of the following are SAS Data Integration Studio job deployment types? (Choose two.)

A. a Web service

B. a Java Runtime Process

C. a SAS Stored Process

D. a SAS Information Map that is accessible in SAS Web Report Studio

Correct Answer: C,D

Question 2

In order to use the SAS Data Integration Studio's Apply Lookup Standardization transformation, Data Quality options must be setup. Select the valid Scheme Repository Types. (Choose two.)

A. Power scheme that is generated by Data Flux.

B. A comma delimited flat file that contains the field names in the first row.

C. A third party RDBMS table that has been generated by the SAS system.

D. A SAS table scheme that is generated by SAS.

Correct Answer: B,D

Question 3

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 merged with the changed record

B. the old record is deleted and the changed record is added

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

D. the old record is flagged and the changed record is added

Correct Answer: D

Question 4

In SAS Data Integration Studio, an index can be specified/defined in which location?

A. the Indexes tab in the properties of a Table Loader transformation

B. the Indexes tab in the properties of a table metadata object

C. the Indexes tab in the properties for any transformation

D. the Indexes tab in the properties of a job metadata object

Correct Answer: B

Question 5

The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored Process requires additional set up that is performed in which client application?

A. SAS Job Deployment Studio

B. SAS Enterprise Guide

C. SAS Management Console

D. SAS Data Integration Studio

Correct Answer: C

Question 6

A SAS administrator has performed the "Clear Projects" action to remove the lock on a SAS Data Integration Studio job called "Create Tables" that some user has checked out in their project repository. What will be the outcome of this action on the user's project repository?

A. It will become empty and will not be accessible until the administrator grants permissions for it to be used again.

B. It will become empty and all new and checked out metadata objects will revert to the not checked out state.

C. It will become empty and the DI job called "Create Tables" will no longer be in a checked out state.

D. It will only contain the new metadata objects. All checked out metadata objects will revert to the not checked out state.

Correct Answer: C

Question 7

Which statement is FALSE regarding foreign keys?

A. A table can have zero or more foreign keys.

B. A table can have only one foreign key defined.

C. A foreign key cannot exist without an associated primary or unique key.

D. A foreign key is one or more columns that are associated with a primary key or unique key in another table.

Correct Answer: B

Welcome to TestSimulate

SASInstitute SAS Data Integration Development (A00-260) Free Practice Test