ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core

Snowflake SnowPro Core Practice Test - Questions Answers, Page 24

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
Which Snowflake technique can be used to improve the performance of a query?
What is a key feature of Snowflake architecture?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
User-level network policies can be created by which of the following roles? (Select TWO).
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Will data cached in a warehouse be lost when the warehouse is resized?

Question 231

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.

Reference: Snowflake Documentation2.

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?

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.

Reference: Snowflake Documentation3.

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?

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.

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

Question 234

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.

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

Question 235

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.

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

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?

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.

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

Question 237

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.

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

Question 238

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.

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

Question 239

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.

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

Question 240

Report
Export
Collapse

Which of the following are characteristics of security in Snowflake?

A.
Account and user authentication is only available with the Snowflake Business Critical edition.
A.
Account and user authentication is only available with the Snowflake Business Critical edition.
Answers
B.
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
B.
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
Answers
C.
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
C.
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
Answers
D.
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
D.
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
Answers
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

Total 627 questions
Go to page: of 63
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