nerdexam
Microsoft

DP-900 · Question #169

What is the primary purpose of a data warehouse?

Sign in or unlock DP-900 to reveal the answer and full explanation for question #169. The question stem and answer options stay visible for context.

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

Question

What is the primary purpose of a data warehouse?

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

Unlock DP-900 to see the answer

You've previewed enough free DP-900 questions. Unlock DP-900 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#data warehouse#analytical queries#historical data#multi-source data
Full DP-900 Practice