Snowflake SnowPro-Core Exam Practice Test Instant Access

Question 1

Which object can be used with Secure Data Sharing?

AView

BMaterialized view

CExternal table

DUser-Defined Function (UDF)

Answer : A

Viewscan be used with Secure Data Sharing in Snowflake.Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.

Question 2

Which Snowflake table objects can be shared with other accounts? (Select TWO).

ATemporary tables

BPermanent tables

CTransient tables

DExternal tables

EUser-Defined Table Functions (UDTFs)

Answer : B, D

In Snowflake,permanent tablesandexternal tablescan be shared with other accounts using Secure Data Sharing.Temporary tables, transient tables, and UDTFs are not shareable objects

Question 3

What transformations are supported when loading data into a table using the COPY INTO

command? (Select TWO).

AColumn reordering

BColumn omission

CJOIN function

DFLATTEN function

EGROUP BY function

Answer : A, B

TheCOPY INTO <table>command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.

Question 4

Which Snowflake database object can be used to track data changes made to table data?

ATag

BTask

CStream

DStored procedure

Answer : C

AStreamobject in Snowflake is used for change data capture (CDC), which records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes3.

Question 5

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?

AGET_PRESIGNED_URL

BGET_ABSOLUTE_PATH

CBUILD_STAGE_FILE_URL

DBUILD SCOPED FILE URL

Answer : C

TheBUILD_STAGE_FILE_URLfunction generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs2.

Question 6

Which Snowflake function will parse a JSON-null into a SQL-null?

ATO_CHAR

BTO_VARIANT

CTO_VARCHAR

DSTRIP NULL VALUE

Answer : D

TheSTRIP_NULL_VALUEfunction in Snowflake is used to convert a JSON null value into a SQL NULL value1.

Question 7

What happens when a Snowflake user changes the data retention period at the schema level?

AAll child objects will retain data for the new retention period.

BAll child objects that do not have an explicit retention period will automatically inherit the new retention period.

CAll child objects with an explicit retention period will be overridden with the new retention period.

DAll explicit child object retention periods will remain unchanged.

Answer : B

When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.

Page: 1 / 14
Total 427 questions

Snowflake SnowPro Core Exam Practice Test