Latest COF-C02 Free Draindumps For SnowPro Core Certification Exam (COF-C02) Certification

NEW QUESTION 1

Which Snowflake view is used to support compliance auditing?

• A. ACCESS_HISTORY
• B. COPY_HISTORY
• C. QUERY_HISTORY
• D. ROW ACCESS POLICIES

Answer: A

Explanation:
The ACCESS_HISTORY view in Snowflake is utilized to support compliance auditing. It provides detailed information on data access within Snowflake, including reads and writes by user queries. This view is essential for regulatory compliance auditing as it offers insights into the usage of tables and columns, and maintains a direct link between the user, the query, and the accessed data1.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 2

What is the default file size when unloading data from Snowflake using the COPY command?

• A. 5 MB
• B. 8 GB
• C. 16 MB
• D. 32 MB

Answer: C

Explanation:
The default file size when unloading data from Snowflake using the COPY command is not explicitly stated in the provided resources. However, Snowflake documentation suggests that the file size can be specified using the MAX_FILE_SIZE option in the COPY INTO <location> command2.

NEW QUESTION 3

Which commands are restricted in owner's rights stored procedures? (Select TWO).

• A. SHOW
• B. MERGE
• C. INSERT
• D. DELETE
• E. DESCRIBE

Answer: AE

Explanation:
In owner??s rights stored procedures, certain commands are restricted to maintain security and integrity. The SHOW and DESCRIBE commands are limited because they can reveal metadata and structure information that may not be intended for all roles.

NEW QUESTION 4

What are benefits of using Snowpark with Snowflake? (Select TWO).

• A. Snowpark uses a Spark engine to generate optimized SQL query plans.
• B. Snowpark automatically sets up Spark within Snowflake virtual warehouses.
• C. Snowpark does not require that a separate cluster be running outside of Snowflake.
• D. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.
• E. Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Answer: CD

Explanation:
Snowpark is designed to bring the data programmability to Snowflake, enabling developers to write code in familiar languages like Scala, Java, and Python. It allows for the execution of these codes directly within Snowflake??s virtual warehouses, eliminating the need for a separate cluster. Additionally, Snowpark??s compatibility with Spark allows users to leverage their existing Spark code with minimal changes1.

NEW QUESTION 5

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

• A. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
• B. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
• C. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYD
• D. K"-'SCHEMA TO USER! ;
• E. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Answer: A

Explanation:
To provide a user with the necessary access to create a materialized view in a schema, the user must be granted a role that has the CREATE MATERIALIZED VIEW privilege on that schema. First, the role is granted to the user, and then the privilege is granted to the role

NEW QUESTION 6

Which statement MOST accurately describes clustering in Snowflake?

• A. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
• B. Clustering is the way data is grouped together and stored within Snowflake micro- partitions.
• C. The clustering key must be included in the COPY command when loading data into Snowflake.
• D. Clustering can be disabled within a Snowflake account.

Answer: B

Explanation:
Clustering in Snowflake refers to the organization of data within micro- partitions, which are contiguous units of storage within Snowflake tables. Clustering keys can be defined to co-locate similar rows in the same micro-partitions, improving scan efficiency and query performance12.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 7

Which Snowflake tool is recommended for data batch processing?

• A. SnowCD
• B. SnowSQL
• C. Snowsight
• D. The Snowflake API

Answer: B

Explanation:
For data batch processing in Snowflake, the recommended tool is:
✑ B. SnowSQL: SnowSQL is the command-line client for Snowflake. It allows for executing SQL queries, scripts, and managing database objects. It's particularly suitable for batch processing tasks due to its ability to run SQL scripts that canexecute multiple commands or queries in sequence, making it ideal for automated or scheduled tasks that require bulk data operations.
SnowSQL provides a flexible and powerful way to interact with Snowflake, supporting operations such as loading and unloading data, executing complex queries, and managing Snowflake objects from the command line or through scripts.
References:
✑ Snowflake Documentation: SnowSQL (CLI Client) at Snowflake Documentation

NEW QUESTION 8

What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

• A. Fail-safe
• B. Time Travel
• C. Cloning
• D. Account replication

Answer: A

Explanation:
Fail-safe is a non-configurable feature in Snowflake that provides an additional layer of data protection beyond Time Travel. Time Travel allows users to access historical data within a configurable period (up to 90 days), while Fail-safe provides an additional 7-day period during which Snowflake retains historical data to recover from significant data loss or corruption incidents. This period is not accessible by users but can be used by Snowflake support to assist in data recovery efforts.References:Snowflake Documentation on Fail-safe and Time Travel

NEW QUESTION 9

What happens when a database is cloned?

• A. It does not retain any privileges granted on the source object.
• B. It replicates all granted privileges on the corresponding source objects.
• C. It replicates all granted privileges on the corresponding child objects.
• D. It replicates all granted privileges on the corresponding child schema objects.

Answer: A

Explanation:
When a database is cloned in Snowflake, it does not retain any privileges that were granted on the source object. The clone will need to have privileges reassigned as necessary for users to access it. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 10

Which Snowflake technique can be used to improve the performance of a query?

