Ingest Semi-Structured and Unstructured Data (for Example, JSON and Nested Data) via Lakeflow Connect and Other Managed Connectors into UnityCatalog–governed Delta Tables. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which of the following is an example of a managed connector that can be used to ingest data into Delta tables?

   • ADelta Live Tables' Python function
   • BSpark SQL's SELECT statement
   • CAuto Loader for cloud storage
   • DDatabricks CLI's cp command
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   What is schema evolution in the context of Delta tables?

   • AThe process of deleting old data from the table
   • BThe ability to automatically add new columns or update data types when the source data changes
   • CThe process of optimizing the table for faster queries
   • DThe process of changing the table's storage location
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which characteristic best describes unstructured data?

   • AIt always contains nested key-value pairs
   • BIt is organized in rows and columns with a strict schema
   • CIt has a flexible schema that can vary between records
   • DIt lacks a predefined data model and is not organized in a predefined manner
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A company uses a managed connector to ingest data from a cloud storage bucket into a Unity Catalog-managed Delta table. The data is in JSON format and is updated hourly. The team wants to ensure that only new files are ingested in each run. What should they configure?

   • AUse Auto Loader with 'cloudFiles' options to track processed files and ingest only new ones.
   • BUse the JDBC connector with a timestamp filter to read only new records.
   • CManually track which files have been processed and skip them in the next run.
   • DUse the Azure Blob Storage connector with 'incremental' mode.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is schema inference in the context of ingesting semi-structured data?

   • AThe process of cleaning and validating data
   • BThe process of converting data from one format to another
   • CThe process of manually defining the schema before loading data
   • DThe process of automatically detecting the structure (columns and types) of the data
   Reveal Solution Discussion Select an answer first