Home / Data Engineer Associate / Objective 2.7

Domain 2: Data Ingestion and Loading · 21% of the exam · Full exam outline

2.7 Ingest semi-structured and unstructured data (for example, JSON and nested data) via Lakeflow Connect and other managed connectors into Unity Catalog-governed Delta tables.

Practice questions

Question 1easy

A bronze table has an ARRAY column named items, holding the line items of each order. Which function returns one output row per element of items?

Included in Master: master every domain.See plans
Question 2easy

A table column body is of type STRING and holds JSON documents. What type does the expression body:shipping.city return?

Included in Master: master every domain.See plans