How Many Questions Of COF-C02 Dumps

NEW QUESTION 1

What is a best practice after creating a custom role?

• A. Create the custom role using the SYSADMIN role.
• B. Assign the custom role to the SYSADMIN role
• C. Assign the custom role to the PUBLIC role
• D. Add CUSTOM to all custom role names

Answer: B

Explanation:
Assigning the custom role to the SYSADMIN role is considered a best practice because it allows the SYSADMIN role to manage objects created by the custom role. This is important for maintaining proper access control and ensuring that the SYSADMIN can perform necessary administrative tasks on objects created by users with the custom role.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Section 1.3 - SnowPro Core Certification Study Guide1

NEW QUESTION 2

What is the purpose of the STRIP NULL_VALUES file format option when loading semi- structured data files into Snowflake?

• A. It removes null values from all columns in the data.
• B. It converts null values to empty strings during loading.
• C. It skips rows with null values during the loading process.
• D. It removes object or array elements containing null values.

Answer: D

Explanation:
The STRIP NULL_VALUES file format option, when set to TRUE, removes object or array elements that contain null values during the loading process of semi- structured data files into Snowflake. This ensures that the data loaded into Snowflake tables does not contain these null elements, which can be useful when the ??null?? values in files indicate missing values and have no other special meaning2.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 3

Which governance feature is supported by all Snowflake editions?

• A. Object tags
• B. Masking policies
• C. Row access policies
• D. OBJECT_DEPENDENCIES View

Answer: D

