Answer-first summary for fast verification
Answer: Use Partner Connect's automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
The correct answer is D because Partner Connect provides an automated workflow specifically designed for integrating Databricks with Fivetran, and it establishes a SQL warehouse (formerly SQL endpoint) rather than a cluster. This approach is documented in Databricks' official documentation and is the recommended method. The community discussion shows unanimous support for option D with 100% consensus and references to official documentation. Other options are incorrect because: A and E use Workflows instead of the specialized Partner Connect integration; B and C incorrectly suggest using clusters, when SQL warehouses are the appropriate compute resource for Fivetran connections; and C uses Partner Connect but incorrectly specifies clusters instead of SQL warehouses.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which of the following methods can be used to connect Databricks to Fivetran for data ingestion?
A
Use Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
B
Use Delta Live Tables to establish a cluster for Fivetran to interact with
C
Use Partner Connect's automated workflow to establish a cluster for Fivetran to interact with
D
Use Partner Connect's automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
E
Use Workflows to establish a cluster for Fivetran to interact with