Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

An organization is building a data lakehouse and needs to ingest data from multiple sources...

Databricks Databricks-Certified-Data-Engineer-Associate Full Course Access
Databricks Databricks-Certified-Data-Engineer-Associate View All Questions

An organization is building a data lakehouse and needs to ingest data from multiple sources into Unity Catalog-managed tables:

    Salesforce: More than 50 objects, frequent schema changes, and OAuth authentication

    An on-premises SQL Server database: More than 100 tables, CDC enabled, and private network connectivity required

    Daily JSON files landing in Azure Data Lake Storage Gen2

The organization wants all ingested data governed by Unity Catalog, minimal engineering effort for schema changes, and serverless processing wherever possible.

Which ingestion strategy meets these requirements?

A.

Use partner connectors such as Fivetran for all three sources through Partner Connect

B.

Use Auto Loader for all three sources, with custom Python code for Salesforce API calls and SQL Server CDC extraction

C.

Use Lakeflow Connect managed connectors for Salesforce and SQL Server, and Auto Loader for the ADLS files, within Lakeflow Spark Declarative Pipelines

D.

Use Lakeflow Connect managed connectors for all three sources

Databricks-Certified-Data-Engineer-Associate PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now Databricks-Certified-Data-Engineer-Associate pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
A data engineer needs to parse only png files in a directory that contains files...
A data engineer has configured a Structured Streaming job to read from a table, manipulate...
Previous