Career upgrade: Learn practical AI skills for better jobs and higher pay.
Level up
PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free SAS Data Integration Developer Practice Questions

Pass your SAS Certified Data Integration Developer for SAS 9 (A00-260) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
Not published Pass Rate
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

A developer changes the length of a column on a registered table. Which action propagates the new length into the affected jobs' column mappings?

A
B
C
D
to track
Same family resources

Explore More SAS Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

SAS Certified Associate: Applied Statistics for Machine Learning

Practice Questions

SAS Certified Associate: Modeling Using SAS Visual Statistics

Practice Questions

SAS Certified Associate: Programming Fundamentals Using SAS 9.4

Practice Questions

SAS Certified Professional Advanced Programming

Practice Questions

SAS Certified Professional: AI & Machine Learning

Practice Questions

SAS Certified Professional: Clinical Trials Programming Using SAS 9.4

Practice Questions
2026 Statistics

Key Facts: SAS Data Integration Developer Exam

52

Exam Questions

SAS official credential page

105 min

Exam Duration

SAS official credential page

69%

Passing Score

SAS official credential page

$180

Exam Fee

SAS global exam pricing

A00-260

Exam Code

SAS certification registry

8

Domains

SAS A00-260 content guide

A00-260 is a 52-question, 105-minute Pearson VUE exam at $180 USD with a 69% passing score. Eight domains weight roughly: Overview 5-6%, Source/Target Metadata 19-20%, Target Data and Jobs 17-18%, Transformations 21-22%, Tables and Table Loader 17-18%, Generated Transformations 5-6%, Deploying Jobs 5-6%, In-Database 7-8%. Technology base: SAS 9.4 with SAS Data Integration Studio 4.8+.

Sample SAS Data Integration Developer Practice Questions

Try these sample questions to test your SAS Data Integration Developer exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1In SAS Data Integration Studio, which tree in the desktop is used to organize jobs, libraries, and tables into a folder hierarchy that mirrors the SAS Folders metadata structure?
A.Inventory tree
B.Folders tree
C.Custom tree
D.Project tree
Explanation: The Folders tree shows objects in the SAS Folders metadata hierarchy and is the recommended way to organize content because the same folder structure is shared across SAS clients such as SAS Management Console and the SAS Add-In for Microsoft Office.
2Which SAS server is the central authority that stores definitions of libraries, tables, jobs, and users used by SAS Data Integration Studio?
A.SAS Workspace Server
B.SAS OLAP Server
C.SAS Metadata Server
D.SAS Stored Process Server
Explanation: The SAS Metadata Server stores all metadata definitions (libraries, tables, columns, jobs, users, groups, ACTs). DI Studio reads from and writes to the Metadata Server for every object it manages.
3Where does a developer register a new SAS library so that SAS Data Integration Studio can use it?
A.Directly in autoexec.sas on the workspace server
B.In SAS Management Console using the Data Library Manager plug-in
C.In SAS Studio under Server Files and Folders
D.In SAS Enterprise Guide using the Tools menu
Explanation: Library definitions used by DI Studio are normally registered through the Data Library Manager plug-in in SAS Management Console. Once registered in metadata, they are available to all SAS clients including DI Studio.
4A team uses SAS Data Integration Studio with change management enabled. What is the effect of checking out a job from the project repository?
A.The job is copied to the user's project, locked from edits by other users, and changes can be checked back in later
B.The job is permanently moved out of the metadata server until it is replaced
C.The job runs immediately in batch mode on the workspace server
D.All other users are forced to log off the metadata server
Explanation: Check-out copies an object into the user's project, marks it as locked in the parent (foundation) repository so other developers cannot edit it, and lets the developer check changes back in once they are ready.
5You need to register an existing physical SAS data set as a metadata table so it can be used as a source in jobs. Which DI Studio feature is the correct tool?
A.New Job wizard
B.Register Tables wizard
C.Code Generator wizard
D.Deploy Job wizard
Explanation: The Register Tables wizard reads physical tables (SAS data sets, DBMS tables, files) through an existing library and writes table and column metadata for use in jobs.
6When registering a delimited external file as a source, what kind of metadata object does SAS Data Integration Studio create to describe the file's structure?
A.A SAS data set
B.An external file definition with delimiter, record, and column metadata
C.A stored process
D.A SAS catalog entry
Explanation: DI Studio creates an external file metadata object that captures the delimiter, record format (delimited, fixed-width, user-written), and column definitions. This object is then used inside a job by transformations such as External File reader.
7Which engine should be selected on a metadata-defined library that points at an Oracle database that DI Studio jobs will read from and write to?
A.BASE
B.META
C.Oracle (a SAS/ACCESS engine)
D.V9
Explanation: To read or write Oracle through metadata, the library must be defined with the Oracle SAS/ACCESS engine and the appropriate connection options. DI Studio then submits LIBNAME statements that connect to Oracle at run time.
8A column on a registered source table is shown as numeric length 8 with format DATE9. and informat DATE9.. What does this tell you?
A.The values are stored as character strings of length 9
B.The values are SAS dates (numeric, count of days from 1960-01-01) displayed as ddMMMyyyy
C.The column is a datetime stored in milliseconds
D.The column is a SAS time value stored in seconds
Explanation: SAS dates are numeric values representing the number of days from 1960-01-01. The DATE9. format displays them as ddMMMyyyy (e.g., 09MAY2026); the matching informat reads that same display format on input.
9Which option is the most reliable way to populate column metadata for a source table that already exists physically?
A.Type each column name and length manually using the New Column action
B.Use the Register Tables wizard which imports columns from the existing physical table
C.Run PROC CONTENTS in SAS Studio and copy the output
D.Edit the .sas7bdat header file with a hex editor
Explanation: The Register Tables wizard reads the existing physical table through the chosen library and imports the column names, types, lengths, formats, and informats automatically, which avoids transcription errors.
10You define a target table that does not yet exist in the database. When the job runs for the first time, what controls whether DI Studio creates the physical table?
A.The target table is always created automatically without configuration
B.The target table is created when the loader transformation is configured to create the table or when load technique 'Create Table' is selected
C.The job must be deployed as a stored process before any table can be created
D.Tables are created only by SAS Management Console, never by jobs
Explanation: Loader transformations such as the Table Loader and SQL Set Operator have a Load technique option (Replace / Append / Update) and a flag to create the table on first run. Without these settings the physical table is not created.

