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

SnowPro Core Certification Changed COF-C02 Questions

Page: 30 / 62
Total 820 questions

SnowPro Core Certification Exam Questions and Answers

Question 117

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

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

Options:

A.

The temporary table will take precedence over the permanent table.

B.

The permanent table will take precedence over the temporary table.

C.

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

D.

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

Question 118

What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'

Options:

A.

Views

B.

Materialized views

C.

Tables

D.

External tables

E.

Future grants

Question 119

Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?

Options:

A.

Automatic clustering

B.

Materialized views

C.

Query acceleration service

D.

Search optimization service

Question 120

While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

Options:

A.

GET_PRESIGNED_URL

B.

GET_ABSOLUTE_PATH

C.

BUILD_STAGE_FILE_URL

D.

BUILD SCOPED FILE URL

Page: 30 / 62
Total 820 questions