
Data Warehouse MCQ
Quiz by Roseline Vaseehar
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
10 questions
Show answers
- Q1The full form of OLAP isOnline Advanced ProcessingOnline Advanced PreparationOnline Analytical ProcessingOnline Analytical Performance20s
- Q2__________is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.Data MiningDocument MiningData WarehousingText Mining20s
- Q3The data is stored, retrieved and updated inSMTPOLTPOLAPKDD20s
- Q4An ___________ system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.OLTPOLAPBoth of the aboveNone of the above20s
- Q5___________ is a good alternative to the star schema.Fact constellationSnowflake schemaStar-snowflake schemaStar schema20s
- Q6Data modeling technique used for data marts isDimensional modelingExtended ER modelSchemaER Model20s
- Q7The data from the operational environment enter _______ of data warehouse.Lightly summarized dataOlder detail dataCurrent detail dataHighly summarized data20s
- Q8The data Warehouse is__________.Read OnlyNoneWrite OnlyRead Write Only20s
- Q9Rollup is aslo known asRegressionConsolationIncreasing a dimensionAggregation20s
- Q10The Slice operation select ____________ dimension from a given cube.210More20s