Microsoft AI-102 Question Answer
What is the primary purpose of a data warehouse?
to provide storage for transactional line-of-business (LOB) applications
to provide transformation services between source and target data stores
to provide read only storage of relational and non relational historical data
to provide answers to complex queries that rely on data from multiple sources
A data warehouse is designed for analytical workloads (OLAP), not transactional workloads (OLTP).
It integrates data from multiple sources and supports complex queries, aggregations, and reporting for decision-making.
A. storage for transactional LOB apps → describes OLTP (e.g., SQL Server, Azure SQL Database), not a data warehouse.
B. transformation services → describes ETL/ELT pipelines (e.g., Data Factory), not the warehouse itself.
C. read-only storage of historical data → partially true but too narrow; the key feature is analytics, not just storage.
D. answers to complex queries across multiple sources → Correct and complete definition.
Correct Answer: D
TESTED 03 Dec 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved