Try and practice the latest Microsoft : DP-750 real questions & answers

You have an Azure Databricks workspace that contains the objects shown in the following table.
Name | Type
Catalog1 | Catalog
Schema1 | Schema
Sales1 | Table
Notebook1 | Notebook
Space1 | AI/BI Genie space
Users often use the following words to refer to a sale: transaction, event, order, and invoice.
You need to create a knowledge store. The solution must ensure that when the users use any of the words in Space1, Genie queries the Sales1 table. Any other Genie spaces must remain unaffected.
To which object should you add the instructions?

• A. Space1
• B. Schema1
• C. Notebook1
• D. Sales1

You have an Azure Databricks workspace that is enabled for Unity Catalog and contains two managed Delta tables named sales.schema1.table1 and sales.schema1.table2.
sales.schema1.table1 contains sales data from the current year.
sales.schema1.table2 contains historical data.
You need to load all the rows from sales.schema1.table1 into sales.schema1.table2. The solution must preserve any existing data in sales.schema1.table2 and minimize processing effort.
Which command should you run?

• A. INSERT OVERWRITE sales.schema1.table2 SELECT * FROM sales.schema1.table1;
• B. CREATE TABLE sales.schema1.table2 AS SELECT * FROM sales.schema1.table1;
• C. CREATE OR REPLACE TABLE sales.schema1.table2 AS SELECT * FROM sales.schema1.table1;
• D. INSERT INTO sales.schema1.table2 SELECT * FROM sales.schema1.table1;

You have an Azure Databricks workspace named Workspace1. You create a compute cluster named Cluser1 that will be used to ingest data.
You need to install the required libraries on Cluster 1. The solution must use Unity Catalog for access control.
What should you do?

• A. Upload the libraries to Workspace1 and install the libraries on Cluster1.
• B. Create a custom dependency management script and run the script from a Databricks notebook.
• C. Install the libraries on Cluster1 and manually restart the cluster.
• D. Install the libraries by using pip3.

You have a Lakeflow Spark Declarative Pipelines {SDP) pipeline in Azure Databricks. The pipeline ingests transaction data into a table named Table1.
You need to ensure that in the event of an invalid record, the pipeline continues to run. The solution must meet the following requirements:
* Invalid records must NOT be written to Table 1.
* Invalid records must be preserved for review.
* Minimize development effort
What should you do?

• A. Define a pipeline expectation.
• B. Run were clauses in downstream queries to filter out invalid records.
• C. Implement advanced logic to quarantine the invalid records.
• D. Add a check constraint to Table1

You have an Azure Databricks workspace.
You have an Apache Spark Structured Streaming job named Job! that processes data continuously and fails periodically due to transient errors You need to ensure that Job! meets the following requirements
* Resumes processing from the point that Job1 failed
* Minimizes how long it takes to restart Job!
* Minimizes the costs to restart Job!
What should you do?

• A. Implement checkpointing.
• B. Decrease the retry interval.
• C. Increase the minimum number of nodes in the cluster
• D. Add an alert and manually restart Job1.