CertsTopics Logo

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

SnowPro Core Certification SnowPro-Core Syllabus Exam Questions Answers

Page: 20 / 45
Total 605 questions
Get SnowPro-Core Full Access Download SnowPro-Core PDF

SnowPro Core Certification Exam Questions and Answers

Question 77

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Options:

A.

Account

B.

Database

C.

Schema

D.

Table

Question 78

Which commands can only be executed using SnowSQL? (Select TWO).

Options:

A.

COPY INTO

B.

GET

C.

LIST

D.

PUT

E.

REMOVE

Question 79

How is unstructured data retrieved from data storage?

Options:

A.

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

B.

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

C.

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

D.

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

Question 80

How should clustering be used to optimize the performance of queries that run on a very large table?

Options:

A.

Manually re-cluster the table regularly.

B.

Choose one high cardinality column as the clustering key.

C.

Use the column that is most-frequently used in query select clauses as the clustering key.

D.

Assess the average table depth to identify how clustering is impacting the query.

Page: 20 / 45
Total 605 questions
Get SnowPro-Core Full Access Download SnowPro-Core PDF