Download SnowPro Core Recertification.COF-R02.ExamTopics.2025-07-07.52q.vcex

Vendor: Snowflake
Exam Code: COF-R02
Exam Name: SnowPro Core Recertification
Date: Jul 07, 2025
File Size: 134 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Streams can be configured to query change data on which Snowflake objects? (Choose two.)
  1. Pipe
  2. Stage
  3. Secure view
  4. Materialized view
  5. Shared table
Correct answer: CE
Explanation:
Question 2
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
  1. Area chart
  2. Box plot
  3. Heat grid
  4. Pie chart
Correct answer: C
Explanation:
Question 3
What does a Notify & Suspend action for a resource monitor do?
  1. Send an alert notification to all account users who have notifications enabled.
  2. Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.
  3. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
  4. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.
Correct answer: C
Explanation:
Question 4
In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
  1. READ
  2. REFERENCES
  3. REFERENCE_USAGE
  4. USAGE
Correct answer: D
Explanation:
Question 5
Which types of subqueries does Snowflake support? (Choose two.)
  1. Uncorrelated scalar subqueries in WHERE clauses
  2. Uncorrelated scalar subqueries in any place that a value expression can be used
  3. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only
  4. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated only
  5. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated
Correct answer: AB
Explanation:
Question 6
What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?
  1. The type of SQL statements executed
  2. The number of tables or databases queried
  3. The amount of data stored in the warehouse
  4. The length of time the compute resources in each cluster run
Correct answer: C
Explanation:
Question 7
Which governance feature is supported by all Snowflake editions?
  1. Object tags
  2. Masking policies
  3. Row access policies
  4. OBJECT_DEPENDENCIES view
Correct answer: C
Explanation:
Question 8
A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.
What table type should be used?
  1. Permanent
  2. Transient
  3. Temporary
  4. External
Correct answer: D
Explanation:
Question 9
When does a materialized view get suspended in Snowflake?
  1. When a column is added to the base table
  2. When a column is dropped from the base table
  3. When a DML operation is run on the base table
  4. When the base table is reclustered
Correct answer: C
Explanation:
Question 10
Which function returns the URL of a stage using the stage name as the input?
  1. BUILD_STAGE_FILE_URL
  2. BUILD_SCOPED_FILE_URL
  3. GET_PRESIGNED_URL
  4. GET_STAGE_LOCATION
Correct answer: A
Explanation:
Question 11
What happens when a suspended virtual warehouse is resized in Snowflake?
  1. It will return an error.
  2. It will return a warning.
  3. The suspended warehouse is resumed and new compute resources are provisioned immediately.
  4. The additional compute resources are provisioned when the warehouse is resumed.
Correct answer: D
Explanation:
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!