Latest Snowflake COF-R02 Exam dumps 2026

Question No: 1

MultipleChoice

Which of the following are characteristics of security in Snowflake?

Options

AAccount and user authentication is only available with the Snowflake Business Critical edition.

BSupport for HIPAA and GDPR compliance is available for UI Snowflake editions.

CPeriodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

DPrivate communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Question No: 2

MultipleChoice

How many days is load history for Snowpipe retained?

Options

A1 day

B7 days

C14 days

D64 days

Question No: 3

MultipleChoice

What is the purpose of multi-cluster virtual warehouses?

Options

ATo create separate data warehouses to increase query optimization

BTo allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

CTo eliminate or reduce Queuing of concurrent queries

DTo allow the warehouse to resize automatically

Question No: 4

MultipleChoice

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Options

ACompute resources

BQuery execution

CAuthentication

DData storage

EMetadata

Question No: 5

MultipleChoice

True or False: A single database can exist in more than one Snowflake account.

Options

ATrue

BFalse

Question No: 6

MultipleChoice

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Options

ASHOW GRANTS OF ROLE MY_ROLE

BSHOW GRANTS TO ROLE MY_ROLE

CSHOW GRANTS FOR ROLE MY_ROLE

DSHOW GRANTS ON ROLE MY_ROLE

Question No: 7

MultipleChoice

What COPY INTO SQL command should be used to unload data into multiple files?

Options

ASINGLE=TRUE

BMULTIPLE=TRUE

CMULTIPLE=FALSE

DSINGLE=FALSE

Question No: 8

MultipleChoice

Which of the following statements are true of Snowflake releases: (Choose two.)

Options

AThey happen approximately weekly

BThey roll up and release approximately monthly, but customers can request early release application

CDuring a release, new customer requests/queries/connections transparently move over to the newer
version

DA customer is assigned a 30 minute window (that can be moved anytime within a week) during which the
system will be unavailable and customer is upgraded

Free Snowflake COF-R02 Exam Dumps July 2026