Home > Databases > Quizzes > Advance Data Management Technology: Data Warehousing, Dimensional Modeling and OLAP
Advance Data Management Technology: Data Warehousing, Dimensional Modeling and OLAP
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 17% • Most missed: “Which of the following indicates the maximum number of entites that can be invol…”
Advance Data Management Technology: Data Warehousing, Dimensional Modeling and OLAP
Time left 00:00
25 Questions

1. Business Intelligence and data warehousing is used for …………..
2. Which of the following mode allows for the collection and uploading of data to occur on demand?
3. The data from the operational environment enter …………………… of data warehouse.
4. A data warehouse is ………………….
5. Due to normalization in the Snowflake schema, the redundancy is reduced and therefore, it becomes easy to maintain and save the storage space.
6. …………………….. supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting.
7. Data Warehouse OLAP provides summarized and multidimensional view of data.
8. Which is also known as galaxy schema?
9. Which of the following indicates the maximum number of entites that can be involved in a relationship ?
10. Which of the following scenario favours cached mode?
11. An operationa system is which of the following?
12. A database uses relational model, while a data warehouse uses
13. What does collector_type_id stands for in the following code snippet?
14. ………………. are responsible for running queries and reports against data warehouse tables.
15. Data warehouse architecture is based on …………………..
16. Normalization splits up the data into additional tables.
17. A recursive relationship is a relationship between an entity and ________ .
18. Data that can be modeled as dimension attributes and measure attributes are called _______ data.
19. Which type of entity represents an actual occurrence of an associated generalized entity?
20. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
21. Point out the wrong statement.
22. The core of the multidimensional model is the ………………….. , which consists of a large set of facts and a number of dimensions.
23. A goal of data mining includes which of the folowng?
24. OLAP stands for
25. List the Schema that a data warehouse system can implement.

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ 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.