DATABRICKS-DAA Question 42

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - Correct answer : A — `CREATE FOREIGN CATALOG pg_catalog USING CONNECTION pg_inventory OPTIONS (database 'retail_db')`, which mirrors the remote database's schemas and tables. A . `CREATE FOREIGN CATALOG` is the correct statement for federation; it takes an existing connection and a remote database name, then mirrors that database's schemas and tables as a foreign catalog in Unity Catalog. B . Plain `CREATE CATALOG` provisions a managed catalog backed by Databricks-managed storage, not a mirror of a remote federated database, so it is the wrong statement for this scenario. C . There is no `CREATE FOREIGN SCHEMA ... FROM CONNECTION` statement in Lakehouse Federation; foreign catalogs are the unit created on top of a connection, and schemas underneath sync automatically. D . `ALTER CONNECTION` modifies properties of an existing connection object; it cannot be used to create or attach a new foreign catalog, which requires its own `CREATE FOREIGN CATALOG` statement.