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

Questions 1–5

1. 1expert · hard

   A provider shares a table containing customer data with a consumer. The provider wants to restrict the consumer from seeing rows where the customer has opted out of data sharing. The provider also wants to ensure that the consumer cannot see the underlying table structure or create their own views on the data. What is the best way to achieve this?

   • AShare the base table and use row-level security to filter out opted-out customers.
   • BCreate a secure view that filters out opted-out customers and share the secure view.
   • CCreate a regular view that filters out opted-out customers and share the regular view.
   • DShare the base table and revoke SELECT on the opt-out column.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A provider wants to share a subset of columns from a table with a consumer. The consumer should be able to query the data but should not be able to see the columns that are not shared. The provider also wants to ensure that the consumer cannot create a view on top of the shared data. What should the provider do?

   • ACreate a view that selects only the desired columns and add the view to the share.
   • BAdd the table to the share and revoke SELECT on the unwanted columns.
   • CCreate a secure view that selects only the desired columns and add the secure view to the share.
   • DCreate a new table with only the desired columns and add that table to the share.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is the purpose of a database role in the context of Snowflake Secure Data Sharing?

   • ATo manage compute resources for the share.
   • BTo monitor consumer usage of the share.
   • CTo replicate the share to other regions.
   • DTo grant privileges on shared objects to consumers.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is the purpose of applying a governance policy to a shared dataset?

   • ATo ensure the data is replicated to the consumer's region.
   • BTo enforce data protection and compliance requirements.
   • CTo increase the performance of queries on the shared data.
   • DTo automatically create reader accounts for consumers.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is the primary responsibility of a consumer in Snowflake Secure Data Sharing?

   • ATo create and manage the share object.
   • BTo replicate the shared data to their own account.
   • CTo pay for the provider's storage costs.
   • DTo accept the share and query the shared data.
   Reveal Solution Discussion Select an answer first