Name: Snowflake SnowPro Core Exam Exam
Brand: Pass4Success
SKU: SnowPro Core Exam
Price: 69.00 USD
Availability: InStock
Rating: 4.9 (22 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 May. 10, 2024

Question #1

What are the least privileges needed to view and modify resource monitors? (Select TWO).

ASELECT

BOWNERSHIP

CMONITOR

DMODIFY

EUSAGE

Reveal Solution

Correct Answer: C, D

To view and modify resource monitors, the least privileges needed are MONITOR and MODIFY.These privileges allow a user to monitor credit usage and make changes to resource monitors3.

Question #2

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

ACREATE TABLE <table_name> LIKE TABLE_A;

BCREATE VIEW <view_name> AS SELECT * FROM TABLE_A;

CCREATE TABLE <table_name> AS SELECT * FROM TABLE_A;

DCREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;

Reveal Solution

Correct Answer: C

When a tag object is assigned to a table, using the statementCREATE TABLE <table_name> AS SELECT * FROM TABLE_Awill automatically assign the TABLE_A tag to the newly created table2.

Question #3

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 #4

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 #5

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);

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