COF-C03 Exam Dumps - Snowflake SnowPro Core Certification Questions and Answers

 The command used to unload files from an internal or external stage to a local file system in Snowflake is the GET command. This command allows usersto download data files that have been staged, making them available on the local file system for further use23.

Unstructured data stored in Snowflake can be retrieved by using SQL functions to generate URLs that point to the data. These URLs can then be used to download the data directly to a client

Snowflake’s Time Travel feature is used for the maintenance of historical data, allowing users to access andrestore data that has been changed or deleted within a defined period4.

The query acceleration service in Snowflake is designed to benefit queries that involve large scans and selective filters. This service can offload portions of the query processing work to shared compute resources, which can handlethese types of workloads more efficiently by performing morework in parallel and reducing the wall-clock time spent in scanning and filtering2. References: [ COF-C03 ] SnowPro Core Certification Exam Study Guide

Snowflake’s architecture allows for the independent scaling of compute resources, meaning you can increase or decrease the computational power as needed without affecting storage. This separation also means that storage can grow independently of compute usage, allowing for more flexible and cost-effective data management. 

 Clustering keys in Snowflake work by sorting the designated columns over time. This process is done in the background and does not block data manipulation language (DML) operations, allowing for normal database operations to continue without interruption. The purpose of clustering keys is to organize the data within micro-partitions to optimizequery performance1.

 Virtual Warehouses in Snowflake can indeed be resized while they are suspended. Resizing a warehouse involves changing the number of compute resources (servers) allocated to it, which can be done to adjust performance and cost. When a warehouse is suspended, it is not currently running any queries, but its definition and metadata remain intact, allowing for modifications like resizing.

To allow secure views the ability to reference data in multiple databases, the REFERENCE_USAGE privilege must be granted on each database that contains objects referenced by the secure view2. This privilege is necessary before granting the SELECT privilege on a secure view to a share.

 The reader account compute will be billed to the provider account. Very Comprehensive Explanation: In Snowflake, when a provider creates a reader account for a consumer who does not have a Snowflake account, the compute resources used by the reader account are billed to the provider’s account. This allows the consumer to query the shared data without incurring any costs. References: [ COF-C03 ] SnowPro Core Certification Exam Study Guide

Snowflake supports storing unstructured data and provides native support for semi-structured file formats such as JSON, Avro, Parquet, ORC, and XML1. GeoJSON, being a type of JSON, and XML are among the formats that can be stored in Snowflake. References: [ COF-C03 ] SnowPro Core Certification Exam Study Guide

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 theACCOUNTADMINrole 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 control database replication settings, maintaining strict governance and security standards.

The propertymins_to_bypass_network_policyis set at the account level in Snowflake. This setting allows administrators to specify a time frame during which users can bypass network policies that have been set on their account. It is particularly useful in scenarios where temporary access needs to be granted from IPs not covered by the existing network policies. By adjusting this property at the account level, Snowflake administrators can manage and enforce network access controls efficiently across the entire account.

The correct answer is B. OWNERSHIP on the database role .

A database role is a securable object within a database. To grant a database role to another role, the granting role must have the authority to manage that database role. The OWNERSHIP privilege on the database role gives full control over the database role, including the ability to grant it.

Why B is correct:

The owner of a database role can grant that database role to another database role or account role, depending on the supported grant relationship.

Example concept:

GRANT DATABASE ROLE database1.db_role1 TO ROLE account_role1;

To perform this action, the executing role must have appropriate authority over database1.db_role1, such as OWNERSHIP.

Why the other options are incorrect:

A. USAGE on the database allows access to the database namespace, but it does not grant authority to grant a database role.

C. CREATE ROLE applies to creating account roles, not granting database roles.

D. MANAGE GRANTS can allow broad grant management, but the specific required object-level privilege in this question is OWNERSHIP on the database role.

Official Snowflake documentation reference:

Snowflake documentation explains that database roles are securable objects and that ownership provides full control over the object, including grant management.

Snowflake allows users to write custom application logic in JavaScript for two types of objects: Stored Procedures and User-Defined Functions (UDFs).

Stored Procedures:Snowflake stored procedures can be written in JavaScript to encapsulate complex business logic and procedural operations.

CREATE OR REPLACE PROCEDURE my_procedure()

RETURNS STRING

LANGUAGE JAVASCRIPT

EXECUTE AS CALLER

AS

$$

// JavaScript logic here

$$;

User-Defined Functions (UDFs):Snowflake UDFs can be written in JavaScript to perform custom calculations or operations on data.

CREATE OR REPLACE FUNCTION my_function(x FLOAT)

RETURNS FLOAT

LANGUAGE JAVASCRIPT

AS

$$

return x * 2;

$$;

A pre-signed URL provides a way to access objects stored in a stage without requiring authentication to Snowflake. This URL contains all the necessary information for access control, including an expiration time, and it’s signed by the service ' s credentials. This mechanism allows users or applications to access specific files stored in a cloud storage location (stage) directly, bypassing the need to authenticate into Snowflake, ensuring secure and temporary access to the data.

Snowflake ' s Cloud Services layer is responsible for managing various aspects of the platform that are not directly related to computing or storage. Specifically, it handles authorisation, ensuring that users have appropriate access rights to perform actions or access data. Additionally, it takes care of query parsing and optimization, interpreting SQL queries and optimizing their execution plans for better performance. This layer abstracts much of the platform ' s complexity, allowing users to focus on their data and queries without managing the underlying infrastructure.

Cross-region replication ensures data availability across multiple cloud regions . In the event of a regional outage, Snowflake accounts with this feature can fail over to a different region.

The correct answer is D. To unload a single file from a table into a stage .

The COPY INTO < location > command is used to unload data from Snowflake to a stage. When the SINGLE = TRUE option is included, Snowflake attempts to unload the query or table result into a single output file instead of multiple files.

Why D is correct:

SINGLE = TRUE is specifically an unload option for COPY INTO < location > . It is useful when a downstream process expects one output file.

Example:

COPY INTO @my_stage/export/customers.csv

FROM customers

FILE_FORMAT = (TYPE = CSV)

SINGLE = TRUE;

Why the other options are incorrect:

A. Preventing duplicate loads is handled by Snowflake load metadata and the FORCE option, not SINGLE = TRUE.

B. Loading an individual file is done with COPY INTO < table > and a file path or the FILES option, not COPY INTO < location > SINGLE = TRUE.

C. “Parse the results into single stages” is not a Snowflake unload concept.

Official Snowflake documentation reference:

Snowflake documentation for COPY INTO < location > describes SINGLE as the option that specifies whether to generate a single file or multiple files when unloading data.