ExamGecko
Login
Home / Snowflake / COF-C02 / List of questions
Ask Question

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

List of questions

Question 141

Report Export Collapse

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Use the DROP <file> command after the load completes.
Use the DROP <file> command after the load completes.
Specify the TEMPORARY option when creating the file format.
Specify the TEMPORARY option when creating the file format.
Specify the PURGE copy option in the COPY INTO <table> command.
Specify the PURGE copy option in the COPY INTO <table> command.
Use the REMOVE command after the load completes.
Use the REMOVE command after the load completes.
Use the DELETE LOAD HISTORY command after the load completes.
Use the DELETE LOAD HISTORY command after the load completes.
Suggested answer: C, D
Explanation:

To delete staged files from a Snowflake stage, you can specify thePURGEoption in theCOPY INTO <table>command, which will automatically delete the files after they have been successfully loaded.Additionally, you can use theREMOVEcommand after the load completes to manually delete the files from the stage12.

References =DROP STAGE,REMOVE

asked 23/09/2024
George Mabry
52 questions

Question 142

Report Export Collapse

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

Which diagram indicates a well-clustered table?

Option A
Option A
Option B
Option B
Option C
Option C
Option D
Option D
Suggested answer: C
Explanation:

A well-clustered table in Snowflake means that the data is organized in such a way that related data points are stored close to each other within the micro-partitions. This optimizes query performance by reducing the amount of scanned data.The diagram indicated by option C shows a well-clustered table, as it likely represents a more evenly distributed range of values across the micro-partitions1.

References =Snowflake Micro-partitions & Table Clustering

asked 23/09/2024
Wellington Rodrigues da Costa
41 questions

Question 143

Report Export Collapse

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

The explain plan output is available graphically.
The explain plan output is available graphically.
An explain plan can be used to conduct performance analysis without executing a query.
An explain plan can be used to conduct performance analysis without executing a query.
An explain plan will handle queries with temporary tables and the query profiler will not.
An explain plan will handle queries with temporary tables and the query profiler will not.
An explain plan's output will display automatic data skew optimization information.
An explain plan's output will display automatic data skew optimization information.
Suggested answer: B
Explanation:

An explain plan is beneficial because it allows for the evaluation of how a query will be processed without the need to actually execute the query.This can help in understanding the query's performance implications and potential bottlenecks without consuming resources that would be used if the query were run

asked 23/09/2024
Mounir Mrabet
45 questions

Question 144

Report Export Collapse

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

VARIANT
VARIANT
VARRAY
VARRAY
STRUCT
STRUCT
ARRAY
ARRAY
QUEUE
QUEUE
Suggested answer: A, D
Explanation:

Snowflake supports the VARIANT and ARRAY data types for semi-structured data. VARIANT can store values of any other type, including OBJECT and ARRAY, making it suitable for semi-structured data formats like JSON.ARRAY is used to store an ordered list of elements

asked 23/09/2024
HWANG SEON TAE
48 questions

Question 145

Report Export Collapse

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Optimizes the virtual warehouse size and multi-cluster setting to economy mode
Optimizes the virtual warehouse size and multi-cluster setting to economy mode
Allows a user to import the files in a sequential order
Allows a user to import the files in a sequential order
Increases the latency staging and accuracy when loading the data
Increases the latency staging and accuracy when loading the data
Allows optimization of parallel operations
Allows optimization of parallel operations
Suggested answer: D
Explanation:

Snowflake recommends file sizes between 100-250 MB compressed when loading data to optimize parallel processing.Smaller, compressed files can be loaded in parallel, which maximizes the efficiency of the virtual warehouses and speeds up the data loading process

asked 23/09/2024
Mario Herrera González
50 questions

Question 146

Report Export Collapse

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

Database replication and failover
Database replication and failover
Automated index management
Automated index management
Customer managed keys (Tri-secret secure)
Customer managed keys (Tri-secret secure)
Extended time travel
Extended time travel
Native support for geospatial data
Native support for geospatial data
Suggested answer: A, D
Explanation:

The Snowflake Enterprise edition includes database replication and failover for business continuity and disaster recovery, as well as extended time travel capabilities for longer data retention periods1.

asked 23/09/2024
Yohan Frachisse
33 questions

Question 147

Report Export Collapse

What is the default file size when unloading data from Snowflake using the COPY command?

5 MB
5 MB
8 GB
8 GB
16 MB
16 MB
32 MB
32 MB
Suggested answer: C
Explanation:

The default file size when unloading data from Snowflake using the COPY command is not explicitly stated in the provided resources.However, Snowflake documentation suggests that the file size can be specified using theMAX_FILE_SIZEoption in theCOPY INTO <location>command2.

asked 23/09/2024
justin staley
38 questions

Question 148

Report Export Collapse

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

Row level access policies
Row level access policies
Data masking policies
Data masking policies
Data encryption
Data encryption
Time Travel
Time Travel
External tokenization
External tokenization
Suggested answer: C, D
Explanation:

Data encryption and Time Travel are part of Snowflake's Continuous Data Protection (CDP) feature set that do not require additional configuration.Data encryption is automatically applied to all files stored on internal stages, and Time Travel allows for querying and restoring data without any extra setup

asked 23/09/2024
Kaliannan K
40 questions

Question 149

Report Export Collapse

Which Snowflake layer is always leveraged when accessing a query from the result cache?

Metadata
Metadata
Data Storage
Data Storage
Compute
Compute
Cloud Services
Cloud Services
Suggested answer: D
Explanation:

The Cloud Services layer in Snowflake is responsible for managing the result cache.When a query is executed, the results are stored in this cache, and subsequent identical queries can leverage these cached results without re-executing the entire query1.

asked 23/09/2024
Govinda Bhikha
42 questions

Question 150

Report Export Collapse

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

How can this requirement be met?

Use data encryption.
Use data encryption.
Use dynamic data masking.
Use dynamic data masking.
Use secure materialized views.
Use secure materialized views.
Revoke all roles for functional managers and end users.
Revoke all roles for functional managers and end users.
Suggested answer: B
Explanation:

Dynamic data masking is a feature in Snowflake that allows administrators to define masking policies to protect sensitive data.It enables partial visibility of the data to certain roles, such as functional managers, while hiding it from others, like end users

asked 23/09/2024
Johnny Tien
54 questions
Total 716 questions
Go to page: of 72
Open VPLUS File
Convert VPLUS to PDF

Related questions

How can the outer array structure of a semi-structured file be removed?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
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?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
How does the search optimization service improve query performance?
What is a key feature of Snowflake architecture?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).