ExamGecko
Home Home / Snowflake / COF-R02

Snowflake COF-R02 Practice Test - Questions Answers, Page 22

Question list
Search
Search

Which SQL commands, when committed, will consume a stream and advance the stream offset?

(Choose two.)

A.
UPDATE TABLE FROM STREAM
A.
UPDATE TABLE FROM STREAM
Answers
B.
SELECT FROM STREAM
B.
SELECT FROM STREAM
Answers
C.
INSERT INTO TABLE SELECT FROM STREAM
C.
INSERT INTO TABLE SELECT FROM STREAM
Answers
D.
ALTER TABLE AS SELECT FROM STREAM
D.
ALTER TABLE AS SELECT FROM STREAM
Answers
E.
BEGIN COMMIT
E.
BEGIN COMMIT
Answers
Suggested answer: C, D

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

A.
Use the DROP <file> command after the load completes.
A.
Use the DROP <file> command after the load completes.
Answers
B.
Specify the TEMPORARY option when creating the file format.
B.
Specify the TEMPORARY option when creating the file format.
Answers
C.
Specify the PURGE copy option in the COPY INTO <table> command.
C.
Specify the PURGE copy option in the COPY INTO <table> command.
Answers
D.
Use the REMOVE command after the load completes.
D.
Use the REMOVE command after the load completes.
Answers
E.
Use the DELETE LOAD HISTORY command after the load completes.
E.
Use the DELETE LOAD HISTORY command after the load completes.
Answers
Suggested answer: C, D

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

Which diagram indicates a well-clustered table?

A.
A.
Answers
B.
B.
Answers
C.
C.
Answers
D.
D.
Answers
Suggested answer: A

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

A.
The explain plan output is available graphically.
A.
The explain plan output is available graphically.
Answers
B.
An explain plan can be used to conduct performance analysis without executing a query.
B.
An explain plan can be used to conduct performance analysis without executing a query.
Answers
C.
An explain plan will handle queries with temporary tables and the query profiler will not.
C.
An explain plan will handle queries with temporary tables and the query profiler will not.
Answers
D.
An explain plan's output will display automatic data skew optimization information.
D.
An explain plan's output will display automatic data skew optimization information.
Answers
Suggested answer: B

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

A.
VARIANT
A.
VARIANT
Answers
B.
VARRAY
B.
VARRAY
Answers
C.
STRUCT
C.
STRUCT
Answers
D.
ARRAY
D.
ARRAY
Answers
E.
QUEUE
E.
QUEUE
Answers
Suggested answer: A, D

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

A.
Optimizes the virtual warehouse size and multi-cluster setting to economy mode
A.
Optimizes the virtual warehouse size and multi-cluster setting to economy mode
Answers
B.
Allows a user to import the files in a sequential order
B.
Allows a user to import the files in a sequential order
Answers
C.
Increases the latency staging and accuracy when loading the data
C.
Increases the latency staging and accuracy when loading the data
Answers
D.
Allows optimization of parallel operations
D.
Allows optimization of parallel operations
Answers
Suggested answer: D

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

A.
Database replication and failover
A.
Database replication and failover
Answers
B.
Automated index management
B.
Automated index management
Answers
C.
Customer managed keys (Tri-secret secure)
C.
Customer managed keys (Tri-secret secure)
Answers
D.
Extended time travel
D.
Extended time travel
Answers
E.
Native support for geospatial data
E.
Native support for geospatial data
Answers
Suggested answer: A, D

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

A.
5 MB
A.
5 MB
Answers
B.
8 GB
B.
8 GB
Answers
C.
16 MB
C.
16 MB
Answers
D.
32 MB
D.
32 MB
Answers
Suggested answer: C

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

A.
Row level access policies
A.
Row level access policies
Answers
B.
Data masking policies
B.
Data masking policies
Answers
C.
Data encryption
C.
Data encryption
Answers
D.
Time Travel
D.
Time Travel
Answers
E.
External tokenization
E.
External tokenization
Answers
Suggested answer: C, D

Which Snowflake layer is always leveraged when accessing a query from the result cache?

A.
Metadata
A.
Metadata
Answers
B.
Data Storage
B.
Data Storage
Answers
C.
Compute
C.
Compute
Answers
D.
Cloud Services
D.
Cloud Services
Answers
Suggested answer: D
Total 330 questions
Go to page: of 33