Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 501:

  What type of NULL values are supported in semi-structured data? (Choose two.)

  A. Avro

  B. JSON

  C. ORC

  D. Parquet

  E. SQL

  Correct Answer: BE

• Question 502:

  What are characteristics of transient tables in Snowflake? (Choose two.)

  A. Transient tables have a Fail-safe period of 7 days.

  B. Transient tables can be cloned to permanent tables.

  C. Transient tables persist until they are explicitly dropped.

  D. Transient tables can be altered to make them permanent tables.

  E. Transient tables have Time Travel retention periods of 0 or 1 day.

  Correct Answer: CE

• Question 503:

  The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)

  A. Views for all the objects contained in the database

  B. Views for all the objects contained in the Snowflake account

  C. Views for historical and usage data across the Snowflake account

  D. Table functions for historical and usage data across the Snowflake account

  E. Table functions for account-level objects, such as roles, virtual warehouses, and databases

  Correct Answer: AD

• Question 504:

  What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?

  A. Reorder the rows in a relational table and then unload the rows into a file.

  B. Convert the rows in a relational table to a single VARIANT column and then unload the rows into a file.

  C. Reorder the data columns according to a target table definition and then unload the rows into the table.

  D. Convert the rows in a source file to a single VARIANT column and then load the rows from the file to a variant table.

  Correct Answer: B

• Question 505:

  Which function generates a Snowflake hosted file URL to a staged file using the stage name and relative file path as inputs?

  A. BUILD_STAGE_FILE_URL

  B. BUILD_SCOPED_FILE_URL

  C. GET_PRESIGNED_URL

  D. GET_STAGE_LOCATION

  Correct Answer: A

• Question 506:

  A user is unloading data to a stage using this command:

  copy into @message from (select object_construct('id', 1, 'first_name', 'Snowflake', 'last_name', 'User', 'city', 'Bozeman')) file_format = (type = json) What will the output file in the stage be?

  A. A single compressed JSON file with a single VARIANT column

  B. Multiple compressed JSON files with a single VARIANT column

  C. A single uncompressed JSON file with multiple VARIANT columns

  D. Multiple uncompressed JSON files with multiple VARIANT columns

  Correct Answer: A

• Question 507:

  A JSON file that contains lots of dates and arrays needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.

  How can this be achieved?

  A. Flatten the data and store it in structured data types in a flattened table. Query the table.

  B. Store the data in a table with a VARIANT data type. Query the table.

  C. Store the data in a table with a VARIANT data type and include STRIP_NULL_VALUES while loading the table. Query the table.

  D. Store the data in an external stage and create views on top of it. Query the views.

  Correct Answer: A

• Question 508:

  Which key governance feature in Snowflake allows users to identify data objects that contain sensitive data and their related objects?

  A. Object tagging

  B. Data classification

  C. Row access policy

  D. Column-level security

  Correct Answer: A

• Question 509:

  What can a Snowflake user do in the Admin area of Snow right?

  A. Analyze query performance.

  B. Write queries and execute them.

  C. Provide an overview of the listings in the Snowflake Marketplace.

  D. Connect to Snowflake partners to explore extended functionality.

  Correct Answer: D

• Question 510:

  When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

  A. There are multiple SQL UDFs with the same names and the same number of arguments.

  B. There are multiple SQL UDFs with the same names and the same number of argument types.

  C. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

  D. There are multiple SQL UDFs with different names but the same number of arguments or argument types.

  Correct Answer: C