nerdexam
Microsoft

DP-900 · Question #124

Drag and Drop Question Match the types of workloads the appropriate scenario. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload…

The correct answer is The CRM system; The data warehouse; The data warehouse. The question appears to match workload types to scenarios involving transactional processing, analytical reporting, and data aggregation. The CRM system is an OLTP (Online Transaction Processing) workload designed for real-time data entry and operational tasks like managing…

Submitted by tarun92· Mar 30, 2026Describe types of core data workloads and the differences between transactional and analytical processing systems

Question

Drag and Drop Question Match the types of workloads the appropriate scenario. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once or not at all. NOTE: Each correct match is worth one point. Answer:

Exhibit

DP-900 question #124 exhibit

Answer Area

Drag items

An in-memory data integration toolThe CRM systemThe data warehouse

Correct arrangement

  • The CRM system
  • The data warehouse
  • The data warehouse

Explanation

The question appears to match workload types to scenarios involving transactional processing, analytical reporting, and data aggregation. The CRM system is an OLTP (Online Transaction Processing) workload designed for real-time data entry and operational tasks like managing customer records. The data warehouse is an OLAP (Online Analytical Processing) workload optimized for complex queries, historical data analysis, and reporting - making it the appropriate fit for scenarios requiring aggregated or analytical data processing. An in-memory data integration tool serves as an intermediary ETL/ELT layer and is not directly associated with end-user operational or analytical workload scenarios in this context.

Topics

#OLTP vs OLAP#Workload Classification#Data Warehouse Architecture#Cloud Data Solutions

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice