A team is migrating an existing Delta Lake table to Unity Catalog. The table is currently stored in a cloud storage location. They want to keep the data in place and register it as a table in Unity Catalog. What should they do?

Drop the existing table and recreate it as a managed table in Unity Catalog.

Create a managed table and point it to the existing storage location.

Copy the data to a new managed table location and create a managed table.

Create an external table in Unity Catalog that references the existing storage location.

In Unity Catalog, what must be specified to create a Delta Lake table in a specific schema?

The cluster ID and notebook path

The catalog name and schema name, in addition to the table name

DatabricksCertified Generative AI Engineer Associate

Domain 2Objective 4

Define Operations and Sequence to Write Given Chunked Text into Delta Lake Tables in Unity Catalog GENERATIVE-AI-ENGINEER-ASSOCIATE Practice Questions (Page 2)

Part of the Section 2: Data Preparation domain, which makes up ~25% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~9–15 in this domain), expect 1–2 from this objective — we provide 19 practice questions to prepare you well beyond it. (estimate)

19questions here

4free pages

5concepts

Questions 6–10

6foundation · easy
Which DataFrame write mode is most appropriate when writing chunked text data to a Delta Lake table for the first time, and you want to ensure the table is created if it does not exist?
Select an answer first
7expert · medium
A data engineer is writing a DataFrame to a Delta Lake table in Unity Catalog. The write fails with a permission error. The engineer has confirmed that they have USAGE on the catalog and schema. What is the most likely missing permission?
Select an answer first
8foundation · easy
What is the default file format when you create a table using DataFrameWriter in Databricks?
Select an answer first
9application · medium
A team is migrating an existing Delta Lake table to Unity Catalog. The table is currently stored in a cloud storage location. They want to keep the data in place and register it as a table in Unity Catalog. What should they do?
Select an answer first
10foundation · easy
In Unity Catalog, what must be specified to create a Delta Lake table in a specific schema?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to GENERATIVE-AI-ENGINEER-ASSOCIATE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “GENERATIVE-AI-ENGINEER-ASSOCIATE” is a trademark of its owner, used for identification only.

Define Operations and Sequence to Write Given Chunked Text into Delta Lake Tables in Unity Catalog GENERATIVE-AI-ENGINEER-ASSOCIATE Practice Questions (Page 2)

Questions 6–10

Which DataFrame write mode is most appropriate when writing chunked text data to a Delta Lake table for the first time, and you want to ensure the table is created if it does not exist?

A data engineer is writing a DataFrame to a Delta Lake table in Unity Catalog. The write fails with a permission error. The engineer has confirmed that they have USAGE on the catalog and schema. What is the most likely missing permission?

What is the default file format when you create a table using DataFrameWriter in Databricks?

A team is migrating an existing Delta Lake table to Unity Catalog. The table is currently stored in a cloud storage location. They want to keep the data in place and register it as a table in Unity Catalog. What should they do?

In Unity Catalog, what must be specified to create a Delta Lake table in a specific schema?

Keep studying — Section 2: Data Preparation