DP-750: Implementing Data Engineering Solutions Using Azure DatabricksDemo

By Microsoft · Question Mode

QuestionQ5

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 foreign catalog in Catalog Explorer.

Does this achieve the goal?

  • A Yes
  • B No
Explanation

A Unity Catalog foreign catalog mirrors an external database, including its schemas and tables, so it can be queried from Azure Databricks and governed alongside other Unity Catalog objects. For Microsoft SQL Server, Lakehouse Federation provides read-only access to the external data without migrating it into Databricks-managed storage.

Learn more

Community Discussion

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