Configure Lakeflow Connect to Reliably Ingest Data from Diverse Enterprise Sources into UnityCatalog–governed Tables. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A manufacturing company wants to ingest data from its ERP system, CRM, and IoT sensors into Unity Catalog tables for unified analytics. The data engineering team is evaluating Lakeflow Connect. What is the primary benefit of using Lakeflow Connect for this scenario?

   • AIt provides a unified ingestion service that connects to multiple source systems and writes directly to Unity Catalog tables.
   • BIt automatically migrates all on-premises data to the cloud without configuration.
   • CIt replaces the need for any data transformation or schema mapping.
   • DIt provides a real-time streaming engine for all data sources.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the purpose of configuring retry mechanisms in a Lakeflow Connect pipeline?

   • ATo speed up the ingestion process by running multiple loads in parallel.
   • BTo automatically re-attempt failed ingestion runs to handle transient errors.
   • CTo validate that the data meets quality rules before loading.
   • DTo ensure that data is loaded exactly once, preventing duplicates.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A logistics company ingests shipment tracking data from an on-premises database into a Unity Catalog table. The source database supports change data capture (CDC) and the table is large. The data engineer needs to keep the target table up to date with minimal latency and avoid reprocessing the entire table. Which ingestion strategy should be configured in Lakeflow Connect?

   • AIncremental load using CDC
   • BFull load with overwrite on each run
   • CFull load on a nightly schedule
   • DIncremental load using a timestamp column
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   In a Lakeflow Connect ingestion pipeline, what is the role of a 'target'?

   • AThe network endpoint used to connect to the source system.
   • BThe destination where the ingested data is loaded, typically a table in Unity Catalog.
   • CThe source system from which data is extracted.
   • DThe compute resource used to run the ingestion job.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is a common technique to optimize the performance of a Lakeflow Connect pipeline for large data volumes?

   • AUsing a smaller compute size to reduce costs.
   • BReducing the number of columns in the target table.
   • CDisabling logging and monitoring to save resources.
   • DIncreasing the parallelism of the ingestion job.
   Reveal Solution Discussion Select an answer first