The correct answer is C. Query acceleration service .
The Query Acceleration Service is a Snowflake performance optimization feature that can temporarily provide additional compute resources to accelerate eligible queries. It is designed for queries that scan large amounts of data and would otherwise take longer or consume significant warehouse resources.
Why C is correct:
The Query Acceleration Service can offload portions of query processing to shared compute resources provided by Snowflake. This helps speed up expensive or long-running queries without permanently resizing the virtual warehouse.
Why the other options are incorrect:
A). Resource monitor controls and monitors credit usage. It can suspend warehouses or send alerts, but it does not scale compute for expensive queries.
B). Materialized view stores precomputed query results to improve performance for repeated query patterns, but it does not temporarily scale a warehouse.
D). Search optimization service improves point lookup and selective query performance on large tables, but it does not temporarily scale virtual warehouse compute.
Official Snowflake documentation reference:
Snowflake documentation describes the Query Acceleration Service as a feature that can improve the performance of eligible queries by using additional compute resources. It is commonly associated with accelerating parts of large scans and reducing the impact of outlier queries.
Reference: Snowflake Documentation - Query Acceleration Service; SnowPro Core Study Guide - Performance Optimization.
==

The Snowflake Cloud Services layer manages a variety of services that are crucial for the operation of the Snowflake platform. Among these services, Authentication and Metadata management are key components.
Authentication is essential for controlling access to the Snowflake environment, ensuring that only authorized users can perform actions within the platform. Metadata management involves handling all the metadata related to objects within Snowflake, such as tables, views, and databases, which is vital for the organization and retrieval of data.
References:
[ COF-C03 ] SnowPro Core Certification Exam Study Guide
Snowflake Documentation12
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

The correct answer is A. SECURITYADMIN .
In Snowflake's default role hierarchy, the SECURITYADMIN role is responsible for managing security- related objects and grants. This role is granted the global MANAGE GRANTS privilege, which allows it to manage object grants across the account.
Why A is correct:
SECURITYADMIN is the built-in role designed to manage users, roles, and grants. By default, it has the ability to grant and revoke privileges.
Why the other options are incorrect:
B). USERADMIN is used primarily for user and role management, but it does not have the same broad default grant management authority as SECURITYADMIN.
C). SYSADMIN is typically used to create and manage account objects such as warehouses, databases, schemas, and tables, but it is not the default security grant administrator.
D). PUBLIC is automatically granted to every user and should not be used for administrative grant management.
Official Snowflake documentation reference:
Snowflake documentation describes SECURITYADMIN as the role that manages grants globally and inherits the privileges of USERADMIN. It includes the MANAGE GRANTS privilege by default.
Reference: Snowflake Documentation - System-defined roles; Snowflake Documentation - Access control overview; SnowPro Core Study Guide - Security and Access Control.
==

Even if a developer is granted ownership of a table with a masking policy, they will not be able to modify the table to read the masked data if their role does not have the necessary permissions. Ownership of a table does not automatically confer the ability to alter masking policies, which are designed to protect sensitive data. Masking policies are applied at the schema level and requirespecific privileges to modify12.
References:
[ COF-C03 ] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Masking Policies

The GOVERNANCE_VIEWER role in the ACCOUNT_USAGE schema provides visibility into policy- related information within Snowflake. This role is specifically designedto access views that display object metadata and usage metrics related to governance12.