You need to implement a foreign catalog to an external MySQL database. The database credentials are stored in Azure Key Vault. What is the correct way to configure the connection?

Create a foreign catalog directly and specify the credentials.

Create a connection with the username and password in the connection string.

Create a connection using a service principal and reference the secret from Key Vault.

Create an external table with JDBC options.

What is the effect of dropping an external table in Unity Catalog?

The external location is also dropped.

The table is moved to a trash folder in the external location.

The table metadata is removed, but the underlying data files remain in the external location.

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

You have a managed table in Unity Catalog that is no longer needed. You want to remove the table and its underlying data files. What should you do?

Run ALTER TABLE to remove the table.

Run TRUNCATE TABLE on the table.

Run DROP TABLE on the managed table.

A manufacturing company stores sensor readings in a Delta table in an external Azure Data Lake Storage Gen2 location. The data engineering team needs to create a table in Unity Catalog that references this existing data without moving it. The table must be managed by Unity Catalog for permissions and lineage. What should the team do?

Create a view over the files using a direct path query.

Create an external table in a schema, specifying the LOCATION of the Delta files.

Create a managed table and then copy the data into it using INSERT.

Create a foreign catalog that points to the ADLS Gen2 location.

Your company uses an external PostgreSQL database for a legacy application. You want to allow Databricks users to query this database directly from Unity Catalog. What is the first step you should take?

Create an external table using JDBC.

Create a connection to the PostgreSQL database.

Create a volume that mounts the PostgreSQL data.

Create a foreign catalog directly.

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 1Objective 2

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

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 1–5

1expert · hard
You need to implement a foreign catalog to an external MySQL database. The database credentials are stored in Azure Key Vault. What is the correct way to configure the connection?
Select an answer first
2foundation · easy
What is the effect of dropping an external table in Unity Catalog?
Select an answer first
3application · medium
You have a managed table in Unity Catalog that is no longer needed. You want to remove the table and its underlying data files. What should you do?
Select an answer first
4application · medium
A manufacturing company stores sensor readings in a Delta table in an external Azure Data Lake Storage Gen2 location. The data engineering team needs to create a table in Unity Catalog that references this existing data without moving it. The table must be managed by Unity Catalog for permissions and lineage. What should the team do?
Select an answer first
5application · medium
Your company uses an external PostgreSQL database for a legacy application. You want to allow Databricks users to query this database directly from Unity Catalog. What is the first step you should take?
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.