When a virtual warehouse in Snowflake is resized, specifically when it is increased in size, the additional compute resources become immediately available to all running and queued queries. Thismeans that the performance of these queries can improve due to the increased resources. Conversely, when the size of a warehouseis reduced, the compute resources are not removed until they are no longer being used by any current operations1.
[References:, [COF-C03] SnowPro Core Certification Exam Study Guide, Snowflake Documentation on Virtual Warehouses2, , ]
Question 17
True or False: A Virtual Warehouse can be resized while suspended.
Virtual Warehouses in Snowflake can indeed be resized while they are suspended. Resizing a warehouse involves changing the number of compute resources (servers) allocated to it, which can be done to adjust performance and cost. When a warehouse is suspended, it is not currently running any queries, but its definition and metadata remain intact, allowing for modifications like resizing.
Secure data sharing in Snowflake allows users to share various objects between Snowflake accounts without physically copying the data, thus not consuming additional storage. Among the options provided, external tables can be shared through secure data sharing. External tables are used to query data directly from files in a stage without loading the data into Snowflake tables, making them suitable for sharing across different Snowflake accounts.
[References:, Snowflake Documentation on Secure Data Sharing, SnowPro™ Core Certification Companion: Hands-on Preparation and Practice, , , ]
Hendrix
Great website with Great Exam Dumps. Just passed my exam today.
LukaOct 8, 2026
Absolutely. Cramkey Dumps only provides the latest and most updated exam questions and answers.
Nadia
Why these dumps are important? Can I pass my exam without these dumps?
JulianOct 13, 2026
The questions in the Cramkey dumps are explained in detail and there are also study notes and reference materials provided. This made it easier for me to understand the concepts and retain the information better.
Nia
Why are these Dumps so important for students these days?
MaryOct 14, 2026
With the constantly changing technology and advancements in the industry, it's important for students to have access to accurate and valid study material. Cramkey Dumps provide just that. They are constantly updated to reflect the latest changes and ensure that the information is up-to-date.
Erik
Hey, I have passed my exam using Cramkey Dumps?
FreyjaOct 5, 2026
Really, what are they? All come in your pool? Please give me more details, I am going to have access their subscription. Please brother, give me more details.
Question 19
Which of the following commands cannot be used within a reader account?
In Snowflake, a reader account is a type of account that is intended for consuming shared data rather than performing any data management or DDL operations. The CREATE SHARE command is used to share data from your account with another account, which is not a capability provided to reader accounts. Reader accounts are typically restricted from creating shares, as their primary purpose is to read shared data rather than to share it themselves.
[References:, Snowflake Documentation on Reader Accounts, SnowPro® Core Certification Study Guide, , , ]