Free COF-C02 Exam Braindumps
SnowPro Core Questions 266–270 (page: 55)

Updated On: 10-Feb-2026

What is the default Time Travel retention period?

  1. 1 day
  2. 7 days
  3. 45 days
  4. 90 days

Answer(s): A



Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Choose two.)

  1. Load files that are approximately 25 MB or smaller.
  2. Remove all dates and timestamps.
  3. Load files that are approximately 100-250 MB (or larger).
  4. Avoid using embedded characters such as commas for numeric data types.
  5. Remove semi-structured data types.

Answer(s): C,D



Which schema has the RESOURCE_MONITORS view?

  1. ACCOUNT_USAGE
  2. READER_ACCOUNT_USAGE
  3. INFORMATION_SCHEMA
  4. WAREHOUSE_USAGE_SCHEMA

Answer(s): B



What is the purpose of enabling Federated Authentication on a Snowflake account?

  1. Disables the ability to use key pair and basic authentication (e.g., username/password) when connecting
  2. Allows dual Multi-Factor Authentication (MFA) when connecting to Snowflake
  3. Forces users to connect through a secure network proxy
  4. Allows users to connect using secure single sign-on (SSO) through an external identity provider

Answer(s): D



Which Snowflake partner category is represented at the top of this diagram (labeled 1)?

  1. Business Intelligence
  2. Machine Learning and Data Science
  3. Security and Governance
  4. Data Integration

Answer(s): D



Viewing page 55 of 221
Viewing questions 271 - 275 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!