Share Data Using Secure Data Sharing COF-C03 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   How does a consumer account gain access to a share in Snowflake?

   • AThe consumer must copy the data to their account before using it.
   • BThe consumer must create a share in their own account.
   • CThe provider automatically grants access without any action from the consumer.
   • DThe consumer accepts the share and then creates a database from it.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   In Snowflake Secure Data Sharing, what is the role of the provider?

   • AThe provider manages the consumer's virtual warehouses.
   • BThe provider only consumes data shared by others.
   • CThe provider creates a share and grants access to consumer accounts.
   • DThe provider is responsible for storing copies of shared data.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company wants to share real-time sales data with a partner. The partner needs to see updates within minutes of the data being inserted into the source table. The company wants to avoid any data duplication and minimize administrative overhead. What is the most appropriate approach?

   • AUse a data marketplace listing to share the data.
   • BUse Secure Data Sharing to share the table directly with the partner's account.
   • CUse database replication to replicate the data to the partner's account.
   • DSet up a recurring task to export the data to a cloud storage location and share the storage location with the partner.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which object can be added to a Snowflake share to expose data to consumers?

   • AStorage integration
   • BResource monitor
   • CTable
   • DVirtual warehouse
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What action can a provider take to revoke a consumer's access to a shared database?

   • AChange the consumer's password.
   • BRemove the consumer account from the share.
   • CDrop the consumer's virtual warehouse.
   • DDelete the consumer's database.
   Reveal Solution Discussion Select an answer first