- (Topic 6)
What are characteristics of Snowflake network policies? (Select TWO).

1. A. They can be set for any Snowflake Edition.
2. B. They can be applied to roles.
3. C. They restrict or enable access to specific IP addresses.
4. D. They are activated using ALTER DATABASE SQL commands.
5. E. They can only be managed using the ORGADMIN role.

Correct Answer: AC
Snowflake network policies are a security feature that allows administrators to control access to Snowflake by specifying allowed and blocked IP address ranges. These policies apply to all editions of Snowflake, making them widely applicable across different Snowflake environments. They are specifically designed to restrict or enable accessbased on the originating IP addresses of client requests, adding an extra layer of security. Network policies are not applied to roles but are set at the account or user level. They are not activated usingALTER DATABASESQL commands but are managed throughALTER ACCOUNTorALTER NETWORK POLICYcommands. The management of network policies does not exclusively require theORGADMINrole; instead, they can be managed by users with the necessary privileges on the account.
Reference: Snowflake Documentation on Network Policies:
https://docs.snowflake.com/en/user-guide/network-policies.html

- (Topic 1)
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

1. A. Okta Verify
2. B. Duo Mobile
3. C. Microsoft Authenticator
4. D. Google Authenticator

Correct Answer: B
Snowflake??s default Multi-Factor Authentication (MFA) service is powered by Duo Security. Users are required to install the Duo Mobile application on their devices to
use MFA for increased login security when connecting to Snowflake. This service is managed entirely by Snowflake, and users do not need to sign up separately with Duo1.

- (Topic 2)
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

1. A. Materialized view
2. B. Sequence
3. C. Secure view
4. D. Transient table
5. E. Clustered table

Correct Answer: AD
In Snowflake, both materialized views and transient tables will incur storage charges because they store data. They will also incur compute charges when queries are run against them, as compute resources are used to process the queries. References:
[COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 3)
Using variables in Snowflake is denoted by using which SQL character?

1. A. @
2. B. &
3. C. $
4. D. #

Correct Answer: C
VeryComprehensiveExplanation=InSnowflake,variablesaredenotedbyadollarsign().Variable s can be used in SQL statements where a literal constant is allowed, and they must be prefixed with a $ sign to distinguish them from bind values and column names.

- (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.