Snowflake COF-C02 SnowPro Core Certification Exam Practice Test

Answer : D

Snowflake recommends not exposing sequence-generated columns in secure views. Secure views are used to protect sensitive data by ensuring that users can only access data for which they have permissions. Exposing sequence-generated columns can potentially reveal information about the underlying data structure or the number of rows, which might be sensitive.

Create Secure Views: Define secure views using the SECURE keyword to ensure they comply with Snowflake's security policies.

Exclude Sensitive Columns: When creating secure views, exclude columns that might expose sensitive information, such as sequence-generated columns.

CREATE SECURE VIEW secure_view AS

SELECT col1, col2

FROM sensitive_table

WHERE sensitive_column IS NOT NULL;

References:

Snowflake Documentation: Secure Views

Snowflake Documentation: Creating Secure Views

These answers and explanations should provide comprehensive guidance on the specified Snowflake topics.

Answer : D

In Snowflake, the DOUBLE data type is used for floating-point numbers and can represent a wide range of values without losing precision. This data type is ideal for storing numerical values that require decimal precision.

Define the Column: When creating a table, specify the column with the DOUBLE data type to store floating-point numbers.

CREATE TABLE example_table (

id INTEGER,

value DOUBLE

);

Insert Data: Insert floating-point numbers into the DOUBLE column.

INSERT INTO example_table (id, value) VALUES (1, 123.456);

References:

Snowflake Documentation: Data Types

Snowflake Documentation: Numeric Data Types

Answer : B

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

Answer : C

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

Answer : A, D

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

Answer : C

To download a 5 GB table into a single file most efficiently in Snowflake, you should set the SINGLE parameter to TRUE. This parameter ensures that the COPY INTO command outputs the result into a single file, regardless of the file size. This approach is more efficient than relying on the default MAX_FILE_SIZE setting, which would split the output into multiple files.

References:

Snowflake Documentation: COPY INTO <location>

Answer : A, D

In a Snowflake Query Profile, the statistics 'Partitions scanned' and 'Bytes scanned' reflect the efficiency of query pruning. Query pruning refers to the ability of the query engine to skip unnecessary data, thereby reducing the amount of data that needs to be processed. Efficient pruning results in fewer partitions and bytes being scanned, improving query performance.

References:

Snowflake Documentation: Understanding Query Profiles

Top of Form

Bottom of Form