CertsTopics Logo

Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

SnowPro Core Certification COF-C02 Reddit Questions

Page: 12 / 52
Total 693 questions
Get COF-C02 Full Access Download COF-C02 PDF

SnowPro Core Certification Exam Questions and Answers

Question 45

What is a responsibility of Snowflake’s virtual warehouses?

Options:

A.

Infrastructure management

B.

Metadata management

C.

Query execution

D.

Query parsing and optimization

E.

Permanent storage of micro-partitions

Question 46

Which stream type can be used for tracking the records in external tables?

Options:

A.

Append-only

B.

External

C.

Insert-only

D.

Standard

Question 47

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

Options:

A.

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

B.

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

C.

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;

D.

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Question 48

Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?

Options:

A.

A User-Defined Table Function (UDTF)

B.

A Scalar User Function (UDF)

C.

A stored procedure

D.

A task

Page: 12 / 52
Total 693 questions
Get COF-C02 Full Access Download COF-C02 PDF