Name: Snowflake SnowPro Core Exam Exam
Brand: Pass4Success
SKU: SnowPro Core Exam
Price: 69.00 USD
Availability: InStock
Rating: 5.0 (121 reviews)

Disscuss Snowflake SnowPro Core Exam Topics, Questions or Ask Anything Related

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!

Free Snowflake SnowPro Core Exam Exam Actual Questions

The questions for SnowPro Core Exam were last updated On Apr. 10, 2024

Question #1

What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'

AViews

BMaterialized views

CTables

DExternal tables

EFuture grants

Reveal Solution

Correct Answer: A, C

Dynamic Data Masking in Snowflake supportstables and views.These objects can have masking policies applied to their columns to dynamically mask data at query time3.

Question #2

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

ABytes spilled to local cache.

BBytes spilled to local storage.

CBytes spilled to remote cache.

DBytes spilled to remote storage.

EBytes spilled to remote metastore.

Reveal Solution

Correct Answer: B, D

Question #3

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

Alist @bronzestage;

Bselect * from directory(@bronzestage);

Cselect metadata$filename from @bronzestage;

Dselect * from table(information_schema.stage_directory_file_registration_history(
stage name=>'bronzestage1));

Reveal Solution

Correct Answer: B

According to the Snowflake documentation1, a directory table stores a catalog of staged files in cloud storage and can be queried to retrieve theSnowflake-hosted file URLto each file in the stage. A file URL has the following format:

https:///api/files/<db_name>.<schema_name>.<stage_name>/<relative_path>

Based on this information, I think the query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage isB. select * from directory(@bronzestage);

Question #4

Which statement accurately describes a characteristic of a materialized view?

AA materialized view can query only a single table.

BData accessed through materialized views can be stale.

CMaterialized view refreshes need to be maintained by the user.

DQuerying a materialized view is slower than executing a query against the base table of the view.

Reveal Solution

Correct Answer: A

Question #5

Which pages are included in the Activity area of Snowsight? (Select TWO).

AContacts

BSharing settings

CCopy History

DQuery History

EAutomatic Clustering History

Reveal Solution

Correct Answer: C, D

Unlock all SnowPro Core Exam Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now