Explanation:
Snowflake's governance features vary across different editions, but the OBJECT_DEPENDENCIESview is supported by all Snowflake editions. This feature is part of Snowflake's Information Schema and is designed to help users understand the dependencies between various objects in their Snowflake environment. TheOBJECT_DEPENDENCIESview provides a way to query and analyze the relationships and dependencies among different database objects, such as tables, views, and stored procedures. This is crucial for governance, as it allows administrators and data engineers to assess the impact of changes, understand object relationships, and ensure proper management of data assets.
Object tags, masking policies, and row access policies are more advanced features that offer fine-grained data governance capabilities such as tagging objects for classification, dynamically masking sensitive data based on user roles, and controlling row-level access to data. These features may have varying levels of support across different Snowflake editions, with some features being exclusive to higher-tier editions.
Reference: Snowflake Documentation on Information Schema
(https://docs.snowflake.com/en/sql-reference/info-schema/object_dependencies.html)

NEW QUESTION 4

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

• A. Schema
• B. View
• C. Internal stage
• D. Table
• E. User
• F. Role

Answer: BD

Explanation:
The UNDROP command in Snowflake can be used to directly restore Views and Tables. These objects, when dropped, are moved to a ??Recycle Bin?? where they can be restored within a time limit before they are permanently deleted. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 5

What COPY INTO SQL command should be used to unload data into multiple files?

• A. SINGLE=TRUE
• B. MULTIPLE=TRUE
• C. MULTIPLE=FALSE
• D. SINGLE=FALSE

Answer: D

Explanation:
The COPY INTO SQL command with the option SINGLE=FALSE is used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process. References: SnowPro Core Certification COPY INTO SQL command unload multiple files

NEW QUESTION 6

Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?

• A. Only while in the ACCOUNTADMIH role
• B. Only while in the securityadmin role
• C. Only the role with the ownership privilege on the network policy
• D. Only Snowflake Support can set the value for this object property

Answer: A

Explanation:
To temporarily bypass an active network policy by configuring the user object propertyMINS_TO_BYPASS_NETWORK_POLICY, the minimum set of privileges required is having the ACCOUNTADMIN role. This role has the necessary privileges to make such changes, including modifying user properties that affect network policies.
References:
✑ Snowflake Documentation: Network Policy Management

NEW QUESTION 7

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

• A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
• B. The transient table version cannot be retrieved after 24 hours.
• C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
• D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Answer: A

Explanation:
To go back to the first version of a transient table created three days prior,
one can use Time Travel if the DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days. This allows the user to access historical data within the specified retention period. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 8

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

• A. Swift
• B. JavaScript
• C. Python
• D. SQL

Answer: C

Explanation:
The Snowpark API allows developers to create User-Defined Functions (UDFs) in various languages, including Python, which is known for its ease of use and wide adoption in data-related tasks. References: Based on general programming and cloud data service knowledge as of 2021.

NEW QUESTION 9

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

• A. Review the granted privileges to the database object.
• B. Review the row access policy for the database object.
• C. Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.
• D. Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGEschema.

Answer: C

Explanation:
To determine which user has accessed a database object containing sensitive information, a Snowflake administrator can query the ACCESS_HISTORY view in the ACCOUNT_USAGE schema, which provides information about access to database objects3.

NEW QUESTION 10

The Snowflake Search Optimization Services supports improved performance of which kind of query?

• A. Queries against large tables where frequent DML occurs
• B. Queries against tables larger than 1 TB
• C. Selective point lookup queries
• D. Queries against a subset of columns in a table

Answer: C

Explanation:
The Snowflake Search Optimization Service is designed to support improved performance for selective point lookup queries. These are queries that retrieve specific records from a database, often based on a unique identifier or a small set of criteria3.

NEW QUESTION 11

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

• A. Internal stages
• B. Incremental backups
• C. Time Travel
• D. Zero-copy clones
• E. Fail-safe

Answer: CE

Explanation:
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

NEW QUESTION 12

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

• A. Query execution
• B. Data loading
• C. Time Travel data
• D. Security
• E. Authentication and access control

Answer: DE

Explanation:
The cloud services layer of Snowflake architecture handles various aspects including security functions, authentication of user sessions, and access control, ensuring that only authorized users can access the data and services23.

NEW QUESTION 13

What should be considered when deciding to use a secure view? (Select TWO).

• A. No details of the query execution plan will be available in the query profiler.
• B. Once created there is no way to determine if a view is secure or not.
• C. Secure views do not take advantage of the same internal optimizations as standard views.
• D. It is not possible to create secure materialized views.
• E. The view definition of a secure view is still visible to users by way of the information schema.

Answer: AC

Explanation:
When deciding to use a secure view, several considerations come into play, especially concerning security and performance:
* A.No details of the query execution plan will be available in the query profiler: Secure views are designed to prevent the exposure of the underlying data and the view definition to unauthorized users. Because of this, the detailed execution plans for queries against secure views are not available in the query profiler. This is intended to protect sensitive data from being inferred through the execution plan.
* C.Secure views do not take advantage of the same internal optimizations as standard views: Secure views, by their nature, limit some of the optimizations that can be applied compared to standard views. This is because they enforce row-level security and mask data, which can introduce additional processing overhead and limit the optimizer's ability to apply certain efficiencies that are available to standard views.
B.Once created, there is no way to determine if a view is secure or notis incorrect because metadata about whether a view is secure can be retrieved from the INFORMATION_SCHEMA views or by using theSHOW VIEWScommand.
* D.It is not possible to create secure materialized viewsis incorrect because the limitation is not on the security of the view but on the fact that Snowflake currently does not support materialized views with the same dynamic data masking and row-level security features as secure views.
* E.The view definition of a secure view is still visible to users by way of the information schemais incorrect because secure views specifically hide the view definition from users who do not have the privilege to view it, ensuring that sensitive information in the definition is not exposed.
Reference: Snowflake Documentation on Secure Views
(https://docs.snowflake.com/en/user-guide/views-secure.html)

NEW QUESTION 14

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

• A. Business Critical Edition
• B. Standard Edition
• C. Virtual Private Snowflake (VPS)
• D. Enterprise Edition

Answer: D

Explanation:
The minimum edition of Snowflake required to use a SCIM security integration is the Enterprise Edition. SCIM integrations are used for automated management of user identities and groups, and this feature is available starting from the Enterprise Edition of Snowflake. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 15

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

• A. Database replication and failover
• B. Automated index management
• C. Customer managed keys (Tri-secret secure)
• D. Extended time travel
• E. Native support for geospatial data

Answer: AD

Explanation:
The Snowflake Enterprise edition includes database replication and failover for business continuity and disaster recovery, as well as extended time travel capabilities for longer data retention periods1.

NEW QUESTION 16

What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

• A. ACCOUNTADMIN
• B. SECURITYADMIN
• C. SYSADMIN
• D. ORGADMIN

Answer: A

Explanation:
TheENABLE_ACCOUNT_DATABASE_REPLICATIONparameter is a critical setting in Snowflake that allows or restricts the replication of databases across Snowflake accounts. Given the significant impact of this parameter on data management and security, only the ACCOUNTADMINrole has the minimum required privileges to set or modify it. This ensures that only users with the highest level of access and responsibility within the Snowflake environment can controldatabase replication settings, maintaining strict governance and security standards.References:Snowflake Documentation on Database Replication

NEW QUESTION 17

When should a stored procedure be created with caller's rights?

• A. When the caller needs to be prevented from viewing the source code of the stored procedure
• B. When the caller needs to run a statement that could not execute outside of the stored procedure
• C. When the stored procedure needs to run with the privileges of the role that called the stored procedure
• D. When the stored procedure needs to operate on objects that the caller does not have privileges on

Answer: C

Explanation:
Stored procedures in Snowflake can be created with either 'owner's rights' or 'caller's rights'. A stored procedure created with caller's rights executes with the privileges of the role that calls the procedure, not the privileges of the role that owns the procedure. This is particularly useful in scenarios where the procedure needs to perform operations that depend on the caller's access permissions, ensuring that the procedure can only access objects that the caller is authorized to access.
Reference: Snowflake's official documentation on stored procedures, specifically the section on execution context (caller's rights vs. owner's rights), provides detailed guidance on when to use caller's rights: https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#caller-s-rights-vs-owner-s-rights

NEW QUESTION 18

Which typos of charts does Snowsight support? (Select TWO).

• A. Area charts
• B. Bar charts
• C. Column charts
• D. Radar charts
• E. Scorecards

Answer: AB

Explanation:
Snowsight, Snowflake??s user interface for executing and analyzing queries, supports various types of visualizations to help users understand their data better. Among the supported types, area charts and bar charts are two common options. Area charts are useful for representing quantities through the use of filled areas on the graph, often useful for showing volume changes over time. Bar charts, on the other hand, are versatile for comparing different groups or categories of data. Both chart types are integral to data analysis, enabling users to visualize trends, patterns, and differences in their data effectively.References:Snowflake Documentation on Snowsight Visualizations

NEW QUESTION 19

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

• A. Customer-managed encryption keys through Tri-Secret Secure
• B. Automatic encryption of all data
• C. Up to 90 days of data recovery through Time Travel
• D. Object-level access control
• E. Column-level security to apply data masking policies to tables and views

Answer: BD

Explanation:
In all Snowflake editions, two key capabilities are universally available:
✑ B. Automatic encryption of all data: Snowflake automatically encrypts all data stored in its platform, ensuring security and compliance with various regulations. This encryption is transparent to users and does not require any configuration or management.
✑ D. Object-level access control: Snowflake provides granular access control mechanisms that allow administrators to define permissions at the object level, including databases, schemas, tables, and views. This ensures that only authorized users can access specific data objects.
These features are part of Snowflake??s commitment to security and governance, and they are included in every edition of the Snowflake Data Cloud.
References:
✑ Snowflake Documentation on Security Features
✑ SnowPro® Core Certification Exam Study Guide

NEW QUESTION 20

What does the LATERAL modifier for the FLATTEN function do?

• A. Casts the values of the flattened data
• B. Extracts the path of the flattened data
• C. Joins information outside the object with the flattened data
• D. Retrieves a single instance of a repeating element in the flattened data

Answer: C

Explanation:
The LATERAL modifier for the FLATTEN function allows joining information outside the object (such as other columns in the source table) with the flattened data, creating a lateral view that correlates with the preceding tables in the FROM clause2345. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 21
......