Configure Lakehouse Federation with Proper Governance Across the Supported Source Systems. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   When creating a foreign catalog, what must be specified to securely connect to the external data source?

   • AThe IP address and port of the external source
   • BThe cloud provider and region of the external source
   • CThe connection name and the external database name
   • DThe username and password for the external source
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which authentication method can be used for a foreign connection to an external data source?

   • AAPI key
   • BClient certificate
   • COAuth token
   • DUsername and password
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A data engineer is troubleshooting a failed query against a foreign catalog. The error message says: `USER does not have permission to access the foreign catalog`. The engineer has confirmed that the user has `USAGE` on the foreign catalog and `SELECT` on the specific table. What else could be causing this error?

   • AThe foreign catalog is not in the same metastore as the user's workspace.
   • BThe user is not a member of the `analyst` group that owns the foreign catalog.
   • CThe source database does not grant the user access to the underlying table.
   • DThe user does not have `USAGE` on the underlying foreign connection.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What is the primary purpose of a foreign connection in Lakehouse Federation?

   • ATo define the schema of the external data source
   • BTo manage user permissions on the external data source
   • CTo store the connection string and authentication details for an external data source
   • DTo cache query results from external data sources
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company wants to use Lakehouse Federation to query data from a MySQL database and a Snowflake database. The MySQL database is on-premises, and the Snowflake database is in the cloud. Both databases require different authentication methods. What is the correct way to set up these connections in Unity Catalog?

   • ACreate a foreign connection for MySQL and a foreign connection for Snowflake, but store the credentials for both in the same secret scope and reference the same secret in both connections.
   • BCreate a single foreign connection that can connect to both MySQL and Snowflake by specifying multiple JDBC URLs in the connection string.
   • CCreate two separate foreign connections, one for MySQL using username/password and one for Snowflake using OAuth or key-pair authentication, then create a foreign catalog for each.
   • DCreate a foreign catalog for MySQL and a foreign catalog for Snowflake, but use the same connection for both by specifying the database type in the catalog properties.
   Reveal Solution Discussion Select an answer first