A00-260 Online Practice Questions and Answers

You want to create a job that checks conditions for your data before that data is loaded into a data warehouse. The job should be able to detect error conditions such as missing data or duplicate data and take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio transformation should you use?

A. Data Transfer

B. Data Validation

C. Data Quality

D. Data Extract

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.

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.

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.

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.

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 definition cannot be imported using a SAS Metadata Bridge?

A. Server definition

B. Library definition

C. Table definition

D. Column Definition

The SAS platform application that can surface the different types of business and analytic content such as information maps, stored processes, and reports on the web browser is:

A. SAS Information Delivery Portal

B. SAS Information Map Studio

C. SAS Web Report Studio

D. SAS OLAP Cube Studio

How can you test the interaction of the options of a SAS Data Integration Studio Generated transformation?

A. The transformation has to be used within a job to interactively test the options with the Test Prompt button in the Options window from the properties of the transformation within the job editor.

B. The options can be tested after finalizing and saving the transformation with the Test Prompt item on the Tools menu.

C. The options can be tested only after adding all options that are assigned to the source code with the Test Prompt button in the Options window of the New Transformation wizard.

D. The options can be tested at any time after adding them to the transformation with the Test Prompt button in the Options window of the New Transformation wizard.

When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data?

A. business key columns

B. Type 1 columns

C. generated columns

D. non-key columns