Data Warehousing
Authored by sathi v
Computers
University
CCSS covered
Used 37+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
72 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
3 mins • 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
3 mins • 1 pt
Which are used in Multi-dimensional modeling?
Foreign key
Fact Table
Dimensional Table
Surrogate key
3.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
Which one come first to build data warehouse
Data Cleansing
Business questions
Data Acquisition
Data Profiling
4.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
Why do we apply snowflake schema?
Aggregation
Normalization
Generalization
Transformation
5.
MULTIPLE SELECT QUESTION
3 mins • 1 pt
What is importance of data profiling to data warehousing? You may answer more than one answer
It helps to aggregate data
It helps to understand data
It helps to detect abnormality in data
It helps to generate sample data
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?
