New Year Special Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

 
Home > SAS Institute > Data Integration Developer > A00-260

A00-260 SAS Data Integration Development Question and Answers

Question # 4

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

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

Full Access
Question # 5

When using SAS Data Integration Studio's SQL Join transformation, which SQL join type can be constructed as either an implicit or an explicit join?

A.

Union

B.

Full

C.

Inner

D.

Cross

Full Access
Question # 6

Which statement defines the characteristics of a SAS Stored Process?

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.

Full Access
Question # 7

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

A.

SAS macro variables

B.

columns of SAS datasets

C.

SAS formats

D.

SAS macro calls

Full Access
Question # 8

Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regardingAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regarding this load style?

A.

It generates PROC APPEND code.

B.

It generates PROC SQL code.

C.

It generates either PROC SQL code or PROC APPEND code depending on further option choices.

D.

It generates DATA STEP APPEND code.

Full Access
Question # 9

In SAS Data Integration Studio, which output format is supported for the default "out-of-the-box" job report?

A.

HTML

B.

PDF

C.

RTF

D.

XML

Full Access
Question # 10

In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?

A.

find row matches using the business key

B.

find row matches using generated cluster numbers

C.

find non-standard values using a generated key

D.

find non-standard values using a business key

Full Access
Copyright myexamcollection.com. All Right Reserved.