- (Topic 2)
What is the minimum Snowflake edition required for row level security?
Correct Answer:
B
Row level security in Snowflake is available starting with the Enterprise edition. This feature allows for the creation of row access policies that can control access to data at the row level within tables and views
- (Topic 6)
What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)
Correct Answer:
AE
Snowflake allows users to write custom application logic in JavaScript for two types of objects: Stored Procedures and User-Defined Functions (UDFs).
✑ Stored Procedures:Snowflake stored procedures can be written in JavaScript to encapsulate complex business logic and procedural operations. CREATE OR REPLACE PROCEDURE my_procedure()
RETURNS STRING LANGUAGE JAVASCRIPT EXECUTE AS CALLER AS
$$
// JavaScript logic here
$$;
✑ User-Defined Functions (UDFs):Snowflake UDFs can be written in JavaScript to perform custom calculations or operations on data.
CREATE OR REPLACE FUNCTION my_function(x FLOAT) RETURNS FLOAT
LANGUAGE JAVASCRIPT AS
$$
return x * 2;
$$;
References:
✑ Snowflake Documentation: Stored Procedures
✑ Snowflake Documentation: User-Defined Functions (UDFs)
- (Topic 2)
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Correct Answer:
AC
Snowflake uses a Role-Based Access Control (RBAC) model to manage access to data and resources. Additionally, Snowflake ensures that all data is encrypted, both at rest and in transit, to provide a high level of security for data stored within the platform. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 6)
A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.
What should the user do?
Correct Answer:
C
In a scenario where a Snowflake user queries only a small number of rows that require significant processing and the data in the table does not change frequently, the most effective way to optimize performance is by creating a materialized view based on the query. Materialized views store the result of the query and can significantly reduce the computation time for queries that are executed frequently over unchanged data.
✑ Why Materialized Views:Materialized views precompute and store the result of the query. This is especially beneficial for queries that require heavy processing. Since the data does not change frequently, the materialized view will not need to be refreshed often, making it an ideal solution for this use case.
✑ Implementation Steps:
CREATEMATERIALIZEDVIEWmy_materialized_viewASSELECT...FROMmy_tableWHER E...;
✑ uk.co.certification.simulator.questionpool.PList@6dd07e9a
Reference:For more information on materialized views and how they can be used to optimize query performance, refer to the Snowflake documentation on materialized views: https://docs.snowflake.com/en/user-guide/views-materialized.html
- (Topic 1)
Which feature is only available in the Enterprise or higher editions of Snowflake?
Correct Answer:
A
Column-level security is a feature that allows fine-grained control over access to specific columns within a table. This is particularly useful for managing sensitive data and ensuring that only authorized users can view or manipulate certain pieces of information. According to my last update, this feature was available in the Enterprise Edition or higher editions of Snowflake.
References: Based on my internal data as of 2021, column-level security is an advanced feature typically reserved for higher-tiered editions like the Enterprise Edition in data warehousing solutions such as Snowflake.
https://docs.snowflake.com/en/user-guide/intro-editions.html
