All About Tested COF-C02 Practice

NEW QUESTION 1

Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?

• A. Secure functions
• B. Secure views
• C. Object tagging
• D. Row-level security

Answer: C

Explanation:
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

NEW QUESTION 2

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

• A. Removing a column from the query SELECT list
• B. Stopping the virtual warehouse that the query is running against
• C. Clustering of the data used by the query
• D. Executing the RESULTS_SCAN() table function
• E. Changing a column that is not in the cached query

Answer: BD

Explanation:
The ResultSet cache is leveraged to quickly return results for repeated queries. Actions that prevent leveraging this cache include stopping the virtual warehouse that the query is running against (B) and executing the RESULTS_SCAN() table function (D). Stopping the warehouse clears the local disk cache, including the ResultSet cache1. The RESULTS_SCAN() function is used to retrieve the result of a previously executed query, which bypasses the need for the ResultSet cache.

NEW QUESTION 3

What causes objects in a data share to become unavailable to a consumer account?

• A. The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.
• B. The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.
• C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
• D. The consumer account acquires the data share through a private data exchange.

Answer: C

Explanation:
Objects in a data share become unavailable to a consumer account if the objects in the data share are deleted or if the permissions on these objects are altered without re- applying the grant permissions systematically. This is because the sharing mechanism in Snowflake relies on explicit grants of permissions on specific objects (like tables, views, or secure views) to the share. If these objects are deleted or if their permissions change without updating the share accordingly, consumers can lose access. TheDATA_RETENTION_TIME_IN_DAYSparameter does not directly affect the availability of shared objects, as it controls how long Snowflake retains historical data for time travel and does not impact data sharing permissions.
Running theGRANT IMPORTED PRIVILEGEScommand in the consumer account is not related to the availability of shared objects; this command is used to grant privileges on imported objects within the consumer's account and is not a routine maintenance command that would need to be run regularly.
Acquiring a data share through a private data exchange does not inherently make objects unavailable; issues would only arise if there were problems with the share configuration or if the shared objects were deleted or had their permissions altered without re-granting access to the share.
Reference: Snowflake Documentation on Managing Access to Shared Data
(https://docs.snowflake.com/en/user-guide/data-sharing-consuming.html#managing-access-to-shared-data)

NEW QUESTION 4

Which statement accurately describes how a virtual warehouse functions?

• A. Increasing the size of a virtual warehouse will always improve data loading performance.
• B. Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.
• C. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
• D. All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.

Answer: C

Explanation:
A virtual warehouse in Snowflake is an independent compute cluster that performs data processing tasks such as executing SQL queries. Each virtual warehouse is dynamically allocated by Snowflake from the cloud provider's resources and does not share compute resources with other warehouses. This architecture ensures that the performance of one warehouse does not impact the performance of another. Adjusting the size of a virtual warehouse affects its computational power by increasing or decreasing the number of compute nodes, which can improve the performance of data processing tasks depending on the workload.
References:
✑ Snowflake Documentation: Understanding Virtual Warehouses

NEW QUESTION 5

Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

• A. Caching
• B. Cluster depth
• C. Query pruning
• D. Retrieval optimization

Answer: C

Explanation:
Query pruning in Snowflake is the mechanism used to limit the number of micro-partitions scanned by a query. By analyzing the filters and conditions applied in a query, Snowflake can skip over micro-partitions that do not contain relevant data, thereby reducing the amount of data processed and improving query performance. This technique is particularly effective for large datasets and is a key component of Snowflake's performance optimization features.
References:
✑ Snowflake Documentation: Query Performance Optimization

NEW QUESTION 6

Which REST API can be used with unstructured data?

• A. inscrtFilcs
• B. insertReport
• C. GET /api/tiles/
• D. loadHistoryScan

Answer: C

Explanation:
The REST API used with unstructured data in Snowflake is GET /api/files/, which retrieves (downloads) a data file from an internal or external stage4.

NEW QUESTION 7

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

• A. ACCESS_HISTORY
• B. DATA_TRANSFER_HISTORY
• C. WAREHOUSE_METERING_HISTORY
• D. MONETIZED_USAGE_DAILY
• E. LISTING TELEMETRY DAILY

Answer: DE

Explanation:
The DATA_SHARING_USAGE schema includes views that display information about listings published in the Snowflake Marketplace or a data exchange, which includes DATA_TRANSFER_HISTORY and LISTING_TELEMETRY_DAILY2.

NEW QUESTION 8

Which metadata table will store the storage utilization information even for dropped tables?

• A. DATABASE_STORAGE_USAGE_HISTORY
• B. TABLE_STORAGE_METRICS
• C. STORAGE_DAILY_HISTORY
• D. STAGE STORAGE USAGE HISTORY

Answer: B

Explanation:
The TABLE_STORAGE_METRICS metadata table stores the storage utilization information, including for tables that have been dropped but are still incurring storage costs2.

NEW QUESTION 9

A user wants to access stored in a stage without authenticating into Snowflake. Which type of URL should be used?

• A. File URL
• B. Staged URL
• C. Scoped URL
• D. Pre-signed URL

Answer: D

Explanation:
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.References:Snowflake Documentation on Stages and Data Loading

NEW QUESTION 10

What privilege should a user be granted to change permissions for new objects in a managed access schema?

• A. Grant the OWNERSHIP privilege on the schema.
• B. Grant the OWNERSHIP privilege on the database.
• C. Grant the MANAGE GRANTS global privilege.
• D. Grant ALL privileges on the schema.

Answer: C

Explanation:
To change permissions for new objects in a managed access schema, a user should be granted the MANAGE GRANTS global privilege. This privilege allows the user to manage access control through grants on all securable objects within Snowflake2. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 11

Snowflake users can create a resource monitor at which levels? (Select TWO).

• A. User level
• B. Pipe level
• C. Account level
• D. Cloud services level
• E. Virtual warehouse level

Answer: CE

Explanation:
Resource monitors in Snowflake are tools used to track and control the consumption of compute resources, ensuring that usage stays within defined limits. These monitors can be created at the account level, allowing administrators to set overall resource consumption limits for the entire Snowflake account. Additionally, resource monitors can be set at the virtual warehouse level, enabling more granular control over the resources consumed by individual warehouses. This dual-level capability allows organizations to manage their Snowflake usage efficiently, preventing unexpected costs and optimizing performance.References:Snowflake Documentation on Resource Monitors Top of Form

NEW QUESTION 12

What does Snowflake's search optimization service support?

• A. External tables
• B. Materialized views
• C. Tables and views that are not protected by row access policies
• D. Casts on table columns (except for fixed-point numbers cast to strings)

Answer: C

Explanation:
Snowflake??s search optimization service supports tables and views that are not protected by row access policies. It is designed to improve the performance of certain types of queries on tables, including selective point lookup queries and queries on fields in VARIANT, OBJECT, and ARRAY (semi-structured) columns1.

NEW QUESTION 13

Which statement about billing applies to Snowflake credits?

• A. Credits are billed per-minute with a 60-minute minimum
• B. Credits are used to pay for cloud data storage usage
• C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs
• D. Credits are consumed based on the warehouse size and the time the warehouse is running

Answer: D

Explanation:
Snowflake credits are the unit of measure for the compute resources used in Snowflake. The number of credits consumed depends on the size of the virtual warehouse and the time it is running. Larger warehouses consume more credits per hour than smaller ones, and credits are billed for the time the warehouse is active, regardless of the actual usage within that time.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 14

Which formats does Snowflake store unstructured data in? (Choose two.)

• A. GeoJSON
• B. Array
• C. XML
• D. Object
• E. BLOB

Answer: AC

Explanation:
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-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 15

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

• A. UPDATE TABLE FROM STREAM
• B. SELECT FROM STREAM
• C. INSERT INTO TABLE SELECT FROM STREAM
• D. ALTER TABLE AS SELECT FROM STREAM
• E. BEGIN COMMIT

Answer: AC

Explanation:
The SQL commands that consume a stream and advance the stream offset are those that result in changes to the data, such as UPDATE and INSERT operations. Specifically, ??UPDATE TABLE FROM STREAM?? and ??INSERT INTO TABLE SELECT
FROM STREAM?? will consume the stream and move the offset forward, reflecting the changes made to the data.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 16

What is the purpose of the use of the VALIDATE command?

• A. To view any queries that encountered an error
• B. To verify that a SELECT query will run without error
• C. To prevent a put statement from running if an error occurs
• D. To see all errors from a previously run COPY INTO <table> statement

Answer: D

Explanation:
TheVALIDATEcommand in Snowflake is used to check for errors that occurred during the execution of aCOPY INTO <table>statement. This command helps users identify and
resolve data loading issues.
✑ Run the COPY INTO Statement:Execute theCOPY INTO <table>command to load data from a stage into a table.
COPY INTO my_table FROM @my_stage
FILE_FORMAT = (FORMAT_NAME = 'my_format');
✑ Validate the Load:Use theVALIDATEfunction to see if there were any errors during the data load.
SELECT *
FROM TABLE(VALIDATE(my_table, JOB_ID => 'my_copy_job_id'));
✑ Review Errors:TheVALIDATEfunction will return details about any errors that occurred, such as parsing errors or data type mismatches.
References:
✑ Snowflake Documentation: Validating Data Loads
✑ Snowflake Documentation: COPY INTO <table>

NEW QUESTION 17

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

• A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
• B. An error will occur, as views with qualified references cannot be cloned.
• C. An error will occur, as stored objects cannot be cloned.
• D. The stored procedures and views will refer to tables in the source database.

Answer: A

Explanation:
When cloning a database containing stored procedures and regular views with fully qualified table references, the cloned views and stored procedures will reference the cloned tables in the cloned database (A). This ensures that the cloned database is a self-contained copy of the original, with all references pointing to objects within the same cloned database. References: SnowPro Core Certification cloning database stored procedures views

NEW QUESTION 18

In which hierarchy is tag inheritance possible?

• A. Organization » Account» Role
• B. Account » User » Schema
• C. Database » View » Column
• D. Schema » Table » Column

Answer: D

Explanation:
In Snowflake, tag inheritance is a feature that allows tags, which are key- value pairs assigned to objects for the purpose of data governance and metadata management, to be inherited within a hierarchy. The hierarchy in which tag inheritance is possible is from Schema to Table to Column. This means that a tag applied to a schema can be inherited by the tables within that schema, and a tag applied to a table can be inherited by the columns within that table.References:Snowflake Documentation on Tagging and Object Hierarchy

NEW QUESTION 19

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

• A. The data retention period is reduced to a minimum of 14 days.
• B. The data retention period is permanently extended for the table.
• C. The data retention period is temporarily extended to the stream's offset.
• D. The data retention period is not affected by the stream consumption.

Answer: C

Explanation:
In Snowflake, the use of streams impacts how the data retention period for a table is handled, particularly in scenarios where the stream has not been consumed. The key point to understand is that Snowflake's streams are designed to capture data manipulation language (DML) changes such as INSERTS, UPDATES, and DELETES that occur on a source table. Streams maintain a record of these changes until they are consumed by a DML operation or a COPY command that references the stream.
When a stream is created on a table and remains unconsumed, Snowflake extends the data retention period of the table to ensure that the changes captured by the stream are preserved. This extension is specifically up to the point in time represented by the stream's offset, which effectively ensures that the data necessary for consuming the stream's contents is retained. This mechanism is in place to prevent data loss and ensure the integrity of the stream's data, facilitating accurate and reliable data processing and analysis based on the captured DML changes.
This behavior emphasizes the importance of managing streams and their consumption appropriately to balance between data retention needs and storage costs. It's also crucial to understand how this temporary extension of the data retention period impacts the overall management of data within Snowflake, including aspects related to data lifecycle, storage cost implications, and the planning of data consumption strategies.
References:
✑ Snowflake Documentation on Streams: Using Streams
✑ Snowflake Documentation on Data Retention: Understanding Data Retention

NEW QUESTION 20

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

• A. Data is live, ready-to-query, and can be personalized.
• B. Data needs to be loaded into a cloud provider as a consumer account.
• C. Data is not available for copying or moving to an individual Snowflake account.
• D. Data is available without copying or moving.
• E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Answer: AD

Explanation:
When leveraging third-party data from the Snowflake Data Marketplace, the data is live, ready-to-query, and can be personalized. Additionally, the data is available without the need for copying or moving it to an individual Snowflake account, allowing for seamless integration with existing data

NEW QUESTION 21
......