Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 401:

  What is the recommended way to change the existing file format type in my_format from CSV to JSON?

  A. ALTER FILE FORMAT my_format SET TYPE=JSON;

  B. ALTER FILE FORMAT my_format SWAP TYPE WITH JSON;

  C. CREATE OR REPLACE FILE FORMAT my_format TYPE=JSON;

  D. REPLACE FILE FORMAT my_format TYPE=JSON;

  Correct Answer: C

  ALTER FILE FORMAT does not support the following actions:

  -Changing the type (CSV, JSON, etc.) for the file format. To make any of these changes, you must recreate the file format.

• Question 402:

  In which Snowsight section can a user switch roles, modify their profile, and access documentation?

  A. The user menu

  B. The activity page

  C. The content pane

  D. The worksheets page

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour#user-menu

• Question 403:

  What does the Activity area of Snowsight allow users to do? (Choose two.)

  A. Schedule automated data backups.

  B. Explore each step of an executed query.

  C. Monitor queries executed by users in an account.

  D. Create and manage user roles and permissions.

  E. Access Snowflake Marketplace to find and integrate datasets.

  Correct Answer: BC

  The keyword is activity area!

  The Activity area of Snowsight, the Snowflake web interface, lets you:

  1)Monitor queries executed by users in your account.

  2)View details about queries.

  3)View performance data.

  4)Explore each step of an executed query.

  5)Monitor the status of data loading using COPY INTO (bulk loading) and pipes (continuous loading).

  6)View details about instances of bulk and continuous data loading.

  7)Navigate to the copy history for individual tables.

  https://docs.snowflake.com/en/user-guide/ui-snowsight-activity

• Question 404:

  The COPY INTO command can unload data from a table directly into which locations? (Choose two.)

  A. A named internal stage

  B. A Snowpipe REST endpoint

  C. A network share on a client machine

  D. A local directory or folder on a client machine

  E. A named external stage that references an external cloud location

  Correct Answer: AE

  Copy into is possible for 1) Named internal stage (or table/user stage). 2) Named external stage that references an external location (Amazon S3, Google Cloud Storage, or Microsoft Azure). 3) External location https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

• Question 405:

  Which activities are managed by Snowflake's Cloud Services layer? (Choose two.)

  A. Authentication

  B. Access delegation

  C. Data pruning

  D. Data compression

  E. Query parsing and optimization

  Correct Answer: AE

• Question 406:

  Why should a Snowflake user configure a secure view? (Choose two.)

  A. To encrypt the data in transit

  B. To execute faster than a standard view

  C. To protect hidden data from other users

  D. To improve the performance of a query

  E. To hide the view definition from other users

  Correct Answer: CE

  Some of the internal optimizations for views require access to the underlying data in the base tables for the view. This access might allow data that is hidden from users of the view to be exposed through user code, such as user-defined functions, or other programmatic methods. Secure views do not utilize these optimizations, ensuring that users have no access to the underlying data.

  For security or privacy reasons, you might not wish to expose the underlying tables or internal structural details for a view. With secure views, the view definition and details are visible only to authorized users (i.e. users who are granted the role that owns the view).

• Question 407:

  Which applications can use key pair authentication? (Choose two).

  A. Snowflake Marketplace

  B. SnowCD

  C. Snowsight

  D. SnowSQL

  E. Snowflake connector for Python

  Correct Answer: DE

  https://docs.snowflake.com/en/user-guide/key-pair-auth

• Question 408:

  What are characteristics of reader accounts in Snowflake? (Choose two.)

  A. Reader account users cannot add new data to the account.

  B. Reader account users can share data to other reader accounts.

  C. A single reader account can consume data from multiple provider accounts.

  D. Data consumers are responsible for reader account setup and data usage costs.

  E. Reader accounts enable data consumers to access and query data shared by the provider.

  Correct Answer: AE

  Reader account belongs to the provider account who created it, it cannot consume data from multiple provider account

• Question 409:

  A Snowflake user wants to share unstructured data through the use of secure views.

  Which URL types can be used? (Choose two.)

  A. Scoped URL

  B. HTTPS URL

  C. Cloud storage URL

  D. File URL

  E. Pre-signed URL

  Correct Answer: AE

  https://docs.snowflake.com/en/user-guide/unstructured-data-sharing

• Question 410:

  What are the recommended steps to address poor SQL query performance due to data spilling? (Choose two.)

  A. Clone the base table.

  B. Fetch required attributes only.

  C. Use a larger virtual warehouse.

  D. Process the data in smaller batches.

  E. Add another cluster in the virtual warehouse.

  Correct Answer: BC