Exam DP-900 topic 1 question 186 discussion

when its not clear here what to consider as correct answer? paying for dump is not worth in this type of question.

Personal preferrence goes to B. Key phrase is 'modern' data warehouse. From Microsoft learn: Large-scale data warehousing solutions combine conventional data warehousing used to support business intelligence (BI) with techniques used for so-called "big data" analytics. A conventional data warehousing solution typically involves copying data from transactional data stores into a relational database with a schema that's optimized for querying and building multidimensional models. Big Data processing solutions on the other hand, are used with large volumes of data in multiple formats, which is batch loaded or captured in real-time streams and stored in a data lake from which distributed processing engines like Apache Spark are used to process it. Answer C is functional of conventional data warehouse. Reference https://learn.microsoft.com/bs-latn-ba/training/modules/examine-components-of-modern-data-warehouse/1-introduction

I vote for C, it is about warehouse, transaction (processing) is not a role of warehouse, as usual. https://learn.microsoft.com/en-us/data-engineering/playbook/solutions/modern-data-warehouse/#understand-the-limitations > The MDW architectural principles are versatile in building analytical data pipelines in a cloud-first environment. However, they don't offer comprehensive guidance in the following areas: > Transactional data workloads. MDW is Modern Data Warehouse

in real life its C but for stupid microsoft its B i think

The function of a data warehouse that is a more recent addition is "supports real-time and batch processing" compared to "provides built-in or native online analytical processing". Explanation: Traditional data warehouses: Historically, data warehouses were primarily designed for batch processing of large datasets, with OLAP (Online Analytical Processing) capabilities being a core feature, allowing for analysis of historical data through multidimensional views. - From Google AI Overview

I believe C is the correct answer per the graph from Microsoft Learn comparing Modern Data Warehouses with Traditional Data Warehouses: https://learn.microsoft.com/en-us/data-engineering/playbook/solutions/modern-data-warehouse/

So is it B or C? Both seem possible.

Answer C seems to make more sense. The main goal of a DWH is to help answering business questions means provide extensive and easy to implement analysis capabilities and it`s valid for 100% of customers. On the other hand, support of the real-time and batch processing together might not be even needed for every customer, many would still be happy with batch alone.

chat gpt mention both B and C

Modern Data Warehouses MUST have the ability to perform the "transform" aspect of the ELT process in the target datastore. Hence, option C would seem most relevant to any mDWH solution, while support for both Stream and Batch processing may also be provided.

C. provides built-in or native online analytical processing A modern data warehouse is designed to support both batch and real-time processing, as well as provide built-in or native online analytical processing (OLAP) capabilities. OLAP allows for complex, interactive data analysis to be performed directly on the data stored in the warehouse. This makes it a powerful tool for generating insights and reports from large volumes of data.

B. supports real-time and batch processing A modern data warehouse is designed to support both real-time and batch processing. It allows organizations to ingest, process, and analyze data in real-time as it's generated, while also supporting traditional batch processing for historical analysis. This flexibility enables businesses to gain insights from their data in a timely manner and make informed decisions based on both current and historical data.

Answer is correct as per chat GPT

The modern data warehouse has two functions: data processing and serving as a data store for analytics programs. https://www.enlighten.co.nz/en/Blog/2020/01/Understanding-the-Two-Main-Functions-of-the-Modern-Data-Warehouse#:~:text=The%20modern%20data%20warehouse%20has,don%27t%20have%20this%20functionality.

B is possible but is not a particularly special feature. C stands out more.

https://www.enlighten.co.nz/en/Blog/2020/01/Understanding-the-Two-Main-Functions-of-the-Modern-Data-Warehouse#:~:text=The%20modern%20data%20warehouse%20has,don't%20have%20this%20functionality.

C is correct! A data warehouse is a relational database in which the data is stored in a schema that is optimized for data analytics rather than transactional workloads. https://learn.microsoft.com/en-us/training/modules/examine-components-of-modern-data-warehouse/4-analytical-data-stores