23 quiz - Question 1 1 out of 1 points A data warehouse...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Question 1 1 out of 1 points A data warehouse contains ________ about how data are organized and how to use them effectively. Answer Selected Answer: metadata Correct Answer: metadata Question 2 1 out of 1 points A star schema contains a central ________ surrounded by several dimension tables. Answer Selected Answer: fact table Correct Answer: fact table Question 3 1 out of 1 points Data warehouse is a(n) ________, integrated, time-variant, nonvolatile collection of data in support of management's decision making process. Answer Selected Answer: subject-oriented Correct Answer: subject-oriented Question 4 1 out of 1 points ETL process consists of extract, transform, and load. Transformation occurs by using ________ or lookup tables or by combining the data with other data. Answer Selected Answer: rules Correct Answer: rules Question 5 1 out of 1 points Guidelines that need to be considered when developing a vendor list include all of the following except: Answer Selected Answer: trade shows Correct Answer: trade shows Question 6 1 out of 1 points Karacsony indicates that there is a direct correlation between the extent of ________ data and the amount of ETL processes. When data are managed correctly as an enterprise asset, ETL efforts are significantly reduced. Answer Selected Answer: redundant Correct Answer: redundant Question 7 1 out of 1 points Once data are entered into the warehouse, users cannot change or update the data. Obsolete data are discarded, and changes are recorded as new data. This ________ characteristic is one of the characteristics of data warehousing.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Answer Selected Answer: nonvolatile Correct Answer: nonvolatile Question 8 1 out of 1 points The ________ have inconsistent data definitions and different dimensions and measures, making it difficult to analyze data across those marts. Answer Selected Answer: independent data marts Correct Answer: independent data marts Question 9 1 out of 1 points The advantage of three-tier architecture for data warehousing is its separation of the functions of the data warehouse, which eliminates resource constraints and makes it possible to easily create data ________. Answer Selected Answer: marts Correct Answer: marts Question 10 1 out of 1 points The high cost of data warehouses limits their use to large companies. As an alternative, many firms use a lower-cost, scaled-down version of a data warehouse referred to as (an) ________. Answer Selected Answer: independent data mart Correct Answer: independent data mart Question 11 1 out of 1 points Users demanding access via PDAs and through speech recognition and synthesis is becoming more commonplace, further complicating ________ issues. Answer Selected Answer: data integration Correct Answer: data integration Question 12 1 out of 1 points When DirectTV decided to implement an active data warehouse solution, the goal of the new system was to send fresh data to the call center at least daily. Once the capabilities of the solutions became apparent, that goal:
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/07/2012 for the course MIS 523 taught by Professor Li during the Spring '11 term at Springfield.

Page1 / 22

23 quiz - Question 1 1 out of 1 points A data warehouse...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online