- (Topic 3)
How many network policies can be assigned to an account or specific user at a time?

1. A. One
2. B. Two
3. C. Three
4. D. Unlimited

Correct Answer: A
According to my knowledge, a security administrator can create multiple network policies, but only one network policy can be active for an account or specific user at any given time. This ensures that there is a clear and consistent policy being applied without conflicts. References: Based on my internal knowledge as of 2021.

- (Topic 6)
Snowflake users can create a resource monitor at which levels? (Select TWO).

1. A. User level
2. B. Pipe level
3. C. Account level
4. D. Cloud services level
5. E. Virtual warehouse level

Correct Answer: CE
Resource monitors in Snowflake are tools used to track and control the consumption of compute resources, ensuring that usage stays within defined limits. These monitors can be created at the account level, allowing administrators to set overall resource consumption limits for the entire Snowflake account. Additionally, resource monitors can be set at the virtual warehouse level, enabling more granular control over the resources consumed by individual warehouses. This dual-level capability allows organizations to manage their Snowflake usage efficiently, preventing unexpected costs and optimizing performance.References:Snowflake Documentation on Resource Monitors Top of Form

- (Topic 5)
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

1. A. Caching
2. B. Cluster depth
3. C. Query pruning
4. D. Retrieval optimization

Correct Answer: C
Query pruning in Snowflake is the mechanism used to limit the number of micro-partitions scanned by a query. By analyzing the filters and conditions applied in a query, Snowflake can skip over micro-partitions that do not contain relevant data, thereby reducing the amount of data processed and improving query performance. This technique is particularly effective for large datasets and is a key component of Snowflake's performance optimization features.
References:
✑ Snowflake Documentation: Query Performance Optimization

- (Topic 6)
When an object is created in Snowflake. who owns the object?

1. A. The public role
2. B. The user's default role
3. C. The current active primary role
4. D. The owner of the parent schema

Correct Answer: C
In Snowflake, when an object is created, it is owned by the role that is currently active. This active role is the one that is being used to execute the creation command. Ownership implies full control over the object, including the ability to grant and revoke access privileges. This is specified in Snowflake's documentation under the topic of Access Control, which states that "the role in use at the time of object creation becomes the owner of the object."
References:
✑ Snowflake Documentation: Object Ownership

- (Topic 4)
What is the purpose of the Snowflake SPLIT TO_TABLE function?

1. A. To count the number of characters in a string
2. B. To split a string into an array of sub-strings
3. C. To split a string and flatten the results into rows
4. D. To split a string and flatten the results into columns

Correct Answer: C
The purpose of the Snowflake SPLIT_TO_TABLE function is to split a string based on a specified delimiter and flatten the results into rows. This table function is useful for transforming a delimited string into a set of rows that can be further processed or queried5.