Contact Us
FAQ's
Login / Register

Home
FORUM
All Vendors
Guarantee
Testimonials
Cart (0)

Snowflake SnowPro Core Certification - SnowPro-Core Exam Practice Test

Page: 1 / 42
Total 630 questions

Please signup / login to view this exam, then you will be able to view the entire exam for free.

Get Full Access Now

Question 1

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

A. QUERY_HISTORY B. ROLES C. RESOURCE_MONIT ORS D. ACCESS_HISTORY E. POLICY_REFERENCES

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

A. Columns can be omitted B. Row level access can be defined C. Incoming data can be joined with other tables D. Columns can be reordered E. Data can be filtered by an optional where clause

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 3

What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

A. WRTTF B. OWNERSHIP C. READ D. USAGK

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 4

What does Snowflake's search optimization service support?

A. Tables and views that are not protected by row access policies B. Casts on table columns (except for fixed-point numbers cast to strings) C. External tables D. Materialized views

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 5

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A. How often the materialized view is queried B. How often the base table changes C. How often the underlying base table is queried D. Whether the materialized view has a cluster key defined E. Whether or not it is also a secure view

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 6

Which of the following statements describes a schema in Snowflake?

A. A named Snowflake object that includes all the information required to share a database B. A uniquely identified Snowflake account within a business entity C. A logical grouping of objects that belongs to multiple databases D. A logical grouping of objects that belongs to a single database

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 7

How can a data provider ensure that a data consumer is going to have access to the required objects?

A. Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated. B. Use the CURRENT_ function to authorize users from a specific account to access rows in a base table. C. Enable the data sharing feature in the account and validate the view. D. Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 8

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

A. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types. B. There are multiple SQL UDFs with different names but the same number of arguments or argument types. C. There are multiple SOL UDFs with the same names and the same number of arguments. D. There are multiple SQL UDFs with the same names and the same number of argument types.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 9

Which feature is only available in the Enterprise or higher editions of Snowflake?

A. Multi-factor Authentication (MFA) B. Object-level access control C. SOC 2 type II certification D. Column-level security

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 10

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

A. Contact Snowflake Support to have the data retrieved from Fail-safe storage. B. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage. C. The transient table version cannot be retrieved after 24 hours. D. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 11

A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.
What should they do?

A. Use the USERADMIN role. B. Contact Snowflake Support. C. Use the SYSADMIN role. D. Use the SECURITYADMIN role.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 12

Which Snowflake layer is associated with virtual warehouses?

A. Database storage B. Query processing C. Elastic memory D. Cloud services

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 13

What internal stages are available in Snowflake? (Choose three.)

A. Table stage B. Database stage C. Schema stage D. Named stage E. User stage F. Stream stage

Discussion 0

Correct Answer: A,D,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 14

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

A. Standard Edition B. Enterprise Edition C. Virtual Private Snowflake Edition D. Business Critical Edition

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 15

A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

A. Query against the metadata excite B. Query against the most-recently created micro-partition C. Query against a virtual warehouse cache D. Query against the result set cache

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Page: 1 / 42
Total 630 questions

Unlock all SnowPro-Core features

No captcha needed
365 Days Free Updates
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Two Modes For SnowPro-Core Practice
Customer Support

Get Full Access Now

Get in Touch

PassTestking

Our Exam Dumps will provide you with the free demo before you purchase. Our Practice Questions can help you improve your professional ability. Our Study Material provide you with excellent prepare materials for you to pass the exam and get the certification.

Latest Practice Tests

H12-821_V1.0 Practice Test
PCPP-32-101 Practice Test
C_TS462 Practice Test
312-49 Practice Test
IdentityIQ-Engineer Practice Test
NCA-GENM Practice Test

Useful Links

All Products
FAQs
Privacy Policy
Guarantee & Refund Policy
Terms & Conditions
How to buy?
About Us

Contact Us

Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday

Support: Contact now

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Copyright © 2026 PASSTESTKING.COM. All rights reserved. All trademarks are the property of their respective owners and we don't provide actual questions from any vendor.