sasbaseprogrammingforsas-全文預(yù)覽
【正文】 oins from a live relational database management system (RDBMS) transactional system. Which of the following are possible negative effects of the above action? I. two phase mit locking II. blocking transaction mits III. exhausting temporary table space IV. degraded OLTP query performance A. I and II only B. III and IV only C. I, II, and III D. II, III, and IV correct_answer = D SAS Warehouse Development Specialist Item 1 Which of the following is most important when deciding on the data structure of a data mart? A. data access tools to be used B. XML data exchange standards C. metadata naming conventions D. extract, transform, and load (ETL) tool to be used correct_answer = A Item 2 For a particular project, legal regulations require that only current data for an individual is stored in the CUSTOMER dimension of a data warehouse. According to The Data Warehouse Toolkit, by Ralph Kimball, which of the following slowly changing dimension techniques is the most appropriate for updating the CUSTOMER dimension? A. Type I B. Type II C. Type III D. Type IV correct_answer = A Item 3 Within SAS/Warehouse Administrator, which of the following actions may be enabled by the metadata record such that a data source is visible in a data warehouse environment? I. Defining the extraction process II. Registering the location of a DBMS table III. Registering the location of a SAS table or view IV. Defining the logical and physical models represented A. I and II only B. III and IV only C. I, II and III only D. I, II, III and IV correct_answer = C Item 4 Which of the following enable changed data capture from a source system with no date/time modification stamps? I. Use a program to read the database log files to detect changed records. II. Process a plete refresh from the source system into the data warehouse. III. Identify an effective date within the source data and utilize it to detect changes. IV. Compare the current warehouse data to the full source input and generate deltas. A. I and II only B. II and III only C. I and IV only D. III and IV only correct_answer = C Item 5 Which of the following ste
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1