You need to create a table that stores customer data. The table should be managed by Unity Catalog and should automatically reflect new data files added to a cloud storage location. Which table type should you create?

A managed table with a defined schema.

A view that queries the storage location.

A materialized view that refreshes periodically.

An external table on the cloud storage location.

A data engineer needs to change the data type of a column in an external Delta table from STRING to TIMESTAMP. The table is defined in Unity Catalog and points to files in ADLS Gen2. What should the engineer do?

Run ALTER TABLE ... ALTER COLUMN ... SET DATA TYPE to change the column type.

Drop the table and recreate it with the new schema.

Use a view to cast the column to TIMESTAMP.

Create a new table and use INSERT OVERWRITE to copy data.

A company has enabled AI/BI Genie for its Unity Catalog. Users are asking Genie questions about sales data, but Genie sometimes returns tables from the finance schema instead of the sales schema because the table names are similar. The data governance team wants to reduce these errors. What should they do?

Rename the finance tables to include a prefix like fin_.

Remove the finance schema from Unity Catalog.

Disable AI/BI Genie for users who ask ambiguous questions.

Add instructions to AI/BI Genie that describe the sales schema and its tables, and clarify the difference from finance tables.

Where are AI/BI Genie instructions configured in Unity Catalog?

At the workspace level, applying to all catalogs.

At the metastore level, applying to all catalogs in the metastore.

At the catalog level, applying to all schemas and tables within that catalog.

At the table level, applying only to that specific table.

Which SQL command creates a schema named 'sales' inside the 'analytics' catalog in Unity Catalog?

CREATE SCHEMA sales IN analytics;

CREATE DATABASE analytics.sales;

CREATE SCHEMA sales FROM analytics;

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 1Objective 2

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

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 11–15

11application · medium
You need to create a table that stores customer data. The table should be managed by Unity Catalog and should automatically reflect new data files added to a cloud storage location. Which table type should you create?
Select an answer first
12application · medium
A data engineer needs to change the data type of a column in an external Delta table from STRING to TIMESTAMP. The table is defined in Unity Catalog and points to files in ADLS Gen2. What should the engineer do?
Select an answer first
13application · medium
A company has enabled AI/BI Genie for its Unity Catalog. Users are asking Genie questions about sales data, but Genie sometimes returns tables from the finance schema instead of the sales schema because the table names are similar. The data governance team wants to reduce these errors. What should they do?
Select an answer first
14foundation · easy
Where are AI/BI Genie instructions configured in Unity Catalog?
Select an answer first
15foundation · easy
Which SQL command creates a schema named 'sales' inside the 'analytics' catalog in Unity Catalog?
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.