Which SQL statement is used to apply a row filter to an existing table in Unity Catalog?

UPDATE TABLE ... SET ROW FILTER

A data engineering team is migrating a legacy data warehouse to Unity Catalog. They need to create table definitions that are discoverable and have clear column descriptions. They also want to ensure that the lineage of the tables is maintained after the migration. What is the best approach?

Create tables using CREATE TABLE with COMMENT clauses and verify lineage in Catalog Explorer.

Create tables and rely on the default column names for discovery.

Create tables and then use the table's properties to add descriptions.

Create tables and then manually add column descriptions using ALTER TABLE.

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 2Objective 2

Govern Unity Catalog Objects DP-750 Practice Questions (Page 3)

Part of the Secure and govern Unity Catalog objects domain, which accounts for 15–20% of the DP-750 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~8–16 in this domain), expect 4–8 from this objective — we provide 35 practice questions to prepare you well beyond it. (estimate)

35questions here

7free pages

9concepts

15–20%of the exam

Questions 11–15

11foundation · easy
Which Unity Catalog feature allows you to add descriptive metadata to a table to improve its discoverability?
Select an answer first
12foundation · easy
Which Unity Catalog feature is used to manage the lifecycle of data by automatically expiring data?
Select an answer first
13foundation · easy
Which Unity Catalog object can be used to apply a policy that restricts access to rows based on a user's group membership?
Select an answer first
14foundation · easy
Which SQL statement is used to apply a row filter to an existing table in Unity Catalog?
Select an answer first
15expert · hard
A data engineering team is migrating a legacy data warehouse to Unity Catalog. They need to create table definitions that are discoverable and have clear column descriptions. They also want to ensure that the lineage of the tables is maintained after the migration. What is the best approach?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-750

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 Microsoft. “DP-750” is a trademark of its owner, used for identification only.

Govern Unity Catalog Objects DP-750 Practice Questions (Page 3)

Questions 11–15

Which Unity Catalog feature allows you to add descriptive metadata to a table to improve its discoverability?

Which Unity Catalog feature is used to manage the lifecycle of data by automatically expiring data?

Which Unity Catalog object can be used to apply a policy that restricts access to rows based on a user's group membership?

Which SQL statement is used to apply a row filter to an existing table in Unity Catalog?

A data engineering team is migrating a legacy data warehouse to Unity Catalog. They need to create table definitions that are discoverable and have clear column descriptions. They also want to ensure that the lineage of the tables is maintained after the migration. What is the best approach?

Keep studying — Secure and govern Unity Catalog objects