Pass with professional DP-750 actual quiz materials

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 enabled for Unity Catalog and contains:
* A catalog named Corpdb
* A schema named Finance in the Corpdb catalog
* A table named Sales in the Finance schema
You have a group named Analysts.
You assign the following permissions to Analysts:
* USE CATALOG on the Corpdb catalog
* USE SCHEMA on the Finance schema
* SELECT on the Sales table
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

2. You have an Azure Databricks workspace that contains a Delta table named Customer.
A job named Job1 performs frequent upserts into Customer.
You discover that Job1 has created many small Parquet files in Customer, and the small files are degrading query performance.
You need to improve query performance for the current data already stored in Customer. The solution must not affect the travel for the Customer table.
What should you do?

A) Run the OPTIMIZE command on the Customer table.
B) Set the delta.autoOptimize.optimizeWrite Apache Spark configuration to true.
C) Set the delta.deletedFileRetentionDuration table property to 1 day.
D) Run the VACUUM command on the Customer table.

3. You have an Azure Databricks workspace that is enabled for Unity Catalog.
You plan to ingest data from CSV files stored in Azure Data Lake Storage Gen2. New rows are appended frequently.
You need to implement a data ingestion solution that meets the following requirements:
* New data must be available in near-real-time (NRT).
* The data must be stored in managed Delta tables.
* The solution must minimize custom code and maintenance effort.
What should you include in the solution?

A) Auto Loader
B) an Azure Data Factory pipeline
C) scheduled Apache Spark batch jobs
D) an external table that references the CSV files

4. 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) separate databricks.yml files for each environment
C) a resources node in a databricks.yml file
D) a targets node in a databricks.yml file

5. You have an Azure Databricks workspace that contains an all-purpose cluster named Cluster! You need to configure Cluster1 to meet the following requirements;
* The cluster must scale up automatically when workloads increase.
* The cluster must scale down automatically when workloads decrease.
The solution must minimize costs.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A) Configure Cluster1 to terminate after 30 minutes of inactivity.
B) Apply a compute policy that enables users to manage the cluster settings.
C) Disable Photon acceleration.
D) Enable autoscaling for Cluster1.
E) Specify a fixed number of workers.

Solutions: