SAS Certified Data Integration Developer for SAS 9 Practice Exam

SAS Certified Data Integration Developer for SAS 9

SAS Certified Data Integration Developer for SAS 9

The SAS Certified Data Integration Developer for SAS 9  exam tests the candidate's ability to apply the skills and knowledge necessary for data integration development in the SAS® environment. Also, it tests the understanding of defining the architecture of the platform for SAS Business Analytics, creating metadata for source and target data, creating metadata for target data and jobs, working with transformations, working with tables and table loader transformation.


Course Structure

The important domains and their topics that the SAS Certified Data Integration Developer for SAS 9 exam covers are: 

1. Overview

Define the architecture of the platform for SAS Business Analytics

Describe the available interfaces

Define the change management feature of SAS Data Integration Studio

Discuss the DataFlux Data Management Server

2. Creating Metadata for Source and Target Data

Define administrative tasks to be performed for SAS Data Integration Studio.

Describe the New Library Wizard.

Use Register Tables wizard to register source data.

Register metadata for a comma-delimited external file.

Import and Export Metadata.

3. Creating Metadata for Target Data and Jobs

Describe the features of the New Table wizard.

Discuss components of Join's Designer window

Investigate mapping and propagation.

Work with performance statistics.

Generate reports on metadata for tables and jobs.

Define Impact and Reverse Impact Analysis.

Import SAS code.

4. Working with Transformations

Discuss and use the Extract and Summary Statistics transformation.

Discuss and use the Loop transformations.

Investigate where status handling is available.

Explain the functionality of the Data Validation transformation.

Discuss and use the Rank, Transpose, Append, List and Sort transformations.

Discuss and use the Apply Lookup Standardization transformation.

Discuss and use the Compare Tables transformation.

Discuss and use transformations in the SQL grouping of transformations.

Apply and use the Standardize with Definition transformation.

5. Working with Tables and the Table Loader Transformation

Discuss reasons to use the Table Loader transformation.

Discuss various load styles provided by the Table Loader transformation.

Discuss various types of keys and how to define in SAS Data Integration Studio.

Discuss indexes and how to define in SAS Data Integration Studio.

Discuss Table Loader options for keys and indexes.

Discuss the Bulk Table Loader transformation.

Discuss and use the components of the Join's Designer Window related to in-database processing.

6. Working with Slowly Changing Dimensions

List the functions of the SCD Type 2 transformation.

Define business keys.

Detect and track changes.

Discuss the Lookup transformation.

Discuss the SCD Type 1 Loader.

7. Defining Generated Transformations

Define SAS code transformation templates.

Create a custom transformation

8. Deploying Jobs

Discuss the types of job deployment available for SAS Data Integration Studio Jobs.

Provide an overview of the scheduling process.

Discuss the types of scheduling servers.

Discuss the Schedule Manager in SAS Management Console.

Discuss batch servers.

Describe deployment of SAS Data Integration Studio jobs as a SAS Stored Process.

9. In Database Processing

Define in-database processing

Enable in-database processing

Define and discuss ELT methods

Use a DBMS function in a SAS DI job


Exam Format

  • Exam Name: SAS Certified Data Integration Developer for SAS 9 
  • Exam Number: A00-260
  • Number of Questions: 76
  • Exam Format: Multiple-choice
  • Time Give: 105 minutes  
  • Passing score: 70%
  • Exam fee: €160 EUR


What do we offer?

  • Full-Length Mock Test with unique questions in each test set
  • Practice objective questions with section-wise scores
  • An in-depth and exhaustive explanation for every question
  • Reliable exam reports evaluating strengths and weaknesses
  • Latest Questions with an updated version
  • Tips & Tricks to crack the test
  • Unlimited access


What are our Practice Exams?

  • Practice exams have been designed by professionals and domain experts that simulate real-time exam scenarios.
  • Practice exam questions have been created on the basis of content outlined in the official documentation.
  • Each set in the practice exam contains unique questions built with the intent to provide real-time experience to the candidates as well as gain more confidence during exam preparation.
  • Practice exams help to self-evaluate against the exam content and work towards building strength to clear the exam.
  • You can also create your own practice exam based on your choice and preference.


100% Assured Test Pass Guarantee

We have built the TestPrepTraining Practice exams with 100% Unconditional and assured Test Pass Guarantee!


If you are not able to clear the exam, you can ask for a 100% refund.

Tags: SAS Certified Data Integration Developer for SAS 9 Practice Exam