Free A00-260 - SAS Certified Data Integration Developer for SAS 9 Exam Questions and Answers

Last updated: September 8, 2026

Exam code

A00-260

Provider

SAS Institute

Questions in our bank

1000+

Free to read

First 10, with answers

Our test mode duration & pass mark

130 mins · 70%

Verified answers

Reviewed weekly

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

1. Question #1

   and Last Name second line is address1 third line is address 2 fourth line contains the phone number What action should you take to read this file?

   • A. Use the New COBOL Copybook wizard.
   • B. Use the New Delimited External File wizard.
   • C. Use the New User Written External File wizard.
   • D. Use the New Fixed Width External File wizard.
   Reveal Answer

2. Question #2

   The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?

   • A. Loads fact table records into a multi-threaded table.
   • B. Loads dimension table records into a fact table.
   • C. Loads source table records into a standardization table.
   • D. Loads source table records into a dimension table.
   Reveal Answer

3. Question #3

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

   • A. The Inner Job cannot be successfully executed by itself unless it is disassociated from the loop
   • B. If the server that executes the job has multiple CPUs, parallel processing can be enabled in the
   • C. The Control Table column is mapped to the parameter defined for the Inner Job using the Loop
   • D. The Inner Job can be successfully executed by itself, but only if the defined parameter has been
   Reveal Answer

4. Question #4

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

5. Question #5

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

   • A. in a SAS catalog
   • B. on any machine that SAS Data Integration Studio can write to
   • C. in metadata
   • D. only on the machine where SAS Data Integration Studio is running
   Reveal Answer

6. Question #6

   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. Extract
   • B. Lookup
   • C. Append
   • D. Mining Results
   Reveal Answer

7. Question #7

   A user needs to find out who has the SAS Data Integration Studio job "Create Tables" checked out. What action should the user perform?

   • A. They need to select the History menu option for the SAS Data Integration Studio job "Create
   • B. They are not able to find out who has the SAS Data Integration Studio job "Create Tables" in
   • C. They need to select the "Properties" menu option and then the "Advanced" tab for the SAS Data
   • D. They need to select the History menu option for the SAS Data Integration Studio job "Create
   Reveal Answer

8. Question #8

   Which statement is FALSE regarding foreign keys?

   • A. A foreign key cannot exist without an associated primary or unique key.
   • B. A table can have zero or more foreign keys.
   • C. A table can have only one foreign key defined.
   • D. A foreign key is one or more columns that are associated with a primary key or unique key in
   Reveal Answer

9. Question #9

   Which statement regarding propagation is FALSE?

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

10. Question #10

    In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?

    • A. Data Validation
    • B. Table Loader
    • C. Lookup
    • D. DataFlux IS Job
    Reveal Answer