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

Questions 16–20

1. 16foundation · easy

   Which of the following is a key metric to monitor for a Lakeflow Connect pipeline?

   • AThe number of users who have access to the target table.
   • BThe number of records ingested per run.
   • CThe version of the Lakeflow Connect connector.
   • DThe color of the pipeline icon in the UI.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What governance benefit does Unity Catalog provide for data ingested via Lakeflow Connect?

   • AGuaranteed data encryption at rest and in transit.
   • BAutomatic data quality validation and cleansing.
   • CReal-time data replication to multiple regions.
   • DCentralized access control and lineage tracking for all ingested tables.
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A data engineering team has a Lakeflow Connect pipeline that ingests data from a partner API. The API occasionally returns malformed records that cause the pipeline to fail. The team wants the pipeline to continue processing valid records and only alert on persistent failures. What should be configured?

   • ARetry the entire batch on any error.
   • BStop the pipeline on the first error and send an alert.
   • CIgnore all errors and rely on the next run to fix them.
   • DConfigure error handling to skip malformed records and set up an alert for when the error rate exceeds a threshold.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A company wants to ingest data from an on-premises Oracle database into Unity Catalog. The database is behind a firewall and cannot be accessed directly from the cloud. What should the data engineer configure to allow Lakeflow Connect to reach the database?

   • AAsk the database administrator to disable the firewall.
   • BSet up a secure tunnel or VPN connection between the on-premises network and the Databricks environment.
   • CUse a cloud database migration service to copy the data first.
   • DOpen the database port to the public internet.
   Reveal Solution Discussion Select an answer first
6. 20expert · hard

   A security auditor requires that all credentials used by Lakeflow Connect be rotated every 90 days and that no credentials be visible to pipeline developers. The data engineering team uses a shared development workspace. What should be implemented to meet these requirements?

   • AEmbed the credentials in the pipeline definition and restrict access to the pipeline.
   • BStore credentials in a Databricks-backed secret scope and reference them in the connection, with a process to rotate them every 90 days.
   • CUse the same credentials for all sources to simplify management.
   • DCreate a service principal with admin access and use its credentials in the connection.
   Reveal Solution Discussion Select an answer first