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

	Web www.certsbraindumps.com