How Many Questions Of COF-C02 Practice Exam

NEW QUESTION 1

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

• A. Use data encryption.
• B. Use dynamic data masking.
• C. Use secure materialized views.
• D. Revoke all roles for functional managers and end users.

Answer: B

Explanation:
Dynamic data masking is a feature in Snowflake that allows administrators to define masking policies to protect sensitive data. It enables partial visibility of the data to certain roles, such as functional managers, while hiding it from others, like end users

NEW QUESTION 2

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

• A. Cloud services layer
• B. Compute layer
• C. Storage layer
• D. Cloud agnostic layer

Answer: A

Explanation:
Query parsing and compilation in Snowflake occur within the cloud services layer. This layer is responsible for various management tasks, including query compilation and optimization

NEW QUESTION 3

What activities can a user with the ORGADMIN role perform? (Select TWO).

• A. Create information_schema in a database
• B. View usage information for all accounts in the organization.
• C. Enable database cloning for an account in the organization.
• D. Enable database replication for an account in the organization.
• E. View micro-partition information for all accounts in the organization.

Answer: BD

Explanation:
The ORGADMIN role in Snowflake is designed to manage organization-level activities. This role can perform several tasks that span across multiple accounts within the organization.
✑ View Usage Information:The ORGADMIN role can view usage statistics and billing
information for all accounts within the organization.
-- Example: Viewing usage information SELECT *
FROM organization_usage_history;
✑ Enable Database Replication:The ORGADMIN role has the authority to enable and manage database replication for accounts within the organization.
-- Example: Enabling database replication
ALTER DATABASE my_database ENABLE REPLICATION TO ACCOUNT other_account;
References:
✑ Snowflake Documentation: Organization Administration
✑ Snowflake Documentation: Replication

NEW QUESTION 4

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

• A. Custom Edition
• B. Virtual Private Snowflake
• C. Business Critical Edition
• D. Standard Edition
• E. Enterprise Edition

Answer: BC

Explanation:
To manage compliance with Personal Identifiable Information (PII) requirements, the Virtual Private Snowflake and Business Critical Editions of Snowflake should be used. These editions provide advanced security features necessary for handling sensitive data

NEW QUESTION 5

Which file function gives a user or application access to download unstructured data from a Snowflake stage?

• A. BUILD_SCOPED_FILE_URL
• B. BUILD_STAGE_FILE_URL
• C. GET_PRESIGNED_URL
• D. GET STAGE LOCATION

Answer: C

Explanation:
The function that provides access to download unstructured data from a Snowflake stage is:
✑ C. GET_PRESIGNED_URL: This function generates a presigned URL for a single file within a stage. The generated URL can be used to directly access or download the file without needing to go through Snowflake. This is particularly useful for unstructured data such as images, videos, or large text files, where direct access via a URL is needed outside of the Snowflake environment.
Example usage: SELECTGET_PRESIGNED_URL('stage_name','file_path');
This function simplifies the process of securely sharing or accessing files stored in Snowflake stages with external systems or users.
References:
✑ Snowflake Documentation: GET_PRESIGNED_URL Function at Snowflake Documentation

NEW QUESTION 6

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

• A. Tags
• B. Comments
• C. Internal tokenization
• D. Row access policies

Answer: A

Explanation:
Tags in Snowflake allow users to track sensitive data for compliance, discovery, protection, and resource usage. They enable the categorization and tracking of data, supporting compliance with privacy regulations678. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 7

Which governance feature is supported by all Snowflake editions?

• A. Object tags
• B. Masking policies
• C. Row access policies
• D. OBJECT_DEPENDENCIES View

Answer: D

