Home / Snowflake / SnowPro Core

Question list

List of questions

Question 1

(0)

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file

Question 2

(0)

What are the default Time Travel and Fail-safe retention periods for transient tables?

Question 3

(0)

What is a best practice after creating a custom role?

Question 4

(0)

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Question 5

(0)

Will data cached in a warehouse be lost when the warehouse is resized?

Question 6

(0)

What happens when a virtual warehouse is resized?

Question 7

(0)

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data

Question 8

(0)

Which of the following describes how clustering keys work in Snowflake?

Question 9

(0)

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Question 10

(0)

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Question 476 - SnowPro Core discussion

How can a user get the MOST detailed information about individual table storage details in Snowflake?

SHOW TABLES command

SHOW EXTERNAL TABLES command

TABLES view

TABLE STORAGE METRICS view

Show Answer

asked 29/10/2024

Fermin Paneque Cabrera

39 questions

Your answer: A B C D

0 comments

Sorted by