Use Delta Share to Share Live Data from Lakehouse to Any Computing Platform. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   What is a key benefit of Delta Sharing's live data access?

   • AIt allows recipients to modify the shared data
   • BIt provides a backup of the data in the recipient's cloud account
   • CIt automatically converts data to Parquet for faster access
   • DIt eliminates the need for data duplication between organizations
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A data engineer is setting up Delta Sharing for a finance team. The team wants to share a curated table with an external auditor. The auditor will use a Python script to read the data. The engineer needs to ensure the auditor can only access the shared table, not any other data in the lakehouse. What is the correct sequence of actions?

   • ACreate a recipient, generate a share credential, create a share, and add the table.
   • BCreate a share, add the table, create a recipient, generate a share credential, and send the credential to the auditor.
   • CAdd the table to a share, create a recipient, and grant the recipient direct access to the underlying cloud storage.
   • DCreate a share, create a recipient, add the table, and share the Databricks workspace URL with the auditor.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data engineer needs to share a Delta table that is updated every hour by a streaming job. The recipient must always see the latest committed data without any manual intervention. The engineer creates a share and adds the table. What else must be done to ensure the recipient sees live data?

   • ANothing; Delta Sharing automatically provides the latest committed version of the table to the recipient.
   • BRe-create the share and re-add the table after each update.
   • CSet up a scheduled job to refresh the share every hour after the streaming job completes.
   • DEnable the 'live data' flag on the share configuration.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A data engineer needs to share a table with a partner who uses Apache Spark in their own environment. The partner wants to read the data using Spark DataFrames. What should the engineer provide to the partner?

   • AA copy of the Parquet files from the table.
   • BThe table's location in cloud storage and a storage account key.
   • CThe Databricks workspace URL and a personal access token.
   • DThe share credential and the URL of the Delta Sharing server.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company wants to share a dataset with a research institution. The institution uses a variety of tools, including Python, R, and SQL. The data is updated frequently, and the institution needs to see the latest data without manual exports. What is the best way to share the data?

   • AExport the data to a shared cloud storage bucket and provide the institution with access keys.
   • BEmail a compressed file of the data weekly.
   • CProvide the institution with a Databricks workspace and run queries on their behalf.
   • DUse Delta Sharing to provide live access via open connectors for Python, R, and SQL.
   Reveal Solution Discussion Select an answer first