Pass4sure SAS Institute Systems Exam 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 Type: Single choice,
QUESTION 8
Which of the following is needed to ensure the continued integrity and reliability of data
in a production data warehouse?
A. monthly meetings with business users to review the functionality of applications
B. regular meetings with IT to review hardware configuration and resource utilization
C. status reports from production schedulers to ensure that warehouse jobs run
successfully
D. formal communication with source system owners to identify structure and content
changes
Answer: D
QUESTION 9
Which of the following is the recommended practice for setting up the production
environment for a data warehouse application?
A. Manually copy entities from development to the production environment.
B. Assign the role of setting up a production environment to the system administrator.
C. Document steps during development and repeat them in the production environment.
D. Create a script in the development environment and run it in the production
environment.
Answer: D
QUESTION 10
Which of the following validate the transfer of binary files between systems?
A. using a checksum and checking the file size
B. using a checksum and comparing the first and last N records
C. using record counts and comparing a random sample of records
D. checking the file size and comparing a random sample of records
Answer: A
QUESTION 11
Which of the following statements are true regarding retrieving archived tape data?
I. SAS can read tape format data.
II. Archived data retrieved to disk should have retention dates.
III. Archived retrieval performance can dictate data storage type, hardware choice, and
partitioning.
IV. Relational database management system (RDBMS) archives can be processed
without returning to disk.
A. II and III only
B. I, II and III only
C. II, III and IV only
D. I, II, III and IV
Answer: B
QUESTION 12
Which of the following is impacted by a data warehousing retention and archiving
policy?
A. disk space requirements only
B. creation of data marts and disk space requirements
C. creation of data marts and versioning/change management
D. disk space requirements and versioning/change management
Answer: D
QUESTION 13
According to The Data Warehouse Lifecycle Toolkit, by Ralph Kimball, which of the
following represent best practices when deploying a data warehouse?
I. Enable warehouse access for all valid users at the same time.
II. Deny warehouse access to end-users who have not received warehouse training.
III. Provide end-users resource support for warehouse to legacy system reconciliation.
IV. End-user education can begin shortly before the production deployment of the
warehouse.
A. III and IV only
B. I, II and III only
C. I, II and IV only
D. II, III and IV only
Answer: D
QUESTION 14
Which of the following is a true statement regarding backup strategies for SAS data sets
after the load has been completed?
A. metadata must be synced
B. file system-level backups are sufficient
C. warehouse must be taken off-line to perform backup
D. incremental backups can be performed based on SAS data set metadata
Answer: B
QUESTION 15
After deploying the warehouse on a UNIX system, jobs accessing the SAS dataset named
SALES are performing poorly. The dataset SALES is stored in the file
/disk1/sales.sas7bdat and is 3Gb in size. Which of the following methods can be used to
most accurately measure the I/O read performance?
A. “options fullstimer; libname in ‘/disk1′; data_NULL_;
set in.sales(drop=_all_); run;”
B. “timex cat /disk1/sales.sas7bdat > /dev/null”
C. “timex cp /disk1/sales.sas7bdat /disk1/foo” and divide the time by 2
D. “timex mv /disk1/sales.sas7bdat /disk1/foo” and divide the time by 2
Answer: A
QUESTION 16
Which of the following helps to reduce the I/O for a procedure that requires every row of
a SAS table to be processed?
A. indexing the SAS table
B. using the SQL procedure
C. partitioning the SAS table
D. compressing the SAS data set
Answer: D
“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?
With the complete collection of questions and answers, Pass4sure has assembled to take you through 65 Q&A to your a00-203 Exam preparation. In the a00-203 exam resources, you will cover every field and category in SAS Institute Systems helping to ready you for your successful SAS Institute Certification.
Questions and Answers : 65 Q&A
Updated: April 20th , 2008
Market Price: $159.99
Member Price: $125.99
Free down:pass4sure sas a00-203
Free down:Testking a00-203
Related Posts
Related Posts
Tags: a00-203
One Response to “Pass4sure SAS Institute Systems Exam a00-203”
September 26th, 2008 at 5:20 pm
[...] Pass4sure a00-201 sas base programming exam Pass4sure a00-202 sas advanced programming exam Pass4sure a00-203 sas warehouse development specialist concepts exam Pass4sure a00-204 sas warehouse architect [...]
Leave a Reply