Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1561:

  Which query types will have significant performance improvement when run using the search optimization service? (Choose two.)

  A. Range searches
  B. Equality searches
  C. Substring searches
  D. Queries with IN predicates
  E. Queries with aggregation
  B. Equality searches
  D. Queries with IN predicates

  ---

  Explanation

• Question 1562:

  At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?

  A. Account
  B. Database
  C. Schema
  D. Table
  A. Account

  ---

  Explanation

• Question 1563:

  When a schema is cloned what happens to the tags that reside in that schema or database?

  A. The tags are deleted and must be redefined in the target schema.
  B. The tags remain in the source schema unchanged.
  C. The tags become temporarily inactive until they are manually reactivated.
  D. The tags are automatically cloned with the schema, maintaining all associations.
  D. The tags are automatically cloned with the schema, maintaining all associations.

  ---

  Explanation

• Question 1564:

  What happens when a suspended virtual warehouse is resized in Snowflake?

  A. It will return an error.
  B. It will return a warning.
  C. The suspended warehouse is resumed and new compute resources are provisioned immediately.
  D. The additional compute resources are provisioned when the warehouse is resumed.
  D. The additional compute resources are provisioned when the warehouse is resumed.

  ---

  Explanation

• Question 1565:

  Which file functions are non-deterministic? (Choose two.)

  A. BUILD_SCOPED_FILE_URL
  B. BUILD_STAGE_FILE_URL
  C. GET_ABSOLUTE_PATH
  D. GET_PRESIGNED_URL
  E. GET_RELATIVE_PATH
  A. BUILD_SCOPED_FILE_URL
  D. GET_PRESIGNED_URL

  ---

  Explanation

• Question 1566:

  What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

  A. Duo Security
  B. OAuth
  C. Okta
  D. Single Sign-On (SSO)
  A. Duo Security

  ---

  Explanation

  MFA provides increased login security for users connecting to Snowflake. MFA support is provided as an integrated Snowflake feature, powered by the Duo Security service, which is managed completely by Snowflake. https://docs.snowflake.com/en/user-guide/ui-snowsight-profile

• Question 1567:

  Which of the following commands are not blocking operations? (Choose two)

  A. UPDATE
  B. INSERT
  C. MERGE
  D. COPY
  B. INSERT
  D. COPY

  ---

  Explanation

• Question 1568:

  Which Snowflake tool provides detailed execution statistics of a query with no cost to the user?

  A. Query Profile
  B. Query history
  C. Visualization chart
  D. Query acceleration service
  A. Query Profile

  ---

  Explanation

• Question 1569:

  Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).

  A. Authorisation
  B. Access delegation
  C. Data pruning
  D. Data compression
  E. Query parsing and optimization
  A. Authorisation
  E. Query parsing and optimization

  ---

  Explanation

  Snowflake's Cloud Services layer is responsible for managing various aspects of the platform that are not directly related to computing or storage. Specifically, it handles authorisation, ensuring that users have appropriate access rights to perform actions or access data. Additionally, it takes care of query parsing and optimization, interpreting SQL queries and optimizing their execution plans for better performance. This layer abstracts much of the platform's complexity, allowing users to focus on their data and queries without managing the underlying infrastructure.

  References: Snowflake Architecture Documentation

• Question 1570:

  What is SnowSQL?

  A. Snowflake's new user interface where users can visualize data into charts and dashboards.
  B. Snowflake's proprietary extension of the ANSI SQL standard, including built-in keywords and system functions.
  C. Snowflake's command line client built on the Python connector which is used to connect to Snowflake and execute SQL.
  D. Snowflake's library that provides a programming interface for processing data on Snowflake without moving it to the system where the application code runs.
  C. Snowflake's command line client built on the Python connector which is used to connect to Snowflake and execute SQL.

  ---

  Explanation