- (Topic 6)
How can a Snowflake user post-process the result of SHOW FILE FORMATS?
Correct Answer:A
first run SHOW FILE FORMATS
then SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(-1)))
https://docs.snowflake.com/en/sql-reference/functions/result_scan#usage-notes
- (Topic 6)
What causes objects in a data share to become unavailable to a consumer account?
Correct Answer:C
Objects in a data share become unavailable to a consumer account if the objects in the data share are deleted or if the permissions on these objects are altered without re- applying the grant permissions systematically. This is because the sharing mechanism in Snowflake relies on explicit grants of permissions on specific objects (like tables, views, or secure views) to the share. If these objects are deleted or if their permissions change without updating the share accordingly, consumers can lose access. TheDATA_RETENTION_TIME_IN_DAYSparameter does not directly affect the availability of shared objects, as it controls how long Snowflake retains historical data for time travel and does not impact data sharing permissions.
Running theGRANT IMPORTED PRIVILEGEScommand in the consumer account is not related to the availability of shared objects; this command is used to grant privileges on imported objects within the consumer's account and is not a routine maintenance command that would need to be run regularly.
Acquiring a data share through a private data exchange does not inherently make objects unavailable; issues would only arise if there were problems with the share configuration or if the shared objects were deleted or had their permissions altered without re-granting access to the share.
Reference: Snowflake Documentation on Managing Access to Shared Data
(https://docs.snowflake.com/en/user-guide/data-sharing-consuming.html#managing-access-to-shared-data)
- (Topic 6)
Which type of role can be granted to a share?
Correct Answer:B
In Snowflake, shares are used to share data between Snowflake accounts. When creating a share, it is possible to grant access to the share to roles within the Snowflake account that is creating the share. The type of role that can be granted to a share is a Custom role. Custom roles are user-defined roles that account administrators can create to manage access control in a more granular way. Unlike predefined roles such as ACCOUNTADMIN or SYSADMIN, custom roles can be tailored with specific privileges to meet the security and access requirements of different groups within an organization.
Granting a custom role access to a share enables users associated with that role to access the shared data if the share is received by another Snowflake account. It is important to carefully manage the privileges granted to custom roles to ensure that data sharing aligns with organizational policies and data governance standards.
References:
✑ Snowflake Documentation on Shares: Shares
✑ Snowflake Documentation on Roles: Access Control
- (Topic 3)
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
Correct Answer:ACF
In Snowflake, you can share several types of objects with other Snowflake accounts. These include schemas, secure views, and secure user-defined functions (UDFs). Sharing these objects allows for collaboration and data access across different Snowflake accounts while maintaining security and governance controls4.
- (Topic 3)
Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
Correct Answer:C
The Snowflake object that helps evaluate virtual warehouse performance impacted by query queuing is the Information_schema.warehouse_load_history. This view provides historical data about the load on a warehouse, including the average number of queries that were running or queued within a specific interval, which can be used to assess performance and identify potential issues with query queuing3.