Courseiva
← Back to Microsoft Azure Data Fundamentals DP-900 questions

Scenario-based practice

Drag and Drop Matching Questions

Practise Microsoft Azure Data Fundamentals DP-900 practice questions — original exam-style scenarios covering every exam domain, with detailed explanations, wrong-answer analysis, and common exam traps.

Start full practice testRead exam guide
10
scenario questions
DP-900
exam code
Microsoft
vendor

Scenario guide

How to approach drag and drop matching questions

Matching questions give you two columns — concepts, commands, or protocols on the left, and their definitions or use-cases on the right. You drag each left item to its correct match. These appear on most certification exams and punish superficial memorisation.

Quick answer

Drag and Drop Matching Questions questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Related practice questions

Related DP-900 topic practice pages

Scenario questions usually connect to one or more exam topics. Use these links to review the underlying concepts behind the scenario.

Describe core data concepts practice questions

Practise DP-900 questions linked to Describe core data concepts.

Describe an analytics workload on Azure practice questions

Practise DP-900 questions linked to Describe an analytics workload on Azure.

Identify considerations for relational data on Azure practice questions

Practise DP-900 questions linked to Identify considerations for relational data on Azure.

Describe considerations for working with non-relational data on Azure practice questions

Practise DP-900 questions linked to Describe considerations for working with non-relational data on Azure.

DP-900 fundamentals practice questions

Practise DP-900 questions linked to DP-900 fundamentals.

DP-900 scenario practice questions

Practise DP-900 questions linked to DP-900 scenario.

DP-900 troubleshooting practice questions

Practise DP-900 questions linked to DP-900 troubleshooting.

Practice set

Practice scenarios

Question 1mediummatching
Full question →

Match each data processing term to its definition.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Extract, Transform, Load

Extract, Load, Transform

Processing large volumes of data at scheduled intervals

Processing data in real-time as it arrives

Online Transaction Processing

Question 2mediummatching
Full question →

Match each Azure storage redundancy option to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Locally redundant storage within a single datacenter

Zone-redundant storage across availability zones

Geo-redundant storage with cross-region replication

Read-access geo-redundant storage

Geo-zone-redundant storage

Question 3mediummatching
Full question →

Match each Azure SQL Database tier to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Low-cost for small workloads

Balanced performance and cost

High performance and low latency

Highly scalable for large databases

Auto-scaling compute based on demand

Question 4mediummatching
Full question →

Match each Azure data service to its primary purpose.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Relational database as a service

NoSQL multi-model database

Big data and analytics

Unstructured object storage

Scalable data lake for analytics

Question 5mediummatching
Full question →

Match each Azure data security feature to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Encrypts data at rest automatically

Encrypts data in use and in transit

Identity-based access control

IP-level network restrictions

Private IP connectivity over Azure backbone

Question 6mediummatching
Full question →

Match each Azure data consistency model to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Reads always see the latest write

Reads may lag behind writes by up to K versions or T time

Consistent reads within a client session

Reads never see out-of-order writes

No ordering guarantee, eventually consistent

Question 7mediummatching
Full question →

Match each data type to its category in Azure.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Relational tables with fixed schema

JSON, XML, or key-value pairs

Blobs, files, and media

Data in tables with relationships

NoSQL data like documents or graphs

Question 8mediummatching
Full question →

Match each Azure Cosmos DB API to its supported data model.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Document (JSON)

Document (BSON)

Column-family

Graph

Key-value

Question 9mediummatching
Full question →

Match each Azure data tool to its purpose.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Data integration and orchestration

Apache Spark-based analytics platform

Real-time stream processing

Distributed analytics (legacy)

Managed open-source analytics service

Question 10mediummatching
Full question →

Match each Azure data migration tool to its use case.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Migrate databases to Azure with minimal downtime

Copy blobs or files to/from Azure Storage

Offline data transfer for large datasets

Ship physical disks to Azure datacenter

Orchestrate data movement and transformation

These DP-900 practice questions are part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style DP-900 questions with detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics.