Free SnowPro Core COF-C03 Exam Braindumps
SnowPro Core COF-C03 Questions 33–40 (page: 6)

Updated On: 9-Apr-2026

Which action can be performed by the SYSADMIN role without requiring elevated privileges from the ACCOUNTADMIN or SECURITYADMIN role?

  1. Granting privileges
  2. Creating a new user
  3. Managing virtual warehouses
  4. Viewing billing and usage information

Answer(s): C

Explanation:

The SYSADMIN role is responsible for managing database objects and compute resources, including creating, modifying, and operating virtual warehouses without requiring higher-level administrative privileges.



Which security features are used to control inbound access to Snowflake and internal stages? (Choose two.)

  1. Network rules
  2. Feature policies
  3. Network policies
  4. Packages policies
  5. Authentication policies

Answer(s): C,E

Explanation:

Network policies restrict inbound access to Snowflake by controlling allowed IP addresses, while authentication policies define how users authenticate, including security requirements such as MFA, helping control secure access to Snowflake and its resources.



Which built-in function should be used to determine if the current role has inherited privileges from another specified role?

  1. INVOKER_ROLE
  2. CURRENT_ROLE
  3. IS_ROLE--IN_SESSION
  4. CURRENT_ROLE_TYPE

Answer(s): C

Explanation:

This function checks whether a specified role is currently active in the session, including roles inherited through role hierarchy, allowing verification of inherited privileges.



A Snowflake user is using the QUERY_HISTORY view in the ACCOUNT_USAGE schema to gather information about two queries that ran in the past 10 minutes, but the expected data is missing.

What would cause this to occur?

  1. The queries were run on a multi-cluster virtual warehouse.
  2. The queries were able to take advantage of the results cache.
  3. The ACCOUNT_USAGE schema does not provide real-time results.
  4. The user does not have privileges to access the QUERY_HISTORY view.

Answer(s): C

Explanation:

The ACCOUNT_USAGE views have a latency (typically up to 45 minutes), so recently executed queries may not yet appear when querying QUERY_HISTORY.



Which feature allows a user to review the monthly projected costs of a Snowflake resource against the monthly actual costs?

  1. Budgets
  2. Auto-suspend
  3. Scaling Policy
  4. Resource monitor

Answer(s): A

Explanation:

Budgets provide visibility into projected monthly costs compared to actual usage, enabling users to monitor and manage spending against defined expectations.



A team needs to monitor and receive alerts for Snowpipe credit usage.

Why should a custom budget be used instead of a resource monitor?

  1. The custom budget is the only tool that can automatically send alert emails to users outside the ACCOUNTADMIN role.
  2. Resource monitors can only track costs for one virtual warehouse, but custom budgets monitor the entire account.
  3. Custom budgets track historical spending, while a resource monitor provides a cost forecast.
  4. Custom budgets can track costs by object tags and include serverless features.

Answer(s): D

Explanation:

Custom budgets can monitor costs across both warehouse and serverless features like Snowpipe and can be scoped using object tags, whereas resource monitors apply only to virtual warehouse usage.



These application roles exist in a company's environment: DEVELOPER_ROLE and ETL_ROLE. Both roles have been granted USAGE, CREATE, and SELECT privileges on the same database and schema table object.

A user with the DEVELOPER_ROLE creates a new table named MYTABLE within the MYDB.MYSCH schema. When a user with the ETL_ROLE attempts to access MYDB.MYSCH.MYTABLE, they receive an error indicating insufficient privileges.

Which statement will enable the ETL_ROLE to access MYDB.MYSCH.MYTABLE upon its creation?

  1. GRANT SELECT ON TABLE MYTABLE TO ROLE ETL_ROLE;
  2. GRANT SELECT ON TABLE MYTABLE TO ROLE DEVELOPER_ROLE;
  3. GRANT SELECT ON FUTURE TABLES IN SCHEMA MYSCH TO ROLE ETL_ROLE;
  4. GRANT SELECT ON FUTURE TABLES IN SCHEMA MYSCH TO ROLE DEVELOPER_ROLE;

Answer(s): C

Explanation:

Granting privileges on future tables in the schema ensures that any newly created tables automatically inherit the required access for the role, eliminating the need to grant permissions manually after each creation.



Which security feature supports the replacement of active keys to enhance key-pair authentication?

  1. Authentication
  2. Passkeys
  3. Rotation
  4. Time-based one-time passcodes

Answer(s): C

Explanation:

Key rotation allows replacing active keys with new ones to maintain security, ensuring that key-pair authentication remains protected over time.



Viewing page 6 of 14
Viewing questions 41 - 48 out of 100 questions


Post your Comments and Discuss Snowflake SnowPro Core COF-C03 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!