Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 481:

  A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

  How can this be accomplished?

  A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
  B. The transient table version cannot be retrieved after 24 hours.
  C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
  D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
  B. The transient table version cannot be retrieved after 24 hours.

  ---

  Explanation

• Question 482:

  Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?

  A. Only while in the ACCOUNTADMIN role
  B. Only while in the SECURITYADMIN role
  C. Only the role with the OWNERSHIP privilege on the network policy
  D. Only Snowflake Support can set the value for this object property
  D. Only Snowflake Support can set the value for this object property

  ---

  Explanation

• Question 483:

  How long is Snowpipe data load history retained?

  A. As configured in the create pipe settings
  B. Until the pipe is dropped
  C. 64 days
  D. 14 days
  D. 14 days

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/functions/pipe_usage_history.html

• Question 484:

  What operation can be performed using Time Travel?

  A. Restoring tables that have been dropped from a data share
  B. Extending a permanent table's retention duration from 90 to 100 days
  C. Creating a clone of an entire table at a specific point in the past from a permanent table
  D. Disabling Time Travel for a specific object by setting DATA_RETENTION_TIME_IN_DAYS to NULL
  C. Creating a clone of an entire table at a specific point in the past from a permanent table

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-time-travel

• Question 485:

  What tasks can an account administrator perform in the Data Exchange? (Choose two.)

  A. Add and remove members.
  B. Delete data categories.
  C. Approve and deny listing approval requests.
  D. Transfer listing ownership.
  E. Transfer ownership of a provider profile.
  A. Add and remove members.
  C. Approve and deny listing approval requests.

  ---

  Explanation

  By default, only an account administrator (a user with the ACCOUNTADMIN role) in the Data Exchange administrator account can manage a Data Exchange, which includes the following tasks: Add or remove members. Approve or deny listing approval requests. Approve or deny provider profile approval requests. https://docs.snowflake.com/en/user-guide/data-exchange-marketplace-privileges

• Question 486:

  Which function, when combined with a COPY INTO command, will convert the rows in a relational table to a single VARIANT column while the rows are being unloaded?

  A. ARRAY_AGG
  B. OBJECT_CONSTRUCT
  C. TO_VARIANT
  D. OBJECT_AGG
  C. TO_VARIANT

  ---

  Explanation

• Question 487:

  A network policy set at which level will override all other network policies?

  A. Account
  B. User
  C. Security integration
  D. Database
  B. User

  ---

  Explanation

• Question 488:

  What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO

  command when loading data from a JSON file into a table?
  A. It flattens multiple arrays into a single array.
  B. It removes the outer array structure and loads separate rows of data.
  C. It transforms a pivoted table into an array.
  D. It tokenizes each data string using the defined delimiters.
  B. It removes the outer array structure and loads separate rows of data.

  ---

  Explanation

  Question 489:

  What is a characteristic of materialized views in Snowflake?

  A. Materialized views do not allow joins.
  B. Clones of materialized views can be created directly by the user.
  C. Multiple tables can be joined in the underlying query of a materialized view.
  D. Aggregate functions can be used as window functions in materialized views.

  A. Materialized views do not allow joins.

  ---

  Explanation

  Question 490:

  Which feature is supported in column-level security in Snow ake?

  A. Object tagging
  B. Data classi cation
  C. External tokenization
  D. Tag-based masking policies

  D. Tag-based masking policies

  ---

  Explanation
  • 1
  • 2
  • ...
  • 48
  • 49
  • 50
  • 51
  • ...
  • 169
  • 170
  Related Exams:

  • ADA-C01

    SnowPro Advanced: Administrator Certification (ADA-C01)

  • ARA-C01

    SnowPro Advanced: Architect Certification (ARA-C01)

  • COF-C02

    SnowPro Core Certification (COF-C02)

  • COF-R02

    SnowPro Core Recertification (COF-R02)

  • DAA-C01

    SnowPro Advanced: Data Analyst (DAA-C01)

  • DSA-C02

    SnowPro Advanced: Data Scientist Certification (DSA-C02)

  • SOL-C01

    SnowPro Associate: Platform Certification
  Tips on How to Prepare for the Exams

  Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.