A team needs to provide a simplified view of a complex join between customer and order tables. The view should always reflect the latest data and should not store any data. What should you create?

A materialized view that refreshes daily.

A regular view that encapsulates the join logic.

A new table that is populated by a scheduled job.

An external table that points to the join output.

Which SQL command creates a volume named 'raw_data' in the 'bronze' schema of the 'analytics' catalog?

CREATE STORAGE analytics.bronze.raw_data;

CREATE VOLUME analytics.bronze.raw_data;

CREATE DIRECTORY analytics.bronze.raw_data;

CREATE VOLUME raw_data IN analytics.bronze;

A company is migrating to Unity Catalog. They have an existing Hive metastore with hundreds of tables. The migration team wants to minimize disruption and avoid rewriting all queries. They also need to enforce new data governance policies. What is the best approach?

Create a view in Unity Catalog that points to each Hive table.

Create a new catalog in Unity Catalog and migrate tables incrementally, updating queries as needed.

Use the Hive metastore as a foreign catalog in Unity Catalog.

Keep the Hive metastore and use a legacy access mode for all clusters.

Your organization uses a Snowflake warehouse for legacy reporting. You want to query Snowflake tables from Azure Databricks without copying data. What should you implement in Unity Catalog?

Create a foreign catalog using a Snowflake connection.

Create an external table pointing to Snowflake's storage.

Create a volume that stores Snowflake export files.

Create a view that queries Snowflake via JDBC.

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 1Objective 2

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

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 31–35

31application · medium
A team needs to provide a simplified view of a complex join between customer and order tables. The view should always reflect the latest data and should not store any data. What should you create?
Select an answer first
32foundation · easy
Which SQL command creates a volume named 'raw_data' in the 'bronze' schema of the 'analytics' catalog?
Select an answer first
33expert · hard
A company is migrating to Unity Catalog. They have an existing Hive metastore with hundreds of tables. The migration team wants to minimize disruption and avoid rewriting all queries. They also need to enforce new data governance policies. What is the best approach?
Select an answer first
34application · medium
Your organization uses a Snowflake warehouse for legacy reporting. You want to query Snowflake tables from Azure Databricks without copying data. What should you implement in Unity Catalog?
Select an answer first
35foundation · easy
You need to create a new catalog in Unity Catalog. Which SQL command should you use?
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.