01. Which statement is true regarding external files?
A.
a) External file objects are accessed with SAS INFILE and FILE statements.
B.
b) External files contain only one record per line.
C.
c) External files can be used as input but not as outputs in SAS Data Integration Studio jobs.
D.
d) SAS can only work with Blank, Comma, Semicolon and Tab as delimiters in external files.
2.
02. Which SAS Data Integration Studio reports, generated as external files, can be stored as document objects within metadata?
A.
a) only job reports
B.
b) only table reports
C.
c) both job reports and table reports
D.
d) No reports can be stored as document objects.
3.
03. Within SAS Data Integration Studio's Table Loader transformation, which load style choice does NOT exist?
A.
a) Delete where
B.
b) Append to Existing
C.
c) Replace
D.
d) Update/Insert
4.
04. In SAS Data Integration Studio, a business key can be defined in the properties of which transformation?
A.
a) Data Validation
B.
b) SQL Join
C.
c) Lookup
D.
d) SCD Type 2 Loader
5.
05. Which products are needed on the local host in order to access data from an MS Access Database using an ODBC Data Source name?
A.
a) SAS/ACCESS interface to DSN
B.
b) SAS/ACCESS interface to ODBC
C.
c) SAS/ACCESS interface to MDB
D.
d) SAS/ACCESS interface to PC Files
Quiz Outcomes
1.
POOR
The A00-260 certification is within your reach now. Get directed to the most valuable A00-260 resources, e.g., the syllabus and practice test, in just one click, and include them in your practical study plan to ace the exam in no time.
2.
GOOD
The A00-260 certification is within your reach now. Get directed to the most valuable A00-260 resources, e.g., the syllabus and practice test, in just one click, and include them in your practical study plan to ace the exam in no time.
3.
VERY GOOD
The A00-260 certification is within your reach now. Get directed to the most valuable A00-260 resources, e.g., the syllabus and practice test, in just one click, and include them in your practical study plan to ace the exam in no time.