support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Snowflake
  4. COF-C02

Free COF-C02 Exam Braindumps
SnowPro Core Questions 241–245 (page: 50)

Updated On: 10-Feb-2026
Page 50 of 221
PDF with 1300 Questions

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

  1. Snowflake leverages a Role-Based Access Control (RBAC) model. Most Voted
  2. Snowflake requires a user to configure an IAM user to connect to the database.
  3. All data in Snowflake is encrypted. Most Voted
  4. Snowflake can run within a user's own Virtual Private Cloud (VPC).
  5. All data in Snowflake is compressed.

Answer(s): A,C



A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

  1. 4 minutes
  2. 10 minutes
  3. 14 minutes Most Voted
  4. 24 minutes

Answer(s): C



What can be used to view warehouse usage over time? (Choose two.)

  1. The LOAD HISTORY view
  2. The query history view
  3. The SHOW WAREHOUSES command
  4. The WAREHOUSE_METERING_HISTORY view Most Voted
  5. The billing and usage tab in the Snowflake web UI Most Voted

Answer(s): D,E



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

  1. Removing a column from the query SELECT list
  2. Stopping the virtual warehouse that the query is running against
  3. Clustering of the data used by the query
  4. Executing the RESULTS_SCAN() table function
  5. Changing a column that is not in the cached query

Answer(s): A,C



Which statement is true about running tasks in Snowflake?

  1. A task can be called using a CALL statement to run a set of predefined SQL commands.
  2. A task allows a user to execute a single SQL statement/command using a predefined schedule.
  3. A task allows a user to execute a set of SQL commands on a predefined schedule.
  4. A task can be executed using a SELECT statement to run a predefined SQL command.

Answer(s): B



  PDF
Viewing page 50 of 221
Viewing questions 246 - 250 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!