Database - Data Warehousing
|
|
|
|
Exercise"Everything you can imagine is real."
- Pablo Picasso
|
| 6. |
A snowflake schema is which of the following types of tables? |
| A. |
Fact | | B. |
Dimension | | C. |
Helper | | D. |
All of the above |
Answer: Option E
Explanation:
No answer description available for this question. Let us discuss.
|
| 7. |
The generic two-level data warehouse architecture includes which of the following? |
| A. |
At least one data mart | | B. |
Data that can extracted from numerous internal and external sources | | C. |
Near real-time updates | | D. |
All of the above. |
Answer: Option D
Explanation:
No answer description available for this question. Let us discuss.
|
| 8. |
Fact tables are which of the following? |
| A. |
Completely denoralized | | B. |
Partially denoralized | | C. |
Completely normalized | | D. |
Partially normalized |
Answer: Option A
Explanation:
No answer description available for this question. Let us discuss.
|
| 9. |
Data transformation includes which of the following? |
| A. |
A process to change data from a detailed level to a summary level | | B. |
A process to change data from a summary level to a detailed level | | C. |
Joining data from one source into various sources of data | | D. |
Separating data from one source into various sources of data |
Answer: Option C
Explanation:
No answer description available for this question. Let us discuss.
|
| 10. |
Reconciled data is which of the following? |
| A. |
Data stored in the various operational systems throughout the organization. | | B. |
Current data intended to be the single source for all decision support systems. | | C. |
Data stored in one operational system in the organization. | | D. |
Data that has been selected and formatted for end-user support applications. |
Answer: Option B
Explanation:
No answer description available for this question. Let us discuss.
|
|
|
