HOME    CONTACT US    FAQ          MY ACCOUNT   LOGIN   REGISTER  
You are here : ››› ››› ›››
Exam Rate (A00-204) 13 users reviews.
SAS Warehouse Architect Concepts ( A00-204 )
Exam : A00-204
To download the latest most up-to-date Q & A of this exam please click on the download button or contact us for further details
Pages:  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26   
Previous Question             Question   11  /  65            Next Question   

Which of the following are benefits of using a metadata management strategy for a data
warehouse project?
l. It captures operational processes.
ll. It enables impact analysis to be performed.
lIl. It documents the contents of the warehouse.
lV. lt stores data transformation and business rules.
A - l and IV only
B - l and Ill only
C - I, II, and Ill only
D - II, Ill, and IV only
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   12  /  65        Next Question

During the Final Test phase of a data warehouse project, a team wishes to verify that the extract,
transform and load (ETL) routines avoid failing when the data volume is increased. Which of the
following tests should be conducted?
A - Stress testing
B - System testing
C - Acceptance testing
D - Performance testing
 
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   13  /  65        Next Question   

Click on the Exhibit button to view a transactional fact table of Automated Teller Machine (ATM)
transactions.
A warehouse architect wishes to create a periodic snapshot schema from this design.
Which of the following characteristics are true regarding the periodic snapshot tact table?
l. Additive facts can exist in this fact table.
lI. The fact table must include the surrogate transaction key.
lll. Semi-additive facts, such as average daily balance, can exist in this fact table.
IV. The transaction fact table and the snapshot fact table can be used together to obtain a
complete picture of account activity.
A - l and II only
B - l and Ill only
C - I, III, and IV only
D - I, II, Ill, and IV
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Exam Features
Success Guaranteed
Instant Download
24/7 Customer Support
Lowest price guaranteed


  
Facebook
See also
Most Popular Exams
(A00-211) SAS Base Programming for SAS (r) 9
(A00-212) SAS Advanced Programming for SAS 9
(A00-260) SAS Data Integration Development
(A00-250) SAS Platform Administration for SAS9
(A00-281) Clinical Trials Programming Using SAS 9 Accelerated Version
(A00-270) SAS BI Content Development
(A00-201) sas base programming exam
(A00-280) SAS Certified Clinical Trials Programmer Using SAS 9
(A00-211_V2) SAS Base Programming for SAS (r) 9
(A00-202) Advanced programming
(A01-250) SAS Platform Administration
(A00-260_V2) SAS Data Integration Development
(A00-204) SAS Warehouse Architect Concepts
(A00-206) SAS Warehouse Technology Exam
(A00-205) SAS Webaf Server-Side Application Development
(A00-203) Sas Warehouse Development Specialist Concepts
All Related Exams
Exam NameCode
sas base programming exam (A00-201)
Advanced programming (A00-202)
Sas Warehouse Development Specialist Concepts (A00-203)
SAS Warehouse Architect Concepts (A00-204)
SAS Webaf Server-Side Application Development (A00-205)
SAS Warehouse Technology Exam (A00-206)
SAS Base Programming for SAS (r) 9 (A00-211)
SAS Advanced Programming for SAS 9 (A00-212)
SAS Platform Administration for SAS9 (A00-250)
SAS Data Integration Development (A00-260)
SAS BI Content Development (A00-270)
SAS Certified Clinical Trials Programmer Using SAS 9 (A00-280)
Clinical Trials Programming Using SAS 9 Accelerated Version (A00-281)
SAS Platform Administration (A01-250)
SAS Base Programming for SAS (r) 9 (A00-211_V2)
SAS Data Integration Development (A00-260_V2)
SAS Advanced Programming (A00-212_V2)
SAS Advanced Programming Exam (A00-202_V2)
SAS Statistical Business Analysis SAS9: Regression and Model (A00-240)
Clinical Trials Programming Using SAS 9 (A00-280_v2)