- (Topic 2)
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?

1. A. PURGE
2. B. MODIFY
3. C. REMOVE
4. D. DELETE

Correct Answer: C
The SQL command used to delete files from a Snowflake internal stage is REMOVE. This command can be used to remove files from either an internal or external stage within Snowflake

- (Topic 6)
Snowflake's access control framework combines which models for securing data? (Select TWO).

1. A. Attribute-based Access Control (ABAC 1
2. B. Discretionary Access Control (DAC)
3. C. Access Control List (ACL)
4. D. Role-based Access Control (RBAC)
5. E. Rule-based Access Control (RuBAC)

Correct Answer: BD
Snowflake's access control framework utilizes a combination of Discretionary Access Control (DAC) and Role-based Access Control (RBAC). DAC in Snowflake allows the object owner to grant access privileges to other roles. RBAC involves assigning roles to users and then granting privileges to those roles. Through roles, Snowflake manages which users have access to specific objects and what actions they can perform, which is central to security and governance in the Snowflake environment.References:Snowflake Documentation on Access Control,

- (Topic 1)
What is a limitation of a Materialized View?

1. A. A Materialized View cannot support any aggregate functions
2. B. A Materialized View can only reference up to two tables
3. C. A Materialized View cannot be joined with other tables
4. D. A Materialized View cannot be defined with a JOIN

Correct Answer: D
Materialized Views in Snowflake are designed to store the result of a query and can be refreshed to maintain up-to-date data. However, they have certain limitations, one of which is that they cannot be defined using a JOIN clause. This means that a Materialized View can only be created based on a single source table and cannot combine data from multiple tables using JOIN operations.
References:
✑ Snowflake Documentation on Materialized Views
✑ SnowPro® Core Certification Study Guide

- (Topic 2)
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

1. A. Default Time Travel Retention is set to 0 day
2. B. Maximum Time Travel Retention is 30 day
3. C. Fail Safe retention time is 1 day.
4. D. Default Time Travel Retention is set to 1 da
5. E. Maximum Time Travel Retention is 365 day
6. F. Fail Safe retention time is 7 days.
7. G. Default Time Travel Retention is set to 0 day
8. H. Maximum Time Travel Retention is 90 day
9. I. Fail Safe retention time is 7 days.
10. J. Default Time Travel Retention is set to 1 da
11. K. Maximum Time Travel Retention is 90 day
12. L. Fail Safe retention time is 7 days.
13. M. Default Time Travel Retention is set to 7 day
14. N. Maximum Time Travel Retention is 1 da
15. O. Fail Safe retention time is 90 days.
16. P. Default Time Travel Retention is set to 90 day
17. Q. Maximum Time Travel Retention is 7 day
18. R. Fail Safe retention time is 356 days.

Correct Answer: D
In the Snowflake Enterprise Edition, the default Time Travel retention is set to 1 day, the maximum Time Travel retention can be set up to 90 days, and the Fail-safe retention time is 7 days3.

- (Topic 3)
What is the difference between a stored procedure and a User-Defined Function (UDF)?

1. A. Stored procedures can execute database operations while UDFs cannot.
2. B. Returning a value is required in a stored procedure while returning values in a UDF is optional.
3. C. Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
4. D. Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

Correct Answer: A
Stored procedures in Snowflake can perform a variety of database operations, including DDL and DML, whereas UDFs are designed to return values and cannot execute database operations1.