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

Certensure 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

Demo: 10 questions
Total 70 questions
Get A00-260 Full Access Download A00-260 PDF

SAS Data Integration Development Questions and Answers

Question 1

A fact table is populated by using which transformation in SAS Data Integration Studio?

Options:

A.

SCD Type 2 Loader

B.

Data Validation

C.

Lookup

D.

DataFlux IS Job

Question 2

Which definition cannot be imported using a SAS Metadata Bridge?

Options:

A.

Server definition

B.

Library definition

C.

Table definition

D.

Column Definition

Question 3

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

Options:

A.

SAS Java Batch Server

B.

SAS DATA Step Batch Server

C.

SAS Generic Batch Server

D.

SAS PROC Step Batch Server

Question 4

You want to register an external file with the following structure: first line contains Customer First and Last Name second line is address1 third line is address 2 fourth line contains the phone number What action should you take to read this file?

Options:

A.

Use the New User Written External File wizard.

B.

Use the New Fixed Width External File wizard.

C.

Use the New Delimited External File wizard.

D.

Use the New COBOL Copybook wizard.

Question 5

Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE?

Options:

A.

The Inner Job can be successfully executed by itself, but only if the defined parameter has been assigned a valid default value.

B.

The Inner Job cannot be successfully executed by itself unless it is disassociated from the loop job.

C.

The Control Table column is mapped to the parameter defined for the Inner Job using the Loop transformation properties window.

D.

If the server that executes the job has multiple CPUs, parallel processing can be enabled in the Loop transformation properties window.

Question 6

In SAS Data Integration Studio, which component allows the definition of job flows with dependencies between different jobs?

Options:

A.

the deployment wizard of SAS Data Integration Studio

B.

the Scheduling Manager plug-in in SAS Management Console

C.

the Scheduling Server

D.

the SAS DATA Step Batch Server

Question 7

Which statement is FALSE regarding foreign keys?

Options:

A.

A foreign key is one or more columns that are associated with a primary key or unique key in another table.

B.

A table can have zero or more foreign keys.

C.

A foreign key cannot exist without an associated primary or unique key.

D.

A table can have only one foreign key defined.

Question 8

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 9

Which statement correctly defines a System DSN?

Options:

A.

Not specific to an individual user. Anyone with permission to access the data source can use it.

B.

Specific to an individual user. It is available only to the user who creates it.

C.

Not specific to an individual user. It can be shared among users even though it is created locally.

D.

Specific to an individual user. But it can be shared among users.

Question 10

When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

Options:

A.

the old record is deleted and the changed record is added

B.

the old record is updated with the new values from the changed record

C.

the old record is flagged and the changed record is added

D.

the old record is merged with the changed record

Load More A00-260 Questions
Demo: 10 questions
Total 70 questions
Get A00-260 Full Access Download A00-260 PDF