Answer-first summary for fast verification
Answer: Enable Azure Synapse Link, configure replication settings for immediate consistency, and use T-SQL queries in Azure Synapse Analytics.
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.
Author: LeetQuiz Editorial Team
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.
A
Enable Azure Synapse Link, configure replication settings for immediate consistency, and use T-SQL queries in Azure Synapse Analytics.
B
Enable Azure Synapse Link, configure replication settings for eventual consistency, and use T-SQL queries in Azure Synapse Analytics.
C
Enable Azure Synapse Link, configure replication settings for immediate consistency, and use Spark SQL queries in Azure Synapse Analytics.
D
Enable Azure Synapse Link, configure replication settings for eventual consistency, and use Spark SQL queries in Azure Synapse Analytics.
No comments yet.