Official Bank 0/70

SAS Data Integration Development (A00-260) - SASI Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
70 Total Questions
1
Question
In SAS Data Integration Studio, which component allows the definition of job flows with dependencies between different jobs?
Options
A the SAS DATA Step Batch Server
B the deployment wizard of SAS Data Integration Studio
C the Scheduling Server
D the Scheduling Manager plug-in in SAS Management Console
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
Registering metadata for an ODBC data source involves registering:
Options
A a table pointing directly to the ODBC data source
B a library that will use a SASIACCESS engine to a specific database
C a server definition that points to the ODBC data source and a library accessing this server definition
D only an ODBC data source definition
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?
Options
A Loads fact table records into a multi-threaded table.
B Loads source table records into a standardization table.
C Loads source table records into a dimension table.
D Loads dimension table records into a fact table.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Which statement regarding propagation is FALSE?
Options
A Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected transformation.
B Automatic propagation can be set globally, so every new job will automatically propagate.
C Automatic propagation that is set globally can be overridden and disabled within a job.
D 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.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
Which statement defines the characteristics of a SAS Stored Process?
Options
A A user written SAS PROC step.
B SAS metadata that describes how to collect and store data sources.
C A SAS program that is stored on the server and described by metadata.
D A document that stores the steps and locations for building a data mart.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.