Abreast Of The Times COF-C02 Vce For SnowPro Core Certification Exam (COF-C02) Certification

NEW QUESTION 1

When does a materialized view get suspended in Snowflake?

• A. When a column is added to the base table
• B. When a column is dropped from the base table
• C. When a DML operation is run on the base table
• D. When the base table is reclustered

Answer: B

Explanation:
A materialized view in Snowflake gets suspended when structural changes that could impact the view's integrity are made to the base table, such asB. When a column is dropped from the base table. Dropping a column from the base table on which amaterialized view is defined can invalidate the view's data, as the view might rely on the column that is being removed. To maintain data consistency and prevent the materialized view from serving stale or incorrect data, Snowflake automatically suspends the materialized view.
Upon suspension, the materialized view does not reflect changes to the base table until it is refreshed or re-created. This ensures that only accurate and current data is presented to users querying the materialized view.
References:
✑ Snowflake Documentation on Materialized Views: Materialized Views

NEW QUESTION 2

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 3

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

• A. A single join node uses more than 50% of the query time
• B. Partitions scanned is equal to partitions total
• C. An AggregateOperacor node is present
• D. The query is spilling to remote storage

Answer: D

Explanation:
When a query in Snowflake is too large to fit into the available memory, it will start spilling to remote storage. This is an indication that the memory allocated for the query is insufficient for its execution, and as a result, Snowflake uses remote disk storage to handle the overflow. This spill to remote storage can lead to slower query performance due to the additional I/O operations required.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Query Profile1
✑ Snowpro Core Certification Exam Flashcards2

NEW QUESTION 4

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

• A. Compute Credits = 50 Credits Cloud Services = 10
• B. Compute Credits = 80 Credits Cloud Services = 5
• C. Compute Credits = 10 Credits Cloud Services = 9
• D. Compute Credits = 120 Credits Cloud Services = 10
• E. Compute Credits = 200 Credits Cloud Services = 26

Answer: AE

Explanation:
In Snowflake, Cloud Services costs are incurred when the Cloud Services usage exceeds 10% of the compute usage (measured in credits). Therefore, scenarios A and E would result in Cloud Services charges because the Cloud Services usage is more than 10% of the compute credits used.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake??s official documentation on billing and usage1

NEW QUESTION 5

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

• A. FLATTEN
• B. GET_PATH
• C. CHECK_JSON
• D. PARSE JSON

Answer: A

Explanation:
The FLATTEN function can be used with the recursive argument to return a list of distinct key names in all nested elements within an object. This function is particularly useful for working with semi-structured data in Snowflake

NEW QUESTION 6

What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

• A. BINARY_FORMAT
• B. ESCAPE_UNENCLOSED_FIELD
• C. FIELD_OPTIONALLY_ENCLOSED_BY
• D. SKIP BYTE ORDER MARK

Answer: C

Explanation:
When creating a CSV file format in Snowflake and the requirement is to wrap columns by single quotes or double quotes, theFIELD_OPTIONALLY_ENCLOSED_BY parameter should be used in the file format specification. This parameter allows you to define a character (either a single quote or a double quote) that can optionally enclose each field in the CSV file, providing flexibility in handling fields that contain special characters or delimiters as part of their data.
References:
✑ Snowflake Documentation: CSV File Format

NEW QUESTION 7

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

• A. An FTP server with TLS encryption
• B. An HTTPS server with WebDAV
• C. A Google Cloud storage bucket
• D. A Windows server file share on Azure

Answer: D

Explanation:
In Snowflake, when the account is located on Microsoft Azure, a valid source for an external stage can be an Azure container or a folder path within an Azure container. This includes Azure Blob storage which is accessible via the azure:// endpoint. A Windows server file share on Azure, if configured properly, can be a valid source for staging data files for Snowflake. Options A, B, and C are not supported as direct sources for an external stage in Snowflake on Azure12. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 8

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

• A. Reader
• B. Consumer
• C. Vendor
• D. Standard
• E. Personalized

Answer: CE

Explanation:
In the Snowflake Data Marketplace, the types of data listings available include ??Vendor??, which refers to the providers of data, and ??Personalized??, which indicates customized data offerings tailored to specific consumer needs45.

NEW QUESTION 9

Which objects together comprise a namespace in Snowflake? (Select TWO).

• A. Account
• B. Database
• C. Schema
• D. Table
• E. Virtual warehouse

Answer: BC

Explanation:
In Snowflake, a namespace is comprised of a database and a schema. The combination of a database and schema uniquely identifies database objects within an account

NEW QUESTION 10

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

• A. SELECT SUM (ORDER_AMT) FROM SALES;
• B. SELECT AVG(ORDER_QTY) FROM SALES;
• C. SELECT MIN(ORDER_AMT) FROM SALES;
• D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Answer: B

Explanation:
Operations that do not require compute resources are typically those that can leverage previously cached results. However, if no queries have been executed
previously, all the given operations would require compute to execute. It??s important to note that certain operations like DDL statements and queries that hit the result cache do not consume compute credits2.

NEW QUESTION 11

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg WH.
Which of the following statements will accommodate this request?

• A. ALLOW RESIZE ON WAREHOUSE MKTG WH TO USER MKTG LEAD;
• B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
• C. GRANT MODIFY ON WAREHOUSE MKTG WH TO USER MKTG LEAD;
• D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Answer: B

Explanation:
The correct statement to accommodate the request for a marketing co- worker to change the size of their medium virtual warehouse called mktg WH is to grant the MODIFY privilege on the warehouse to the ROLE MARKETING. This privilege allows the role to change the warehouse size among other properties.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Access Control Privileges1

