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

Questions 26–30

1. 26foundation · easy

   Why is it important to use secure connections (e.g., TLS) for Lakeflow Connect sources?

   • ATo reduce the cost of the ingestion pipeline.
   • BTo protect data in transit from being intercepted or tampered with.
   • CTo simplify the connection configuration.
   • DTo speed up the data transfer process.
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A media company runs multiple Lakeflow Connect pipelines that ingest data from various sources into Unity Catalog tables. The data engineering team wants to be notified immediately when any pipeline fails or when data volume deviates significantly from the expected baseline. What should be configured?

   • AConfigure the pipeline to send an email only when the pipeline succeeds.
   • BSet up alerts on pipeline run status and row count anomalies in the monitoring system.
   • CCreate a dashboard that shows pipeline status and check it manually each morning.
   • DRely on the source system to notify the team of any issues.
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A large e-commerce company ingests millions of order records daily from a transactional database into a Unity Catalog table. The current Lakeflow Connect pipeline takes too long and consumes excessive resources. The data engineer needs to improve throughput without changing the source system. Which optimization should be applied?

   • AUse a full load instead of incremental load.
   • BDisable error handling to speed up the pipeline.
   • CIncrease the parallelism of the ingestion job by configuring more workers or partitions.
   • DReduce the frequency of ingestion to once a week.
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   Which of the following best describes the role of Lakeflow Connect in the data engineering workflow?

   • AIt orchestrates complex multi-hop ETL pipelines using notebooks and workflows.
   • BIt is a data transformation engine that cleans and prepares data for analysis.
   • CIt provides a no-code/low-code interface to configure and run data ingestion from sources like Salesforce and Workday into Unity Catalog.
   • DIt is a data catalog that stores metadata and lineage for all tables in the organization.
   Reveal Solution Discussion Select an answer first
6. 30application · medium

   A healthcare organization runs a nightly Lakeflow Connect pipeline that ingests patient records from an external EHR system. Occasionally, the EHR system is unavailable for a few minutes during the scheduled run, causing the pipeline to fail. The data engineer needs to make the pipeline more resilient without manual intervention. What should be configured?

   • AChange the source to a different EHR system.
   • BSchedule the pipeline to run every hour instead of nightly.
   • CIgnore the failure and rely on the next day's run to pick up the data.
   • DSet up a retry policy with exponential backoff for transient failures.
   Reveal Solution Discussion Select an answer first