Free Microsoft DP-750 Exam Questions

Question 1

You have an Azure Databricks workspace named Workspace1 that contains a lakehouse and is enabled forUnity Catalog.You have a connection to a Microsoft SQL Server database named DB1.You need to expose the schemas and tables of DB1 to meet the following requirements:• The schemas and tables can be queried in Databricks.• The schemas and tables appear alongside other Unity Catalog objects.• The data is NOT copied into Databricks-managed storage.Solution: You create a Databricks access connector.Does this meet the goal?

A : Yes

B : No

Answer: B

Question 2

You have an Azure Databricks workspaceYou are creating a Lakeflow Spark Declarative Pipelines (SDP) pipeline that scales automatically. You needto configure compute for the pipeline. The solution must minimize operational costs and effort. What shouldyou use?

A : an all-purpose cluster that uses autoscaling

B : the existing SQL warehouse

C : a job cluster that uses autoscaling

D : a single-node, all-purpose cluster

Answer: C

Question 3

You have an Azure Databricks workspaceYou are creating a Lakeflow Spark Declarative Pipelines (SDP) pipeline that scales automatically. You needto configure compute for the pipeline. The solution must minimize operational costs and effort. What shouldyou use?

A : an all-purpose cluster that uses autoscaling

B : the existing SQL warehouse

C : a job cluster that uses autoscaling

D : a single-node, all-purpose cluster

Answer: C

Question 4

You have an Azure Databricks workspace named Workspace1 that contains a lakehouse and is enabled forUnity Catalog.You have a connection to a Microsoft SQL Server database named DB1.You need to expose the schemas and tables of DB1 to meet the following requirements:• The schemas and tables can be queried in Databricks.• The schemas and tables appear alongside other Unity Catalog objects.• The data is NOT copied into Databricks-managed storage.Solution: You create a Databricks access connector.Does this meet the goal?

A : Yes

B : No

Answer: B

Question 5

You have an Azure Databricks workspace named Workspace1 that contains a takehouse and is enabled forUnity Catalog.You have a connection to a Microsoft SQL Server database named DB1.You need to expose the schemas and tables of DB1 to meet the following requirements:• The schemas and tables can be queried in Databricks.• The schemas and tables appear alongside other Unity Catalog objects.• The data is NOT copied into Databricks-managed storage.Solution: You create a new native catalog in Unity Catalog. Does this meet the goal?

A : Yes

B : No

Answer: B