CERTIFIED-DATA-ANALYST-ASSOCIATE Question #73: Real Exam Question with Answer & Explanation

Question

Which approach should be used to connect Databricks to Fivetran for data ingestion?

Options

• AUse Delta Live Tables to establish a cluster for Fivetran to interact with.
• BUse Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to
• CUse Partner Connect's automated workflow to establish a SQL warehouse (formerly known as a
• DUse Partner Connect's automated workflow to establish a cluster for Fivetran to interact with.

Explanation

Option D is correct because Databricks Partner Connect provides an automated, guided workflow specifically designed to integrate partner tools like Fivetran, and it establishes an all-purpose cluster - which is what Fivetran requires to write/ingest data via a Spark-based JDBC connection.

Why the distractors are wrong:

• A is wrong because Delta Live Tables is a pipeline framework for transforming data inside Databricks, not a mechanism for setting up partner integrations.
• B is wrong on two counts: Workflows is for orchestrating jobs (not partner setup), and a SQL warehouse is the wrong compute type for Fivetran's ingestion needs.
• C is nearly right in method (Partner Connect is correct) but wrong on compute type - SQL warehouses are optimized for BI/analytics partners (e.g., Tableau, Power BI), not for data ingestion tools like Fivetran that need cluster-based Spark connectivity.

Memory tip: Think "Fivetran → Flows into a Cluster via Partner Connect." The key distinction is cluster (general compute, used by ingestion tools) vs. SQL warehouse (query-optimized, used by BI tools) - and always use Partner Connect's automated workflow rather than manual setup tools like Workflows or Delta Live Tables.

No community discussion yet for this question.