Free COF-C02 Exam Braindumps
SnowPro Core Questions 576–580 (page: 117)

Updated On: 10-Feb-2026

What is the abbreviated form to get all the files in the stage for the current user?

  1. LIST @~;
  2. LS @~;
  3. LS @usr;
  4. SHOW @%;

Answer(s): B



Which features make up Snowflake's column level security? (Choose two.)

  1. Continuous Data Protection (CDP)
  2. Dynamic Data Masking
  3. External Tokenization
  4. Key pair authentication
  5. Row access policies

Answer(s): B,C



Which programming languages are supported for Snowflake User-Defined Functions (UDFs)? (Choose two.)

  1. C#
  2. JavaScript
  3. PHP
  4. Python
  5. TypeScript

Answer(s): B,D



What is the MAXIMUM number of days that Snowflake resets the 24-hour retention period for a query result every time the result is used?

  1. 1 day
  2. 10 days
  3. 31 days
  4. 60 days

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/querying-persisted-results.html#:~:text=Each%20time%20the%20persisted%20result,the%20query%20was%20first%20executed



There are 300 concurrent users on a production Snowflake account using a single cluster virtual warehouse. The queries are small, but the response time is very slow.

What is causing this to occur?

  1. The warehouse is queuing the queries, increasing the overall query execution time.
  2. The warehouse parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set too low.
  3. The application is not using the latest native ODBC driver which is causing latency.
  4. The queries are not taking advantage of the data cache.

Answer(s): A


Reference:

https://www.snowflake.com/blog/snowflake-challenge-concurrent-load-and-query/



Viewing page 117 of 221
Viewing questions 581 - 585 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!