DP-750: Implementing Data Engineering Solutions Using Azure DatabricksDemo

By Microsoft · Question Mode

QuestionQ6

Secure and govern Unity Catalog objects

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 satisfy 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: Create a new native catalog in Unity Catalog.

Does this meet the goal?

  • A Yes
  • B No
Explanation

A SQL Server database must be exposed through a Unity Catalog foreign catalog that uses the SQL Server connection. A foreign catalog mirrors the external database’s schemas and tables in Unity Catalog and supports querying the source data without copying it into Databricks-managed storage. A native catalog does not create that federated mapping.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!