COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:

<< First
Prev
1
2
3
4
5
6
7
8
9
10
Next
Last >>

Question # 25

A permanent table and temporary table have the same name, TBL1, in a schema.

What will happen if a user executes select * from TBL1 ;?

The temporary table will take precedence over the permanent table.

The permanent table will take precedence over the temporary table.

An error will say there cannot be two tables with the same name in a schema.

The table that was created most recently will take precedence over the older table.

Full Access

Question # 26

What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

The objects are dropped.

The objects enter the Fail-safe period.

The objects enter the Time Travel period.

The objects are immediately moved to the provider account.

Full Access

Question # 27

How is unstructured data retrieved from data storage?

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

Full Access

Question # 28

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Warehouses that are multi-cluster can have nodes of different sizes.

Warehouses can be started and stopped at any time.

Warehouses can be resized at any time, even while running.

Warehouses are billed on a per-minute usage basis.

Warehouses can only be used for querying and cannot be used for data loading.

Full Access

Question # 29

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

Column compression

Data clustering

Micro-partitioning

Metadata management

Full Access

Question # 30

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

It removes null values from all columns in the data.

It converts null values to empty strings during loading.

It skips rows with null values during the loading process.

It removes object or array elements containing null values.

Full Access

Question # 31

What factors impact storage costs in Snowflake? (Select TWO).

The account type

The storage file format

The cloud region used by the account

The type of data being stored

The cloud platform being used

Full Access

Question # 32

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

File URL

Scoped URL

Relative URL

Pre-Signed URL

Full Access