Demonstrate Delta Sharing Securely Between Databricks Deployments Using Databricks to Databricks Sharing (D2D) or to External Platforms Using the Open Sharing Protocol (D2O). DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 1)

Questions 1–5

1. 1expert · hard

   A data engineer is troubleshooting a D2D sharing issue. The recipient can see the share and the tables, but when they run a query, they get an error that the table does not exist. The provider has verified the table exists and is in the share. What is the most likely cause?

   • AThe recipient is querying the table using the fully qualified name from their own metastore instead of the share's namespace.
   • BThe table was dropped and recreated after the share was created.
   • CThe recipient's workspace is in a different region.
   • DThe recipient does not have SELECT permission on the table.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   When configuring D2O sharing for an external client, what does the provider generate for the recipient?

   • AA cloud storage SAS token for direct access
   • BA Databricks workspace URL and a username
   • CA public certificate for TLS encryption
   • DA share credential that includes the endpoint URL and a bearer token
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A financial services firm needs to share a monthly risk report table with an external auditor who uses a Snowflake account. The auditor does not have a Databricks workspace. The firm's security policy requires that the auditor's access be revocable at any time and that the auditor cannot access any data outside the specific table. What should the data engineer configure?

   • ACreate a share and grant the auditor's Snowflake service principal direct access to the underlying cloud storage.
   • BExport the risk report table to a CSV file and email it to the auditor each month.
   • CCreate a Databricks-to-Databricks share and ask the auditor to create a free Databricks community edition workspace to access the data.
   • DCreate a share, add the risk report table, create a recipient, generate an open-sharing credential, and send the credential to the auditor to use with their Snowflake account.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A data architect is explaining Delta Sharing to a new team member. The architect needs to describe how a recipient securely accesses shared data. Which statement accurately describes the flow?

   • AThe recipient must have a Databricks workspace to access any shared data.
   • BThe recipient uses a credential to authenticate with the provider's Delta Sharing server, which then grants access to the shared data.
   • CThe provider pushes the data to the recipient's storage account.
   • DThe recipient directly accesses the underlying cloud storage using the provider's storage account key.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A data engineer needs to share a table with an external data science team that uses a custom Python application. The application supports Delta Sharing's open protocol. The engineer wants to provide the team with a way to access the data without exposing the underlying cloud storage credentials. What should the engineer provide?

   • AA share credential (URL and token) generated from the recipient's profile.
   • BThe cloud storage account key and container name.
   • CA Databricks personal access token for the provider workspace.
   • DA connection string to the Databricks SQL warehouse.
   Reveal Solution Discussion Select an answer first