Free COF-C02 Exam Braindumps
SnowPro Core Questions 401–405 (page: 82)

Updated On: 10-Feb-2026

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

  1. Roles
  2. Databases
  3. Warehouses
  4. Users
  5. Accounts

Answer(s): D,E



Where is Snowflake metadata stored?

  1. Within the data files
  2. In the virtual warehouse layer
  3. In the cloud services layer
  4. In the remote storage layer

Answer(s): C



What columns are returned when performing a FLATTEN command on semi-structured data? (Choose two.)

  1. KEY
  2. NODE
  3. VALUE
  4. LEVEL
  5. ROOT

Answer(s): A,C



Which of the following Snowflake features provide continuous data protection automatically? (Choose two.)

  1. Internal stages
  2. Incremental backups
  3. Time Travel
  4. Zero-copy clones
  5. Fail-safe

Answer(s): C,E



A developer is granted ownership of a table that has a masking policy. The developer’s role is not able to see the masked data.

Will the developer be able to modify the table to read the masked data?

  1. Yes, because a table owner has full control and can unset masking policies.
  2. Yes, because masking policies only apply to cloned tables.
  3. No, because masking policies must always reference specific access roles.
  4. No, because ownership of a table does not include the ability to change masking policies.

Answer(s): D



Viewing page 82 of 221
Viewing questions 406 - 410 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!