SAS A00-260 Exam Practice Test Instant Access

Question 1

Within SAS Data Integration Studio, automatic mappings are disabled for a job. A transformation has defined source columns and defined target columns. One of the source columns, named COLI, is character with a length of 50. One of the target columns, named COLI, is also character but of length 25. What will happen if the COLI columns are mapped?

AThe COLI columns are successfully mapped, one-to-one, with no warnings.

BThe COLI columns are not mapped because the lengths are different.

CThe COLI columns are mapped but an expression is defined for the target COLI that uses a generic specification of the LENGTH function.

DThe COLI columns are successfully mapped, one-to-one, but a warning occurs.

Answer : D

Question 2

Which batch server is queried to retrieve the command needed to run traditional .SAS programs having DATA and PROC steps?

ASAS Java Batch Server

BSAS DATA Step Batch Server

CSAS Generic Batch Server

DSAS PROC Step Batch Server

Answer : B

Question 3

Which statement regarding scheduling SAS Data Integration Studio jobs is true?

ATo schedule a job flow you must first use SAS Management Console to deploy the job for scheduling.

BTo schedule the job on the Platform Process Manager you require a dependency generator.

CMultiple job flows can be scheduled to a deployment directory.

DTo schedule a job flow in SAS Management console you must first deploy the job for scheduling using SAS Data Integration Studio.

Answer : D

Question 4

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 5

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 6

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

AHTML

BPDF

CRTF

DXML

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 A00-260 SAS Certified Data Integration Developer for SAS Exam Practice Test