A data engineer must ingest data from a SaaS Salesforce source and a self-managed SQL Server database into Unity Catalog tables using Lakeflow Connect managed connectors. Which statement correctly describes how these managed connectors operate?
Answer & explanation
Correct answer: C
WHY C: The SQL Server managed connector supports both change tracking and CDC, and SaaS connectors like Salesforce run exclusively on serverless, incurring serverless Lakeflow pipeline DBU charges. WHY NOT A: managed connectors are Databricks-operated and do not need a self-managed all-purpose cluster; Salesforce ingests incrementally via a cursor column, not full snapshots. WHY NOT B: managed connectors land data directly into Unity Catalog tables, not into a volume needing a separate Auto Loader step. WHY NOT D: the SQL Server connector supports change tracking as well as CDC, not CDC only. WHY NOT E: managed connectors are configured via UI/API and write directly to Unity Catalog, not through hive_metastore.