Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

SAS Institute A00-260 - SAS Data Integration Development

SAS Institute A00-260 Premium Access     Download Demo    
Page: 1 / 3
Total 70 questions

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 are updated in the target table and new rows are added.

B.

From the source table, matching rows AND new rows are added, but the original matching row in the target table

is marked as inactive.

C.

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

D.

A or C, depending on further options chosen.

A SAS Data Integration Studio job was successfully scheduled and the appropriate event for triggering it occurred. Which statement describes the situation correctly?

A.

The scheduling server calls the SAS DATA Step Batch Server over the SAS Object Server which spawns the job,

getting its source code from the deployment directory, and sends the results directly to the Schedule Manager

plug-in of the SAS Management Console.

B.

The scheduling server uses the command obtained from the SAS DATA Step Batch Server and the source code from

the deployment directory to run the job. The results from the executing command are directly sent to the

scheduling server.

C.

The scheduling server uses the command from the deployed job in the deployment directory and executes it with

the SAS DATA Step Batch Server which gets the source code from the Metadata Server. The results are sent back

to the deployment directory.

D.

The scheduling server uses the command obtained from the Schedule Manager, the source code from SAS DATA Step

Batch Server and executes it. The results are directly sent to the scheduling server.

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

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

You want to create a table containing all customers from Italy. Assume that global customer order information is available in a single table. Identify the SAS Data Integration Studio transformation that will help you perform the task easily.

A.

Append

B.

Extract

C.

Lookup

D.

Mining Results

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

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?

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.

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.

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

A.

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

B.

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

C.

Multiple job flows can be scheduled to a deployment directory.

D.

To schedule a job flow in SAS Management console you must first deploy the job for scheduling using SAS Data

Integration Studio.

How can you make a SAS Data Integration Studio Generated transformation option required?

A.

The name of the option has to start with _REQUIRED.

B.

The type of the column has to be defined as Required Data source column.

C.

The option can be marked as Requires a non-blank value.

D.

It is not possible to make an option required.

Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)

A.

Create and replace permanent tables.

B.

Maintain access privileges to permanent tables.

C.

Apply and maintain constraints on permanent tables.

D.

Delete and remove permanent tables.