nerdexam
Microsoft

DP-900 · Question #234

What is a function of a modern data warehouse?

The correct answer is B. supports real-time and batch processing. 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…

Submitted by manish99· Mar 30, 2026Describe an analytics workload on Azure

Question

What is a function of a modern data warehouse?

Options

  • Asupports batch processing only
  • Bsupports real-time and batch processing
  • Cprovides built-in or native online analytical processing
  • Dstores raw data only

How the community answered

(54 responses)
  • A
    2% (1)
  • B
    94% (51)
  • C
    4% (2)

Explanation

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. https://learn.microsoft.com/bs-latn-ba/training/modules/examine-components-of-modern-data- warehouse/1-introduction

Topics

#data warehouse#batch processing#real-time processing#modern analytics

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice