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

examout.co

Registering metadata for an ODBC data source involves registering:

A.

a library that will use a SAS/ACCESS engine to a specific database

B.

only an ODBC data source definition

C.

a server definition that points to the ODBC data source and a library accessing this server definition

D.

a table pointing directly to the ODBC data source

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

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.

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.)

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.

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.

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

A.

Loads source table records into a standardization table.

B.

Loads dimension table records into a fact table.

C.

Loads source table records into a dimension table.

D.

Loads fact table records into a multi-threaded table.

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.

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.

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.

The profile reports generated in dfPower Profile jobs are viewed:

A.

in dfPower Profile (Viewer)

B.

in the Reports tab of dfPower Profile (Configurator)

C.

in any HTML viewer

D.

in any text viewer

Which statement is FALSE regarding foreign keys?

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.