sas a00-260 practice test

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.

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

Which action is performed by the Lookup transformation in SAS Data Integration Studio?

• A. combines rows from multiple tables into a single row
• B. combines rows from multiple tables into multiple rows
• C. validates that values are unique
• D. validates that values are not null

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

• 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

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, the default values for generated surrogate and retained keys contain
which type of values?

• A. datetime values
• B. alpha-numeric values
• C. binary values
• D. integer values

SAS Data Integration Studio is dependent on which administration functions?

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

Consider the job flow diagram in the display. Which of these objects has parameters defined for it?

• A. Control table
• B. Loop transformation
• C. lnner Job
• D. Loop End

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.

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

• A. SCDType2 Loader
• B. Data Validation
• C. Lookup
• D. DataFlux lS Job