The fail-safe retention period is how many days?
B
Explanation:
Fail-safe is a feature in Snowflake that provides an additional layer of data protection. After the Time
Travel retention period ends, Fail-safe offers a non-configurable 7-day period during which historical
data may be recoverable by Snowflake. This period is designed to protect against accidental data loss
and is not intended for customer access.
References:
Understanding and viewing Fail-safe | Snowflake Documentation
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small
Warehouse.
A
Explanation:
Provisioning time can vary based on the size of the warehouse. A 4X-Large Warehouse typically has
more resources and may take longer to provision compared to a X-Small Warehouse, which has
fewer resources and can generally be provisioned more quickly.References:
Understanding and
viewing Fail-safe | Snowflake Documentation
How would you determine the size of the virtual warehouse used for a task?
D
Explanation:
The size of the virtual warehouse for a task can be configured to handle concurrency automatically
using a Multi-cluster warehouse (MCW). This is because tasks are designed to run their body on a
schedule, and MCW allows for scaling compute resources to match the task’s execution needs
without manual intervention. References: [COF-C02] SnowPro Core Certification Exam Study Guide
The Information Schema and Account Usage Share provide storage information for which of the
following objects? (Choose three.)
B, C, D
Explanation:
The Information Schema and Account Usage Share in Snowflake provide metadata and historical
usage data for various objects within a Snowflake account. Specifically, they offer storage information
for Tables, Databases, and Internal Stages. These schemas contain views and table functions that
allow users to query object metadata and usage metrics, such as the amount of data stored and
historical activity.
Tables: The storage information includes data on the daily average amount of data in database
tables.
Databases: For databases, the storage usage is calculated based on all the data contained within the
database, including tables and stages.
Internal Stages: Internal stages are locations within Snowflake for temporarily storing data, and their
storage usage is also tracked.
References: The information is verified according to the SnowPro Core Certification Study Guide and
Snowflake documentation
What is the default File Format used in the COPY command if one is not specified?
A
Explanation:
The default file format for the COPY command in Snowflake, when not specified, is CSV (Comma-
Separated Values). This format is widely used for data exchange because it is simple, easy to read,
and supported by many data analysis tools.
True or False: Reader Accounts are able to extract data from shared data objects for use outside of
Snowflake.
B
Explanation:
Reader accounts in Snowflake are designed to allow users to read data shared with them but do not
have the capability to extract data for use outside of Snowflake. They are intended for consuming
shared data within the Snowflake environment only.
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
B
Explanation:
Snowflake does not require source data files to be no larger than 16MB. In fact, Snowflake
recommends that for optimal load performance, data files should be roughly 100-250 MB in size
when compressed. However, it is not recommended to load very large files (e.g., 100 GB or larger)
due to potential delays and wasted credits if errors occur. Smaller files should be aggregated to
minimize processing overhead, and larger files should be split to distribute the load among compute
resources in an active warehouse.
References: Preparing your data files | Snowflake Documentation
True or False: A Virtual Warehouse can be resized while suspended.
A
Explanation:
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.
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-
suspended-warehouse
True or False: When you create a custom role, it is a best practice to immediately grant that role to
ACCOUNTADMIN.
B
Explanation:
The ACCOUNTADMIN role is the most powerful role in Snowflake and should be limited to a select
number of users within an organization. It is responsible for account-level configurations and should
not be used for day-to-day object creation or management. Granting a custom role to
ACCOUNTADMIN could inadvertently give broad access to users with this role, which is not a
recommended security practice.
Reference:
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
A, C
Explanation:
In Snowflake, Data Shares can be created and managed in two primary ways:
Via the Snowflake Web Interface (UI): Users can create and manage shares through the graphical
interface provided by Snowflake, which allows for a user-friendly experience.
Via SQL commands: Snowflake also allows the creation and management of shares using SQL
commands. This method is more suited for users who prefer scripting or need to automate the
process.
Reference:
https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
True or False: Fail-safe can be disabled within a Snowflake account.
B
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a
system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail-safe feature
cannot be enabled or disabled from the user end.
True or False: It is possible for a user to run a query against the query result cache without requiring
an active Warehouse.
A
Explanation:
Snowflake’s architecture allows for the use of a query result cache that stores the results of queries
for a period of time. If the same query is run again and the underlying data has not changed,
Snowflake can retrieve the result from this cache without needing to re-run the query on an active
warehouse, thus saving on compute resources.
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
B
Explanation:
The auto-suspend and auto-resume settings in Snowflake apply to the entire virtual warehouse.
These settings allow the warehouse to automatically suspend when it’s not in use, helping to save on
compute costs. When queries or tasks are submitted to the warehouse, it can automatically resume
operation. This functionality is designed to optimize resource usage and cost-efficiency.
References:
SnowPro Core Certification Exam Study Guide (as of 2021)
Snowflake documentation on virtual warehouses and their settings (as of 2021)
Which of the following Snowflake features provide continuous data protection automatically? (Select
TWO).
C, E
Explanation:
Snowflake’s Continuous Data Protection (CDP) encompasses a set of features that help protect data
stored in Snowflake against human error, malicious acts, and software failure. Time Travel allows
users to access historical data (i.e., data that has been changed or deleted) for a defined period,
enabling querying and restoring of data. Fail-safe is an additional layer of data protection that
provides a recovery option in the event of significant data loss or corruption, which can only be
performed by Snowflake.
References:
Continuous Data Protection | Snowflake Documentation1
Data Storage Considerations | Snowflake Documentation2
Snowflake SnowPro Core Certification Study Guide3
Snowflake Data Cloud Glossary
https://docs.snowflake.com/en/user-guide/data-availability.html
Which of the following conditions must be met in order to return results from the results cache?
(Select TWO).
A, E
Explanation:
To return results from the results cache in Snowflake, certain conditions must be met:
Privileges: The user must have the appropriate privileges on the objects associated with the query.
This ensures that only authorized users can access cached data.
Time Frame: The query must have been run within 24 hours of the previously-run query. Snowflake’s
results cache is designed to store the results of queries for a short period, typically 24 hours, to
improve performance for repeated queries.