Question 14

An analytics team needs read-only access to operational tables that live in an existing Azure Database for PostgreSQL server. The data must **not** be copied into Azure Databricks; analysts should query it live and have access managed by Unity Catalog using normal `GRANT` statements. A platform admin has already run the following statement: ```sql CREATE CONNECTION pg_ops TYPE postgresql OPTIONS ( host '<server>.postgres.database.azure.com', port '5432', user '<user>', password secret('ops','pg_pwd') ); ``` Which command completes the Lakehouse Federation setup so that the PostgreSQL database `orders_db` is mirrored as a queryable catalog in Unity Catalog?

• A`CREATE FOREIGN CATALOG orders USING CONNECTION pg_ops OPTIONS (database 'orders_db');`
• B`CREATE CATALOG orders MANAGED LOCATION 'abfss://...' OPTIONS (database 'orders_db');`
• C`CREATE EXTERNAL LOCATION orders URL 'postgresql://orders_db' WITH (CONNECTION pg_ops);`
• D`CREATE TABLE orders USING postgresql OPTIONS (dbtable 'orders_db', host '...', port '5432');`
• E`CREATE SHARE orders USING CONNECTION pg_ops OPTIONS (database 'orders_db');`