Databricks Generative AI Engineer Associate Question 66
Select 3You are working with a chunked text dataset and need to write each chunk into a Delta Lake table using Unity Catalog. Which of the following operations and sequence ensures the data is written correctly while maintaining compliance with Unity Catalog's governance model?
- A
Create a Delta table in Unity Catalog by specifying a catalog and schema.
- B
Use the
overwritemode to write data into the Delta table without checking for schema consistency. - C
Ensure that the cluster or notebook is attached to a Unity Catalog-enabled workspace.
- D
Use a managed Delta table to ensure Unity Catalog manages the metadata and storage.
- E
Directly write the data into Delta Lake files without registering a table in Unity Catalog.
Show answer and explanation
Correct answers: A, C, D
Explanation
To write chunked text into Delta Lake tables in Unity Catalog, you must follow Unity Catalog's governance requirements. This includes creating a Delta table within a catalog and schema, ensuring the workspace is Unity Catalog-enabled, and using managed Delta tables for proper metadata and storage handling. Avoid practices like bypassing Unity Catalog by writing directly to Delta files or using modes that ignore schema consistency.
- A. Correct.
Correct: Unity Catalog requires a catalog and schema to properly manage the Delta table's metadata and data governance.
- B. Incorrect.
Incorrect: Using
overwritemode without schema consistency checks may result in schema mismatches, which is not compliant with Unity Catalog best practices. - C. Correct.
Correct: Unity Catalog operations require the workspace or cluster to be properly configured for Unity Catalog.
- D. Correct.
Correct: Managed Delta tables are recommended in Unity Catalog for proper governance and storage management.
- E. Incorrect.
Incorrect: Directly writing to Delta Lake files bypasses Unity Catalog's governance and metadata management.