Online Access Free A00-260 Practice Test

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 Validation
• B.Data Transfer
• C.Data Quality
• D.Data Extract

In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain which type of values?

• A.alpha-numeric values
• B.datetime values
• C.integer values
• D.binary values

In SAS Data Integration Studio, an index can be specified/defined in which location?

• A.the Indexes tab in the properties of a table metadata object
• B.the Indexes tab in the properties of a job metadata object
• C.the Indexes tab in the properties for any transformation
• D.the Indexes tab in the properties of a Table Loader transformation

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 Web Report Studio
• C.SAS OLAP Cube Studio
• D.SAS Information Map Studio

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 Scheduling Manager plug-in in SAS Management Console
• D.the SAS DATA Step Batch Server