Snowflake COF-R02 Exam Questions Instant Access

Question 1

Which stage type can be altered and dropped?

ADatabase stage

BExternal stage

CTable stage

DUser stage

Answer : C

https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages

Question 2

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 : D

Question 3

Which Snowflake architectural layer is responsible for a query execution plan?

ACompute

BData storage

CCloud services

DCloud provider

Answer : D

Question 4

Which feature is only available in the Enterprise or higher editions of Snowflake?

AColumn-level security

BSOC 2 type II certification

CMulti-factor Authentication (MFA)

DObject-level access control

Answer : A

https://docs.snowflake.com/en/user-guide/intro-editions.html

Question 5

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

ACompute resources

BQuery execution

CAuthentication

DData storage

EMetadata

Answer : C, E

https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.

Services managed in this layer include:

Authentication

Infrastructure management

Metadata management

Query parsing and optimization

Access control

Question 6

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

AIs available to all Snowflake Editions

BIs only available to customers with Business Critical Edition

CRestricts or enables access to specific IP addresses

DIs activated using an ''ALTER DATABASE'' command

Answer : A, C

Question 7

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

ATri-Secret Secure

BTime Travel

CFail-safe

DData encryption

EExternal stages

Answer : B, C

Snowflake SnowPro Core Recertification COF-R02 Exam Questions