Free COF-C02 Exam Braindumps
SnowPro Core Questions 411–415 (page: 84)

Updated On: 10-Feb-2026

What happens to historical data when the retention period for an object ends?

  1. The data is cloned into a historical object.
  2. The data moves to Fail-safe
  3. Time Travel on the historical data is dropped.
  4. The object containing the historical data is dropped.

Answer(s): B



A company’s security audit requires generating a report listing all Snowflake logins (e.g., date and user) within the last 90 days.

Which of the following statements will return the required information?


  1. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
    FROM ACCOUNT_USAGE.USERS;

  2. SELECT EVENT_TIMESTAMP, USER_NAME
    FROM table(information_schema.login_history_by_user())

  3. SELECT EVENT_TIMESTAMP, USER_NAME
    FROM ACCOUNT_USAGE.ACCESS_HISTORY;

  4. SELECT EVENT_TIMESTAMP, USER_NAME
    FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Answer(s): D



What are common issues found by using the Query Profile? (Choose two.)

  1. Identifying queries that will likely run very slowly before executing them
  2. Locating queries that consume a high amount of credits
  3. Identifying logical issues with the queries
  4. Identifying inefficient micro-partition pruning
  5. Data spilling to a local or remote disk

Answer(s): D,E



The Snowflake Search Optimization Services supports improved performance of which kind of query?

  1. Queries against large tables where frequent DML occurs
  2. Queries against tables larger than 1 TB
  3. Selective point lookup queries
  4. Queries against a subset of columns in a table

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimization%20service%20can%20improve%20the%20performance%20of%20point,OBJECT%2C%20and%20ARRAY%20columns)



Which file formats are supported for unloading data from Snowflake? (Choose two.)

  1. Avro
  2. JSON
  3. ORC
  4. XML
  5. Delimited (CSV, TSV, etc.)

Answer(s): B,E



Viewing page 84 of 221
Viewing questions 416 - 420 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!