Pass4sure SAS Institute Exam a00-204
Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcampsas warehouse architect concepts : a00-204 Exam
QUESTION 13
According to the SAS Rapid Warehousing Methodology, which of the following is a
clear and well-defined requirement for inclusion in the Detailed Requirements Document
that is generated during the Requirements Phase?
A. Extract, transform and load (ETL) Job B is dependent on ETL Job A, and it should not
run if ETL Job A fails.
B. Extract, transform and load (ETL) module shall produce an error report that allows
quick resolution of errors when used by the end users.
C. Extract, transform and load (ETL) job code application interface will use the customer
standards.
D. Extract, transform and load (ETL) scheduler shall provide status messages at regular
intervals not less than every 60 seconds.
Answer: A
QUESTION 14
The source for an input data file has changed. To ensure that the new source file reads
correctly and meets requirements, a test is conducted to ensure that the new file conforms
to the specified layout. Which of the following describes the type of test conducted?
A. unit test
B. acceptance test
C. system test
D. integration test
Answer: A
QUESTION 15
According to “The Data Warehouse Toolkit” by Ralph Kimball, which of the following
has the greatest impact on end-user multi-dimensional business reporting?
A. the relational database management system (RDBMS) used for warehouse storage
B. the speed at which an SQL answer set can be returned to the users
C. the ability to quickly integrate multiple SQL answer sets
D. the efficiency of the extract, transform and load (ETL) process
Answer: C
QUESTION 16
A data warehouse uses a relational database management system (RDBMS) for its core
data repository. Bulk loading has been proposed as the method for loading larger
RDBMS tables into the warehouse.
Which of the following must be considered when developing the bulk load routines?
I.indexes
II.join efficiency
III.integrity constraints
IV.representation of null values
A. I, III, and IV only
B. III and IV only
C. I and II only
D. I, II, and III only
Answer: A
QUESTION 17
Which of the following is true for two data marts that contain exactly the same data?
A. The snowflake schema has the same number of tables as the star schema.
B. The snowflake schema is further normalized from the star schema.
C. The snowflake schema has fewer tables than the star schema.
D. The snowflake schema is further denormalized from the star schema.
Answer: B
QUESTION 18
An international airline has an online ticket sale facility located in London, England. A
data warehouse is being used to analyze customers’ online activity and includes
performance metrics such as response times for fare quotations. In order to provide a
detailed analysis of the online activity and manage IT resources in London, which of the
following business rules should be applied to the clickstream (weblogs)?
A. retaining web-server local time
B. retaining both Greenwich Mean Time (GMT) and customer’s local time
C. converting all times to Greenwich Mean Time (GMT)
D. retaining customer’s local time
Answer: B
QUESTION 19
According to the SAS Rapid Warehousing Methodology, which of the following are
recommended techniques for gathering high level business requirements during the
Assessment Phase?
A. interviews and workshops only
B. interviews, questionnaires, and workshops
C. process modeling and prototyping
D. interviews, process modeling, and workshops
Answer: D
QUESTION 20
A product table with columns named PRODUCT_ID and COST contains over a million
rows. Assume the following business rule: A product only has one cost value. Which of
the following techniques produces data which can validate the above business rule?
A. conducting a random sample of data on PRODUCT_ID and COST
B. generating a frequency distribution of PRODUCT_ID by COST
C. obtaining all distinct values of PRODUCT_ID
D. selecting a stratified sample with replacement of the data on PRODUCT_ID and
COST
Answer: B
QUESTION 21
Prior to deploying an OLAP solution to 50 users, the OLAP client application must
undergo system testing.
Which of the following must be tested during this phase?
I.security model
II.data volume of the result set
III.number of concurrent users
IV.time to build supporting OLAP data mart
A. I, II, and III only
B. II and IV only
C. I and III only
D. I, II, III, and IV
Answer: A
QUESTION 22
Which of the following are benefits of using a metadata management strategy for a data
warehouse project?
I.It captures operational processes.
II.It enables impact analysis to be performed.
III.It documents the contents of the warehouse.
IV.It stores data transformation and business rules.
A. II, III, and IV only
B. I, II, and III only
C. I and III only
D. I and IV only
Answer: A
QUESTION 23
An interview has been arranged with a business analyst to determine the functional
requirements of a data warehouse. Which of the following should be reviewed in the
discussion?
A. acceptance test plan
B. data model design
C. company standards
D. process for making business decisions
Answer: D
Exam Number/Code: a00-204
Exam Name: sas warehouse architect concepts
Questions Type: Single choice,
“sas warehouse architect concepts”, also known as a00-204 exam, is a SAS Institute certification.
Preparing for the a00-204 exam? Searching a00-204 Test Questions, a00-204 Practice Exam, a00-204 Dumps?
With the complete collection of questions and answers, Pass4sure has assembled to take you through 65 Q&A to your a00-204 Exam preparation. In the a00-204 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: May 12th , 2008
Market Price: $159.99
Member Price: $125.99
Free down:Pass4sure sas a00-204
Free down:Testking a00-204
Related Posts
Related Posts
Tags: a00-204
Leave a Reply