Ultimate Guide to Prepare COF-C02 Certification Exam for SnowPro Core in 2026 [Q378-Q402]

NEW QUESTION 378
What should be considered when deciding to use a secure view? (Select TWO).

NEW QUESTION 379
What is the recommended compressed file size range for continuous data loads using Snowpipe?

NEW QUESTION 380
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

NEW QUESTION 381
True or False: Fail-safe can be disabled within a Snowflake account.

NEW QUESTION 382
Which of the following SQL statements will list the version of the drivers currently being used?

NEW QUESTION 383
What happens to historical data when the retention period for an object ends?

NEW QUESTION 384
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

NEW QUESTION 385
Which Snowflow object does not consume and storage costs?

NEW QUESTION 386
Which privilege is required on a virtual warehouse to abort any existing executing queries?

NEW QUESTION 387
What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

NEW QUESTION 388
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

NEW QUESTION 389
Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

NEW QUESTION 390
A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as “Notify & Suspend Immediately”.

What is the MAXIMUM limit of credits that Warehouse 2 can consume?

NEW QUESTION 391
Using which object-level parameters will help limit query processing and concurrency slowdowns? (Select TWO).

NEW QUESTION 392
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

NEW QUESTION 393
Queries are frequently run on very large tables and return only a few rows.
Use of which feature or service will optimize the query performance?

NEW QUESTION 394
Network policies can be set at which Snowflake levels? (Choose two.)

NEW QUESTION 395
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

NEW QUESTION 396

What do these Query Profile metrics indicate about the query micro-partition pruning?

NEW QUESTION 397
Which data protection feature should only be used when all other data recovery options have been attempted?

NEW QUESTION 398
A directory table that references an external stage is being refreshed manually.
What will happen to any scheduled automatic-refresh operations occurring at the same time as the manual- refresh operations?

NEW QUESTION 399
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers

NEW QUESTION 400
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

NEW QUESTION 401
Which Snowflake tasks are managed in the cloud services layer? Select TWO.

NEW QUESTION 402
A virtual warehouse query queuing time has been increasing due to a large number of users accessing the warehouse at the same time each day. Which warehouse configurations would address this issue MOST cost- effectively? (Select TWO).