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.
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?
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.
A SAS Data Integration Studio job was successfully scheduled and the appropriate event for triggering it occurred. Which statement describes the situation correctly?
A. The scheduling server calls the SAS DATA Step Batch Server over the SAS Object Server which spawns the job, getting its source code from the deployment directory, and sends the results directly to the Schedule Manager plug-in of the SAS Management Console.
B. The scheduling server uses the command obtained from the SAS DATA Step Batch Server and the source code from the deployment directory to run the job. The results from the executing command are directly sent to the scheduling server.
C. The scheduling server uses the command from the deployed job in the deployment directory and executes it with the SAS DATA Step Batch Server which gets the source code from the Metadata Server. The results are sent back to the deployment directory.
D. The scheduling server uses the command obtained from the Schedule Manager, the source code from SAS DATA Step Batch Server and executes it. The results are directly sent to the scheduling server.
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.
When using the Table Loader transformation to load an existing target table that contains one or more indexes in SAS Data Integration Studio, which statement is true?
A. Indexes are removed when the Table Loader executes and must be re-created using the Table Structure transformation.
B. Indexes are automatically preserved when the Table Loader executes.
C. Indexes are removed at the beginning of the load process and must be re-created in a subsequent job step.
D. Indexes can be removed or preserved at the beginning of the process depending on options chosen. Additional table loader options specify whether to re-create the index at the end of the process.
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
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
When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?
A. the old record is deleted and the changed record is added
B. the old record is updated with the new values from the changed record
C. the old record is flagged and the changed record is added
D. the old record is merged with the changed record
In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?
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
