Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 60certs

SAS Institute A00-260 Dumps

Page: 1 / 3
Total 70 questions

SAS Data Integration Development Questions and Answers

Question 1

In SAS Data Integration Studio, an index can be specified/defined in which location?

Options:

A.

the Indexes tab in the properties of a Table Loader transformation

B.

the Indexes tab in the properties of a table metadata object

C.

the Indexes tab in the properties for any transformation

D.

the Indexes tab in the properties of a job metadata object

Question 2

Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?

Options:

A.

The physical table(s) selected are copied to the application server specified in the library.

B.

The physical table(s) selected are copied to the SAS Folders location specified in the wizard.

C.

Metadata for the physical table(s) selected is stored on the application server specified in the library.

D.

Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.

Question 3

SAS Data Integration Studio is dependent on which administration functions?

Options:

A.

Setting up of SAS Information Map environment.

B.

Setting up of SAS Web and SAS Portal environments.

C.

Setting up of SAS Application Servers.

D.

Setting up of SAS Libraries definitions.

Question 4

After creating a stored process from a SAS Data Integration Studio job, how can you test the stored process to make sure it runs correctly?

Options:

A.

Execute the stored process in SAS Data Integration Studio.

B.

Execute the stored process in SAS Management Console.

C.

Execute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.

D.

Execute the stored process using SAS Display Manager's Stored Process Test window.

Question 5

The profile reports generated in dfPower Profile jobs are viewed:

Options:

A.

in dfPower Profile (Viewer)

B.

in the Reports tab of dfPower Profile (Configurator)

C.

in any HTML viewer

D.

in any text viewer

Question 6

In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?

Options:

A.

find row matches using the business key

B.

find row matches using generated cluster numbers

C.

find non-standard values using a generated key

D.

find non-standard values using a business key

Question 7

In order to use the SAS Data Integration Studio's Apply Lookup Standardization transformation, Data Quality options must be setup. Select the valid Scheme Repository Types. (Choose two.)

Options:

A.

A comma delimited flat file that contains the field names in the first row.

B.

Power scheme that is generated by Data Flux.

C.

A SAS table scheme that is generated by SAS.

D.

A third party RDBMS table that has been generated by the SAS system.

Question 8

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?

Options:

A.

Union

B.

Full

C.

Inner

D.

Cross

Question 9

Within SAS Data Integration Studio's SQL Join transformation, the Validate Expression button is located in:

Options:

A.

a Where clause definition

B.

an Expression Builder window

C.

a field Expression definition

D.

a Subquery definition

Question 10

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?

Options:

A.

Data Transfer

B.

Data Validation

C.

Data Quality

D.

Data Extract

Page: 1 / 3
Total 70 questions