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:  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31   
Previous Question             Question   16  /  65            Next Question   
Question Is not available in this preview
Available for regestered users only

To support the extract, transform and load (ETL) process, the warehouse architect is attempting
to determine what data can be made available from the source system. Which of the following
should be reviewed during an interview with the operational source system expert?
A - Database schema
B - Warehouse architecture
C - Business operations issues
D - Analytical queries submitted to the IT department
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   17  /  65        Next Question
Question Is not available in this preview
Available for regestered users only

A warehouse architect is validating tables before adding them to the warehouse process. A
SALES table includes a column named CUSTID which is define as a foreign key in a referential
integrity constraint and references a CUSTOMER table. Which of the following statements must
be true given the above assumptions?
A - The CUSTID column in the SALES table must be fully populated.
B - The CUSTID column in the SALES table must be unique and non-missing.
C - The non-missing values of CUSTID in the SALES table must exist in the CUSTOMER table.
D - For each value of CUSTID in the CUSTOMER table, there must be a corresponding record in
the SALES table.
 
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   18  /  65        Next Question   
Question Is not available in this preview
Available for regestered users only

A star schema data model has been adopted for a data warehouse. A customer dimension
includes a date-of-birth column that is frequently used for analysis. Which of the following
techniques improves the performance of a query based on date-of-birth?
A - Adding an index to the date-of-birth column
B - Modifying the date-of-birth column to four bytes
C - Generating an age column derived from the date-of-birth
D - Creating a composite index on the customer key and date-of-birth columns
 


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)