Winter Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

SnowPro Core Certification COF-C02 Dumps PDF

Page: 4 / 52
Total 693 questions

SnowPro Core Certification Exam Questions and Answers

Question 13

Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?

Options:

A.

Directory table

B.

Temporary table

C.

Transient table

D.

A table with a materialized view

Question 14

What activities can a user with the ORGADMIN role perform? (Select TWO).

Options:

A.

Create information_schema in a database

B.

View usage information for all accounts in the organization.

C.

Enable database cloning for an account in the organization.

D.

Enable database replication for an account in the organization.

E.

View micro-partition information for all accounts in the organization.

Question 15

Authorization to execute CREATE statements comes only from which role?

Options:

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

Question 16

Given the statement template below, which database objects can be added to a share?(Select TWO).

GRANT ON To SHARE ;

Options:

A.

Secure functions

B.

Stored procedures

C.

Streams

D.

Tables

E.

Tasks

Page: 4 / 52
Total 693 questions