About the SAS Data Integration Developer Exam

The SAS Certified Data Integration Developer for SAS 9 (A00-260) exam validates the skills needed to design, build, deploy, and maintain ETL workflows in SAS Data Integration Studio 4.8 and later. It covers the SAS Metadata Server model, source/target metadata, the full transformation library (SQL Join, Lookup, Append, Splitter, Standardization, Match Codes, User-Written), the Table Loader and SCD load patterns, generated (user-defined) transformations, job deployment for scheduling and stored processes, and in-database processing through implicit and explicit pass-through SQL.

Assessment

52 multiple-choice and short-answer questions

Time Limit

105 minutes

Passing Score

69%

Exam Fee

$180 USD (SAS / Pearson VUE)

SAS Data Integration Developer Exam Content Outline

5-6%

Overview

DI Studio desktop, metadata model, Folders/Inventory/Custom trees, change management, Metadata/Workspace servers, Management Console.

19-20%

Creating Metadata for Source and Target Data

Register libraries, tables, columns, and external files using wizards. Manage column properties, formats, and engines.

17-18%

Creating Metadata for Target Data and Jobs

Define target tables, build jobs in Process Designer, propagate column changes, configure code-generation, and use lineage / impact analysis.

21-22%

Working with Transformations

SQL Join, Append, Lookup (hash cache), Splitter, Extract, Sort, Transpose, Standardization, Match Codes, Data Validation, User-Written Code, Stored Process.

17-18%

Working with Tables and Table Loader Transformation

Table Loader load techniques (Append, Replace, Truncate-and-load, Update/Insert), bulk load, drop/restore indexes, SCD Type 1/2/3.

5-6%

Defining Generated Transformations

Build, parameterize (options/prompts), and share user-defined transformations using the Transformation Generator and &_INPUT/&_OUTPUT macros.

5-6%

Deploying Jobs

Deploy for scheduling and as stored processes, manage deployed jobs in Schedule Manager / LSF, status handling, performance statistics, promotion.

7-8%

In-Database Processing

Implicit and explicit pass-through SQL, SQL_FUNCTIONS=ALL, DIRECT_SQL=YES, heterogeneous join limits, and CDC / incremental load patterns.

How to Pass the SAS Data Integration Developer Exam

What You Need to Know

  • Passing score: 69%
  • Assessment: 52 multiple-choice and short-answer questions
  • Time limit: 105 minutes
  • Exam fee: $180 USD

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

SAS Data Integration Developer Study Tips from Top Performers

1Spend the most time on Transformations (21-22%) and Source/Target Metadata (19-20%); together they are roughly 40% of the exam.
2Build at least one end-to-end SCD Type 2 load with the Surrogate Key Generator, valid-from / valid-to dates, and a current-record flag in a real DI Studio job.
3Memorize the four Table Loader load techniques (Append, Replace drop/recreate, Replace truncate-and-load, Update/Insert) and when each is appropriate.
4Practice telling implicit from explicit pass-through SQL by reading the SAS log: implicit shows a 'SELECT statement was passed to the DBMS' note.
5Know the &_INPUT and &_OUTPUT macro variable substitution used by generated transformations for input/output table names.

Frequently Asked Questions

How many questions are on the SAS A00-260 exam?

The SAS Certified Data Integration Developer for SAS 9 exam contains 52 multiple-choice and short-answer questions to be completed in 105 minutes.

What score do I need to pass?

You need 69% on the 52-question A00-260 exam. Scoring is item-based, not scaled.

How much does the SAS A00-260 exam cost?

The exam fee is $180 USD worldwide through Pearson VUE.

What technology base is the exam aligned to?

A00-260 is based on SAS 9.4 using SAS Data Integration Studio 4.8 and later.

Are there prerequisites for the SAS A00-260 exam?

There are no formal prerequisites. SAS recommends SAS Programming 1/2 plus the Data Integration Studio: Fast Track and ETL Programming courses.