DP-900 Practice Question: Identify considerations for relational data on Azure
A company has both transactional and analytical workloads on the same SQL Server database. They want to move to Azure and separate these workloads to improve performance. They need a solution that supports both workloads without duplicating data. What should they do?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use Azure Synapse Link for SQL to replicate data in near real-time to an analytical store.
Azure Synapse Link for SQL enables near real-time replication of transactional data from Azure SQL Database to Synapse Analytics for analytical queries without ETL and without duplicating data. Option A is wrong because Azure Data Factory does not provide real-time replication and would require data duplication. Option C is wrong because using Azure SQL Database and SQL Data Warehouse separately with periodic data copy duplicates data. Option D is wrong because using Azure SQL Database for both workloads does not separate workloads.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use Azure Data Factory to move data between two Azure SQL Databases.
Why it's wrong here
Data Factory is for ETL, not real-time.
- ✓
Use Azure Synapse Link for SQL to replicate data in near real-time to an analytical store.
Why this is correct
Synapse Link provides real-time replication without ETL.
- ✗
Use Azure SQL Database for transactions and Azure SQL Data Warehouse for analytics, with periodic data copy.
Why it's wrong here
Requires data duplication.
- ✗
Use Azure SQL Database for both workloads.
Why it's wrong here
Does not separate workloads.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Data warehouse
A data warehouse is a central repository that stores large amounts of structured data from multiple sources, optimized for querying and analysis rather than day-to-day transactions.
Key term
Transactional data
Transactional data is information that captures a specific event or exchange, such as a sale, a payment, or a system log entry, and is recorded in a database or log system.
About these practice questions
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-900 exam.