Snowflake COF-C03 Exam Questions Instant Access

Question 1

Which privilege must be granted by one role to another role, and cannot be revoked?

AMONITOR

BOPERATE

COWNERSHIP

DALL

Answer : C

The OWNERSHIP privilege is unique in that it must be granted by one role to another and cannot be revoked. This ensures that the transfer of ownership is deliberate and permanent, reflecting the importance of ownership in managing access and permissions.

Question 2

A security review identified several roles that are no longer being used. Which of the roles can be dropped?

AACCOUNTADMIN

BUSERADMIN

CFINANCEADMIN

DPUBLIC

Answer : C

Question 3

What is the LEAST-PRIVILEGED role that can create a share in Snowflake by default?

ASYSADMIN

BSECURITYADMIN

CUSERADMIN

DACCOUNTADMIN

Answer : D

Question 4

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

Agrant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

Bgrant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

Cgrant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

Dgrant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

Egrant SELECT on all tables in database DB1 to role MYROLE;

Fgrant SELECT on future tables in database DB1 to role MYROLE;

Answer : C, D

To grant a role the privilege to select data from all current and future tables in a schema, two separate commands are needed.The first command grants theSELECTprivilege on all existing tables within the schema, and the second command grants theSELECTprivilege on all tables that will be created in the future within the same schema.

Question 5

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

AWhen the system has enough load for 2 minutes

BWhen the system has enough load for 6 minutes

CWhen the system has enough load for 8 minutes

DWhen the system has enough load for 10 minutes

Answer : A

In an auto-scaling multi-cluster virtual warehouse with the SCALING_POLICY set to ECONOMY, another cluster is started when the system has enough load for 2 minutes (A).This policy is designed to optimize the balance between performance and cost, starting additional clusters only when the sustained load justifies it2.

Question 6

Which role has the ability to create and manage users and roles?

AORGADMIN

BUSERADMIN

CSYSADMIN

DSECURITYADMIN

Answer : B

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 7

Which functions are used to manipulate semi-structured data? (Select TWO)

AWIDTH_BUCKET

BHASH_AGG

CARRAY_APPEND

DOBJECT_INSERT

ELISTAGG

Answer : C, D

Functions like ARRAY_APPEND() and OBJECT_INSERT() are system-defined for manipulating ARRAY and OBJECT types within VARIANT data structures.

Snowflake Docs: Functions for Semi-Structured Data

===========

Snowflake SnowPro Core Certification 2026 COF-C03 Exam Questions