Data Warehousing
Authored by Firoz Khan
Instructional Technology
Professional Development
Used 20+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which one is correct for data warehousing?
It can be updated by end users
It can solve all business questions
It is designed for focus subject areas
It contains only current data
2.
MULTIPLE SELECT QUESTION
1 min • 1 pt
Which are used in Multi-dimensional modeling?
Foreign key
Fact Table
Dimensional Table
Surrogate key
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which one come first to build data warehouse
Data Cleansing
Business questions
Data Acquisition
Data Profiling
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Why aggregate is used in dimensional model of data warehouse?
To store data in one operational system
To retrieve data from an operational system
To combine data from heterogeneous sources
To take the dimension and change its granularity
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Why do we apply snowflake schema?
Aggregation
Normalization
Generalization
Transformation
6.
MULTIPLE SELECT QUESTION
3 mins • 1 pt
What is metadata in data warehousing? You may answer more than one
Business definition
Data dictionary
BI report
Measures
7.
MULTIPLE SELECT QUESTION
3 mins • 1 pt
What is CORRECT about data warehouse? You may answer more than one
It makes use of historical data to answer business questions
It reveals insight from data
It supports roll-up and drill-down to explore data
Its design is the same as database
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
