sasbaseprogrammingforsas(编辑修改稿)

sasbaseprogrammingforsas(编辑修改稿)内容摘要：

set。 where date 39。 31mar202039。 d or revenue 50000。 run。 correct_answer = A SAS Warehouse Architect Concepts Item 1 A warehouse architect is trying to determine what data must be included in the warehouse. A meeting has been arranged with a business analyst to understand the data requirements. According to The Data Warehouse Lifecycle Toolkit by Ralph Kimball, which of the following should be included on the agenda? A. number of users B. routine reporting C. database design D. corporate objectives correct_answer = B Item 2 According to the SAS Rapid Warehouse Methodology, which of the following occurs during the Final Test phase? I. system test II. integration test III. performance test IV. change management A. I and III only B. I, II, and III only C. I, III, and IV only D. I, II, III, and IV correct_answer = C Item 3 A client has a customeroriented data mart currently in place. A new data mart is being developed using customer information from the current data mart and a new customeroriented data source. There is a requirement to provide rollups across data marts using this customer information. Which of the following meets this requirement? A. building a separate customer dimension for each data mart B. appending both customer sources and adding attributes identifying the source from where customer information was derived C. using a surrogate primary key similar to the production systems so that they may be reused or merged with other system keys D. building a conformed customer dimension by creating a master table of customers with a clean customer key and many wellmaintained attributes correct_answer = A Item 4 A warehouse architect has pleted the logical design of a dimensional data model and is developing the corresponding physical model. Which of the following must be considered in the physical design of the dimensional data model? I. data volume II. usage patterns III. source data repository IV. warehouse data repository A. I and II only B. I and IV only C. I, II, and IV D. II, III, and IV correct_answer = C Item 5 A large data warehouse source extract requires table。