Curious about Actual Snowflake SnowPro Certification (SnowPro-Core) Exam Questions?

Here are sample Snowflake SnowPro Core (SnowPro-Core) Exam questions from real exam. You can get more Snowflake SnowPro Certification (SnowPro-Core) Exam premium practice questions at TestInsights.

Page: 1 /
Total 427 questions
Question 1

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?


Correct : 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.


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 2

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


Correct : 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.


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 3

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

command? (Select TWO).


Correct : 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.


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 4

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


Correct : 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


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 5

A Snowflake account has activated federated authentication.

What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?


Correct : A

When federated authentication is activated in Snowflake, users authenticate via an external identity provider (IdP) rather than using Snowflake-managed credentials. Therefore, a user with a password defined by Snowflake will be unable to enter a password and must use their IdP credentials to log in.


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Page:    1 / 86   
Total 427 questions