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 4)

Questions 16–20

1. 16application · medium

   A data engineer has a JSON file with the following structure: {"id": 1, "tags": ["red", "blue"]}. They want to create a Delta table with one row per tag, repeating the 'id' for each tag. Which Spark transformation should they use?

   • AUse 'regexp_extract' on the 'tags' column.
   • BUse 'explode' on the 'tags' column.
   • CUse 'collect_list' on the 'tags' column.
   • DUse 'split' on the 'tags' column.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which of the following is an example of semi-structured data?

   • AA plain text file containing a novel
   • BA JPEG image file
   • CA JSON file containing nested customer records
   • DA CSV file with a fixed header row
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   What is the benefit of writing ingested data to a Unity Catalog-governed Delta table?

   • AAutomatic data transformation and cleaning
   • BFaster query performance compared to non-governed tables
   • CCentralized access control and data governance across workspaces
   • DGuaranteed data quality and schema validation
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A healthcare company receives patient records in two formats: JSON files with nested observations, and scanned PDF documents of handwritten notes. They want to ingest both into Unity Catalog-managed Delta tables for analysis. What is the most appropriate approach?

   • AStore PDFs in a separate cloud storage location and only ingest JSON into Delta.
   • BConvert PDFs to JSON before ingestion so both can be loaded into the same table.
   • CIngest JSON files using Lakeflow Connect into a Delta table, and store PDFs as binary data in a separate Delta table.
   • DIngest both JSON and PDFs into the same Delta table using a single Lakeflow Connect job.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company receives customer feedback in two formats: CSV files with structured fields (customer_id, rating, comment) and audio recordings of phone calls. They want to ingest both into Unity Catalog-managed Delta tables for analysis. What is the most appropriate approach?

   • AIngest both CSV and audio files into the same Delta table using a single Lakeflow Connect job.
   • BIngest CSV files into a Delta table using a managed connector, and store audio files as binary data in a separate Delta table.
   • CStore audio files in a separate cloud storage location and only ingest CSV into Delta.
   • DConvert audio files to text using speech-to-text before ingestion, then load both as text into the same table.
   Reveal Solution Discussion Select an answer first