Q. Which of the following is NOT a benefit of data warehousing?
-
A.
Improved data quality
-
B.
Enhanced data analysis capabilities
-
C.
Increased transaction speed
-
D.
Consolidated data from multiple sources
Solution
Data warehousing focuses on analytical processing rather than transaction speed, which is a characteristic of operational databases.
Correct Answer:
C
— Increased transaction speed
Learn More →
Q. Which of the following is NOT a type of data warehouse architecture?
-
A.
Single-tier architecture
-
B.
Two-tier architecture
-
C.
Three-tier architecture
-
D.
Multi-dimensional architecture
Solution
Multi-dimensional architecture is not a recognized type of data warehouse architecture; the common types are single-tier, two-tier, and three-tier.
Correct Answer:
D
— Multi-dimensional architecture
Learn More →
Q. Which of the following is NOT a typical use case for a data warehouse?
-
A.
Business intelligence reporting
-
B.
Data mining
-
C.
Real-time transaction processing
-
D.
Historical data analysis
Solution
Data warehouses are not typically used for real-time transaction processing, which is better suited for operational databases.
Correct Answer:
C
— Real-time transaction processing
Learn More →
Showing 31 to 33 of 33 (2 Pages)
