MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Data Warehousing
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
Both status data and event data can be stored in a database.
True
False
Q.2
Static extract is used for ongoing warehouse maintenance.
True
False
Q.3
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
True
False
Q.4
Every key used to join the fact table with a dimensional table should be a surrogate key.
True
False
Q.5
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
True
False
Q.6
A data mart is designed to optimize the performance for well-defined and predicable uses.
True
False
Q.7
Joining is the process of partitioning data according to predefined criteria.
True
False
Q.8
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
True
False
Q.9
The role of the ETL process is to identify erroneous data and to fix them.
True
False
Q.10
The load and index is which of the following?
A process to reject data from the data warehouse and to create the necessary indexes
A process to load the data in the data warehouse and to create the necessary indexes
A process to upgrade the quality of data after it is moved into a data warehouse
A process to upgrade the quality of data before it is moved into a data warehouse
Q.11
Data in operational systems are typically fragmented and inconsistent.
True
False
Q.12
Most operational systems are based on the use of transient data.
True
False
Q.13
Independent data marts are often created because an organization focuses on a series of short-term business objectives.
True
False
Q.14
Data in the data warehouse are loaded and refreshed from operational systems.
True
False
Q.15
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
True
False
Q.16
Periodic data are data that are physically altered once added to the store.
True
False
Q.17
The extract process is which of the following?
Capturing all of the data contained in various operational systems
Capturing a subset of the data contained in various operational systems
Capturing all of the data contained in various decision support systems
Capturing a subset of the data contained in various decision support systems
Q.18
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
Q.19
Transient data is which of the following?
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
Data that are never altered or deleted once they have been added
Data that are never deleted once they have been added
Q.20
A multifield transformation does which of the following?
Converts data from one field into multiple fields
Converts data from multiple fields into one field
Converts data from multiple fields into multiple fields
All of the above
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page