TestinsideSAS Institute Systems Certification A00-203
Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcampsas warehouse development specialist concepts exam : A00-203 Exam
Exam Number/Code: A00-203
Exam Name: sas warehouse development specialist concepts exam
Questions and Answers: 65 Q&As
Price: $125.00
Update Time: 2008-6-21
QUESTION 18
Which of the following products are needed on the local host to access data from
ORACLE on a remote host that is not running SAS?
A. SAS/ACCESS to ORACLE only
B. SAS/ACCESS to ORACLE and SQL*NET
C. SAS/ACCESS to ORACLE and SAS/CONNECT
D. SAS/ACCESS to ORACLE and SAS/SHARE*NET
Answer: B
QUESTION 19
Which one of the following delivers the best I/O performance when creating a temporary
SAS data set from a permanent SAS data set?
A. Create the new data set in a library on a different physical disk.
B. Create the new data set in the same library as the existing data set.
C. Create the new data set in a library managed by a different disk controller.
D. Create the new data set in a different library than the existing data set but on the same
physical disk.
Answer: C
QUESTION 20
Which of the following job flow dependencies can be defined using SAS Schedule
Manager?
I.The programs in the job flow run simultaneously.
II.The programs in the job flow are dependent on time.
III.The programs in the job flow are dependent on completed job execution.
IV.The programs in the job flow are dependent on changes in operating system directory
structure.
A. I only
B. II and III only
C. II, III and IV only
D. I, II III, and IV
Answer: C
QUESTION 21
Which of the following individuals is most likely to determine the requirements that
define how data will be displayed and grouped in applications and reporting?
A. business end-user
B. warehouse architect
C. data quality manager
D. warehouse database administrator
Answer: A
QUESTION 22
Which of the following are primary information that those responsible for running the
warehouse jobs need?
I. recovery and restart procedures in case of failure
II. schedule dependencies between processing jobs
III. table of business rules used to load the warehouse
IV. list of all input data sources and persons responsible
A. I and II only
B. I, II and IV only
C. I, III and IV only
D. II, III and IV only
Answer: B
Actualtests.com – The Power of Knowing
QUESTION 23
Which of the following is verified by integration testing?
A. Warehouse processes work together.
B. Data tables are imported into the database.
C. External data is combined with internal data.
D. The data integration rules of the extract, transform, and load (ETL) processes work.
Answer: A
QUESTION 24
Which of the following is/are data quality checks?
I. matching control tables and totals
II. comparing values to external sources
III. checking program and function return codes
IV. verifying that source data files were imported
A. I only
B. I and II only
C. II and III only
D. I, III and IV only
Answer: B
QUESTION 25
Two physical disks are shared between the production and test environments. Which of
the following is the recommended approach when full table scans are the predominant
access method?
A. Use one disk and its file system for the production system and the other disk and its
file system for the test system.
B. Create one logical volume with one overall file system using both disks and use
directory structures to share space.
C. Create two logical volumes on each physical disk and a file system per logical
volume. Then, use one file system from each disk for test and one for production.
D. Create two logical devices on each disk, then create two file systems. Then, with each
file system, use one logical volume from each disk and stripe the data across the two
selected logical volumes.
Answer: D
QUESTION 26
Which of the following allows data to be extracted from a single relational database
management system (RDBMS) table using changed data capture?
A. source RDBMS rollback log
B. row level modification date/time stamp
C. table level modification date/time stamp
D. warehouse operational data store (ODS) metadata
Answer: B
QUESTION 27
According to the SAS Rapid Warehousing Methodology, in which of the following
phases must the acceptance test criteria be defined?
A. final test
B. assessment
C. deployment
D. requirements
Answer: D
QUESTION 28
Which of the following objects can be defined as metadata in a data warehouse that uses
SAS data sets for storage?
A. indexes and tables only
B. indexes, schemas, and tables only
C. indexes, primary/foreign keys, and tables only
D. indexes, primary/foreign keys, schemas, and tables
Answer: C
QUESTION 29
Which of the following is the best action to perform during the warehouse process when
the values in the source data do not conform to the documented business rules during
data validation?
A. Write a file of incorrect data for review by data owners.
B. Create a program to update the original source data files.
C. Change the validation code to correct the incorrect values.
D. Load non-conforming records and mark them for future fix.
Answer: A
QUESTION 30
Which of the following allow files to be shared in heterogeneous environments?
I. NFS mounts
II. a network filer
III. FTP processes
IV. an array attached to the hosts via a split bus
A. I and III only
B. I, II, and III only
C. I, III, and IV only
D. I, II, III, and IV
Answer: B
“sas warehouse development specialist concepts exam”, also known as A00-203 exam, is a SAS Institute certification.
Preparing for the A00-203 exam? Searching A00-203 Test Questions, A00-203 Practice Exam, A00-203 Dumps?
Free A00-203 Demo Download
TestInside offers free demo for A00-203 exam ( sas warehouse development specialist concepts exam). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Free down:pass4sure sas a00-203
Free down:Testking a00-203
Related Posts
Related Posts
Tags: a00-203
Leave a Reply