Prepare with Microsoft DP-750 exam practice material, pass for sure

Microsoft DP-750 Exam Overview:

Microsoft DP-750 Exam Syllabus Topics:

Microsoft Implementing Data Engineering Solutions Using Azure Databricks Sample Questions:

1. You have an Azure Databricks workspace that is attached to a Unity Catalog metastore named metastore1.
Metastore1 contains a catalog named catalog 1.
You need to create a new schema named schema2 that meets the following requirements:
* Is contained in catalog1
* Uses abfss://containergstorageaccount.dfs.core.windows.net/data as the Managed location Which SQL statement should you execute?

A) CREATE SCHEMA catalog1.schema2
WITH DBPROPERTIES (LOCATION= ' abfss://[email protected]/data
' );
B) CREATE SCHEMA catalog1.schema2
MANAGED LOCATION ' abfss://[email protected]/data ' ;
C) CREATE SCHEMA catalog1.schema2
LOCATION ' abfss://[email protected]/data ' ;
D) CREATE CATALOG schema2
MANAGED LOCATION ' abfss://[email protected]/data ' ;

2. You have an Azure Databricks workspace named Workspace1 that contains a cluster named Cluster1.
You need to enable a user named User1 to install a Maven package on all the nodes of Cluster1. The solution must follow the principle of least privilege.
What should you do?

A) Grant User1 the CAN RESTART permission for Cluster1.
B) Assign User1 the Contributor role for the resource group that contains Workspace1.
C) Grant User1 the CAN MANAGE permission for Cluster1.
D) Assign User1 the workspace admins role for Workspace1.

3. You have an Azure Databricks workspace that is enabled for Unity Catalog and contains a managed Delta table named Payments.
Payments stores transaction data and contains a column named payment_amount of the Decimal data type.
You must enforce the following business rule:
payment_amount must be between 0 and 10,000, inclusive
You need to ensure that records that violate the rule are rejected when data is written to the Payments table.
What should you do?

A) Add a CHECK constraint to payment_amount to enforce the allowed range.
B) Create a table update trigger.
C) Configure row-level security (RLS) to hide records that have invalid values.
D) Run SELECT statements to filter out records that have invalid values in payment_amount.

4. You have an Azure Databricks workspace that is enabled for Unity Catalog and contains a managed Delta table named Table1.
Table1 stores customer profile data.
Business users must analyze how customer profile records change over time. They must also be able to query earlier versions of the table.
You need to implement a solution that:
* Maintains persistent historical versions of customer profile records for long-term analysis.
* Allows users to query earlier versions of the Delta table.
* Minimizes maintenance effort.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

5. You use Databricks Asset Bundles to manage two jobs and an app.
You need to deploy the bundle to development and production environments. The solution must meet the following requirements
* Deploy the app to both environments.
* Deploy only one job to development.
* Minimize administrative effort.
What should you use?

A) a variables node in a databricks.yml file
B) a targets node in a databricks.yml file
C) a resources node in a databricks.yml file
D) separate databricks.yml files for each environment

Solutions: