SASInstitute A00-260 問題集

質問 1：
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 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.
B. 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.
C. 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.
D. 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.
正解：D

質問 2：
Given the table below as a source table for the Transpose transformation in SAS Data Integration Studio:

In the Options tab in the Properties window for the Transpose transformation, if the columns are assigned as follows: Select columns to transpose (VAR statement): Payment Select a column for Output column names (ID statement): Month Select columns whose values define groups of records to transpose (BY statement): Name
Which of the following tables is a possible resulting target table?

A. Exhibit C
B. Exhibit B
C. Exhibit D
D. Exhibit A
正解：D

質問 3：
When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?
A. &target
B. %target
C. &syslast
D. syslast
正解：C

質問 4：
In SAS Data Integration Studio, primary keys, foreign keys and unique keys can be specified/defined in which location?
A. the Keys tab in the properties of a Table Loader transformation
B. the Keys tab in the properties of a job metadata object
C. the Keys tab in the properties for any transformation
D. the Keys tab in the properties of a table metadata object
正解：D

質問 5：
Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE?

A. If the server that executes the job has multiple CPUs, parallel processing can be enabled in the Loop transformation properties window.
B. The Control Table column is mapped to the parameter defined for the Inner Job using the Loop transformation properties window.
C. The Inner Job can be successfully executed by itself, but only if the defined parameter has been assigned a valid default value.
D. The Inner Job cannot be successfully executed by itself unless it is disassociated from the loop job.
正解：D