IndiaBIX

Database - Data Warehousing

Exercise : Data Warehousing - General Questions
6.
A snowflake schema is which of the following types of tables?
Fact
Dimension
Helper
All of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
7.
The generic two-level data warehouse architecture includes which of the following?
At least one data mart
Data that can extracted from numerous internal and external sources
Near real-time updates
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
8.
Fact tables are which of the following?
Completely denoralized
Partially denoralized
Completely normalized
Partially normalized
Answer: Option
Explanation:
No answer description is available. Let's discuss.
9.
Data transformation includes which of the following?
A process to change data from a detailed level to a summary level
A process to change data from a summary level to a detailed level
Joining data from one source into various sources of data
Separating data from one source into various sources of data
Answer: Option
Explanation:
No answer description is available. Let's discuss.
10.
Reconciled data is which of the following?
Data stored in the various operational systems throughout the organization.
Current data intended to be the single source for all decision support systems.
Data stored in one operational system in the organization.
Data that has been selected and formatted for end-user support applications.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers