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.
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.
Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata definitions for two simple indexes. Which of the following is NOT a valid location for viewing which columns are indexed?
A. the Load Technique tab in the Table Loader transformation properties window
B. the Indexes tab in the table properties window
C. the Columns tab in the table properties window
D. the Columns tab in the Details panel of the open job, with the table selected in the job flow
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.
Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding theAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding the relationship between the source table and the target table?
A. From the source table, matching rows are updated in the target table and new rows are added.
B. From the source table, matching rows AND new rows are added, but the original matching row in the target table is marked as inactive.
C. From the source table, matching rows are skipped, and new rows are added.
D. A or C, depending on further options chosen.
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.
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.
Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regardingAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regarding this load style?
A. It generates PROC APPEND code.
B. It generates PROC SQL code.
C. It generates either PROC SQL code or PROC APPEND code depending on further option choices.
D. It generates DATA STEP APPEND code.
In SAS Data Integration Studio, an index can be specified/defined in which location?
A. the Indexes tab in the properties of a Table Loader transformation
B. the Indexes tab in the properties of a table metadata object
C. the Indexes tab in the properties for any transformation
D. the Indexes tab in the properties of a job metadata object
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.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only SAS Institute exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your A00-260 exam preparations and SAS Institute certification application, do not hesitate to visit our Vcedump.com to find your solutions here.