Snowflake COF-C02 Exam Practice Test Instant Access

Question 1

Which Snowflake feature enables loading data from cloud storage as soon as files ate available in a stage?

ACOPY_INTO <location> command

BData replication

CSnowpipe

DDirect share

Answer : C

Question 2

What is the expiration period tor a file URL used to access unstructured data in cloud storage?

AThe remainder of the session

BAn unlimited amount of time

CThe length of time specified in the expiration_time argument

DThe same length of time as the expiration period for the query results cache

Answer : D

Question 3

Which Snowflake data governance feature supports resource usage monitoring?

AData classification

BColumn lineage

CAccess history

DObject tagging

Answer : D

Question 4

When cloning a schema, which Snowflake object will not be included in the clone?

AAn external stage

BA named internal stage

CA task

DA User-Defined Function (UDF)

Answer : A

Question 5

Which features can be used with the Snowflake Standard edition? (Select TWO).

AMaterialized views

BExternal functions

CMulti-cluster virtual warehouses

DFail-safe

ERow-level security

Answer : A, C

Question 6

Which privilege is required for a user to be able to view a resource monitor?

AUSAGE

BSELECT

CMONITOR

DOPERATE

Answer : C

Question 7

A user creates a stage using the following command:

What will be the outcome?

AA stage with a directory table set to automatically refresh will be created.

BA stage with a directory table that has metadata that must be manually refreshed will be created.

CAn error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.

DThe command will fail to run because the name of the directory table is not specified.

Answer : A

Snowflake COF-C02 SnowPro Core Certification Exam Practice Test