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.

When using the Table Loader transformation in SAS Data Integration Studio to update an existing table containing indexes or constraints, which statement is true?

A. You can control the removal and/or creation of indexes and constraints in the target table only if you are using a Load style other than Replace.

B. You can control the removal and/or creation of indexes and constraints in the target table for all Load Styles.

C. If using the Append to Existing load style, indexes and constraints can be added but not removed.

D. For the Update/Insert load style it is possible to remove indexes not required for the Update/Insert processing, but no indexes can be added.

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.

Which statement is true regarding SAS packages created in SAS Data Integration Studio?

A. SAS packages are used to import and export SAS applications.

B. SAS packages are used to import and export stand-alone SAS programs.

C. SAS packages are used to import and export third-party metadata.

D. SAS packages are used to import and export SAS metadata.

Which action is required for enabling performance statistics on the executing SAS Workspace Server?

A. Define a logfile for output.

B. Define Collect Diagnostics for the SAS Data Integration Studio job.

C. Define Collect Runtime statistics for the SAS Data Integration Studio job.

D. Enable the logging facility of the SAS Workspace Server.

When exporting a SAS package file using SAS Data Integration Studio, where can it be saved?

A. in metadata

B. on any machine that SAS Data Integration Studio can write to

C. in a SAS catalog

D. only on the machine where SAS Data Integration Studio is running

Within SAS Data Integration Studio, automatic mappings are disabled for a job. A transformation has defined source columns and defined target columns. One of the source columns, named COL1, is character with a length of 50. One of the target columns, named COL1, is also character but of length 25. What will happen if the COL1 columns are mapped?

A. The COL1 columns are successfully mapped, one-to-one, with no warnings.

B. The COL1 columns are not mapped because the lengths are different.

C. The COL1 columns are mapped but an expression is defined for the target COL1 that uses a generic specification of the LENGTH function.

D. The COL1 columns are successfully mapped, one-to-one, but a warning occurs.

Within SAS Data Integration Studio, how many inputs and outputs can be defined for a Generated transformation?

A. A transformation can have zero or more inputs and exactly one output.

B. A transformation needs at least one input and at least one output.

C. A transformation can have zero or more inputs and zero or more outputs.

D. A transformation needs at least one input and exactly one output.

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.

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