- (Topic 6)
Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?
Correct Answer:
A
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
- (Topic 2)
Which minimum Snowflake edition allows for a dedicated metadata store?
Correct Answer:
B
The Enterprise edition of Snowflake allows for a dedicated metadata store, providing additional features designed for large-scale enterprises
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
- (Topic 5)
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
Correct Answer:
C
In Snowflake, overloading refers to the creation of multiple User-Defined
Functions (UDFs) with the same name but differing in the number or types of their arguments. This feature allows for more flexible function usage, as Snowflake can differentiate between functions based on the context of their invocation, such as the types or the number of arguments passed. Overloading helps to create more adaptable and readable code, as the same function name can be used for similar operations on different types of data.
References:
✑ Snowflake Documentation: User-Defined Functions
- (Topic 1)
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
Correct Answer:
D
In Snowflake, to create a materialized view, the user must have the necessary privileges on the schema where the view will be created. These privileges are granted through roles, not directly to individual users. Therefore, the correct process is to grant the role to the user and then grant the privilege to create the materialized view to the role itself.
The statement GRANT ROLE MYROLE TO USER USER1; grants the specified role to the user, allowing them to assume that role and exercise its privileges. The subsequent statement CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO
MYROLE; grants the privilege to create a materialized view within the specified schema to the role MYROLE. Any user who has been granted MYROLE can then create materialized views in MYDB.MYSCHEMA.
References:
✑ Snowflake Documentation on Roles
✑ Snowflake Documentation on Materialized Views
