Free COF-C02 Exam Braindumps
SnowPro Core Questions 386–390 (page: 79)

Updated On: 10-Feb-2026

How long is Snowpipe data load history retained?

  1. As configured in the CREATE PIPE settings
  2. Until the pipe is dropped
  3. 64 days
  4. 14 days

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%20data%20load&text=Stored%20in%20the%20metadata%20of%20the%20pipe%20for%2014%20days



A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

  1. Okta Verify
  2. Duo Mobile
  3. Microsoft Authenticator
  4. Google Authenticator

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/ui-preferences.html#:~:text=Enrolling%20in%20MFA%20(Multi%2DFactor%20Authentication),-MFA%20is%20a&text=This%20second%20form%20of%20authentication,enabled%20for%20individual%20Snowflake%20users



Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

  1. Pre-signed URL
  2. Scoped URL
  3. Signed URL
  4. File URL

Answer(s): A



Where would a Snowflake user find information about query activity from 90 days ago?

  1. account_usage.query_history view
  2. account_usage.query_history_archive view
  3. information_schema.query_history view
  4. information_schema.query_history_by_session view

Answer(s): A



A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called MKTG_WH.

Which of the following statements will accommodate this request?

  1. ALLOW RESIZE ON WAREHOUSE MKTG_WH TO USER MKTG_LEAD;
  2. GRANT MODIFY ON WAREHOUSE MKTG_WH TO ROLE MARKETING;
  3. GRANT MODIFY ON WAREHOUSE MKTG_WH TO USER MKTG_LEAD;
  4. GRANT OPERATE ON WAREHOUSE MKTG_WH TO ROLE MARKET;

Answer(s): B



Viewing page 79 of 221
Viewing questions 391 - 395 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!