A data engineer has configured a Lakeflow Job that runs daily to ingest customer transaction data from a legacy relational database. The extracted data must be written directly to a Unity Catalog table and be immediately queryable through SQL. The team must also preserve data lineage.
Which action enables this ingestion with direct landing in Unity Catalog, preserved lineage, and immediate SQL query capability?

• A.Use ODBC pooling to extract all records in one batch and write them to /dbfs/
• B.Stage the data in cloud storage through a REST API and load it with a separate job
• C.Use spark.read.format("jdbc") and write the resulting DataFrame with saveAsTable("catalog.schema.table")
• D.Extract the data to a Pandas DataFrame, convert it to Spark, and use save() to write it to an external path

Comment: *

Name: *

Email: *

Verification: *

Identify a scenario to use an external table.
A Data Engineer needs to create a parquet bronze table and wants to ensure that it gets stored in a specific path in an external location.
Which table can be created in this scenario?

• A.An external table where the schema has managed location pointing to specific path in external location.
• B.An external table where the location is pointing to specific path in external location.
• C.A managed table where the location is pointing to specific path in external location.
• D.A managed table where the catalog has managed location pointing to specific path in external location.

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs to provide access to a group named manufacturing-team. The team needs privileges to create tables in the quality schema.
Which set of SQL commands will grant a group named manufacturing-team to create tables in a schema named production with the parent catalog named manufacturing with the least privileges?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs to find all customers who have never placed an order. The customers table contains customer_id, customer_name, and other customer attributes. The orders table contains order_id, customer_id, and other order attributes. Both tables share customer_id as the join key. The result must include only customer columns, with no order-related columns in the output.
Which expression exactly achieves this requirement?

• A.An inner join followed by filtering for a NULL order_id
• B.A left anti-join from customers to orders
• C.A left outer join from orders to customers
• D.A full outer join followed by filtering where order_id IS NULL

Comment: *

Name: *

Email: *

Verification: *

A data engineer is loading a dataset into a Delta table but expects the schema to evolve over time as new columns are added. The pipeline should automatically handle new fields without failing ingestion jobs. Which Delta Lake option should the engineer enable during the write operation?

• A.mergeSchema
• B.overwriteSchema
• C.optimizeWrite
• D.autoCompact

Comment: *

Name: *

Email: *

Verification: *