DP-750 Practice Online

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?

You have an Azure Databricks workspace that is enabled for Unity Catalog and contains two Delta tables

named Table1 and Table2 of the same data type.

Table1 contains a column named Columnl. Table2 contains a column named Column2. You run the following

query.

SELECT Column1

FROM Table1

GROUP BY Column1

HAVING COUNT(") > 1

INTERSECT

SELECT C0lumn2

FROM Table2

GROUP BY Column2

HAVING COUNT(') > 1;

What occurs when you run the query?

You have an Azure Databricks workspace named Workspace1 that contains a takehouse and is enabled for

Unity 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 have an Azure Databricks workspace

You are creating a Lakeflow Spark Declarative Pipelines (SDP) pipeline that scales automatically. You need

to configure compute for the pipeline. The solution must minimize operational costs and effort. What should

you use?

You have an Azure Databricks workspace named Workspace1 that contains a lakehouse and is enabled for

Unity 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?