Free DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine Demo

Q27 Single choice

A data company uses Databricks Unity Catalog and has multiple enterprise data sources, including PostgreSQL, Snowflake, and SQL Server. The central data platform team wants to configure Lakehouse Federation so analysts can query external tables directly in Databricks using Databricks SQL, without duplicating data.

Which steps are necessary to configure Lakehouse Federation in a secure and governed manner?

A
Mirror the external datasets into Delta Lake using Auto Loader, and govern them using Data Lineage and System Tables.
B
Configure connections and foreign catalog in Unity Catalog, then grant access to foreign catalogs, schemas, and tables using Unity Catalog permissions.
C
Use Partner Connect to create linked datasets, and apply table ACLs at the source system to govern access through Databricks.
D
Create external locations and storage credentials to connect to each database, then register foreign tables in Unity Catalog.

DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine demo