ExamGecko
Login
Home / Snowflake / SnowPro Core / List of questions
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 24

List of questions

Question 231

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.

Reference: Snowflake Documentation2.

asked 23/09/2024
Gage Adams
37 questions

Question 232

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.

Reference: Snowflake Documentation3.

asked 23/09/2024
Swen Evers
41 questions

Question 233

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.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
BRUNO DE BRIDA
41 questions

Question 234

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.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Mario Alba Barrero
34 questions

Question 235

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.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Stephanie Scheffers
45 questions

Question 236

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.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
David Ezejimofor
42 questions

Question 237

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.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Baljit Bhadare
44 questions

Question 238

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.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Jose Walter
37 questions

Question 239

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.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Tim baxter
45 questions

Question 240

Report Export Collapse

Which of the following are characteristics of security in Snowflake?

Account and user authentication is only available with the Snowflake Business Critical edition.
Account and user authentication is only available with the Snowflake Business Critical edition.
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
Suggested answer: C
Explanation:

One of the security features of Snowflake includes the periodic rekeying of encrypted data, which is available with the Snowflake Enterprise edition and higher2. This ensures that the encryption keys are rotated regularly to maintain a high level of security.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
adil benmekki
39 questions
Total 627 questions
Go to page: of 63
Open VPLUS File
Convert VPLUS to PDF

Related questions

What is a key feature of Snowflake architecture?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
How is unstructured data retrieved from data storage?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
A materialized view should be created when which of the following occurs? (Choose two.)
What happens when a virtual warehouse is resized?
How can a Snowflake user traverse semi-structured data?
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
User-level network policies can be created by which of the following roles? (Select TWO).