nerdexam
Microsoft

DP-203 · Question #415

You have an Azure subscription that contains an Azure SQL database named SQLDB1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. You need to replicate data from SQLDB1 to Pool1. The solu

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

Submitted by alyssa_d· Mar 30, 2026Design and implement data storage

Question

You have an Azure subscription that contains an Azure SQL database named SQLDB1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. You need to replicate data from SQLDB1 to Pool1. The solution must meet the following requirements:

  • Minimize performance impact on SQLDB1.
  • Support near-real-time (NRT) analytics.
  • Minimize administrative effort.

What should you use?

Options

  • AAzure Synapse Link
  • BAzure Private Link
  • CSQL Data Sync for Azure
  • Dtransactional replication in Microsoft SQL Server

Unlock DP-203 to see the answer

You've previewed enough free DP-203 questions. Unlock DP-203 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

#Azure Synapse Link#data replication#NRT analytics#dedicated SQL pool
Full DP-203 Practice