Logo ExamsQA
Exit
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
Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding theAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding the relationship between the source table and the target table?
Options
A A or C, depending on further options chosen.
B From the source table, matching rows are updated in the target table and new rows are added.
C From the source table, matching rows are skipped, and new rows are added.
D From the source table, matching rows AND new rows are added, but the original matching row in
the target table is marked as inactive.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
When exporting a SAS package file using SAS Data Integration Studio, where can it be saved?
Options
A only on the machine where SAS Data Integration Studio is running
B in metadata
C in a SAS catalog
D on any machine that SAS Data Integration Studio can write to
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
The profile reports generated in dfPower Profile jobs are viewed:
Options
A in any text viewer
B in dfPower Profile (Viewer)
C in any HTML viewer
D in the Reports tab of dfPower Profile (Configurator)
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to its options?
Options
A SAS macro calls
B SAS macro variables
C SAS formats
D columns of SAS datasets
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
Which statement correctly defines a System DSN?
Options
A Specific to an individual user. But it can be shared among users.
B Not specific to an individual user. Anyone with permission to access the data source can use 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. It is available only to the user who creates it.
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.