Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.

You are implementing Azure Synapse Link to replicate data from an Azure SQL Database to Azure Synapse Analytics. Describe the steps you would take to ensure that the replicated data is consistent and up-to-date. Also, explain how you would query the replicated data in Azure Synapse Analytics.

Simulated

Explanation:

Enabling Azure Synapse Link and configuring replication settings for immediate consistency ensures that the replicated data is up-to-date and consistent. Using T-SQL queries in Azure Synapse Analytics provides a familiar and efficient way to query the replicated data.