Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Snowflake SnowPro Core Certification SnowPro-Core Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.
Exam SnowPro-Core Premium Access

View all detail and faqs for the SnowPro-Core exam

Go to Exam

822 Students Passed

87% Average Score

93% Same Questions
Viewing page 5 out of 13 pages
Viewing questions 61-75 out of questions
Questions # 61:

How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

Options:

A.

Use the SHOW STAGES command.

B.

Use the DESCRIBE STAGE command.

C.

Use the GET_ABSOLUTE_PATH function.

D.

Use the GET_STAGE_LOCATION function.

Questions # 62:

Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPS)

Questions # 63:

Snowflake's access control framework combines which models for securing data? (Select TWO).

Options:

A.

Attribute-based Access Control (ABAC 1

B.

Discretionary Access Control (DAC)

C.

Access Control List (ACL)

D.

Role-based Access Control (RBAC)

E.

Rule-based Access Control (RuBAC)

Questions # 64:

What does a table with a clustering depth of 1 mean in Snowflake?

Options:

A.

The table has only 1 micro-partition.

B.

The table has 1 overlapping micro-partition.

C.

The table has no overlapping micro-partitions.

D.

The table has no micro-partitions.

Questions # 65:

What are characteristics of Snowflake network policies? (Select TWO).

Options:

A.

They can be set for any Snowflake Edition.

B.

They can be applied to roles.

C.

They restrict or enable access to specific IP addresses.

D.

They are activated using ALTER DATABASE SQL commands.

E.

They can only be managed using the ORGADMIN role.

Questions # 66:

What happens when a suspended virtual warehouse is resized in Snowflake?

Options:

A.

It will return an error.

B.

It will return a warning.

C.

The suspended warehouse is resumed and new compute resources are provisioned immediately.

D.

The additional compute resources are provisioned when the warehouse is resumed.

Questions # 67:

Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).

Options:

A.

Authorisation

B.

Access delegation

C.

Data pruning

D.

Data compression

E.

Query parsing and optimization

Questions # 68:

Which typos of charts does Snowsight support? (Select TWO).

Options:

A.

Area charts

B.

Bar charts

C.

Column charts

D.

Radar charts

E.

Scorecards

Questions # 69:

Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

Options:

A.

Persisted query results

B.

QUERY_HISTORY View

C.

Query acceleration service

D.

Query Profile

Questions # 70:

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

USERADMIN

Questions # 71:

Which statement describes Snowflake tables?

Options:

A.

Snowflake tables arc logical representation of underlying physical data.

B.

Snowflake tables are the physical instantiation of data loaded into Snowflake.

C.

Snowflake tables require that clustering keys be defined lo perform optimally.

D.

Snowflake tables are owned by a use.

Questions # 72:

Given the statement template below, which database objects can be added to a share?(Select TWO).

GRANT ON To SHARE ;

Options:

A.

Secure functions

B.

Stored procedures

C.

Streams

D.

Tables

E.

Tasks

Questions # 73:

Snowflake users can create a resource monitor at which levels? (Select TWO).

Options:

A.

User level

B.

Pipe level

C.

Account level

D.

Cloud services level

E.

Virtual warehouse level

Questions # 74:

Which function can be used with the copy into statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

Options:

A.

FLATTEN

B.

OBJECT_AS

C.

OBJECT_CONSTRUCT

D.

TO VARIANT

Questions # 75:

Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?

Options:

A.

GET_RELATIVE_PATH

B.

GET_PRESIGNED_URL

C.

BUILD_STAGE_FILE_URL

D.

BUILD_SCOPED_FILE_URL

Viewing page 5 out of 13 pages
Viewing questions 61-75 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25
ADM-201
Agentforce-Specialist
CMMC-CCP
Data-Cloud-Consultant
PDI
PSE-Strata-Pro-24
Secure-Software-Design
Sharing-and-Visibility-Architect
Workday-Pro-Integrations
ZDTA