Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 621:

  Which Snowflake command can be used to unload the result of a query to a single file?

  A. Use COPY INTO followed by a GET command to download the file.
  B. Use COPY INTO followed by a PUT command to download the file.
  C. Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.
  D. Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.
  C. Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.

  ---

  Explanation

• Question 622:

  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?

  A. Okta Verify
  B. Duo Mobile
  C. Microsoft Authenticator
  D. Google Authenticator
  B. Duo Mobile

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-mfa.html

• Question 623:

  What is Snowflake's general guideline for files used to load data?

  A. Files can be loaded directly into a table.
  B. Any delimiter is supported: the default is a semicolon.
  C. Electronic Data Interchange (EDI) is one of the supported semi-structured formats.
  D. For delimited files, the default character set is UTF-8.
  D. For delimited files, the default character set is UTF-8.

  ---

  Explanation

• Question 624:

  When do Snowflake object owners lose their ability to make grant decisions?

  A. When the object owner has been granted a database role
  B. When the object owner has been granted an account role
  C. When the object is part of a managed access schema
  D. When the object is part of a regular schema
  C. When the object is part of a managed access schema

  ---

  Explanation

  In a managed access schema, only the schema owner can manage privileges. Object owners lose their ability to make grant decisions because access control is centrally managed at the schema level.

  This is useful for enforcing strict governance policies.

  References:

  Snowflake Documentation: Managed Access Schemas

  Snowflake Best Practices for Object Ownership

• Question 625:

  What command is used to download data from a Snowflake stage?

  A. PUT
  B. INSERT
  C. GET
  D. COPY
  C. GET

  ---

  Explanation

• Question 626:

  Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?

  A. GET
  B. PUT
  C. CREATE STREAM
  D. COPY INTO
  B. PUT

  ---

  Explanation

• Question 627:

  Which query type is supported for implementing the search optimization service?

  A. Queries with column concatenation
  B. Substring search queries on external tables
  C. String searches on columns using the COLLATE function
  D. Geography value column searches using geospatial functions
  D. Geography value column searches using geospatial functions

  ---

  Explanation

• Question 628:

  Which of the following describes external functions in Snowflake?

  A. They are a type of User-defined Function (UDF).
  B. They contain their own SQL code.
  C. They call code that is stored inside of Snowflake.
  D. They can return multiple rows for each row received
  A. They are a type of User-defined Function (UDF).

  ---

  Explanation

  External functions are user-defined functions that are stored and executed outside of Snowflake. External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your data pipelines.

  https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside% 20of%20Snowflake.

• Question 629:

  Which data type is supported by Snowflake data classification?

  A. Binary
  B. Float
  C. Geography
  D. Variant
  B. Float

  ---

  Explanation

• Question 630:

  What does a Query Profile provide in Snowflake?

  A. A multi-step query that displays each processing step in the same panel.
  B. A pre-computed data set derived from a query specification and stored for later use.
  C. A graphical representation of the main components of the processing plan for a query.
  D. A collapsible panel in the operator tree pane that lists nodes by execution time in descending order for a query.
  C. A graphical representation of the main components of the processing plan for a query.

  ---

  Explanation