A00-260 Exam Questions

Which statement correctly defines a System DSN?

When exporting a SAS package file using SAS Data Integration Studio, where can it be saved?

In SAS Data Integration Studio, which output format is supported for the default "out-of-the-box" job report?

Which statements are true regarding columns when using SAS Data Integration Studio's New Tables wizard? 1. You can access metadata for any column from any table already registered...

Consider the job flow diagram in the display. Which of these objects has parameters defined for it?

You want to create a table containing all customers from Italy. Assume that global customer order information is available in a single table. Identify the SAS Data Integration Stud...

In the following display, can status handling be enabled for the Extract transformation?

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 da...

When using SAS Data Integration Studio's SQL Join transformation, which SQL join type can be constructed as either an implicit or an explicit join?

How do you enable performance statistics for a SAS Data Integration Studio job?

Which statement regarding propagation is FALSE?

Within SAS Data Integration Studio's SQL Join transformation, the Validate Expression button is located in:

Which definition cannot be imported using a SAS Metadata Bridge?

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 transformatio...

Within SAS Data Integration Studio, which type of expression can be created using the Expression Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression...

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

Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?

In order to use the SAS Data Integration Studio's Apply Lookup Standardization transformation, Data Quality options must be setup. Select the valid Scheme Repository Types. (Choose...

In SAS Data Integration Studio, which statement is FALSE regarding status handling?

The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is FALSE regarding the Platform Process Manager server?

Which statement regarding scheduling SAS Data Integration Studio jobs is true?

A platform administrator wants to physically segregate the physical storage for metadata in a single environment. What should the platform administrator create?

Within SAS Data Integration Studio, which one of the following is NOT an option available from the File-> New menu choice under External File grouping?