SnowPro Core Certification Exam Questions and Answers
Question 25
What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?
Options:
A.
Repair the failed resources.
B.
Restart failed resources.
C.
Queue the failed resources
D.
Provision the failed resources
Answer:
B
Explanation:
If any compute resources for a virtual warehouse fail to provision during startup, Snowflake will attempt to restart those failed resources. The system is designed to automatically handle transient issues that might occur during the provisioning of compute resources. By restarting the failed resources, Snowflake aims to ensure that the virtual warehouse has the necessary compute capacity to handle the user's workloads without manual intervention.
[References: Snowflake Documentation on Virtual Warehouses, , ]
Question 26
What action is required to load data from a local file system into a Snowflake table?
Options:
A.
Use the COPY INTO
command directly on the local file system.
B.
Upload data files to a Snowflake external stage using the COPY INTO
and then use the GET command.
C.
Use the PUT command directly on the local file system.
D.
Upload data files to a Snowflake internal stage using the PUT command and then use the COPY INTO
command.
Answer:
D
Explanation:
To load local files into Snowflake:
First, use the PUT command to upload files from local storage to an internal stage.
Then, use the COPY INTO
command to load data from the internal stage into the table.
[Reference:, Snowflake Docs: Loading Data from Local Files, ===========]
Question 27
Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?
Options:
A.
Fail-safe
B.
Network policies
C.
End-to-end encryption
D.
Multi-Factor Authentication (MFA)
Answer:
A
Explanation:
Snowflake's Continuous Data Protection (CDP) features encompass several mechanisms designed to protect data and ensure its availability and recoverability. Among these features, the one that has associated costs is Fail-safe.
Fail-safe is an additional layer of protection that kicks in after the Time Travel period expires. While Time Travel allows users to access historical data within a defined retention period (which can vary from 1 to 90 days depending on the Snowflake edition), Fail-safe provides a further 7 days (for a total of 7 additional days beyond the Time Travel period)during which Snowflake retains the data. This period is primarily intended for Snowflake's internal operations to recover data in the event of extreme scenarios, such as significant operational failures, and is not directly accessible by customers for data recovery purposes.
The associated costs with Fail-safe arise because Snowflake continues to store the data beyond the customer-specified Time Travel period, thereby incurring additional storage costs. It's important to note that while users do not incur direct costs for enabling Fail-safe (as it is an automatic feature of Snowflake), the extended storage of data during this period contributes to overall storage costs.
[References:, Snowflake Documentation on Continuous Data Protection: Continuous Data Protection (CDP), Snowflake Documentation on Fail-safe: Understanding Fail-safe, , , ]
Question 28
If a virtual warehouse is suspended, what happens to the warehouse cache?
Options:
A.
The cache is dropped when the warehouse is suspended and is no longer available upon restart.
B.
The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.
C.
The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.
D.
The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.
Answer:
A
Explanation:
When a virtual warehouse in Snowflake is suspended, the cache is dropped and is no longer available upon restart. This means that all cached data, including results and temporary data, are cleared from memory. The purpose of this behavior is to conserve resources while the warehouse is not active. Upon restarting the warehouse, it will need to reload any data required for queries from storage, which may result in a slower initial performance until the cache is repopulated. This is a critical consideration for managing performance and cost in Snowflake.
