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:  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27   
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
Previous Question         Question   14  /  65        Next Question   

A warehouse is being designed in SAS. User access to the warehouse data will be secure and
web-based.
Which of the following must be considered when planning the physical infrastructure for the web
deployment?
l. storage systems
ll. middleware server
Ill authentication services
IV. graphical user interface
A - II and Ill only
B - Ill and IV only
C - I II, and IV only
D - I, II, and Ill only
 


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)