ExamGecko
Search Search Login
Home Home / Snowflake / COF-C02
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
Which minimum Snowflake edition allows for a dedicated metadata store?
How can the outer array structure of a semi-structured file be removed?
Who can access the data published in a Data Exchange?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
What virtual warehouse configuration should be used when processing a large number of complex queries?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
Which Query Profile metrics will provide information that can be used to improve query performance? (Select TWO).
How does the search optimization service improve query performance?
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Select TWO).

Question 573 - COF-C02 discussion

Report
Export

What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

A.
Use the automatic sharing feature for seamless access.
Answers
A.
Use the automatic sharing feature for seamless access.
B.
Drop the object and then re-add it to the database to trigger sharing.
Answers
B.
Drop the object and then re-add it to the database to trigger sharing.
C.
Recreate the object with a different name in the database before sharing.
Answers
C.
Recreate the object with a different name in the database before sharing.
D.
Use the grant privilege ... TO share command to grant the necessary privileges.
Answers
D.
Use the grant privilege ... TO share command to grant the necessary privileges.
Suggested answer: D

Explanation:

When a Snowflake user wants to share a newly created object in a database with consumers, the correct action to take is to use the GRANT privilege ... TO SHARE command to grant the necessary privileges for the object to be shared. This approach allows the object owner or a user with the appropriate privileges to share database objects such as tables, secure views, and streams with other Snowflake accounts by granting access to a named share.

The GRANT statement specifies which privileges are granted on the object to the share. The object remains in its original location; sharing does not duplicate or move the object. Instead, it allows the specified share to access the object according to the granted privileges.

For example, to share a table, the command would be:

GRANT SELECT ON TABLE new_table TO SHARE consumer_share;

This command grants the SELECT privilege on a table named new_table to a share named consumer_share, enabling the consumers of the share to query the table.

Automatic sharing, dropping and re-adding the object, or recreating the object with a different name are not required or recommended practices for sharing objects in Snowflake. The use of the GRANT statement to a share is the direct and intended method for this purpose.

Show Answer
asked 23/09/2024
Dimitri Alvarez Ruiz
41 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms