Font size
WorksheetsData Warehouse - Foundations 2
Total questions: 18
Worksheet time: 29mins
Data mining means______
data fetching
data accesing
knowledge discovery
Is the data in a data warehouse generally updated in real-time?
Yes
No
What does the acronym ETL stands for?
Explain,Transfer and Lead
Extract,Transform and Load
Extract,Transfer and Load
Effect,Transfer and Load
What is the system of data warehousing mostly used for?
Data integration and Data Mining
Data Mining and Data Storage
Reporting and Data Analysis
Data Cleaning and Data Storage
Which small logical units do data warehouses hold large amounts of information?
Data Storage
Data Marts
Access Layers
Data Miners
Why data analysis is needed? (select all that apply)
require tactical and strategic decisions
business environment is dynamic
search for competitive advantage
to get more public attention
The main characteristics of online analytical processing:
Use single dimension data analysis techniques
Provide advanced database support (drill-down/roll-up)
Provide low level user interface
Do not support client/server architecture
Why do we need ODS? You may answer multiple correct answers
To isolate from production
To update data periodically
To prepare data for ETL
To back up data
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
Which one come first to build data warehouse
Data Cleansing
Business questions
Data Acquisition
Data Profiling
Why do we apply snowflake schema?
Aggregation
Normalization
Generalization
Transformation
What is WRONG about surrogate key?
It is a list of running numbers
It is a primary key of fact table
It is designed for handling slowly change dimension problem
It is the join key between fact and dimension table
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
What is the relationship type between fact and dimension table in star schema?
Many-to-Many
One-to-One
One-to-Many
Many-to-One
