SAS A00-260 Exam Practice Test Instant Access

Question 1

The purpose of change management in SAS Data Integration Studio is to manage:

Ametadata objects across metadata servers

Bmetadata objects within a logged on user's personal folder

Cmetadata objects within a metadata server

Dmetadata objects within a logged on user's Checkouts Tree

Answer : C

Question 2

After creating a stored process from a SAS Data Integration Studio job, how can you test the stored process to make sure it runs correctly?

AExecute the stored process in SAS Data Integration Studio.

BExecute the stored process in SAS Management Console.

CExecute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.

DExecute the stored process using SAS Display Manager's Stored Process Test window.

Answer : C

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

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 5

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

Question 6

The SAS Platform application that can surface the different types of business and analytic content such as information maps, stored processes, and reports on the web browser is:

ASAS Information Delivery Portal

BSAS Information Map Studio

CSAS Web Report Studio

DSAS OLAP Cube Studio

Answer : A

Question 7

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

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