ExamGecko
Home / Snowflake / COF-R02
Ask Question

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

Question list
Search

Question 31

Report
Export
Collapse

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

True
True
False
False
Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

asked 23/09/2024
Peter Sundstrom
31 questions

Question 32

Report
Export
Collapse

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Customers can change the size of the Warehouse after creation
Customers can change the size of the Warehouse after creation
A Warehouse can be resized while running
A Warehouse can be resized while running
A Warehouse can be configured to suspend after a period of inactivity
A Warehouse can be configured to suspend after a period of inactivity
A Warehouse can be configured to auto-resume when new queries are submitted
A Warehouse can be configured to auto-resume when new queries are submitted
Suggested answer: A, B, C, D

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

asked 23/09/2024
soliman sallam
40 questions

Question 33

Report
Export
Collapse

The PUT command: (Choose two.)

Automatically creates a File Format object
Automatically creates a File Format object
Automatically uses the last Stage created
Automatically uses the last Stage created
Automatically compresses files using Gzip
Automatically compresses files using Gzip
Automatically encrypts files
Automatically encrypts files
Suggested answer: C, D

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html

asked 23/09/2024
Enrique Jose Lopez Bolivar
43 questions

Question 34

Report
Export
Collapse

Which interfaces can be used to create and/or manage Virtual Warehouses?

The Snowflake Web Interface (UI)
The Snowflake Web Interface (UI)
SQL commands
SQL commands
Data integration tools
Data integration tools
All of the above
All of the above
Suggested answer: D

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/warehouses.html

asked 23/09/2024
Adetutu Ogunsowo
45 questions

Question 35

Report
Export
Collapse

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty
The Pipe load history is reset to empty
The REFRESH parameter is set to TRUE
The REFRESH parameter is set to TRUE
Previously loaded files will be ignored
Previously loaded files will be ignored
All of the above
All of the above
Suggested answer: A

Explanation:

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history

"When a pipe is recreated, the load history is dropped."

asked 23/09/2024
Pedro Miguel Garcia Valdes
43 questions

Question 36

Report
Export
Collapse

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Standard
Standard
Premier
Premier
Enterprise
Enterprise
Business Critical Edition
Business Critical Edition
Suggested answer: D

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html

asked 23/09/2024
Armands Vestmanis
45 questions

Question 37

Report
Export
Collapse

True or False: It is possible to load data into Snowflake without creating a named File Format object.

True
True
False
False
Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-fileformat.html

asked 23/09/2024
Maria Telan
32 questions

Question 38

Report
Export
Collapse

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True
True
False
False
Suggested answer: B
asked 23/09/2024
Sae Frrr
29 questions

Question 39

Report
Export
Collapse

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

True
True
False
False
Suggested answer: A
asked 23/09/2024
Jeffrey VanBemmel
39 questions

Question 40

Report
Export
Collapse

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

They happen approximately weekly
They happen approximately weekly
They roll up and release approximately monthly, but customers can request early release application
They roll up and release approximately monthly, but customers can request early release application
During a release, new customer requests/queries/connections transparently move over to the newer version
During a release, new customer requests/queries/connections transparently move over to the newer version
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
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
Suggested answer: A, C

Explanation:

https://docs.snowflake.com/en/user-guide/intro-releases.html

asked 23/09/2024
Tr Skumar
55 questions
Total 330 questions
Go to page: of 33