Question 1

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Options :

A : The Pipe load history is reset to empty.

B : The REFRESH command is executed.

C : The stage will be purged.

D : The destination table is truncated.

Answer: B

Question 2

What is the default file size when unloading data from Snowflake using the COPY command?

Options :

A : 5 MB

B : 8 GB

C : 16 MB

D : 32 MB

Answer: C

Question 3

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 4

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 5

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

Options :

A : The ability to scale up warehouses

B : The use of warehouse auto scaling

C : The ability to resize warehouses

D : Use of multi-clustered warehouses

E : The use of warehouse indexing

Answer: B,D

Higher Test Marks with Free Online COF-R02 Exam Practice