Question 1

How long is Snowpipe data load history retained?

Accepted Answer

Snowpipe data load history is retained for 64 days. This retention period allows users to review and audit the data load operations performed by Snowpipe over a
significant period of time, which can be crucial for troubleshooting and ensuring data integrity.
References:
? [COF-C02] SnowPro Core Certification Exam Study Guide
? Snowflake Documentation on Snowpipe1

Question 2

Which of the following objects can be shared through secure data sharing?

Accepted Answer

Secure data sharing in Snowflake allows users to share various objects between Snowflake accounts without physically copying the data, thus not consuming
additional storage. Among the options provided, external tables can be shared through secure data sharing. External tables are used to query data directly from
files in a stage without loading the data into Snowflake tables, making them suitable for sharing across different Snowflake accounts.
References:
? Snowflake Documentation on Secure Data Sharing
? SnowPro™ Core Certification Companion: Hands-on Preparation and Practice

Question 3

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Accepted Answer

Snowflake??s Continuous Data Protection (CDP) encompasses a set of features that help protect data stored in Snowflake against human error, malicious acts,
and software failure. Time Travel allows users to access historical data (i.e., data that has been changed or deleted) for a defined period, enabling querying and
restoring of data. Fail-safe is an additional layer of data protection that provides a recovery option in the event of significant data loss or corruption, which can only
be performed by Snowflake. References:
? Continuous Data Protection | Snowflake Documentation1
? Data Storage Considerations | Snowflake Documentation2
? Snowflake SnowPro Core Certification Study Guide3
? Snowflake Data Cloud Glossary
https://docs.snowflake.com/en/user-guide/data-availability.html

Question 4

What features does Snowflake Time Travel enable?

Accepted Answer

Snowflake Time Travel is a powerful feature that allows users to access historical data within a defined period. It enables two key capabilities:
? B. Restoring data-related objects that have been deleted within the past 90 days:
Time Travel can be used to restore tables, schemas, and databases that have been accidentally or intentionally deleted within the Time Travel retention period.
? C. Conducting point-in-time analysis for BI reporting: It allows users to query
historical data as it appeared at a specific point in time within the Time Travel retention period, which is crucial for business intelligence and reporting purposes.
While Time Travel does allow querying of past data, it is limited to the retention period set for the Snowflake account, which is typically 1 day for standard accounts

From SurePassExam
https://www.surepassexam.com/COF-C02-exam-dumps.html (695 New Questions)
and can be extended up to 90 days for enterprise accounts. It does not enable querying or restoring objects created or deleted beyond the retention period, nor
does it provide analysis over all periods of time.
References:
? Snowflake Documentation on Time Travel
? SnowPro® Core Certification Study Guide

Question 5

Which Snowflake feature is used for both querying and restoring data?

Accepted Answer

Snowflake??s Time Travel feature is used for both querying historical data in tables and restoring and cloning historical data in databases, schemas, and tables3.
It allows users to access historical data within a defined period (1 day by default, up to 90 days for Snowflake Enterprise Edition) and is a key feature for data
recovery and management. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 6

Which account usage views are used to evaluate the details of dynamic data masking? (Select TWO)

Accepted Answer

To evaluate the details of dynamic data masking,
the POLICY_REFERENCES and ACCESS_HISTORY views in the account_usage schema are used. The POLICY_REFERENCES view provides information
about the objects to which a masking policy is applied, and the ACCESS_HISTORY view contains details about access to the masked data, which can be used to
audit and verify the application of
dynamic data masking policies.
References:
? [COF-C02] SnowPro Core Certification Exam Study Guide
? Snowflake Documentation on Dynamic Data Masking1

Question 7

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

Accepted Answer

Snowflake supports several methods for authenticating users, including federated authentication, key-pair authentication, and OAuth. Federated authentication
allows users to authenticate using their organization??s identity provider. Key-pair authentication uses a public-private key pair for secure login, and OAuth is an
open standard for access delegation commonly used for token-based authentication. References: Authentication policies | SnowflakeDocumentation,
Authenticating to the server | Snowflake Documentation, External API authentication and secrets | Snowflake Documentation.

Question 8

When is the result set cache no longer available? (Select TWO)

Accepted Answer

The result set cache in Snowflake is invalidated and no longer available when the underlying data of the query results has changed, ensuring that queries return
the most current data. Additionally, the cache expires after 24 hours to maintain the efficiency and accuracy of data retrieval1.

From SurePassExam
https://www.surepassexam.com/COF-C02-exam-dumps.html (695 New Questions)

Question 9

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

Accepted Answer

In Snowflake, to create a materialized view, the user must have the necessary privileges on the schema where the view will be created. These privileges are
granted through roles, not directly to individual users. Therefore, the correct process is to grant the role to the user and then grant the privilege to create the
materialized view to the role itself.
The statement GRANT ROLE MYROLE TO USER USER1; grants the specified role to the user, allowing them to assume that role and exercise its privileges. The
subsequent statement CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO
MYROLE; grants the privilege to create a materialized view within the specified schema to the role MYROLE. Any user who has been granted MYROLE can then
create materialized views in MYDB.MYSCHEMA.
References:
? Snowflake Documentation on Roles
? Snowflake Documentation on Materialized Views

Question 10

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?

Accepted Answer

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.