examstrack logo
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
When the system has enough load for 2 minutes
When the system has enough load for 6 minutes
When the system has enough load for 8 minutes
When the system has enough load for 10 minutes
In an auto-scaling multi-cluster virtual warehouse with the SCALING_POLICY set to ECONOMY, another cluster is started when the system has enough load for 2 minutes (A). This policy is designed to optimize the balance between performance and cost, starting additional clusters only when the sustained load justifies it2.
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
Scaling out adds clusters of varying sizes to a virtual warehouse.
Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
Scaling up resizes a virtual warehouse so it can handle more complex workloads.
Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
Scaling out in Snowflake involves adding clusters of the same size to a virtual warehouse, which allows for handling more concurrent queries without affecting the performance of individual queries. Scaling up refers to resizing a virtual warehouse to increase its compute resources, enabling it to handle more complex workloads and larger queries more efficiently.
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
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
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 dynamic data masking.
Use secure materialized views.
Revoke all roles for functional managers and end users.
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
Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)
NUMBER
OBJECT
STRING
VARCHAR
VARIANT
Snowflake supports semi-structured data types, which include OBJECT and VARIANT. These data types are capable of storing JSON-like data structures, allowing for flexibility in data representation. OBJECT can directly contain VARIANT, and thus indirectly contain any other data type, including itself1.
How does a scoped URL expire?
When the data cache clears.
When the persisted query result period ends.
The encoded URL access is permanent.
The length of time is specified in the expiration_time argument.
A scoped URL expires when the persisted query result period ends, which is typically after the results cache expires. This is currently set to 24 hours
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
30 days
7 days
48 hours
24 hours
For a temporary table, the maximum total Continuous Data Protection (CDP) charges incurred are for the duration of the session in which the table was created, which does not exceed 24 hours2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation2
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Use the DROP
Specify the TEMPORARY option when creating the file format.
Specify the PURGE copy option in the COPY INTO
|
PDF + Testing Engine
|
|---|
|
$57.75 |
|
Testing Engine
|
|---|
|
$43.75 |
|
PDF (Q&A)
|
|---|
|
$36.75 |
Snowflake Free Exams |
|---|
|
Copyright © 2025 Examstrack. All Rights Reserved
TESTED 13 Jul 2025
