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

Questions 11–15

1. 11expert · hard

   A data engineer is setting up a Lakeflow Connect pipeline to ingest data from a CSV file stored in cloud storage into a Unity Catalog table. The CSV has inconsistent date formats (e.g., 'MM/dd/yyyy' and 'yyyy-MM-dd') and some numeric fields contain commas as thousand separators. The target table expects a standard DATE and DECIMAL type. What should the data engineer do?

   • APre-process the CSV file manually before uploading to cloud storage.
   • BStore the data as STRING and convert it in every downstream query.
   • CIngest the CSV as-is and let Unity Catalog infer the schema.
   • DUse a transformation step in the pipeline to parse the date and numeric fields consistently before writing to the target.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A data engineer is setting up a Lakeflow Connect pipeline to ingest data from a SQL Server database into a Unity Catalog table. The source table has columns that are not needed in the target, and some column names need to be renamed. What should the data engineer configure in the pipeline?

   • AModify the source table to remove the unneeded columns.
   • BIngest all columns and use a downstream view to hide the unneeded ones.
   • CDefine a schema mapping that selects only the needed columns and renames them as required.
   • DCreate a separate pipeline for each column.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A multinational corporation ingests HR data from multiple regional sources into a single Unity Catalog table. The data governance team requires that only HR analysts can view sensitive columns (e.g., salary) and that all data lineage be tracked. What should the data engineer configure in Lakeflow Connect?

   • AUse Unity Catalog table permissions and column-level masking, and enable lineage tracking.
   • BCreate a view that excludes sensitive columns and grant access to that view only.
   • CStore the data in a separate table for each region and grant access to all users.
   • DEncrypt the entire table and share the decryption key with all analysts.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   In Lakeflow Connect, what is the purpose of schema mapping?

   • ATo schedule the pipeline to run at specific times.
   • BTo encrypt data in transit between the source and target.
   • CTo define how source fields and data types are translated to the target Unity Catalog table schema.
   • DTo monitor the health of the ingestion pipeline.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company needs to ingest data from a Salesforce instance into a Unity Catalog table. The data engineer has been given the Salesforce username and password, but the security policy requires using OAuth. What should the data engineer do to configure the Lakeflow Connect source?

   • AUse the provided username and password directly in the connection.
   • BUse a Salesforce security token instead of OAuth.
   • CCreate a connected app in Salesforce and use its client ID and secret for OAuth authentication.
   • DAsk the Salesforce admin to disable OAuth for the integration.
   Reveal Solution Discussion Select an answer first