Confidently Practice Online with Free COF-R02 Exam Cram

Practice your SnowPro Core Recertification certification test with free COF-R02 exam cram and take control of your certification preparation. At FreeExamCram, you can practice online for free using real COF-R02 exam dumps, verified questions, and expert-designed free online practice tests. Moreover our Snowflake COF-R02 exam cram backed by our confidence-boosting refund guarantee.

Question 1

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

Options :

A : A directory table is a separate database object.

B : Directory tables store data file metadata.

C : A directory table will be automatically added to a stage.

D : Directory tables do not have their own grantable privileges.

E : Directory table data can not be refreshed manually.

Answer: B,D

Question 2

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Options :

A : Materialized views

B : Sequences

C : Procedures

D : Tables

E : Secure User Defined Functions (UDFs)

Answer: A,D

Question 3

Which of the following roles is recommended to be used to create and manage users and roles?

Options :

A : SYSADMIN

B : SECURITYADMIN

C : PUBLIC

D : ACCOUNTADMIN

Answer: B

Question 4

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

Options :

A : They happen approximately weekly

B : They roll up and release approximately monthly, but customers can request early release application

C :

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

version

D :

A 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

Answer: A,C

Question 5

When loading data into Snowflake, how should the data be organized?

Options :

A : Into single files with 100-250 MB of compressed data per file

B : Into single files with 1-100 MB of compressed data per file

C : Into files of maximum size of 1 GB of compressed data per file

D : Into files of maximum size of 4 GB of compressed data per file

Answer: A