Snowflake COF-C02 Practice Test - Questions Answers, Page 67

Snowflake uses both Discretionary Access Control (DAC) and Role-Based Access Control (RBAC) to manage access control. DAC allows object owners to grant access privileges to other users. RBAC assigns permissions to roles, and roles are then granted to users, making it easier to manage permissions based on user roles within the organization.

References:

Snowflake Documentation: Access Control in Snowflake

Object tagging in Snowflake allows users to assign metadata labels to various database objects to improve data governance and access control. Tags can be used to categorize and manage data based on business needs, helping to enforce governance policies and streamline database administration.

References:

Snowflake Documentation: Object Tagging

The minimum Snowflake edition that supports database replication is the Enterprise edition. Database replication allows data to be replicated between different Snowflake accounts or regions, providing high availability and disaster recovery capabilities.

References:

Snowflake Documentation: Database Replication

The query acceleration service in Snowflake is beneficial for workloads that include on-demand data analyses. This service optimizes query performance by dynamically allocating additional resources to execute queries faster, particularly useful for ad-hoc analysis where data volume and complexity can vary.

References:

Snowflake Documentation: Query Acceleration Service

Snowflake applies egress charges in the case of database replication when data is transferred out of a Snowflake region to another region or cloud provider. This is because the data transfer incurs costs associated with moving data across different networks. Egress charges are not applied for data sharing within the same region, query result retrieval, or loading data into Snowflake, as these actions do not involve data transfer across regions.

References:

[COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Data Replication and Egress Charges1

By default, the Snowflake role required to create a share is ACCOUNTADMIN (D).This role has the necessary privileges to perform administrative tasks, including creating shares for data sharing purposes

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.

To convert rows in a relational table to a single VARIANT column and unload the rows into a file in JSON format, you can use the COPY command in combination with the OBJECT_CONSTRUCT function. The OBJECT_CONSTRUCT function converts the row into a JSON object stored in a VARIANT column, and the COPY command can then be used to unload this data into a JSON file.

References:

Snowflake Documentation: OBJECT_CONSTRUCT

Snowflake Documentation: COPY INTO <location>

Top of Form

Bottom of Form

Snowflake recommends removing data files from the staging area after they have been loaded into the target table. This practice ensures that the data is only loaded once and prevents accidental reloading of the same data. By removing the files, you eliminate the risk of duplicate data loads.

Stage the Data: Upload the data files to a Snowflake stage (internal or external).

Load the Data: Use the COPY INTO command to load the data from the stage into the Snowflake table.

Remove the Data Files: After successfully loading the data, remove the data files from the stage using the REMOVE command.

References:

Snowflake Documentation: Loading Data into Snowflake

Snowflake Documentation: Staging Data Files

Snowflake Documentation: COPY INTO Command