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

Question

Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

Options

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

Explanation

Partner Connect is Databricks' built-in feature specifically designed to automate the setup and configuration of third-party data partner integrations like Fivetran - its automated workflow provisions a cluster that Fivetran can interact with for data ingestion, making C the correct answer.

Why the distractors fail:

• A & E (Workflows): Databricks Workflows is an orchestration tool for scheduling and running jobs - it has no role in provisioning infrastructure for external partner connections.
• B (Delta Live Tables): DLT is a declarative ETL framework for building data pipelines within Databricks; it cannot establish external partner connectivity.
• D (Partner Connect + SQL warehouse): Partner Connect is correct, but it provisions a cluster, not a SQL warehouse, for Fivetran's data ingestion use case.

Memory tip: Think of it this way - Partner Connect is literally named for connecting partners. When you see a question about integrating a third-party partner like Fivetran, Partner Connect is almost always the right mechanism. The "automated workflow" phrasing in the answer is the giveaway that you're using the purpose-built tool rather than improvising with Workflows or DLT.

No community discussion yet for this question.