Snowflake COF-C02 Exam Questions
SnowPro Core (Page 27 )

Updated On: 17-Feb-2026

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

  1. True
  2. False

Answer(s): B


Reference:

https://www.mobilize.net/blog/overcoming-the-filesize-limit-when-importing-data-into-snowflake



True or False: A Virtual Warehouse can be resized while suspended.

  1. True
  2. False

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse



True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

  1. True
  2. False

Answer(s): B


Reference:

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



Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?

  1. Account -> Schema -> Database -> Table
  2. Account -> Database -> Schema -> Table
  3. Database -> Schema -> Table -> Account
  4. Database -> Table -> Schema -> Account

Answer(s): B


Reference:

https://docs.snowflake.com/en/sql-reference/ddl-database.html



True or False: All Snowflake table types include fail-safe storage.

  1. True
  2. False

Answer(s): B






Post your Comments and Discuss Snowflake COF-C02 exam dumps with other Community members:

Join the COF-C02 Discussion