Home > Databases > Quizzes > Advance Data Management Technology: ETL Process
Advance Data Management Technology: ETL Process
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 22% • Most missed: “Expansion for DSS in DW is”
Advance Data Management Technology: ETL Process
Time left 00:00
25 Questions

1. Dimensionality refers to
2. A definition of a concept is—–if it recognizes all the instances of that concept
3. _______ are numeric measurements or values that represent a specific business aspect or activity
4. The log is a sequence of _________ recording all the update activities in the database.
5. The @active data warehouse architecture includes which of the following?
6. :Data selection is
7. In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.
8. A special redo-only log record < Ti, Xj, V1> is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called
9. The actions which are played in the order while recording it is called ______________ history.
10. What is true of storing data in DW?
11. A fact is said to be fully additive if __________.
12. Fact tables are described by which of the following?
13. If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.
14. ____________ using a log record sets the data item specified in the log record to the old value.
15. Data in a data warehouse
16. Data cubes can grow to n-number of dimensions, thus becoming _______
17. A star schema has what type of relationship from a dimension to the fact table?
18. A data warehouse
19. __________ predicts future trends & behaviors, allowing business managers to make knowledge-driven decisions
20. The main organisational justification for implementing a data warehouse is to provide
21. :A definition or a concept is————- if it classifies any examples as coming within the concept
22. Data warehouse contains ________data that is seldom found in the operational environment
23. An operational system is which of the following?
24. ___________ is a good alternative to the star schema.
25. A data warehouse is described by which of the following?

⚡ 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.