Font size
WorksheetsEnterprise Data Management
Total questions: 30
Worksheet time: 45mins
The term Data Warehouse was coined by Bill Inmon in 1990, which
he defined in the following way:
"A warehouse is a subject-oriented, integrated, stable and volatile collection of data in support of management's decision making process".
"A warehouse is a subject-oriented,integrated, time-variant and non-volatile collection of data in support of management's decision making process".
Both A and B
None of above
Definition of Subject Oriented Data: Data that gives information about a particular subject
instead of about a company's ongoing operations.
True
False
Definition of Integrated Data: Data that is gathered into the data warehouse from a variety of sources and merged into a coherent whole.
True
False
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
When customer change address, we can overwrite the existing record.
True
False
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
What is metadata in data warehousing? You may answer more than one
Business definition
Data dictionary
BI report
Measures
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
Data warehouse is subject-oriented
True
False
What is data to describe data in data warehouse?
Relational data
Operational data
Informational data
Metadata
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
data warehousing used in_______________
transaction system
decision support system
a data warehouse can include
flat-files
database table
online data
all
Using features to predict unknown or future values of the same or other feature is known as ___________ power of data mining
Clustering
Predictive
Associative
Descriptive
"Process of sifting through large data sets to identify and describe patterns, discover and establish relationships with an intent to predict future trends based on those patterns and relationships". What does this statement explain about?
Visualization
Representation
Data mining
Business intelligence
Select the skills mainly required as a competent data analyst/scientist/miner
SQL
R
Python
Java
Data mining process includes reporting and analysis
True
False
Focus on the specific organisation data to detect patterns
True
False
