Testking A00-204 Exam :SAS Warehouse Architect Concepts
Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcamp A00-204 Exam :SAS Warehouse Architect Conceptstk a00-204Interactive Testing Engine Included!
65 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Add to Cart
SAS Institute A00-204 Exam
Exam A00-204: SAS Warehouse Architect Concepts
QUESTION 1
A data warehouse is being designed to allow analysis of a retail bank’s customers.
Customers can have one or more accounts and an account can be owned by one or more
customers. An account fact table stores data by month and by account. Which of the
following describes the model for the above business scenario?
A. a customer dimension and an account dimension connected with a bridge table
B. a fact table with customer and account dimension foreign keys
C. a customer dimension with a foreign key to the account dimension
D. an account dimension with a foreign key to the customer dimension
Answer: A
QUESTION 2
During warehouse process and architecture planning, which of the following are required
inputs for an effective gap analysis of the operational source systems?
I.detailed logical models
II.locations of source data
III.detailed physical models
IV.business requirements document
A. III and IV only
B. I, III, and IV only
C. I and III only
D. I, II, and IV only
Answer: B
QUESTION 3
Which of the following statements is true regarding the creation and definition of the
corporate subject model?
A. It helps confirm the understanding of the business.
B. Each subject must be comprehensively modeled.
C. It is a combined result of the logical and dimensional modeling processes.
D. The information needed to create the subject model is captured during the
Requirements Phase.
Answer: A
QUESTION 4
A business analyst has developed a credit scoring model and wishes to apply this to all
the customers in a denormalized table. The input table contains over 10 million rows and
the output is to be retained for detailed analysis. Which of the following techniques
optimizes performance?
A. sampling
B. ensuring that the WORK library is on a different disk
C. indexing
D. retaining only the columns required for the analysis
Answer: D
QUESTION 5
The extract, transform and load (ETL) process for building a data mart consists of a very
small SAS data set joined with a very large database management system (DBMS) table.
SAS/ACCESS technology will be used in the join process. The subset of the DBMS data
required for the join will be retrieved into SAS. Which of the following enables this
retrieval?
A. using the DBKEY option
B. extracting the entire universe of data from the DBMS for the join processing
C. using cost-based optimizer on the DBMS
D. using the BULKLOAD option
Answer: A
QUESTION 6
Which of the following must be considered when sizing disk space for a SAS data
warehouse after the extract, transform and load (ETL) phase?
I.catalog space
II.transaction log space
III.temporary table space
IV.size of the fact and dimension tables
A. II, III, and IV only
B. I, II, and III only
C. I, II, III, and IV
D. I and IV only
Answer: A
QUESTION 7
Users of a warehouse request that a series of reports be generated and distributed on a
monthly basis. In addition, the users want dynamic notification when any report
information has been updated. Which of the following meets the above requirements?
A. developing distributed object models using COM
B. publishing and subscribing via message-oriented middleware technologies
C. developing distributed object models using CORBA
D. using LDAP enterprise directory services
Answer: B
QUESTION 8
Which of the following is the most useful for creating physical tables and relationships in
an Oracle database management system (DBMS)?
A. spreadsheet
B. entity-relationship (E/R) diagram
C. subject model
D. data definition language with SQL
Answer: D
QUESTION 9
Which of the following statements regarding subjects are true?
I.Subjects will vary by industry sector.
II.Subjects are described by their name, attributes, and relations.
III.Subjects correspond exactly with the entities in the logical data model.
IV.Subjects are major areas of interest for organizations to collect information.
A. I, III, and IV only
B. I, II, and IV only
C. II and III only
D. I and IV only
Answer: D
QUESTION 10
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. analytical queries submitted to the IT department
C. business operations issues
D. warehouse architecture
Answer: A
QUESTION 11
The SAS Open Metadata Architecture is a general-purpose metadata management facility
that provides common metadata services to SAS applications.
Which of the following are true of the SAS Open Metadata Architecture?
I.It contains a SAS Metadata Server.
II.It contains a SAS Metadata Model.
III.It utilizes a SAS Open Metadata Interface.
IV.It utilizes an XML transport format and XML representation of metadata.
A. I and II only
B. II, III, and IV only
C. I and III only
D. I, II, III, and IV
Answer: D
II.It contains a SAS Metadata Model.
III.It utilizes a SAS Open Metadata Interface.
IV.It utilizes an XML transport format and XML representation of metadata.
A. I and II only
B. II, III, and IV only
C. I and III only
D. I, II, III, and IV
Answer: D
Related Posts
Related Posts
Tags: a00-204
One Response to “Testking A00-204 Exam :SAS Warehouse Architect Concepts”
September 27th, 2008 at 6:12 am
[...] sas advanced programming exam Testking a00-203 sas warehouse development specialist concepts exam Testking a00-204 sas warehouse architect concepts Testking a00-205 sas webaf server-side application development [...]
Leave a Reply