ExamGecko
Search Search Login
Home Home / Snowflake / COF-C02

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

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
Which minimum Snowflake edition allows for a dedicated metadata store?
How can the outer array structure of a semi-structured file be removed?
Who can access the data published in a Data Exchange?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
What virtual warehouse configuration should be used when processing a large number of complex queries?
Which Query Profile metrics will provide information that can be used to improve query performance? (Select TWO).
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How does the search optimization service improve query performance?
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Select TWO).

Question 221

Report
Export
Collapse

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

A.
1
A.
1
Answers
B.
2
B.
2
Answers
C.
3
C.
3
Answers
D.
4
D.
4
Answers
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

Question 222

Report
Export
Collapse

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

A.
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.
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 ..
Answers
B.
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();
B.
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();
Answers
C.
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();
C.
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();
Answers
D.
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.
D.
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.
Answers
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.

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?

A.
Standard
A.
Standard
Answers
B.
Enterprise
B.
Enterprise
Answers
C.
Business Critical
C.
Business Critical
Answers
D.
Virtual Private Snowflake
D.
Virtual Private Snowflake
Answers
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.

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?

A.
When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
A.
When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
Answers
B.
When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
B.
When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
Answers
C.
When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
C.
When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
Answers
D.
When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
D.
When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
Answers
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

Question 225

Report
Export
Collapse

What is cached during a query on a virtual warehouse?

A.
All columns in a micro-partition
A.
All columns in a micro-partition
Answers
B.
Any columns accessed during the query
B.
Any columns accessed during the query
Answers
C.
The columns in the result set of the query
C.
The columns in the result set of the query
Answers
D.
All rows accessed during the query
D.
All rows accessed during the query
Answers
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

Question 226

Report
Export
Collapse

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

A.
Caching query results
A.
Caching query results
Answers
B.
Running EXPLAIN and SHOW commands
B.
Running EXPLAIN and SHOW commands
Answers
C.
Cloning a database
C.
Cloning a database
Answers
D.
Running a custom query
D.
Running a custom query
Answers
E.
Running COPY commands
E.
Running COPY commands
Answers
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

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?

A.
The reader account will automatically use the Standard edition of Snowflake.
A.
The reader account will automatically use the Standard edition of Snowflake.
Answers
B.
The reader account compute will be billed to the provider account.
B.
The reader account compute will be billed to the provider account.
Answers
C.
The reader account can clone data the provider has shared, but cannot re-share it.
C.
The reader account can clone data the provider has shared, but cannot re-share it.
Answers
D.
The reader account can create a copy of the shared data using CREATE TABLE AS...
D.
The reader account can create a copy of the shared data using CREATE TABLE AS...
Answers
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

Question 228

Report
Export
Collapse

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

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

Question 229

Report
Export
Collapse

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

A.
The warehouse size does not change until all queries currently running in the warehouse have completed.
A.
The warehouse size does not change until all queries currently running in the warehouse have completed.
Answers
B.
The warehouse size does not change until all queries currently in the warehouse queue have completed.
B.
The warehouse size does not change until all queries currently in the warehouse queue have completed.
Answers
C.
The warehouse size does not change until the warehouse is suspended and restarted.
C.
The warehouse size does not change until the warehouse is suspended and restarted.
Answers
D.
It does not return from the command until the warehouse has finished changing its size.
D.
It does not return from the command until the warehouse has finished changing its size.
Answers
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

Question 230

Report
Export
Collapse

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

A.
GeoJSON
A.
GeoJSON
Answers
B.
Array
B.
Array
Answers
C.
XML
C.
XML
Answers
D.
Object
D.
Object
Answers
E.
BLOB
E.
BLOB
Answers
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

Total 716 questions
Go to page: of 72
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms