A00-260 Online Practice Questions and Answers

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.

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?

A. Data Transfer

B. Data Validation

C. Data Quality

D. Data Extract

The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is FALSE regarding the Platform Process Manager server?

A. The server enables you to schedule jobs using a variety of recurrence criteria and dependencies on other jobs, time events, or file events.

B. The server enables you to schedule jobs using a variety of recurrence criteria but does NOT allow you to specify any type of dependencies.

C. The Flow Manager application (part of the Platform Suite for SAS) can be used to manage already scheduled jobs.

D. Metadata for the Platform Process Manager server must be defined and must include the network address or host name of a machine as well as the port number for the server.

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.

Which statement best describes a deployment directory as used in the Schedule Manager in SAS Management Console?

A. A folder or directory location on a server where the SAS code from a deployed SAS Data integration Studio job is stored.

B. A location in the metadata repository where job flows are deployed.

C. A location in the SAS Management console job directory storing the metadata for jobs that can be added to job flows.

D. A SAS Folder in the Schedule Manager plug-in within SAS Management Console containing listings of all flows organized by server type.

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.

The purpose of change management in SAS Data Integration Studio is to manage:

A. metadata objects across metadata servers

B. metadata objects within a logged on user's personal folder

C. metadata objects within a metadata server

D. metadata objects within a logged on user's Checkouts Tree

Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to its options?

A. SAS macro variables

B. columns of SAS datasets

C. SAS formats

D. SAS macro calls

How can you test the interaction of the options of a SAS Data Integration Studio Generated transformation?

A. The transformation has to be used within a job to interactively test the options with the Test Prompt button in the Options window from the properties of the transformation within the job editor.

B. The options can be tested after finalizing and saving the transformation with the Test Prompt item on the Tools menu.

C. The options can be tested only after adding all options that are assigned to the source code with the Test Prompt button in the Options window of the New Transformation wizard.

D. The options can be tested at any time after adding them to the transformation with the Test Prompt button in the Options window of the New Transformation wizard.

In SAS Data Integration Studio, surrogate and retained key values are:

A. generated by the Lookup transformation

B. copied from source tables into dimension tables

C. generated by the SCD Type 2 Loader transformation

D. copied from dimension tables into source tables