Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. SnowPro-Core
  5. SnowPro Core Certification Exam Questions and Answers

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

Exam SnowPro-Core All Questions
Exam SnowPro-Core Premium Access

View all detail and faqs for the SnowPro-Core exam

Go to Exam
Viewing page 5 out of 15 pages
Viewing questions 41-50 out of questions
Questions # 41:

Which role has the ability to create a share from a shared database by default?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Expert Solution
Questions # 42:

Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?

Options:

A.

Materialized View

B.

Pipe

C.

Stream

D.

Task

Expert Solution
Questions # 43:

A clustering key was defined on a table, but It is no longer needed. How can the key be removed?

Options:

A.

ALTER TABLE

PURGE CLUSTERING KEY

B.

ALTER TABLE

DELETE CLUSTERING KEY

C.

ALTER TABLE

DROP CLUSTERING KEY

D.

ALTER TABLE

REMOVE CLUSTERING KEY

Expert Solution
Questions # 44:

How does the search optimization service help Snowflake users improve query performance?

Options:

A.

It scans the micro-partitions based on the joins used in the queries and scans only join columns.

B.

II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.

C.

It scans the local disk cache to avoid scans on the tables used in the Query.

D.

It keeps track of running queries and their results and saves those extra scans on the table.

Expert Solution
Questions # 45:

Authorization to execute CREATE statements comes only from which role?

Options:

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

Expert Solution
Questions # 46:

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

A)

Question # 46

B)

Question # 46

C)

Question # 46

D)

Question # 46

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Expert Solution
Questions # 47:

Which user preferences can be set for a user profile in Snowsight? (Select TWO).

Options:

A.

Multi-Factor Authentication (MFA)

B.

Default database

C.

Default schema

D.

Notification

E.

Username

Expert Solution
Questions # 48:

What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

Options:

A.

Fail-safe

B.

Time Travel

C.

Cloning

D.

Account replication

Expert Solution
Questions # 49:

Which statements reflect valid commands when using secondary roles? (Select TWO).

Options:

A.

Use SECONDARY ROLES RESUME

B.

USE SECONDARY ROLES SUSPEND

C.

USE SECONDARY RLES ALL

D.

USE SECONDARY ROLES ADD

E.

Use SECONDARY ROLES NONE

Expert Solution
Questions # 50:

What are the main differences between the account usage views and the information schema views? (Select TWO).

Options:

A.

No active warehouse to needed to query account usage views but one is needed to query information schema views.

B.

Account usage views do not contain data about tables but information schema views do.

C.

Account issue views contain dropped objects but information schema views do not.

D.

Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

E.

Information schema views are read-only but account usage views are not.

Expert Solution
Viewing page 5 out of 15 pages
Viewing questions 41-50 out of questions