Home

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?

Open VPLUS File

Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)

When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

A user needs to create a materialized view in the schema MYDB.MYSCHEM

Which Snowflake technique can be used to improve the performance of a query?

What is a key feature of Snowflake architecture?

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

User-level network policies can be created by which of the following roles? (Select TWO).

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

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

Question 224 - SnowPro Core discussion

Report

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A.

A directory table is a separate database object.

B.

Directory tables store data file metadata.

C.

A directory table will be automatically added to a stage.

D.

Directory tables do not have their own grantable privileges.

E.

Directory table data can not be refreshed manually.

Show Answer

asked 23/09/2024

Bradley Coetzee

32 questions

User

Your answer: A B C D E

0 comments

Sorted by

Leave a comment first