35)When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is A)dice B)slice C)roll- D)drill down Answer: D Diff: 3 Page Ref: 159 36)What is Six Sigma? A)a letter in the greek al phabet that statisticians use to measure process variability B)a methodology aimed at reducing the number of defects in a business process C)a methodology aimed at reducing the amount of variability in a business process D)a methodology aimed at measuring the amount of variability in a business process Answer: B Diff: 2 Page Ref: 180 37)Real-time data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is A)country of(data)origin B)nature of the data C)speed of data transfe D)source of the data Answer: C Diff: 2 Page Ref: 168 38)A large storage location that can hold vast quantities of data(mostly unstructured) in its native/raw format for future/potential analytics consumption is referred to as a(n) A)extended ASP B)data cloud C)data lake D)relational database Answer: C Diff: 3 Page Ref: 166 39) How does the use of cloud computing affect the scalability of a data warehouse? A)Cloud computing vendors bring as much hardware as needed to users' offices B) Hardware resources are dynamically allocated as use increases C)Cloud vendors are mostly based overseas where the cost of labor is low D)Cloud computing has little effect on a data warehouse's scalabilit Answer Diff: 3 Page Ref: 165-166 Copyright C 2018 Pearson Education, Inc6 Copyright © 2018 Pearson Education, Inc. 35) When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is A) dice. B) slice. C) roll-up. D) drill down. Answer: D Diff: 3 Page Ref: 159 36) What is Six Sigma? A) a letter in the Greek alphabet that statisticians use to measure process variability B) a methodology aimed at reducing the number of defects in a business process C) a methodology aimed at reducing the amount of variability in a business process D) a methodology aimed at measuring the amount of variability in a business process Answer: B Diff: 2 Page Ref: 180 37) Real-time data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is A) country of (data) origin. B) nature of the data. C) speed of data transfer. D) source of the data. Answer: C Diff: 2 Page Ref: 168 38) A large storage location that can hold vast quantities of data (mostly unstructured) in its native/raw format for future/potential analytics consumption is referred to as a(n) A) extended ASP. B) data cloud. C) data lake. D) relational database. Answer: C Diff: 3 Page Ref: 166 39) How does the use of cloud computing affect the scalability of a data warehouse? A) Cloud computing vendors bring as much hardware as needed to users' offices. B) Hardware resources are dynamically allocated as use increases. C) Cloud vendors are mostly based overseas where the cost of labor is low. D) Cloud computing has little effect on a data warehouse's scalability. Answer: B Diff: 3 Page Ref: 165-166