Free Snowflake SnowPro-Core Exam Actual Questions

The questions for SnowPro-Core were last updated On Feb 20, 2025

At ValidExamDumps, we consistently monitor updates to the Snowflake SnowPro-Core exam questions by Snowflake. Whenever our team identifies changes in the exam questions,exam objectives, exam focus areas or in exam requirements, We immediately update our exam questions for both PDF and online practice exams. This commitment ensures our customers always have access to the most current and accurate questions. By preparing with these actual questions, our customers can successfully pass the Snowflake SnowPro Core Exam exam on their first attempt without needing additional materials or study guides.

Other certification materials providers often include outdated or removed questions by Snowflake in their Snowflake SnowPro-Core exam. These outdated questions lead to customers failing their Snowflake SnowPro Core Exam exam. In contrast, we ensure our questions bank includes only precise and up-to-date questions, guaranteeing their presence in your actual exam. Our main priority is your success in the Snowflake SnowPro-Core exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.

 

Get All 629 Questions
Question No. 1

What type of function returns one value for each Invocation?

Show Answer Hide Answer
Correct Answer: B

Scalar functions in Snowflake (and SQL in general) are designed to return a single value for each invocation. They operate on a single value and return a single result, making them suitable for a wide range of data transformations and calculations within queries.


Snowflake Documentation: Functions

Question No. 2

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

Show Answer Hide Answer
Correct Answer: C

TheACCESS_HISTORYview in theSNOWFLAKE.ACCOUNT_USAGEschema contains information about the access history of Snowflake objects, such as tables and views, within the last 365 days1.


Question No. 3

Which features make up Snowflake's column level security? (Select TWO).

Show Answer Hide Answer
Correct Answer: B, C

Snowflake's column level security features include Dynamic Data Masking and External Tokenization.Dynamic Data Masking uses masking policies to selectively mask data at query time, while External Tokenization allows for the tokenization of data before loading it into Snowflake and detokenizing it at query runtime5.


Question No. 4

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

Show Answer Hide Answer
Correct Answer: C

To determine which user has accessed a database object containing sensitive information, a Snowflake administrator can query theACCESS_HISTORYview in theACCOUNT_USAGEschema, which provides information about access to database objects3.


Question No. 5

Which key access control concept does Snowflake descibe as a defined level of access to an object?

Show Answer Hide Answer
Correct Answer: B

In Snowflake, the term 'privilege' refers to a defined level of access to an object. Privileges are specific actions that roles can perform on securable objects in Snowflake, such as tables, views, warehouses, databases, and schemas. These privileges are granted to roles and can be further granted to users through their roles, forming the basis of Snowflake's access control framework. Reference: Snowflake Documentation on Access Control Privileges


Get All 629 Questions Explore Other Snowflake Exams