Which features are included in Snowsight? (Select TWO)
Correct Answer: A,D
Question 27
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.
Question 28
The Snowflake VARIANT data type imposes a 16 MB size limit on what?
Correct Answer: B
Question 29
In the Data Exchange, who can get or request data from the listings? (Select TWO).
Correct Answer: A,D
In the Snowflake Data Exchange, the ability to get or request data from listings is generally controlled by specific roles and privileges: A . Users with ACCOUNTADMIN role: This role typically has the highest level of access within a Snowflake account, including the ability to manage and access all features and functions. Users with this role can access data listings within the Data Exchange. D . Users with import share privilege: This specific privilege is necessary for users who need to import shared data from the Data Exchange. This privilege allows them to request and access data listings explicitly shared with them.
Question 30
Which privilege is required to grant a database role to another role?
Correct Answer: B
The correct answer is B. OWNERSHIP on the database role . A database role is a securable object within a database. To grant a database role to another role, the granting role must have the authority to manage that database role. The OWNERSHIP privilege on the database role gives full control over the database role, including the ability to grant it. Why B is correct: The owner of a database role can grant that database role to another database role or account role, depending on the supported grant relationship. Example concept: GRANT DATABASE ROLE database1.db_role1 TO ROLE account_role1; To perform this action, the executing role must have appropriate authority over database1.db_role1, such as OWNERSHIP. Why the other options are incorrect: A). USAGE on the database allows access to the database namespace, but it does not grant authority to grant a database role. C). CREATE ROLE applies to creating account roles, not granting database roles. D). MANAGE GRANTS can allow broad grant management, but the specific required object-level privilege in this question is OWNERSHIP on the database role. Official Snowflake documentation reference: Snowflake documentation explains that database roles are securable objects and that ownership provides full control over the object, including grant management. Reference: Snowflake Documentation - Database roles; Snowflake Documentation - GRANT DATABASE ROLE; Snowflake Documentation - Access control privileges; SnowPro Core Study Guide - Security and Access Control. ==
