Data Warehousing Review Questions
Course Introduction
Data Warehousing is a course that introduces students to the concepts, architectures, and technologies used in the storage, retrieval, and management of large volumes of data for analytical processing and decision support. The course covers the design and implementation of data warehouses, including data modeling (star and snowflake schemas), ETL (Extract, Transform, Load) processes, data integration, and the use of OLAP (Online Analytical Processing) tools. Students will also explore best practices for maintaining data quality, managing metadata, and optimizing query performance in data warehousing environments. Through theoretical instruction and practical exercises, learners will gain the skills necessary to design and manage effective data warehousing solutions in real-world organizations.
Recommended Textbook
Business Intelligence 2nd Edition by Efraim Turban Ramesh Sharda
Available Study Resources on Quizplus
6 Chapters
415 Verified Questions
415 Flashcards
Source URL: https://quizplus.com/study-set/1402
Page 2
Chapter 1: Business Intelligence
Available Study Resources on Quizplus for this Chatper
65 Verified Questions
65 Flashcards
Source URL: https://quizplus.com/quiz/27901
Sample Questions
Q1) ________ are now extremely compressed; faster, more informed, and better decision making is therefore a competitive imperative.
Answer: Business cycle times
Q2) Business intelligence (BI) combines architectures, tools, ________, analytical tools, applications, and methodologies.
Answer: databases
Q3) The process of business intelligence is based on the ________ of data to information, then to decisions, and finally to actions.
Answer: transformation
Q4) List two BI analytical applications and their business value.
Answer: See Table 1.2 in textbook.
Q5) ________ is a process of searching for unknown relationships or information in large databases or data warehouses, using intelligent tools.
Answer: Data mining
Q6) Dashboards and information portals are important BI data visualization tools. A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Data Warehousing
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/27902
Sample Questions
Q1) ________ is a small data warehouse designed for a strategic business unit (SBU) or a department.
Answer: Independent data mart
Q2) EII (enterprise information integration) tools use predefined metadata to populate views that make integrated data appear relational to end-users. ________ may be the most important aspect of EII, because it allows data to be tagged either at the time of creation or later.
Answer: Extensible markup language (XML)
Q3) An ________ is a large-scale data warehouse that is utilized across the enterprise for decision support.
Answer: enterprise data warehouse (EDW)
Q4) A data warehouse maintains historical data that do not necessarily provide current status, except in real-time systems. A)True
B)False
Answer: True
Q5) Describe or sketch two alternative architectures to the basic architectural design types in data warehousing.
Answer: See Figure 2.5 in the textbook.
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Business Performance Management
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/27903
Sample Questions
Q1) ________ focuses on the elimination of waste or non-value-added activities.
Answer: Lean
Q2) Sigma, , is a Greek alphabet letter used by statisticians to measure the ________ in a process.
A) variance
B) mean
C) inconsistency
D) variability
Answer: D
Q3) The Palladium Group found that 75 percent of organizations tied their budgets to their strategic plans.
A)True
B)False
Answer: False
Q4) ________ focuses on reducing the variation or improving the consistency of a process.
Answer: Six Sigma
Q5) ________ refers to both the logical and physical design of a system.
Answer: System architecture
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Data Mining for Business Intelligence
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/27904
Sample Questions
Q1) Explain the simple split methodology for classification. Explain the advantages of the k-fold cross-validation methodology over the simple split methodology.
Q2) ________ partitions a collection of things, such as objects and events stored in a dataset, into segments whose members share similar characteristics.
Q3) Because the data mining is driven by experience and experimentation, depending on the problem situation and the analyst's knowledge, the whole process can be ________ and ________, i.e., one should expect to go back and forth through the steps quite a few times.
A) simple; iterative
B) expensive; hypothetical
C) time consuming; iterative
D) time consuming; hypothetical
Q4) Data mining is a prime candidate for better management of companies that are data-rich, but knowledge-poor.
A)True
B)False
Q5) Sketch a simple taxonomy of data in data mining.
Q6) Identify and describe the two types of numerical data. Give an example of each.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Text and Web Mining
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/27905
Sample Questions
Q1) ________ analysis is a technique used to detect favorable and unfavorable opinions toward specific products and services using textual data sources, such as customer feedback in Web postings and the detection of unfavorable rumors.
Q2) Why does the Web pose great challenges for effective and efficient knowledge discovery?
A) The Web search engines are indexed-based.
B) The Web is too dynamic.
C) The Web is too specific to a domain.
D) The Web infrastructure contains hyperlink information.
Q3) Amazon.com leverages Web usage history dynamically and recognizes the user by reading a cookie written by a Web site on the visitor's computer.
A)True
B)False
Q4) The quality of search results is impossible to measure accurately using strictly quantitative measures such as click-through rate, abandonment, and search frequency. Additional quantitative and qualitative measures are required.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Business Intelligence Implementation:
Integration and Emerging Trends
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/27906
Sample Questions
Q1) One of the significant differences between Web 2.0 and the traditional Web is the ________ of Web 2.0.
A) enhanced privacy and security protection
B) opportunity to offer decision support capabilities in a novel way
C) greater collaboration among Internet users and other users, content providers, and enterprises
D) All of the above.
Q2) A major objective of Web 2.0 is to enhance creativity, information sharing, and ________.
Q3) RFID tag data for products consist of the following information except:
A) manufacturer
B) carrier
C) product
D) serial number
Q4) Without committed management support and sponsorship a business implementation has a high risk of failure.
A)True
B)False
Page 8
Q5) List four characteristics and benefits of SaaS.
Q6) What is the main function of middleware?
To view all questions and flashcards with answers, click on the resource link above.
Page 9