Exam DP-900 topic 1 question 160 discussion

A is more logical.

The ans should be A. In the textbook DP-900T00-A-Microsoft Azure Data Fundamentals Module 4 Describe modern data warehousing: ''A data warehouse gathers data from many different sources within an organization...The focus of a data warehouse is to provide answers to complex queries...''

The correct answer is: A. to provide answers to complex queries that rely on data from multiple sources Explanation: The primary purpose of a data warehouse is to integrate data from multiple sources, structure it for analysis, and support decision-making by enabling complex queries, reporting, and analytics. Here’s why the other options are less accurate:

relational and non-relational it`s a lakehouse architecture I suppose

option A

A - to provide answers to complex queries that rely on data from multiple sources

Answer is: A. The primary purpose of a Data Warehouse is for ANALYTICS. To provide/gain insight from very large dataset. Data is often aggregated from various data sources.

This question appeared in the 07/07/23 exam and the answer is correct.

DWH can store non-relational data ? i think it should be A (not C)

it's A, passed the exam today with a score of 1000.

I think A. Why C is not correct? ".....and non-relational historical data ". look: https://azure.microsoft.com/en-us/resources/cloud-computing-dictionary/what-is-a-data-warehouse/#data-warehouse-benefits Data warehouse: Structured, Relational .

I think its C https://azure.microsoft.com/en-us/resources/cloud-computing-dictionary/what-is-a-data-warehouse/#data-warehouse-definition

The primary purpose of a data warehouse is to provide answers to complex queries that rely on data from multiple sources. A data warehouse is a large, centralized repository of data that is specifically designed for reporting and analysis. The primary purpose of a data warehouse is to store historical data from multiple sources in a single location, in a format that makes it easy to query and analyze. This data is typically read-only, meaning that it is not intended for transactional use. Instead, it is used for reporting and analysis, such as generating business intelligence reports, performing data mining and modeling, and supporting decision-making processes. Data warehousing also includes transforming data from various sources into a consistent format, making it easy for users to query and analyze data from multiple systems.

Answer is C. Read "When to use this solution": https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing

Answer C is not correct. From Microsoft AZure web site: 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. Reference What is a data warehouse? https://azure.microsoft.com/en-us/resources/cloud-computing-dictionary/what-is-a-data-warehouse/

Exam: 20/10/2022

A seems more likely