Free COF-C02 Exam Braindumps
SnowPro Core Questions 561–565 (page: 114)

Updated On: 10-Feb-2026

Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?

  1. Temporary
  2. Local
  3. User
  4. Transient

Answer(s): A



What is a characteristic of a role in Snowflake?

  1. Roles cannot be granted to other roles.
  2. System-defined roles can be dropped.
  3. Privileges granted to system roles by Snowflake can be revoked.
  4. Privileges on securable objects can be granted and revoked to a role.

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/security-access-control-overview.html#:~:text=Roles%20are%20assigned%20to%20users,using%20separate%20sets%20of%20privileges



What command would a user execute to load unstructured data files into a Snowflake internal stage?

  1. PUT
  2. GET
  3. LIST
  4. COPY INFO

Answer(s): A



How do managed access schemas help with data governance?

  1. They log all operations and enable fine-grained auditing.
  2. They provide centralized privilege management with the schema owner.
  3. They enforce identical privileges across all tables and views in a schema.
  4. They require the use of masking and row access policies across every table and view in the schema.

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/security-access-control-configure.html



What is the default period of time the Warehouse Activity section provides a graph of Snowsight activity?

  1. 2 hours
  2. 1 week
  3. 2 weeks
  4. 1 month

Answer(s): C



Viewing page 114 of 221
Viewing questions 566 - 570 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!