- (Topic 1)
True or False: Fail-safe can be disabled within a Snowflake account.

1. A. True
2. B. False

Correct Answer: B
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.

- (Topic 2)
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

1. A. 10-50 MB
2. B. 100-250 MB
3. C. 300-500 MB
4. D. 1000-1500 MB

Correct Answer: B
For loading data into Snowflake via Snowpipe, the recommended compressed file size is between 100-250 MB. This size range is optimal for balancing the performance of parallel processing and minimizing the overhead associated with handling many small files2.

- (Topic 1)
What are ways to create and manage data shares in Snowflake? (Select TWO)

1. A. Through the Snowflake web interface (Ul)
2. B. Through the DATA_SHARE=TRUE parameter
3. C. Through SQL commands
4. D. Through the enable share=true parameter
5. E. Using the CREATE SHARE AS SELECT * TABLE command

Correct Answer: AC
Data shares in Snowflake can be created and managed through the Snowflake web interface, which provides a user-friendly graphical interface for various operations. Additionally, SQL commands can be used to perform these tasks programmatically, offering flexibility and automation capabilities123.

- (Topic 4)
A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).

1. A. GRANT
2. B. SELECT
3. C. MODIFY
4. D. OWNERSHIP
5. E. CREATE USER

Correct Answer: DE
A user with the OWNERSHIP privilege on a user object or the CREATE USER privilege on the account can create or manage other users in a Snowflake account56.

- (Topic 5)
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

1. A. GROUP BY
2. B. LIMIT
3. C. ORDER BY
4. D. PARTITION BY
5. E. UNION ALL

Correct Answer: CD
Valid sub-clauses to theOVERclause for a window function in SQL are:
✑ C. ORDER BY: This clause specifies the order in which the rows in a partition are processed by the window function. It is essential for functions that depend on the row order, such as ranking functions.
✑ D. PARTITION BY: This clause divides the result set into partitions to which the window function is applied. Each partition is processed independently of other partitions, making it crucial for functions that compute values across sets of rows that share common characteristics.
These clauses are fundamental to defining the scope and order of data over which the window function operates, enabling complex analytical computations within SQL queries. References:
✑ Snowflake Documentation: Window Functions