[2026] SASInstitute SAS Data Integration Development

문제1

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

A. SAS formats

B. SAS macro variables

C. SAS macro calls

D. columns of SAS datasets

정답: B

문제2

When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?

A. &target

B. %target

C. syslast

D. &syslast

정답: D

문제3

When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data?

A. business key columns

B. non-key columns

C. generated columns

D. Type 1 columns

정답: B

문제4

Which statements are true regarding columns when using SAS Data Integration Studio's New Tables wizard? 1. You can access metadata for any column from any table already registered in metadata but cannot change it. 2. You can access metadata for any column from any table already registered in metadata and can override the imported information. 3. You can define new columns for the table. 4. You cannot define new columns.

A. 2 and 3

B. 1 and 3

C. 1 and 2

D. 2 and 4

정답: A

문제5

Which statement is true regarding SAS packages created in SAS Data Integration Studio?

A. SAS packages are used to import and export third-party metadata.

B. SAS packages are used to import and export SAS applications.

C. SAS packages are used to import and export SAS metadata.

D. SAS packages are used to import and export stand-alone SAS programs.

정답: C

문제6

Which statement defines the characteristics of a SAS Stored Process?

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

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

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

D. A user written SAS PROC step.

정답: C

문제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?

A. From the source table, matching rows AND new rows are added, but the original matching row in the target table is marked as inactive.

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

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

D. A or C, depending on further options chosen.

정답: D

SASInstitute SAS Data Integration Development - A00-260무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트