最新なSASInstitute A00-260問題集（70題）、真実試験の問題を全部にカバー！

質問 1：
In SAS Data Integration Studio, which statement is FALSE regarding status handling?
A. The available Condition/Action pairs for transformations and jobs will vary - that is,
different
Condition/Action pairs may exist for the SQL Join transformation versus the Table Loader
transformation.
B. Only one Condition/Action pair can be defined for a single transformation or for a job.
C. If status handling has been defined for a transformation or the job, a macro definition
(and a call to it)
will be added to the generated code to check for the specified condition(s).
D. When a job is executed in SAS Data Integration Studio, a return code for each
transformation in the job is
captured in a macro variable. The return code for the job is set to the least successful
transformation in the
job. SAS Data Integration Studio enables you to associate a return code condition, such as
Successful, with an
action, such as Send Email.
正解：B

質問 2：
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 Server
C. the SAS DATA Step Batch Server
D. the Scheduling Manager plug-in in SAS Management Console
正解：D

質問 3：
The profile reports generated in dfPower Profile jobs are viewed:
A. in any HTML viewer
B. in any text viewer
C. in dfPower Profile (Viewer)
D. in the Reports tab of dfPower Profile (Configurator)
正解：C

質問 4：
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 removed at the beginning of the load process and must be re-created in a subsequent job step.
C. 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.
D. Indexes are automatically preserved when the Table Loader executes.
正解：C

質問 5：
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 for any transformation
B. the Keys tab in the properties of a job metadata object
C. the Keys tab in the properties of a table metadata object
D. the Keys tab in the properties of a Table Loader transformation
正解：C

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

質問 7：
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 using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.
C. Execute the stored process using SAS Display Manager's Stored Process Test window.
D. Execute the stored process in SAS Management Console.
正解：B