Explanation:
Snowflake's governance features vary across different editions, but the OBJECT_DEPENDENCIESview is supported by all Snowflake editions. This feature is part of Snowflake's Information Schema and is designed to help users understand the dependencies between various objects in their Snowflake environment. TheOBJECT_DEPENDENCIESview provides a way to query and analyze the relationships and dependencies among different database objects, such as tables, views, and stored procedures. This is crucial for governance, as it allows administrators and data engineers to assess the impact of changes, understand object relationships, and ensure proper management of data assets.
Object tags, masking policies, and row access policies are more advanced features that offer fine-grained data governance capabilities such as tagging objects for classification, dynamically masking sensitive data based on user roles, and controlling row-level access to data. These features may have varying levels of support across different Snowflake editions, with some features being exclusive to higher-tier editions.
Reference: Snowflake Documentation on Information Schema
(https://docs.snowflake.com/en/sql-reference/info-schema/object_dependencies.html)

NEW QUESTION 8

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

• A. Internal stages
• B. Incremental backups
• C. Time Travel
• D. Zero-copy clones
• E. Fail-safe

Answer: CE

Explanation:
Snowflake??s Continuous Data Protection (CDP) encompasses a set of features that help protect data stored in Snowflake against human error, malicious acts, and software failure. Time Travel allows users to access historical data (i.e., data that has been changed or deleted) for a defined period, enabling querying and restoring of data. Fail-safe is an additional layer of data protection that provides a recovery option in the event of significant data loss or corruption, which can only be performed by Snowflake. References:
✑ Continuous Data Protection | Snowflake Documentation1
✑ Data Storage Considerations | Snowflake Documentation2
✑ Snowflake SnowPro Core Certification Study Guide3
✑ Snowflake Data Cloud Glossary
https://docs.snowflake.com/en/user-guide/data-availability.html

NEW QUESTION 9

How can a user get the MOST detailed information about individual table storage details in Snowflake?

• A. SHOW TABLES command
• B. SHOW EXTERNAL TABLES command
• C. TABLES view
• D. TABLE STORAGE METRICS view

Answer: D

Explanation:
To get the most detailed information about individual table storage details in Snowflake, theTABLE STORAGE METRICSview should be used. This Information Schema view provides granular storage metrics for tables within Snowflake, including data related to the size of the table, the amount of data stored, and storage usage over time. It's an essential tool for administrators and users looking to monitor and optimize storage consumption and costs.
References:
✑ Snowflake Documentation: Information Schema - TABLE STORAGE METRICS View

NEW QUESTION 10

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470. How can this issue be resolved?

• A. Compress the file and load the compressed file.
• B. Split the file into multiple files in the recommended size range (100 MB - 250 MB).
• C. Use a larger-sized warehouse.
• D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Answer: B

Explanation:
The error ??Max LOB size (16777216) exceeded?? indicates that the size of the parsed column exceeds the maximum size allowed for a single column value in Snowflake, which is 16 MB. To resolve this issue, the file should be split into multiple smaller files that are within the recommended size range of 100 MB to 250 MB. This will ensure that each JSON document within the files is smaller than the maximum LOB size allowed. Compressing the file, using a larger-sized warehouse, or setting STRIP_OUTER_ARRAY=TRUE will not resolve the issue of the column size exceeding the maximum allowed. References: COPY INTO Error during Structured Data Load: ??Max LOB size (16777216) exceeded????

NEW QUESTION 11

What features does Snowflake Time Travel enable?

• A. Querying data-related objects that were created within the past 365 days
• B. Restoring data-related objects that have been deleted within the past 90 days
• C. Conducting point-in-time analysis for Bl reporting
• D. Analyzing data usage/manipulation over all periods of time

Answer: BC

Explanation:
Snowflake Time Travel is a powerful feature that allows users to access historical data within a defined period. It enables two key capabilities:
✑ B. Restoring data-related objects that have been deleted within the past 90 days:
Time Travel can be used to restore tables, schemas, and databases that have been accidentally or intentionally deleted within the Time Travel retention period.
✑ C. Conducting point-in-time analysis for BI reporting: It allows users to query
historical data as it appeared at a specific point in time within the Time Travel retention period, which is crucial for business intelligence and reporting purposes.
While Time Travel does allow querying of past data, it is limited to the retention period set for the Snowflake account, which is typically 1 day for standard accounts and can be extended up to 90 days for enterprise accounts. It does not enable querying or restoring objects created or deleted beyond the retention period, nor does it provide analysis over all periods of time.
References:
✑ Snowflake Documentation on Time Travel
✑ SnowPro® Core Certification Study Guide

NEW QUESTION 12

What can a Snowflake user do with the information included in the details section of a Query Profile?

• A. Determine the total duration of the query.
• B. Determine the role of the user who ran the query.
• C. Determine the source system that the queried table is from.
• D. Determine if the query was on structured or semi-structured data.

Answer: A

Explanation:
The details section of a Query Profile in Snowflake provides users with various statistics and information about the execution of a query. One of the key pieces of information that can be determined from this section is the total duration of the query, which helps in understanding the performance and identifying potential bottlenecks. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 13

The VALIDATE table function has which parameter as an input argument for a Snowflake user?

• A. Last_QUERY_ID
• B. CURRENT_STATEMENT
• C. UUID_STRING
• D. JOB_ID

Answer: C

Explanation:
The VALIDATE table function in Snowflake would typically use a unique identifier, such as a UUID_STRING, as an input argument. This function is designed to validate the data within a table against a set of constraints or conditions, often requiring a specific identifier to reference the particular data or job being validated.
References:
✑ There is no direct reference to a VALIDATE table function with these specific parameters in Snowflake documentation. It seems like a theoretical example for understanding function arguments. Snowflake documentation on UDFs andsystem functions can provide guidance on how to create and use custom functions for similar purposes.

NEW QUESTION 14

How would a user run a multi-cluster warehouse in maximized mode?

• A. Configure the maximum clusters setting to "Maximum."
• B. Turn on the additional clusters manually after starting the warehouse.
• C. Set the minimum Clusters and maximum Clusters settings to the same value.
• D. Set the minimum clusters and maximum clusters settings to different values.

Answer: C

Explanation:
To run a multi-cluster warehouse in maximized mode, a user should set the minimum and maximum number of clusters to the same value. This ensures that all clusters are available when thewarehouse is started, providing maximum resources for query execution. References: Snowflake Documentation2.

NEW QUESTION 15

How can a data provider ensure that a data consumer is going to have access to the required objects?

• A. Enable the data sharing feature in the account and validate the view.
• B. Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
• C. Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.
• D. Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

Answer: A

Explanation:
To ensure a data consumer has access to the required objects, a data provider can enable the data sharing feature and validate that the consumer can access the views or tables shared with them. References: Based on general data sharing practices in cloud services as of 2021.

NEW QUESTION 16

How should clustering be used to optimize the performance of queries that run on a very large table?

• A. Manually re-cluster the table regularly.
• B. Choose one high cardinality column as the clustering key.
• C. Use the column that is most-frequently used in query select clauses as the clustering key.
• D. Assess the average table depth to identify how clustering is impacting the query.

Answer: B

Explanation:
For optimizing the performance of queries that run on a very large table, it is recommended to choose one high cardinality column as the clustering key. This helps to co-locate similar rows in thesame micro-partitions, improving scan efficiency in queries by skipping data that does not match filtering predicates4.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 17

What feature can be used to reorganize a very large table on one or more columns?

• A. Micro-partitions
• B. Clustering keys
• C. Key partitions
• D. Clustered partitions

Answer: B

Explanation:
Clustering keys in Snowflake are used to reorganize large tables based on one or more columns. This feature optimizes the arrangement of data within micro- partitions to improve query performance, especially for large tables where efficient data retrieval is crucial. References: [COF-C02] SnowPro Core Certification Exam Study Guide https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

NEW QUESTION 18

Which data types can be used in Snowflake to store semi-structured data? (Select TWO)

• A. ARRAY
• B. BLOB
• C. CLOB
• D. JSON
• E. VARIANT

Answer: AE

Explanation:
Snowflake supports the storage of semi-structured data using the ARRAY and VARIANT data types. The ARRAY data type can directly contain VARIANT, and thus indirectly contain any other data type, including itself. The VARIANT data type can store a value of any other type, including OBJECT and ARRAY, and is often used to represent semi-structured data formats like JSON, Avro, ORC, Parquet, or XML34.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 19
......