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

Questions 31–35

1. 31foundation · easy

   Which of the following is a common configuration parameter for a Lakeflow Connect source connection to a cloud database like Azure SQL Database?

   • AThe database's blob storage endpoint and an account key.
   • BThe database's connection string and a client certificate.
   • CThe database server name, database name, and authentication credentials.
   • DThe database's public IP address and a shared access signature (SAS) token.
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   When setting up a Lakeflow Connect pipeline, what is the typical first step after creating a connection to the source?

   • AStarting the pipeline to test the connection.
   • BConfiguring error handling and retry policies.
   • CDefining the target table schema in Unity Catalog.
   • DSelecting the source objects (e.g., tables or reports) to ingest.
   Reveal Solution Discussion Select an answer first
4. 33foundation · easy

   What is the primary purpose of setting up alerts for a Lakeflow Connect ingestion pipeline?

   • ATo notify administrators of failures or anomalies so they can take corrective action.
   • BTo document the pipeline configuration for auditing purposes.
   • CTo automatically fix any data quality issues in the source system.
   • DTo increase the compute resources allocated to the pipeline.
   Reveal Solution Discussion Select an answer first
5. 34expert · hard

   A company ingests a large fact table (billions of rows) from a data warehouse into Unity Catalog using Lakeflow Connect. The initial full load takes 12 hours, and the team wants to reduce the time for future loads. The source supports incremental extraction based on a last-modified timestamp, but the target table is used for historical reporting and requires all historical data. What strategy should be used?

   • AContinue with full loads nightly to ensure all data is always current.
   • BPerform an initial full load, then switch to incremental loads based on the timestamp, using MERGE to update changed rows.
   • CPartition the target table by date and load only the latest partition.
   • DUse incremental loads only, starting from the current timestamp, and ignore historical data.
   Reveal Solution Discussion Select an answer first
6. 35application · medium

   A retail company needs to ingest daily sales data from a cloud-based SaaS platform into a Unity Catalog table. The security team requires that credentials never be stored in plain text and that access be scoped to the specific source system. Which approach should the data engineer take when configuring the Lakeflow Connect source?

   • ACreate a service principal in the SaaS platform and use its client ID and secret in the Lakeflow Connect connection, storing the secret in a Databricks-backed secret scope.
   • BStore the username and password in a notebook secret scope and reference it in the connection string.
   • CUse the SaaS platform's admin account credentials and embed them directly in the pipeline definition for simplicity.
   • DCreate a personal access token (PAT) for the data engineer and use it in the connection.
   Reveal Solution Discussion Select an answer first