Enable and Detail Data Ingestion Patterns, Including Batch, Streaming, and Incremental Loading, and Import Data from Sources Such as Local Files, Lakeflow Connect Standard Connectors, and Lakeflow Connect Managed Connectors. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 5)

Questions 21–23

1. 21foundation · easy

   What is a key benefit of using a Lakeflow Connect managed connector?

   • AIt works only with on-premises data sources.
   • BIt eliminates the need for any data transformation.
   • CIt reduces the operational overhead of managing ingestion infrastructure.
   • DIt guarantees zero data loss during ingestion.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which Databricks feature provides pre-built connectors for ingesting data from common external sources like Salesforce and Google BigQuery?

   • ADelta Live Tables
   • BDatabricks SQL warehouses
   • CLakeflow Connect standard connectors
   • DDatabricks CLI
   Reveal Solution Discussion Select an answer first
3. 23application · easy

   A healthcare company receives daily claims files from multiple hospitals as CSV files in a shared cloud storage bucket. The files arrive at different times throughout the day, but the company only needs to process them once per day. Which ingestion pattern should they use?

   • AManual upload of files to Databricks using the UI when they arrive.
   • BBatch ingestion using a scheduled Databricks job that runs once daily to load all files from the storage bucket.
   • CIncremental loading using a watermark column to load only new files since the last run.
   • DStreaming ingestion using Auto Loader to process each file as soon as it arrives.
   Reveal Solution Discussion Select an answer first