A multinational company is setting up Unity Catalog for a data mesh architecture. Each business domain (e.g., sales, finance) should own its data. The company also uses an external Snowflake instance for some legacy data and wants to query it from Databricks. They need a naming convention that clearly identifies the source system and domain. What should they do?

Create a foreign catalog named snowflake and put all domains in it.

Create one catalog named company and use table prefixes like sales_ and finance_.

Create catalogs named sales, finance, and snowflake_legacy, with schemas representing subdomains.

Create schemas named sales, finance, and snowflake in a single catalog.

A healthcare company is creating a Unity Catalog environment. They need to store patient data and clinical trial data. The compliance team requires that patient data be stored in a specific Azure region and that access be restricted to a small group of analysts. The clinical trial data can be stored anywhere. What should the administrator do?

Create two schemas in the same catalog: patient_data and clinical_trials, and grant access to the patient_data schema only to the analysts.

Create two separate catalogs: patient and clinical, and place each in a different region.

Create a volume for patient data and a schema for clinical trials.

Create one schema and use table-level permissions to restrict access to patient tables.

A data engineering team uses Unity Catalog to manage data across development, staging, and production environments. They also need to share certain datasets with external partners. Which naming convention approach aligns with Unity Catalog best practices?

Name all catalogs with a prefix indicating the environment, such as dev_analytics, staging_analytics, prod_analytics.

Create separate catalogs for each environment (e.g., dev, staging, prod) and use a distinct catalog for external sharing.

Use a single catalog for all environments and separate schemas for dev, staging, and prod.

Use one catalog for all data and rely on table names to indicate environment, such as prod_sales, dev_sales.

What happens when you drop a managed table in Unity Catalog?

The table is converted to an external table before deletion.

The table is moved to a recycle bin and can be restored within 30 days.

Only the table metadata is removed, and the underlying data files are retained.

Both the table metadata and the underlying data files are deleted.

You are configuring AI/BI Genie for a sales data catalog. Users often ask about 'net revenue' but the underlying column is named 'revenue_after_discounts'. What should you include in the Genie instructions?

A mapping note that 'net revenue' refers to the column revenue_after_discounts.

A request to rename the column to net_revenue.

A list of all table names and their column names.

A note that users should use the exact column name.

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 1Objective 2

Create and Organize Objects in Unity Catalog DP-750 Practice Questions (Page 4)

Part of the Set up and configure an Azure Databricks environment 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 42 practice questions to prepare you well beyond it. (estimate)

42questions here

9free pages

9concepts

15–20%of the exam

Questions 16–20

16application · medium
A multinational company is setting up Unity Catalog for a data mesh architecture. Each business domain (e.g., sales, finance) should own its data. The company also uses an external Snowflake instance for some legacy data and wants to query it from Databricks. They need a naming convention that clearly identifies the source system and domain. What should they do?
Select an answer first
17application · medium
A healthcare company is creating a Unity Catalog environment. They need to store patient data and clinical trial data. The compliance team requires that patient data be stored in a specific Azure region and that access be restricted to a small group of analysts. The clinical trial data can be stored anywhere. What should the administrator do?
Select an answer first
18foundation · easy
A data engineering team uses Unity Catalog to manage data across development, staging, and production environments. They also need to share certain datasets with external partners. Which naming convention approach aligns with Unity Catalog best practices?
Select an answer first
19foundation · easy
What happens when you drop a managed table in Unity Catalog?
Select an answer first
20application · medium
You are configuring AI/BI Genie for a sales data catalog. Users often ask about 'net revenue' but the underlying column is named 'revenue_after_discounts'. What should you include in the Genie instructions?
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.

Create and Organize Objects in Unity Catalog DP-750 Practice Questions (Page 4)

Questions 16–20

A data engineering team uses Unity Catalog to manage data across development, staging, and production environments. They also need to share certain datasets with external partners. Which naming convention approach aligns with Unity Catalog best practices?

What happens when you drop a managed table in Unity Catalog?

You are configuring AI/BI Genie for a sales data catalog. Users often ask about 'net revenue' but the underlying column is named 'revenue_after_discounts'. What should you include in the Genie instructions?

Keep studying — Set up and configure an Azure Databricks environment