Free Microsoft DP-750 Exam Questions
Absolute Free DP-750 Exam Practice for Comprehensive Preparation
-
Microsoft DP-750 Exam Questions
-
Provided By: Microsoft
- Exam: Implementing Data Engineering Solutions Using Azure Databricks
- Certification: Microsoft Certified Associate
-
Total Questions: 58
-
Updated On: Jul 15, 2026
-
Rated: 4.9 |
-
Online Users: 116
-
Question 1
-
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?
Answer: B
-
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?
-
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?
Answer: C
-
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?
-
Question 3
-
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?
Answer: B
-
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?
-
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?
Answer: B
-
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?
-
Question 5
-
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains two Delta tablesnamed Table1 and Table2 of the same data type.Table1 contains a column named Columnl. Table2 contains a column named Column2. You run the followingquery.SELECT Column1FROM Table1GROUP BY Column1HAVING COUNT(") > 1INTERSECTSELECT C0lumn2FROM Table2GROUP BY Column2HAVING COUNT(') > 1;What occurs when you run the query?
Answer: B
-
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains two Delta tablesnamed Table1 and Table2 of the same data type.Table1 contains a column named Columnl. Table2 contains a column named Column2. You run the followingquery.SELECT Column1FROM Table1GROUP BY Column1HAVING COUNT(") > 1INTERSECTSELECT C0lumn2FROM Table2GROUP BY Column2HAVING COUNT(') > 1;What occurs when you run the query?