You are creating a schema for a new data science project. The schema will contain raw ingestion tables and curated feature tables. The team wants to use a naming convention that clearly separates these two types of data. Which schema design should you use?

Create two catalogs: one for raw and one for curated.

Create two schemas: one named raw and one named curated.

Create one schema named data and use tags to distinguish raw from curated.

Create one schema and use table names like raw_customers and curated_customers.

A team needs to provide real-time dashboards on a large fact table. The dashboard queries a complex aggregation that takes several minutes to run. The team wants to avoid impacting the source table's performance. Which approach best balances freshness and performance?

Create a table that is manually refreshed by a job.

Create a materialized view that refreshes every 15 minutes.

Create an external table pointing to the source table.

Create a regular view and let the dashboard query it directly.

A data science team needs to store raw CSV files and image files that are used for model training. The files are currently in an Azure Data Lake Storage Gen2 container. The team wants to access these files directly from Databricks notebooks without loading them into tables. The security policy requires that only the data science team can read the files. What should the administrator create in Unity Catalog?

A managed table that ingests the CSV files and stores them as Delta.

A view that reads the files using a UDF.

A volume in a schema, backed by the ADLS Gen2 location, and grant READ VOLUME to the data science team.

An external table with a schema that maps to the CSV files.

When creating a catalog in Unity Catalog, which statement is true?

A catalog can be created only if it has at least one schema.

A catalog must be associated with a specific storage location.

A catalog can contain schemas, tables, views, and volumes.

A catalog can be created only by an account admin.

You have an external table in Unity Catalog that points to a cloud storage path. You need to change the table's schema by adding a column. What is the correct way to perform this DDL operation?

Run ALTER TABLE ADD COLUMN on the external table.

Create a new external table with the same location and new schema.

Modify the underlying files and then refresh the table.

Drop and recreate the table with the new schema.

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 1Objective 2

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

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 26–30

26application · medium
You are creating a schema for a new data science project. The schema will contain raw ingestion tables and curated feature tables. The team wants to use a naming convention that clearly separates these two types of data. Which schema design should you use?
Select an answer first
27expert · hard
A team needs to provide real-time dashboards on a large fact table. The dashboard queries a complex aggregation that takes several minutes to run. The team wants to avoid impacting the source table's performance. Which approach best balances freshness and performance?
Select an answer first
28application · medium
A data science team needs to store raw CSV files and image files that are used for model training. The files are currently in an Azure Data Lake Storage Gen2 container. The team wants to access these files directly from Databricks notebooks without loading them into tables. The security policy requires that only the data science team can read the files. What should the administrator create in Unity Catalog?
Select an answer first
29foundation · easy
When creating a catalog in Unity Catalog, which statement is true?
Select an answer first
30application · medium
You have an external table in Unity Catalog that points to a cloud storage path. You need to change the table's schema by adding a column. What is the correct way to perform this DDL operation?
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.