A data analyst wants to add a comment to a table and set a table property, but they are not comfortable writing SQL. Which UI feature allows them to do both?

The Query Editor, which allows you to run SQL without writing it yourself.

The Jobs UI, which has a 'Metadata' tab for tables.

The Data tab in the workspace, which has a 'Properties' section.

Catalog Explorer, using the edit options on the table's Overview page.

Why is recording ownership important for data governance?

It automatically optimizes query performance

It determines the physical storage format of the data

It defines the data's retention policy

It identifies who is responsible for the data asset

A data engineer needs to verify that a table `analytics.customer` has a specific table property `pii` set to 'true', and also wants to see the column comments for that table. Which single SQL command provides both pieces of information?

SHOW TBLPROPERTIES analytics.customer

SHOW CREATE TABLE analytics.customer

DESCRIBE EXTENDED analytics.customer

Which of the following is a metadata attribute that Unity Catalog manages for a table?

The table's physical file format

The cluster's autoscaling configuration

The table's owner and access permissions

A data engineer needs to list all table properties for a table `hr.employees` and also see the column comments. They want to use SQL. Which two commands should they run?

SHOW TBLPROPERTIES hr.employees; DESCRIBE hr.employees;

SHOW CREATE TABLE hr.employees; DESCRIBE hr.employees;

SELECT * FROM hr.employees; DESCRIBE hr.employees;

DESCRIBE EXTENDED hr.employees;

DatabricksCertified Data Engineer Professional

Domain 8Objective 1

Create and Add Descriptions/metadata About Enterprise Data to Make It More Discoverable. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 3)

Part of the Data Governance domain, which accounts for 7% of the DATA-ENGINEER-PROFESSIONAL exam. Databricks does not publish an official question count, but from its 120-minute exam (~50–80 total, ~4–6 in this domain), expect 2–3 from this objective — we provide 30 practice questions to prepare you well beyond it. (estimate)

30questions here

6free pages

7concepts

7%of the exam

Questions 11–15

11application · easy
A data analyst wants to add a comment to a table and set a table property, but they are not comfortable writing SQL. Which UI feature allows them to do both?
Select an answer first
12foundation · easy
Why is recording ownership important for data governance?
Select an answer first
13application · medium
A data engineer needs to verify that a table `analytics.customer` has a specific table property `pii` set to 'true', and also wants to see the column comments for that table. Which single SQL command provides both pieces of information?
Select an answer first
14foundation · easy
Which of the following is a metadata attribute that Unity Catalog manages for a table?
Select an answer first
15application · medium
A data engineer needs to list all table properties for a table `hr.employees` and also see the column comments. They want to use SQL. Which two commands should they run?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ENGINEER-PROFESSIONAL

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. “DATA-ENGINEER-PROFESSIONAL” is a trademark of its owner, used for identification only.