Question - 1
Which of the following statement is true?
The data warehouse consists of data marts and operational data
The operational data are used as a source for the data warehouse
The data warehouse is used as a source for the operational data
All of the above
Show Answer
Solutions
Answer- B
Question - 2
Which of the following features usually applies to data in a data warehouse?
Data are often deleted
Most applications consist of transactions
Data are rarely deleted
Relatively few records are processed by applications
Show Answer
Solutions
Answer- C
Question - 3
The most common source of change data in refreshing a data warehouse is:
Queryable change data
Cooperative change data
Logged change data
Snapshot change data
Show Answer
Solutions
Answer- D
Question - 4
A data warehouse is which of the following?
Can be updated by end users
contains numerous naming conventions and formats
Organized around important subject areas
contains only current data
Show Answer
Solutions
Answer- C
Question - 5
Does the generic two-level data warehouse architecture include:
at least one data mart
data that can extracted from numerous internal and external sources
near real-time updates
All of the above
Show Answer
Solutions
Answer- B
Question - 6
Which of the following is transient data?
Data in which changes to existing records cause the previous version of the records to be eliminated
Data in which changes to existing records do not cause the previous version of the records to be eliminated
Dta that are never altered or deleted once they have been added
Data that are never deleted once they have been added
Show Answer
Solutions
Answer- A
Question - 7
A snowflake schema is which of the following types of tables?
Fact
Dimension
Helper
All of the above
Show Answer
Solutions
Answer- D
Question - 8
Which of the following is a fact table?
Completely denoralized
Partially denoralized
Completely normalized
Partially normalized
Show Answer
Solutions
Answer- C
Question - 9
A star schema has what type of relationship between a dimension and fact table?
Many-to-many
One-to-one
One-to-many
All of the above
Show Answer
Solutions
Answer- C
Question - 10
The role of the ETL process is:
to identify erroneous data and to fix them.
to process the data
to enhance the data
None of these
Show Answer
Solutions
Answer- A
Question - 11
A numeric value with value 0
The absence of a value
A very small value
An erroneous value
Show Answer
Solutions
Answer- B
Question - 12
In the relational database terminology, a table is synonymous with:
A column
A row
An attribute
A relation
Show Answer
Solutions
Answer- D
Question - 13
The term Data Warehouse was first coined by:
Roger Mougalas
Arthur Samuel
Bill Inmon
Herbert Simon
Show Answer
Solutions
Answer- C
Question - 14
In Which year, Data Warehouse was first coined?
Answer- D
Question - 15
How many types of data warehouses are there?
Answer- B
Question - 16
Which of the following involves finding and correcting the errors in data?
Data Extraction
Data Cleaning
Data Transformation
Data Loading
Show Answer
Solutions
Answer- B
Question - 17
To integrate heterogeneous databases, we have ___________ approaches.
Answer- B
Question - 18
time-variant
integrated
subject oriented
All of the above
Show Answer
Solutions
Answer- D
Question - 19
Which one of the following refers to querying the unstructured textual data?
Information access
Information update
Information retrieval
Information manipulation
Show Answer
Solutions
Answer- C
Question - 20
A data warehouse is designed to-
enable and support business intelligence(BI) activities, especially analytics
support processing the data
Both A and B
None of these
Show Answer
Solutions
Answer- A
Practice more set questions