Weekend Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 169

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

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.

Full Access
Question # 170

What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

A.

A VARIANT column

B.

A column with very low cardinality

C.

A column with very high cardinality

D.

A column that is most actively used in selective filters

E.

A column that is most actively used in join predicates

Full Access
Question # 171

What internal stages are available in Snowflake? (Choose three.)

A.

Schema stage

B.

Named stage

C.

User stage

D.

Stream stage

E.

Table stage

F.

Database stage

Full Access
Question # 172

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

A.

When users will be using compute at different times throughout a 24/7 period

B.

When managing a steady workload

C.

When the compute must be available with no delay or lag time

D.

When the user does not want to have to manually turn on the warehouse each time it is needed

E.

When the warehouse is shared across different teams

Full Access
Question # 173

What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

A.

READ

B.

OWNERSHIP

C.

USAGK

D.

WRTTF

Full Access
Question # 174

If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

A.

Auto-scale mode

B.

Maximized mode

C.

Economy scaling policy

D.

Standard scaling policy

Full Access
Question # 175

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?

A.

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

B.

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.

C.

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.

D.

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 # 176

Which of the following statements describes a schema in Snowflake?

A.

A logical grouping of objects that belongs to a single database

B.

A logical grouping of objects that belongs to multiple databases

C.

A named Snowflake object that includes all the information required to share a database

D.

A uniquely identified Snowflake account within a business entity

Full Access
Go to page: