- (Topic 6)
In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
Correct Answer:
D
In addition to performing all the standard steps to share data, theUSAGEprivilege must be granted on each database referenced by a secure view in order to be shared. When sharing a database or specific objects like secure views, the receiving account needs to have theUSAGEprivilege on the database and schema to access the shared data. This privilege enables the receiving account to access the database and its schemas but does not allow for any DML operations. It's a prerequisite for accessing any objects within the database.
For a secure view to be part of a share, not only does the view itself need to be shared, but the underlying database (and schema, if applicable) must also be accessible to therecipients. GrantingUSAGEprivilege on the database ensures that the receiving account can access the database in a read-only mode to utilize the shared view.
References:
✑ Snowflake Documentation on Shares: Creating and Managing Shares
- (Topic 6)
Which access control entity in Snowflake can be created as part of a hierarchy within an account?
Correct Answer:
B
In Snowflake, a role is an access control entity that can be created as part of a hierarchy within an account. Roles are used to grant and manage privileges in a structured and scalable manner.
✑ Understanding Roles:
✑ Role Hierarchy:
✑ Creating Roles:
✑ Example Usage: CREATE ROLE role1; CREATE ROLE role2;
GRANT ROLE role1 TO role2;
✑ uk.co.certification.simulator.questionpool.PList@546f4af7
✑ Benefits:
References:
✑ Snowflake Documentation: Access Control in Snowflake
✑ Snowflake Documentation: Creating and Managing Roles
- (Topic 3)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
Correct Answer:
A
Snowsight automatically detects if a target account is in a different region and enables cross-cloud auto-fulfillment when using a paid listing on the Snowflake Marketplace. This feature allows Snowflake to manage the replication of data products to consumer regions as needed, without manual intervention1.
- (Topic 3)
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
Correct Answer:
D
In a standard multi-cluster warehouse with auto-scaling, a cluster will shut down when, after 2-3 consecutive checks, the system determines that the load on the least-loaded cluster could be redistributed to other clusters. This ensures efficient resource utilization and cost management. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 3)
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)
Correct Answer:
BDF
The Snowflake PUT command is used to upload files from a local file system to Snowflake stages, specifically the user stage, table stage, and internal named stage. These stages are where the data files are temporarily stored before being loaded into Snowflake tables
