A BI team needs a centralized store of CLEANED, structured historical data optimized for fast analytical queries and reporting. What is this called?
A.Data lake
Lakes store raw data — not curated-for-BI.
B.Data warehouse
Curated analytics store = warehouse. Correct.
C.OLTP database
OLTP serves transactions — not analytical scans.
D.Message queue
Queues move messages — not analytical storage.
Why this answer
Data warehouse = curated, structured data optimized for analytics (star schemas, columnar storage, MPP). The lake holds raw data; the warehouse holds processed data ready for BI.
Correct answer: B · Last reviewed 2026-11-05
Official AWS references
Practice this interactively
Answer without seeing the solution first in the Analytics on Azure practice session.
Practice Analytics on Azure