Home > Data Mining > Quizzes > Data warehouse and Data mining: Introduction to Data Warehouse and Dimensional modeling
Data warehouse and Data mining: Introduction to Data Warehouse and Dimensional modeling
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 100% • Most missed: “Fact tables are which of the following?”
Data warehouse and Data mining: Introduction to Data Warehouse and Dimensional modeling
Time left 00:00
25 Questions

1. Most operational systems are based on the use of transient data.
2. Static extract is used for ongoing warehouse maintenance.
3. The generic two-level data warehouse architecture includes which of the following?
4. A goal of data mining includes which of the following?
5. A data mart is designed to optimize the performance for well-defined and predicable uses.
6. Both status data and event data can be stored in a database.
7. Joining is the process of partitioning data according to predefined criteria.
8. Data in operational systems are typically fragmented and inconsistent.
9. A data mart is designed to optimize the performance for well-defined and predicable uses.
10. The @active data warehouse architecture includes which of the following?
11. The load and index is which of the following?
12. A data warehouse is which of the following?
13. Transient data is which of the following?
14. The role of the ETL process is to identify erroneous data and to fix them.
15. A multifield transformation does which of the following?
16. Data transformation includes which of the following?
17. Fact tables are which of the following?
18. Every key used to join the fact table with a dimensional table should be a surrogate key.
19. Independent data marts are often created because an organization focuses on a series of short-term business objectives.
20. Data scrubbing is which of the following?
21. Star schema is suited to online transaction processing and therefore is generally used in operational systems, operational data stores, or an EDW.
22. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
23. A star schema has what type of relationship between a dimension and fact table?
24. Derived data are detailed, current data intended to be single, authoritative source for all decision suport applications.
25. An operational system is which of the following?

⚡ Recently practiced quizzes in this topic
Live quiz activity
Data warehouse and Data mining: Mining Frequent Patterns and Association Rules Data Mining Practice Test Data Mining MCQs Data Mining and Business Intelligence Practice Test Data Mining and Business Intelligence: Clustering Data warehouse and Data mining: ETL Process and OLAP Data warehouse and Data mining: Introduction to Data Mining, Data Exploration and Preprocessing Data Mining and Business Intelligence: Frequent Patterns Data Mining Fundamentals Test Data warehouse and Data mining: Classification, Prediction and Clustering
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.