Crucial Exams

Microsoft Azure Data Fundamentals DP-900 Practice Question

A retailer plans to load several terabytes of historical point-of-sale data into an Azure Synapse Analytics dedicated SQL pool so that analysts can run quarterly sales trend reports. Which feature is typical of this analytical workload?

  • Queries are mostly read-intensive and return aggregated results across large data sets.

  • Strict row-level locking is required to prevent concurrent reads.

  • Data must be updated in real time with sub-second latency.

  • The workload consists of many small, short-lived transactions that modify individual rows.

Microsoft Azure Data Fundamentals DP-900
Describe core data concepts
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot