ExamGecko
Home / Snowflake / COF-R02
Ask Question

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

Question list
Search

Question 191

Report
Export
Collapse

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

10-50 MB
10-50 MB
100-250 MB
100-250 MB
300-500 MB
300-500 MB
1000-1500 MB
1000-1500 MB
Suggested answer: B
asked 23/09/2024
Alex Agenjo Fernandez
26 questions

Question 192

Report
Export
Collapse

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

External Tokenization
External Tokenization
External Tables
External Tables
Materialized Views
Materialized Views
User-Defined Table Functions (UDTF)
User-Defined Table Functions (UDTF)
Suggested answer: A
asked 23/09/2024
Kyle Norton
37 questions

Question 193

Report
Export
Collapse

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

VIEWS_HISTORY
VIEWS_HISTORY
OBJECT_HISTORY
OBJECT_HISTORY
ACCESS_HISTORY
ACCESS_HISTORY
LOGIN_HISTORY
LOGIN_HISTORY
Suggested answer: C
asked 23/09/2024
Angélica González
41 questions

Question 194

Report
Export
Collapse

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

1 second
1 second
60 seconds
60 seconds
5 minutes
5 minutes
60 minutes
60 minutes
Suggested answer: B
asked 23/09/2024
Brooke Galiata
32 questions

Question 195

Report
Export
Collapse

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

Authentication
Authentication
Resource management
Resource management
Virtual warehouse caching
Virtual warehouse caching
Query parsing and optimization
Query parsing and optimization
Query execution
Query execution
Physical storage of micro-partitions
Physical storage of micro-partitions
Suggested answer: A, D, E
asked 23/09/2024
Karlis Priede
34 questions

Question 196

Report
Export
Collapse

How long is the Fail-safe period for temporary and transient tables?

There is no Fail-safe period for these tables.
There is no Fail-safe period for these tables.
1 day
1 day
7 days
7 days
31 days
31 days
90 days
90 days
Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

asked 23/09/2024
Deshawn Sharpe
38 questions

Question 197

Report
Export
Collapse

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

PUT
PUT
GET
GET
COPY
COPY
SELECT
SELECT
Suggested answer: B

Explanation:

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

asked 23/09/2024
mckeon mackey
31 questions

Question 198

Report
Export
Collapse

How does Snowflake Fail-safe protect data in a permanent table?

Fail-safe makes data available up to 1 day, recoverable by user operations.
Fail-safe makes data available up to 1 day, recoverable by user operations.
Fail-safe makes data available for 7 days, recoverable by user operations.
Fail-safe makes data available for 7 days, recoverable by user operations.
Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
Suggested answer: C
asked 23/09/2024
Dinuka Darshana
45 questions

Question 199

Report
Export
Collapse

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

Snowflake COF-R02 image Question 199 74035 09232024004436000000

What action should be taken to address this situation?

Increase the warehouse size from Medium to 2XL.
Increase the warehouse size from Medium to 2XL.
Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
Configure the warehouse to a multi-cluster warehouse.
Configure the warehouse to a multi-cluster warehouse.
Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
Suggested answer: B
asked 23/09/2024
Sergey Aleksandrov
50 questions

Question 200

Report
Export
Collapse

Which minimum Snowflake edition allows for a dedicated metadata store?

Standard
Standard
Enterprise
Enterprise
Business Critical
Business Critical
Virtual Private Snowflake
Virtual Private Snowflake
Suggested answer: D

Explanation:

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

asked 23/09/2024
Kareem Dadoul
43 questions
Total 330 questions
Go to page: of 33