Microsoft Azure Data Fundamentals — Question 268

What is the primary purpose of a data warehouse?

Answer options

• A. to provide answers to complex queries that rely on data from multiple sources
• B. to provide transformation services between source and target data stores
• C. to provide read-only storage of relational and non-relational historical data
• D. to provide storage for transactional line-of-business (LOB) applications

Correct answer: A

Explanation

The correct answer is A because a data warehouse is specifically designed to handle complex queries that require integrating data from various sources. Option B focuses on data transformation, which is not the primary role of a data warehouse. Option C describes storage capabilities but does not highlight the querying aspect, while option D refers to transactional data storage, which is not the main purpose of a data warehouse.