• A. Clustering
• B. Indexing
• C. Fragmenting
• D. Using INDEX HINTS

Answer: A

Explanation:
Clustering is a technique used in Snowflake to improve the performance of queries. It involves organizing the data in a table into micro-partitions based on the values of one or more columns. This organization allows Snowflake to efficiently prune non- relevant micro-partitions during a query, which reduces the amount of data scanned and improves query performance.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Clustering

NEW QUESTION 11

Which roles can make grant decisions to objects within a managed access schema? (Select TWO)

• A. ACCOUNTADMIN
• B. SECURITYADMIN
• C. SYSTEMADMIN
• D. ORGADMIN
• E. USERADMIN

Answer: AB

Explanation:
✑ Managed Access Schemas:These are a special type of schema designed for fine- grained access control in Snowflake.
✑ Roles with Grant Authority:
✑ Important Note:The ORGADMIN role focuses on organization-level management, not object access control.

NEW QUESTION 12

When unloading data, which file format preserves the data values for floating-point number columns?

• A. Avro
• B. CSV
• C. JSON
• D. Parquet

Answer: D

Explanation:
When unloading data, the Parquet file format is known for its efficiency in preserving the data values for floating-point number columns. Parquet is a columnar storage file format that offers high compression ratios and efficient data encoding schemes. It is especially effective for floating-point data, as it maintains high precision and supports efficient querying and analysis.
References:
✑ Snowflake Documentation: Using the Parquet File Format for Unloading Data

NEW QUESTION 13

What is the MINIMUM permission needed to access a file URL from an external stage?

• A. MODIFY
• B. READ
• C. SELECT
• D. USAGE

Answer: D

Explanation:
To access a file URL from an external stage in Snowflake, the minimum permission required is USAGE on the stage object. USAGE permission allows a user to reference the stage in SQL commands, necessary for actions like listing files or loading data from the stage, but does not permit the user to alter or drop the stage.
References:
✑ Snowflake Documentation: Access Control

NEW QUESTION 14

Which command can be used to stage local files from which Snowflake interface?

• A. SnowSQL
• B. Snowflake classic web interface (Ul)
• C. Snowsight
• D. .NET driver

Answer: A

Explanation:
SnowSQL is the command-line client for Snowflake that allows users to execute SQL queries and perform all DDL and DML operations, including staging files for bulk data loading. It is specifically designed for scripting and automating tasks. References:
✑ SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on SnowSQL https://docs.snowflake.com/en/user-guide/snowsql-use.html

NEW QUESTION 15

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

• A. Indefinitely
• B. Until the result_cache expires
• C. Until the retention_time is met
• D. Until the expiration time is exceeded

Answer: D

Explanation:
A data consumer who has a pre-signed URL can access data files using Snowflake until the expiration time is exceeded. The expiration time is set when the pre- signed URL is generated and determines how long the URL remains valid3.

NEW QUESTION 16

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

• A. 10-50 MB
• B. 100-250 MB
• C. 300-500 MB
• D. 1000-1500 MB

Answer: B

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

NEW QUESTION 17

For which use cases is running a virtual warehouse required? (Select TWO).

• A. When creating a table
• B. When loading data into a table
• C. When unloading data from a table
• D. When executing a show command
• E. When executing a list command

Answer: BC

Explanation:
Running a virtual warehouse is required when loading data into a table and when unloading data from a table because these operations require compute resources that are provided by the virtual warehouse23.

NEW QUESTION 18

A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?

• A. Source_column.element[1]:name
• B. Source_column.element[0]:name
• C. Source_column.element[1].name
• D. Source_column.element[0]:name

Answer: C

Explanation:
In Snowflake, when dealing with semi-structured data such as a JSON document stored in aVARIANTcolumn, the proper syntax to extract a value is to use the column name followed by the path to the specific element. Since arrays in JSON are zero-indexed, the first element is referenced with[0]. Therefore, to extract thenamefrom the first element of the elementsarray, the correct syntax isSource_column:elements[0].name
.References:Snowflake Documentation on Semi-Structured Data

NEW QUESTION 19

The is the minimum Fail-safe retention time period for transient tables?

• A. 1 day
• B. 7 days
• C. 12 hours
• D. 0 days

Answer: D

Explanation:
Transient tables in Snowflake have a minimum Fail-safe retention time period of 0 days. This means that once the Time Travel retention period ends, there is no additional Fail-safe period for transient tables

NEW QUESTION 20

Snowflake's access control framework combines which models for securing data? (Select TWO).

• A. Attribute-based Access Control (ABAC 1
• B. Discretionary Access Control (DAC)
• C. Access Control List (ACL)
• D. Role-based Access Control (RBAC)
• E. Rule-based Access Control (RuBAC)

Answer: BD

Explanation:
Snowflake's access control framework utilizes a combination of Discretionary Access Control (DAC) and Role-based Access Control (RBAC). DAC in Snowflake allows the object owner to grant access privileges to other roles. RBAC involves assigning roles to users and then granting privileges to those roles. Through roles, Snowflake manages which users have access to specific objects and what actions they can perform, which is central to security and governance in the Snowflake environment.References:Snowflake Documentation on Access Control,

NEW QUESTION 21
......