Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1631:

  The property MINS_TO_BYPASS_NETWORK_POLICY is set at which level?

  A. User
  B. Role
  C. Account
  D. Organization
  A. User

  ---

  Explanation

• Question 1632:

  What are characteristics of Snowflake network policies? (Choose two.)

  A. They can be set for any Snowflake Edition
  B. They can be applied to roles.
  C. They restrict or enable access to specific IP addresses.
  D. They are activated using ALTER DATABASE SQL commands.
  E. They can only be managed using the ORGADMIN role.
  A. They can be set for any Snowflake Edition
  C. They restrict or enable access to specific IP addresses.

  ---

  Explanation

• Question 1633:

  How can staged files be removed during data loading once the files have loaded successfully?

  A. Use the DROP command.
  B. Use the PURGE copy option.
  C. Use the FORCE = TRUE parameter.
  D. Use the LOAD_UNCERTAIN_FILES copy option.
  B. Use the PURGE copy option.

  ---

  Explanation

• Question 1634:

  A complex SQL query involving eight tables with joins is taking a while to execute. The Query Profile shows that all partitions are being scanned.

  What is causing the query performance issue?

  A. Pruning is not being performed efficiently.
  B. A huge volume of data is being fetched, with many joins applied.
  C. Incorrect joins are being used, leading to scanning and pulling too many records.
  D. The columns in the micro-partitions need granular ordering based on the dataset.
  A. Pruning is not being performed efficiently.

  ---

  Explanation

• Question 1635:

  The is the minimum Fail-safe retention time period for transient tables?

  A. 1 day
  B. 7 days
  C. 12 hours
  D. 0 days
  D. 0 days

  ---

  Explanation

• Question 1636:

  What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

  A. VIEWS_HISTORY
  B. OBJECT_HISTORY
  C. ACCESS_HISTORY
  D. LOGIN_HISTORY
  C. ACCESS_HISTORY

  ---

  Explanation

• Question 1637:

  Which command will indicate whether a materialized view is being used in a query?

  A. SHOW
  B. DESCRIBE
  C. EXPLAIN
  D. USE
  C. EXPLAIN

  ---

  Explanation

• Question 1638:

  What does Snowflake recommend when con guring the auto-suspend parameter for a virtual warehouse?

  A. Set auto-suspend to the maximum possible duration for optimal resource utilization.
  B. Enable auto-suspend to a high value to maximize warehouse availability.
  C. Enable auto-suspend to a low value to minimize credit consumption during inactivity.
  D. Disable auto-suspend to ensure continuous availability of the warehouse.
  C. Enable auto-suspend to a low value to minimize credit consumption during inactivity.

  ---

  Explanation

• Question 1639:

  In the Data Exchange, who can get or request data from the listings? (Choose two.)

  A. Users with ACCOUNTADMIN role
  B. Users with SYSADMIN role
  C. Users with ORGADMIN role
  D. Users with IMPORT SHARE privilege
  E. Users with MANAGE GRANTS privilege
  A. Users with ACCOUNTADMIN role
  D. Users with IMPORT SHARE privilege

  ---

  Explanation

• Question 1640:

  If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

  A. Table definition
  B. Stage definition
  C. Session level
  D. COPY INTO TABLE statement
  D. COPY INTO TABLE statement

  ---

  Explanation