Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 38 of 119
Free Preview · 119 of 395 · questions 1–119 of 395 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
- Correct answer : A — Change tracking and CDC are not supported on SQL Server read replicas, so the connector must point at the primary instance instead. A . SQL Server's change tracking and CDC features are only available against the primary instance; secondary replicas cannot serve as a CDC source, so the connector must be pointed at the primary regardless of its available capacity. B . Lakeflow Connect supports SQL Server across on-premises deployments, EC2, Azure VMs, Azure SQL, and Amazon RDS, so the connector is not restricted to Azure-hosted deployments. C . Authentication is handled through the Unity Catalog connection's stored credentials and is independent of whether the target instance is primary or secondary; the failure here is about CDC support, not authentication. D . Network reachability is a separate concern from CDC support; even with working connectivity, change tracking and CDC simply are not exposed on secondary replicas.