DP-900 · Question #169
What is the primary purpose of a data warehouse?
The correct answer is A. to provide answers to complex queries that rely on data from multiple sources. A data warehouse is relational in nature. This means that the structure or schema of the data is determined by predefined business and product requirements that are curated, conformed, and optimized for SQL query operations. As a result, data warehouses are best used for…
Question
Options
- Ato provide answers to complex queries that rely on data from multiple sources
- Bto provide transformation services between source and target data stores
- Cto provide read-only storage of relational and non-relational historical data
- Dto provide storage for transactional line-of-business (LOB) applications
How the community answered
(36 responses)- A86% (31)
- B3% (1)
- C3% (1)
- D8% (3)
Explanation
A data warehouse is relational in nature. This means that the structure or schema of the data is determined by predefined business and product requirements that are curated, conformed, and optimized for SQL query operations. As a result, data warehouses are best used for storing data that has been treated with a specific purpose in mind, such as data mining for BI analysis, or for sourcing a business use case that has already been identified. https://azure.microsoft.com/en-us/resources/cloud-computing-dictionary/what-is-a-data-
Topics
Community Discussion
No community discussion yet for this question.