SAS Institute A00-260 Online Practice Questions and Exam Preparation

SAS Institute A00-260 Online Questions & Answers

• Question 51:

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

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

• Question 52:

  Which statement correctly defines a System DSN?

  A. Not specific to an individual user. Anyone with permission to access the data source can use it.
  B. Specific to an individual user. It is available only to the user who creates it.
  C. Not specific to an individual user. It can be shared among users even though it is created locally.
  D. Specific to an individual user. But it can be shared among users.
  A. Not specific to an individual user. Anyone with permission to access the data source can use it.

• Question 53:

  When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

  A. the old record is deleted and the changed record is added
  B. the old record is updated with the new values from the changed record
  C. the old record is flagged and the changed record is added
  D. the old record is merged with the changed record
  C. the old record is flagged and the changed record is added

• Question 54:

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

• Question 55:

  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 Studio transformation that will help you perform the task easily.

  A. Append
  B. Extract
  C. Lookup
  D. Mining Results
  B. Extract

• Question 56:

  Which statement best describes a deployment directory as used in the Schedule Manager in SAS Management Console?

  A. A folder or directory location on a server where the SAS code from a deployed SAS Data integration Studio job is stored.
  B. A location in the metadata repository where job flows are deployed.
  C. A location in the SAS Management console job directory storing the metadata for jobs that can be added to job flows.
  D. A SAS Folder in the Schedule Manager plug-in within SAS Management Console containing listings of all flows organized by server type.
  A. A folder or directory location on a server where the SAS code from a deployed SAS Data integration Studio job is stored.

• Question 57:

  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
  B. Data Validation

• Question 58:

  Which of the following are SAS Data Integration Studio job deployment types? (Choose two.)

  A. a Web service
  B. a SAS Stored Process
  C. a Java Runtime Process
  D. a SAS Information Map that is accessible in SAS Web Report Studio
  B. a SAS Stored Process
  D. a SAS Information Map that is accessible in SAS Web Report Studio

• Question 59:

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

• Question 60:

  Which statement regarding propagation is FALSE?

  A. Automatic propagation can be set globally, so every new job will automatically propagate.
  B. Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from the end to the beginning is not available.
  C. Automatic propagation that is set globally can be overridden and disabled within a job.
  D. Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected transformation.
  B. Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from the end to the beginning is not available.