Free DP-750 Mock Exam – Practice Online Confidently

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?

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?

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?

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 thefollowing requirements• Deploy the app to both environments.• Deploy only one job to development.• Minimize administrative effort.What should you use?

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?