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

Questions 16–20

1. 16foundation · easy

   How does Unity Catalog govern access to federated data?

   • ABy requiring users to have direct access to the external source
   • BBy applying standard Unity Catalog grants on the foreign catalog and its objects
   • CBy applying permissions on the foreign connection
   • DBy using the external source's native permissions
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What is predicate pushdown in the context of Lakehouse Federation?

   • AA technique to push filters and projections to the external source to reduce data transfer
   • BA way to increase parallelism by distributing queries across multiple clusters
   • CA technique to compress data before sending it over the network
   • DA method to cache query results in Databricks
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which of the following is a supported external data source for Lakehouse Federation?

   • ASnowflake
   • BMongoDB
   • COracle Database
   • DRedis
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   What is a key performance consideration when querying federated data?

   • AFederated queries do not use compute resources
   • BAll data is transferred to Databricks before query execution
   • CFederated queries are always faster than querying native tables
   • DQueries may be slower due to network latency and data transfer overhead
   Reveal Solution Discussion Select an answer first
6. 20expert · hard

   A data engineer is setting up a foreign connection to a PostgreSQL database. The engineer has created the connection and tested it successfully from the Databricks workspace. However, when a downstream job runs, it fails with a connection timeout. The job runs on a different cluster than the one used for testing. What is the most likely cause of this failure?

   • AThe PostgreSQL database has a connection limit, and the testing cluster consumed all available connections, blocking the job's cluster.
   • BThe downstream job's cluster does not have the same network access as the testing cluster, such as being in a different VNet or lacking a private endpoint.
   • CThe service principal used by the job does not have permission to use the foreign connection, even though the testing cluster used a different service principal.
   • DThe connection string in the foreign connection is incorrect, but it worked during testing because the testing cluster cached the connection details.
   Reveal Solution Discussion Select an answer first