Snowflake SnowPro Core Practice Test - Questions Answers, Page 35
Related questions
Question 341

Which task privilege does a Snowflake role need in order to suspend or resume a task?
Explanation:
In Snowflake, the OPERATE privilege is required for a role to suspend or resume a task.This privilege allows the role to perform operational tasks such as starting and stopping tasks, which includes suspending and resuming them6
Question 342

Which role has the ability to create and manage users and roles?
Explanation:
The USERADMIN role in Snowflake has the ability to create and manage users and roles within the Snowflake environment.This role is specifically dedicated to user and role management and creation
Topic 4, Exam pool D
Question 343

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
Explanation:
In Snowflake, a user with the SECURITYADMIN role or higher can activate and enforce a network policy for all users in an account.Additionally, a role that has ownership of the network policy can also activate and enforce it
Question 344

A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
Explanation:
In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created4.
Question 345

What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Explanation:
An account administrator in the Data Exchange can perform tasks such as adding and removing members and approving or denying listing approval requests.These tasks are part of managing the Data Exchange and ensuring that only authorized listings and members are part of it12.
Question 346

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
Explanation:
The statistics that can be used to identify queries with inefficient pruning are 'Partitions scanned' and 'Partitions total'.These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34.
Question 347

Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
Explanation:
The GOVERNANCE_VIEWER role in the ACCOUNT_USAGE schema provides visibility into policy-related information within Snowflake.This role is specifically designed to access views that display object metadata and usage metrics related to governance12.
Question 348

Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
Explanation:
The Snowflake data types that can be used to build nested hierarchical data are OBJECT and VARIANT.These data types support the storage and querying of semi-structured data, allowing for the creation of complex, nested data structures
Question 349

How can a dropped internal stage be restored?
Explanation:
Once an internal stage is dropped in Snowflake, it cannot be recovered or restored using Time Travel or UNDROP commands.The only option is to recreate the dropped stage
Question 350

Who can grant object privileges in a regular schema?
Explanation:
In a regular schema within Snowflake, the object owner has the privilege to grant object privileges.The object owner is typically the role that created the object or to whom the ownership of the object has been transferred78.
Reference = [COF-C02] SnowPro Core Certification Exam Study Guide
Question