SAS A00-260 Exam Practice Test Instant Access

Question 1

Which action is performed by the Lookup transformation in SAS Data Integration Studio?

Acombines rows from multiple tables into a single row

Bcombines rows from multiple tables into multiple rows

Cvalidates that values are unique

Dvalidates that values are not null

Answer : A

Question 2

In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?

AData Validation

BLookup

CDataFlux lS Job

DTable Loader

Answer : B

Question 3

Consider the job flow diagram in the display. Which of these objects has parameters defined for it?

AControl table

BLoop transformation

Clnner Job

DLoop End

Answer : C

Question 4

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

Agenerate cpu statistics

Bgenerate a datetime value

Cgenerates cluster numbers

Dgenerates standardization values

Answer : B

Question 5

Which statement defines the characteristics of a SAS Stored Process?

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

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

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

DA user written SAS PROC step.

Answer : C

Question 6

You want to create a job that checks conditions for your data before that data is loaded into a data warehouse. The job should be able to detect error conditions such as missing data or duplicate data and take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio transformation should you use?

AData Transfer

BData Validation

CData Quality

DData Extract

Answer : B

Question 7

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

Aa Web service

Ba SAS Stored Process

Ca Java Runtime Process

Da SAS Information Map that is accessible in SAS Web Report Studio

Answer : B, D

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