Home > Data Warehousing > Quizzes > Data Warehousing Fundamentals Test
Data Warehousing Fundamentals Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 8% • Most missed: “Under OLAP terminology - slice and dice refers to:”
Data Warehousing Fundamentals Test
Time left 00:00
25 Questions

1. Data quality management refers to the fact that:
2. Which of the following is not true regarding an OLTP system?
3. The data warehouse is typically a large database on a high performance SMP system. Here SMP stands for:
4. Which technique of Data Mining involves developing mathematical structures with the ability to learn?
5. Which Data Mining technique partitions the database so that each partition or group is similar according to some criteria or metric ?
6. Which of the following features are required by OLAP applications?
7. Which of the following is not associated with data warehousing?
8. A Star Schema is a database design that consists of:
9. The applications of Data Mining would not include:
10. In a star schema - a table which contains data about one of the dimensions is called a:
11. Normalisation is:
12. Which of the following would not be considered as a variable affecting the design of an OLAP system?
13. In which component of the enterprise is the data re-organised for analysis and information extracted from the data?
14. OLAP queries can be characterised as on-line transactions that do not:
15. The main objective of Data Mining is:
16. Which Data Mining function/technique is used to analyse a collection of records over a period of time?
17. Which of the following would not be an application of Data Mining in the banking field?
18. Which of the following rules would be considered the central core of OLAP?
19. Under OLAP terminology - slice and dice refers to:
20. Which of the following would be the only similarity between a datawarehouse and OLTP system?
21. Which of the following stage is concerned with the extraction of patterns from the data?
22. SQL stands for:
23. A means of extending the data accessible to the end user beyond that which is stored in the OLAP server is know as :
24. Which of the following type of data is most likely to be stored on some form of mass storage ?
25. The logical organisation of data in a database is called:

⚡ Recently practiced quizzes in this topic
Live quiz activity
Data Mining and Data Warehouse Practice Test Data Warehousing Fundamentals Test 2
 
❤ 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.