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

Questions 21–25

1. 21foundation · easy

   What is the benefit of using a service principal for a foreign connection?

   • AIt automatically rotates credentials
   • BIt allows the connection to use a shared user account
   • CIt eliminates the need for network connectivity to the external source
   • DIt provides a dedicated identity for the connection, avoiding reliance on individual user credentials
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A data engineer is querying a large MySQL table through Lakehouse Federation. The query filters on a column that has an index in MySQL and joins with a small table in the Databricks lakehouse. The query is running slowly. What is the most likely cause and the best first step to improve performance?

   • AThe query is not pushing down the filter to MySQL, causing all rows to be transferred to Databricks. The engineer should rewrite the query to use a subquery that filters in the source.
   • BThe MySQL table is not indexed on the join column. The engineer should ask the MySQL DBA to add an index on the join column.
   • CThe Databricks cluster is too small to handle the data transfer. The engineer should increase the cluster size to improve query performance.
   • DThe join is being performed in MySQL, which is not optimized for large joins. The engineer should move the join to Databricks by creating a temporary view of the MySQL table.
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A financial services company has created a foreign catalog named `finance_ext` that connects to a Snowflake database. The data engineering team needs to grant the `analyst` group read access to only the `transactions` table in the `public` schema of this foreign catalog. What is the correct sequence of SQL statements to achieve this?

   • A`GRANT USAGE ON FOREIGN CATALOG finance_ext TO analyst;` followed by `GRANT SELECT ON TABLE finance_ext.public.transactions TO analyst;`
   • B`GRANT USAGE ON CATALOG finance_ext TO analyst;` followed by `GRANT SELECT ON TABLE finance_ext.public.transactions TO analyst;`
   • C`GRANT SELECT ON FOREIGN CATALOG finance_ext TO analyst;` followed by `GRANT SELECT ON TABLE finance_ext.public.transactions TO analyst;`
   • D`GRANT SELECT ON TABLE finance_ext.public.transactions TO analyst;` only, because table-level grants automatically include catalog-level access.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   In the Lakehouse Federation architecture, what component acts as the bridge between Databricks and an external data source?

   • AA cluster
   • BA Delta table
   • CA foreign catalog
   • DA foreign connection
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A company is evaluating whether to use Lakehouse Federation to query data from a PostgreSQL database. The database is large, and the company is concerned about query performance. What is the primary benefit of Lakehouse Federation in this scenario?

   • AIt creates a cached copy of the PostgreSQL data in Databricks, which is refreshed periodically.
   • BIt converts the PostgreSQL data to Delta format in the lakehouse, enabling fast queries.
   • CIt allows queries to be executed directly on the PostgreSQL database, avoiding data movement and leveraging the source's query optimizer.
   • DIt automatically replicates the PostgreSQL data to the Databricks lakehouse, making queries faster but requiring storage.
   Reveal Solution Discussion Select an answer first