Snowflake COF-R02 Exam Questions Instant Access

Question 1

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

ADatabase replication and failover

BAutomated index management

CCustomer managed keys (Tri-secret secure)

DExtended time travel

ENative support for geospatial data

Answer : A, D

Question 2

The number of queries that a Virtual Warehouse can concurrently process is determined by:

Choose 2 answers

AThe complexity of each query

BThe CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

CThe size of the data required for each query

DThe tool that s executing the query

Answer : A, C

Question 3

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

AThe data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

BThe data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

CThe data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

DThe data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Answer : C

Question 4

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked dat

a. Will the developer be able to modify the table to read the masked data?

AYes, because a table owner has full control and can unset masking policies.

BYes, because masking policies only apply to cloned tables.

CNo, because masking policies must always reference specific access roles.

DNo, because ownership of a table does not include the ability to change masking policies

Answer : A

Question 5

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

AConfigure the warehouse to a size larger than generally required

BSet the minimum and maximum clusters to autoscale

CUse the standard warehouse scaling policy

DUse the economy warehouse scaling policy

Answer : B

Question 6

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

AThe primary cluster in the virtual warehouse

BThe entire virtual warehouse

CThe database in which the virtual warehouse resides

DThe Queries currently being run on the virtual warehouse

Answer : B

https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse.

Question 7

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

ACustom Edition

BVirtual Private Snowflake

CBusiness Critical Edition

DStandard Edition

EEnterprise Edition

Answer : B, C

Snowflake SnowPro Core Recertification COF-R02 Exam Questions