COF-R02 Exam Dumps - SnowPro Core Recertification Exam

Go to page:

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

Question # 25

How a Snowpipe charges calculated?

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

Full Access

Question # 26

What is the MOST performant file format for loading data in Snowflake?

CSV (Unzipped)

Parquet

CSV (Gzipped)

ORC

Full Access

Question # 27

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

The tables are now orphaned

The user that deleted the role

SYSADMIN

The assumed role that dropped the role

Full Access

Question # 28

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True

False

Full Access

Question # 29

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

True

False

Full Access

Question # 30

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

Authentication

Resource management

Virtual warehouse caching

Query parsing and optimization

Query execution

Physical storage of micro-partitions

Full Access

Question # 31

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Full Access

Question # 32

Which data type can store more than one type of data structure?

JSON

BINARY

VARCHAR

VARIANT

Full Access

Go to page: