Snowflake COF-R02 Exam Practice Test Instant Access

Question 1

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

AThe reader account will automatically use the Standard edition of Snowflake.

BThe reader account compute will be billed to the provider account.

CThe reader account can clone data the provider has shared, but cannot re-share it.

DThe reader account can create a copy of the shared data using CREATE TABLE AS...

Answer : C

Question 2

Which data type can store more than one type of data structure?

AJSON

BBINARY

CVARCHAR

DVARIANT

Answer : D

Question 3

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

AA directory table is a separate database object.

BDirectory tables store data file metadata.

CA directory table will be automatically added to a stage.

DDirectory tables do not have their own grantable privileges.

EDirectory table data can not be refreshed manually.

Answer : B, D

Question 4

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

AUSERADMIN

BPUBLIC

CORGADMIN

DSYSADMIN

Answer : D

Question 5

Which statement describes how Snowflake supports reader accounts?

AA reader account can consume data from the provider account that created it and combine it with its own data.

BA consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

CThe users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

DThe SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Answer : C

Question 6

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 7

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

ASchemas

BRoles

CSecure Views

DStored Procedures

ETables

FSecure User-Defined Functions (UDFs)

Answer : A, B, F

Snowflake COF-R02 SnowPro Core Recertification Exam Practice Test