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 546–550 (page: 111)

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

Snowflake strongly recommends that all users with what type of role be required to use Multi-Factor Authentication (MFA)?

  1. USERADMIN
  2. ACCOUNTADMIN
  3. SECURITYADMIN
  4. SYSADMIN

Answer(s): B



What does it mean when the sample function uses the Bernoulli sampling method?

  1. The data is based on sampling every row.
  2. The data is based on sampling 10% of the source data.
  3. The data is based on sampling blocks of the source data.
  4. The data is based on sampling 1000 rows of the source data.

Answer(s): A



What are characteristics of Snowflake network policies? (Choose two.)

  1. They can be set for any Snowflake Edition
  2. They can be applied to roles.
  3. They restrict or enable access to specific IP addresses.
  4. They are activated using ALTER DATABASE SQL commands.
  5. They can only be managed using the ORGADMIN role.

Answer(s): A,C



Which function should be used to find the query ID of the second query executed in a current session?

  1. Select LAST_QUERY_ID(-2)
  2. Select LAST_QUERY_ID(-1)
  3. Select LAST_QUERY_ID(1)
  4. Select LAST_QUERY_ID(2)

Answer(s): D



How is the hierarchy of database objects organized in Snowflake?

  1. A database consists of one or more schemas. A schema contains tables and views.
  2. A schema consists of one or more databases. A database contains tables and views.
  3. A schema consists of one or more databases. A database contains tables, views, and warehouses.
  4. A database consists of one of more schemas and warehouses. A schema contains tables and views.

Answer(s): A



  PDF
Viewing page 111 of 221
Viewing questions 551 - 555 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!