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 481–485 (page: 98)

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

Which parameter prevents streams on tables from becoming stale?

  1. MAX_DATA_EXTENSION_TIME_IN_DAYS
  2. MIN_DATA_RETENSION_TIME_IN_DAYS
  3. LOCK_TIMEOUT
  4. STALE_AFTER

Answer(s): A



If a virtual warehouse runs for 30 seconds after it is provisioned, how many seconds will the customer be billed for?

  1. 30 seconds
  2. 60 seconds
  3. 121 seconds
  4. 1 hour

Answer(s): B



When should a stored procedure be created with caller's rights?

  1. When the caller needs to be prevented from viewing the source code of the stored procedure
  2. When the caller needs to run a statement that could not execute outside of the stored procedure
  3. When the stored procedure needs to run with the privileges of the role that called the stored procedure
  4. When the stored procedure needs to operate on objects that the caller does not have privileges on

Answer(s): C



What JavaScript delimiters are available in Snowflake stored procedures? (Choose two.)

  1. Double quotes (“)
  2. Single quote (’)
  3. Double forward slash (//)
  4. Double backslash (\\)
  5. Double dollar sign ($$)

Answer(s): B,E



What type of function can be used to estimate the approximate number of distinct values from a table that has trillions of rows?

  1. MD5
  2. Window
  3. External
  4. HyperLogLog (HLL)

Answer(s): D



  PDF
Viewing page 98 of 221
Viewing questions 486 - 490 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!