Snowflake COF-C02 SnowPro Core Certification Exam Practice Test

Answer : B, C

The features associated with Continuous Data Protection (CDP) that require additional Snowflake-provided data storage are Time Travel and Fail-safe. Time Travel allows users to access historical data within a defined period, while Fail-safe provides an additional layer of data protection beyond the Time Travel period.References:[COF-C02] SnowPro Core Certification Exam Study Guide

Answer : C

The Merge operator is considered a DML (Data Manipulation Language) operator in Snowflake. DML operators are used to modify data in tables, and the Merge operator specifically allows for conditional updates, inserts, or deletes in a target table based on the results of a join with a source table.

References:

Snowflake Documentation: Query Profile Overview

Snowflake Documentation: MERGE Statement

Answer : D

The function used to determine the kind of value stored in a VARIANT column in Snowflake is TYPEOF.

Understanding VARIANT Data Type:

VARIANT is a flexible data type in Snowflake that can store semi-structured data, such as JSON, Avro, and XML.

This data type can hold values of different types, including strings, numbers, objects, arrays, and more.

Using TYPEOF Function:

The TYPEOF function returns the data type of the value stored in a VARIANT column.

It helps in identifying the type of data, which is crucial for processing and transforming semi-structured data accurately.

Example Usage:

SELECT TYPEOF(variant_column)

FROM my_table;

This query retrieves the type of data stored in variant_column for each row in my_table.

Possible return values include 'OBJECT', 'ARRAY', 'STRING', 'NUMBER', etc.

Benefits:

Simplifies data processing: Knowing the data type helps in applying appropriate transformations and validations.

Enhances query accuracy: Ensures that operations on VARIANT columns are performed correctly based on the data type.

References:

Snowflake Documentation: TYPEOF

Snowflake Documentation: VARIANT Data Type

Answer : C

The GET_PRESIGNED_URL function in Snowflake generates a presigned URL for a file stored in an internal stage, allowing direct access to the file without requiring Snowflake access. This feature is particularly useful for sharing unstructured data with external applications or tools that do not have direct access to Snowflake. The presigned URL provides temporary access to the file, making it an ideal solution for securely sharing unstructured data from an internal stage with a reporting tool or any other external application.

References:

Snowflake Documentation: Generating Presigned URLs

Answer : D

Snowflake recommends using the COPY command for bulk loading data batches from files already available in cloud storage.This command allows for efficient and large-scale data loading operations from files staged in cloud storage into Snowflake tables3.

Answer : A, B

Managed Access Schemas: These are a special type of schema designed for fine-grained access control in Snowflake.

Roles with Grant Authority:

ACCOUNTADMIN:The top-level administrative role can grant object privileges on all objects within the account, including managed access schemas.

SECURITYADMIN:Can grant and revoke privileges on objects within the account, including managed access schemas.

Important Note: The ORGADMIN role focuses on organization-level management, not object access control.

Answer : D, E

A user with the OWNERSHIP privilege on a user object or the CREATE USER privilege on the account can create or manage other users in a Snowflake account56.