ExamGecko
Home / Snowflake / COF-C02
Ask Question

Snowflake COF-C02 Practice Test - Questions Answers, Page 23

Question list
Search

Question 221

Report
Export
Collapse

How many resource monitors can be assigned at the account level?

1
1
2
2
3
3
4
4
Suggested answer: A

Explanation:

Snowflake allows for only one resource monitor to be assigned at the account level.This monitor oversees the credit usage of all the warehouses in the account. References: Snowflake Documentation

asked 23/09/2024
Idan Bar-On
37 questions

Question 222

Report
Export
Collapse

How would a user execute a series of SQL statements using a task?

Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
Suggested answer: C

Explanation:

To execute a series of SQL statements using a task, a user would use a stored procedure that contains multiple SQL statements and invoke this stored procedure from the task. References: Snowflake Documentation2.

asked 23/09/2024
rudzani nndwammbi
30 questions

Question 223

Report
Export
Collapse

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

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

Explanation:

The minimum Snowflake edition required for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery is the Business Critical edition. References: Snowflake Documentation3.

asked 23/09/2024
Saikhantsetseg Donnelly
38 questions

Question 224

Report
Export
Collapse

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
Suggested answer: D

Explanation:

In a standard multi-cluster warehouse with auto-scaling, a cluster will shut down when, after 2-3 consecutive checks, the system determines that the load on the least-loaded cluster could be redistributed to other clusters. This ensures efficient resource utilization and cost management. References: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Francinilo Leitao Ferreira
34 questions

Question 225

Report
Export
Collapse

What is cached during a query on a virtual warehouse?

All columns in a micro-partition
All columns in a micro-partition
Any columns accessed during the query
Any columns accessed during the query
The columns in the result set of the query
The columns in the result set of the query
All rows accessed during the query
All rows accessed during the query
Suggested answer: C

Explanation:

During a query on a virtual warehouse, the columns in the result set of the query are cached. This allows for faster retrieval of data if the same or a similar query is run again, as the system can retrieve the data from the cache rather than reprocessing the entire query. References: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Melissa Petrini
29 questions

Question 226

Report
Export
Collapse

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Caching query results
Caching query results
Running EXPLAIN and SHOW commands
Running EXPLAIN and SHOW commands
Cloning a database
Cloning a database
Running a custom query
Running a custom query
Running COPY commands
Running COPY commands
Suggested answer: B, D

Explanation:

Running EXPLAIN and SHOW commands, as well as running a custom query, consume virtual warehouse credits in the Snowflake environment. These activities require computational resources, and therefore, credits are used to account for the usage of these resources. References: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Adrien BARDE
31 questions

Question 227

Report
Export
Collapse

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called 'CONSUMER'

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

The reader account will automatically use the Standard edition of Snowflake.
The reader account will automatically use the Standard edition of Snowflake.
The reader account compute will be billed to the provider account.
The reader account compute will be billed to the provider account.
The reader account can clone data the provider has shared, but cannot re-share it.
The reader account can clone data the provider has shared, but cannot re-share it.
The reader account can create a copy of the shared data using CREATE TABLE AS...
The reader account can create a copy of the shared data using CREATE TABLE AS...
Suggested answer: B

Explanation:

The reader account compute will be billed to the provider account. Very Comprehensive Explanation: In Snowflake, when a provider creates a reader account for a consumer who does not have a Snowflake account, the compute resources used by the reader account are billed to the provider's account. This allows the consumer to query the shared data without incurring any costs. References: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Francesco MARRELLA
40 questions

Question 228

Report
Export
Collapse

Which of the following can be used when unloading data from Snowflake? (Choose two.)

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
Use the ENCODING file format option to change the encoding from the default UTF-8.
Use the ENCODING file format option to change the encoding from the default UTF-8.
The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
Suggested answer: C, D

Explanation:

The OBJECT_CONSTRUCT function is used in Snowflake to create a JSON object from relational data, which is useful when unloading semi-structured data. The SINGLE = TRUE parameter is used when unloading data to ensure that the data is exported as a single file, which can be up to 5 GB in size. References: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Jerome Fortin
34 questions

Question 229

Report
Export
Collapse

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

The warehouse size does not change until all queries currently running in the warehouse have completed.
The warehouse size does not change until all queries currently running in the warehouse have completed.
The warehouse size does not change until all queries currently in the warehouse queue have completed.
The warehouse size does not change until all queries currently in the warehouse queue have completed.
The warehouse size does not change until the warehouse is suspended and restarted.
The warehouse size does not change until the warehouse is suspended and restarted.
It does not return from the command until the warehouse has finished changing its size.
It does not return from the command until the warehouse has finished changing its size.
Suggested answer: D

Explanation:

The WAIT_FOR_COMPLETION = TRUE parameter in an ALTER WAREHOUSE command ensures that the command does not return until the warehouse has completed resizing. This means that the command will wait until all the necessary compute resources have been provisioned and the warehouse size has been changed. References: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Anil Dagar
39 questions

Question 230

Report
Export
Collapse

Which formats does Snowflake store unstructured data in? (Choose two.)

GeoJSON
GeoJSON
Array
Array
XML
XML
Object
Object
BLOB
BLOB
Suggested answer: A, C

Explanation:

Snowflake supports storing unstructured data and provides native support for semi-structured file formats such as JSON, Avro, Parquet, ORC, and XML1. GeoJSON, being a type of JSON, and XML are among the formats that can be stored in Snowflake. References: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
PANAGIOTIS SYKAS
39 questions
Total 716 questions
Go to page: of 72