Free COF-C02 Exam Braindumps
SnowPro Core Questions 461–465 (page: 94)

Updated On: 10-Feb-2026

As a best practice, all custom roles should be granted to which system-defined role?

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

Answer(s): D



Which Snowflake object can be accessed in the FROM clause of a query, returning a set of rows having one or more columns?

  1. A User-Defined Table Function (UDTF)
  2. A Scalar User Defined Function (UDF)
  3. A stored procedure
  4. A task

Answer(s): A



How are micro-partitions typically generated in Snowflake?

  1. Automatically
  2. ORDER BY <>;
  3. PARTITION BY <>;
  4. GROUP BY <>;

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html#:~:text=In%20contrast%20to%20traditional%20static,front%20or%20maintained%20by%20users



What does Snowflake recommend regarding database object ownership? (Choose two.)

  1. Create objects with ACCOUNTADMIN and do not reassign ownership.
  2. Create objects with SYSADMIN.
  3. Create objects with SECURITYADMIN to ease granting of privileges later.
  4. Create objects with a custom role and grant this role to SYSADMIN.
  5. Use only managed access schemas for objects owned by ACCOUNTADMIN.

Answer(s): B,D



Other than ownership what privileges does a user need to view and modify resource monitors in Snowflake? (Choose two.)

  1. ALTER
  2. MONITOR
  3. MODIFY
  4. CREATE
  5. DROP

Answer(s): B,C


Reference:

https://docs.snowflake.com/en/user-guide/resource-monitors.html#:~:text=Only%20account%20administrators%20(users%20with,MODIFY%20privilege%20on%20each%20warehouse



Viewing page 94 of 221
Viewing questions 466 - 470 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!