COF-C02 VCE Exam Download

SnowPro Core Certification Exam Questions and Answers

Question 49

Which objects together comprise a namespace in Snowflake? (Select TWO).

Account

Database

Schema

Table

Virtual warehouse

Question 50

How does a scoped URL expire?

When the data cache clears.

When the persisted query result period ends.

The encoded URL access is permanent.

The length of time is specified in the expiration_time argument.

Question 51

Which statement describes pruning?

The filtering or disregarding of micro-partitions that are not needed to return a query.

The return of micro-partitions values that overlap with each other to reduce a query's runtime.

A service that is handled by the Snowflake Cloud Services layer to optimize caching.

The ability to allow the result of a query to be accessed as if it were a table.

Question 52

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

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

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

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

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