NEW QUESTION 12

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

• A. Materialized view
• B. Sequence
• C. Secure view
• D. Transient table
• E. Clustered table

Answer: AD

Explanation:
In Snowflake, both materialized views and transient tables will incur storage charges because they store data. They will also incur compute charges when queries are run against them, as compute resources are used to process the queries. References:
[COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 13

What happens when an external or an internal stage is dropped? (Select TWO).

• A. When dropping an external stage, the files are not removed and only the stage is dropped
• B. When dropping an external stage, both the stage and the files within the stage are removed
• C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
• D. When dropping an internal stage, the files are deleted with the stage and the files arenot recoverable
• E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Answer: AD

Explanation:
When an external stage is dropped in Snowflake, the reference to the external storage location is removed, but the actual files within the external storage (like Amazon S3, Google Cloud Storage, or Microsoft Azure) are not deleted. This means that the data remains intact in the external storage location, and only the stage object in Snowflake is removed.
On the other hand, when an internal stage is dropped, any files that were uploaded to the stage are deleted along with the stage itself. These files are not recoverable once the internal stage is dropped, as they are permanently removed from Snowflake??s storage. References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Stages

NEW QUESTION 14

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

• A. Pipes
• B. Streams
• C. Tasks
• D. Procedures

Answer: B

Explanation:
In Snowflake, Streams are the objects that track Data Manipulation Language (DML) changes made to tables, such as inserts, updates, and deletes. Streams record these changes along with metadata about each change, enabling actions to be taken using the changed data. This process is known as change data capture (CDC)2.

NEW QUESTION 15

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

• A. View
• B. Secure view
• C. Materialized view
• D. External table

Answer: C

Explanation:
A materialized view in Snowflake denotes a pre-computed data set derived from a SELECT query specification and stored for later use. Unlike standard views, which dynamically compute the data each time the view is accessed, materialized views store the result of the query at the time it is executed, thereby speeding up access to the data, especially for expensive aggregations on large datasets.
References:
✑ Snowflake Documentation: Materialized Views

NEW QUESTION 16

Which of the following are benefits of micro-partitioning? (Select TWO)

• A. Micro-partitions cannot overlap in their range of values
• B. Micro-partitions are immutable objects that support the use of Time Travel.
• C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
• D. Rows are automatically stored in sorted order within micro-partitions
• E. Micro-partitions can be defined on a schema-by-schema basis

Answer: BC

Explanation:
Micro-partitions in Snowflake are immutable objects, which means once they are written, they cannot be modified. This immutability supports the use of Time Travel, allowing users to access historical data within a defined period. Additionally, micro-partitions can significantly reduce the amount of I/O from object storage to virtual warehouses. This is because Snowflake??s query optimizer can skip over micro-partitions that do not contain relevant data for a query, thus reducing the amount of data that needs to be scanned and transferred.
References: [COF-C02] SnowPro Core Certification Exam Study Guide https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

NEW QUESTION 17

If a virtual warehouse is suspended, what happens to the warehouse cache?

• A. The cache is dropped when the warehouse is suspended and is no longer available upon restart.
• B. The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.
• C. The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.
• D. The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.

Answer: A

Explanation:
When a virtual warehouse in Snowflake is suspended,the cache is dropped and is no longer available upon restart. This means that all cached data, including results and temporary data, are cleared from memory. The purpose of this behavior is to conserve resources while the warehouse is not active. Upon restarting the warehouse, it will need to reload any data required for queries from storage, which may result in a slower initial performance until the cache is repopulated. This is a critical consideration for managing performance and cost in Snowflake.

NEW QUESTION 18

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

• A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
• B. A Data Exchange allows groups of accounts to share data privately among the accounts.
• C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
• D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
• E. The sharing of data in a Data Exchange is bidirectiona
• F. An account can be a provider for some datasets and a consumer for others.

Answer: BE

Explanation:
A Snowflake Data Exchange allows groups of accounts to share data privately among the accounts (B), and it supports bidirectional sharing, meaning an account can be both a provider and a consumer of data (E). This facilitates secure and governed data collaboration within a selected group3.

NEW QUESTION 19

When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi- Factor Authentication (MFA) token valid for?

• A. 1 hour
• B. 2 hours
• C. 4 hours
• D. 8 hours

Answer: C

Explanation:
A cached MFA token is valid for up to four hours.https://docs.snowflake.com/en/user-guide/security-mfa#using-mfa-token-caching-to-minimize-the-number-of-prompts-during-authentication-optional

NEW QUESTION 20

Which of the following statements describe features of Snowflake data caching? (Choose two.)

• A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
• B. When the data cache is full, the least-recently used data will be cleared to make room.
• C. A user can only access their own queries from the query result cache.
• D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
• E. The RESULT_SCAN table function can access and filter the contents of the query result cache.

Answer: BE

Explanation:
Snowflake??s data caching features include the ability to clear the least- recently used data when the data cache is full to make room for new data. Additionally, the RESULT_SCAN table function can access and filter the contents of the query result cache, allowing users to retrieve and work with the results of previous queries. The other statements are incorrect: the data cache is not saved on the remote storage layer when a virtual warehouse is suspended, users can access queries from the query result cache that were run by other users, and there is no setting calledUSE_METADATA_CACHE in Snowflake. References: Caching in the Snowflake Cloud Data Platform, Optimizing the warehouse cache

NEW QUESTION 21
......