New Year Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. SAS Institute
  3. Data Integration Developer
  4. A00-260 - SAS Data Integration Development

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

Page: 1 / 7
Total 70 questions
Get A00-260 Full Access Download A00-260 PDF

SAS Data Integration Development Questions and Answers

Question 1

Which statement defines the characteristics of a SAS Stored Process?

Options:

A.

SAS metadata that describes how to collect and store data sources.

B.

A document that stores the steps and locations for building a data mart.

C.

A SAS program that is stored on the server and described by metadata.

D.

A user written SAS PROC step.

Question 2

Within SAS Data Integration Studio's SQL Join transformation, the Validate Expression button is located in:

Options:

A.

a Where clause definition

B.

an Expression Builder window

C.

a field Expression definition

D.

a Subquery definition

Question 3

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

Options:

A.

metadata objects across metadata servers

B.

metadata objects within a logged on user's personal folder

C.

metadata objects within a metadata server

D.

metadata objects within a logged on user's Checkouts Tree

Question 4

Which action is required for enabling performance statistics on the executing SAS Workspace Server?

Options:

A.

Define a logfile for output.

B.

Define Collect Diagnostics for the SAS Data Integration Studio job.

C.

Define Collect Runtime statistics for the SAS Data Integration Studio job.

D.

Enable the logging facility of the SAS Workspace Server.

Question 5

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

Options:

A.

Loads source table records into a standardization table.

B.

Loads dimension table records into a fact table.

C.

Loads source table records into a dimension table.

D.

Loads fact table records into a multi-threaded table.

Question 6

Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to its options?

Options:

A.

SAS macro variables

B.

columns of SAS datasets

C.

SAS formats

D.

SAS macro calls

Question 7

In SAS Data Integration Studio, surrogate and retained key values are:

Options:

A.

generated by the Lookup transformation

B.

copied from source tables into dimension tables

C.

generated by the SCD Type 2 Loader transformation

D.

copied from dimension tables into source tables

Question 8

How can you test the interaction of the options of a SAS Data Integration Studio Generated transformation?

Options:

A.

The transformation has to be used within a job to interactively test the options with the Test Prompt button

in the Options window from the properties of the transformation within the job editor.

B.

The options can be tested after finalizing and saving the transformation with the Test Prompt item on the

Tools menu.

C.

The options can be tested only after adding all options that are assigned to the source code with the Test

Prompt button in the Options window of the New Transformation wizard.

D.

The options can be tested at any time after adding them to the transformation with the Test Prompt button in

the Options window of the New Transformation wizard.

Question 9

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?

Options:

A.

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

B.

From the source table, matching rows AND new rows are added, but the original matching row in the target table

is marked as inactive.

C.

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

D.

A or C, depending on further options chosen.

Question 10

Within SAS Data Integration Studio, which type of expression can be created using the Expression Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression 2) an SQL expression 3) an XML expression 4) a constant

Options:

A.

1 and 2 only

B.

1 and 3 only

C.

1, 2 and 4 only

D.

1, 2, 3, and 4

Load More A00-260 Questions 
Page: 1 / 7
Total 70 questions
Get A00-260 Full Access Download A00-260 PDF