SnowPro-Core by Snowflake Actual Free Exam Questions And Answers

Question 1

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

A.

B.

C.

D.

Discussion 0

Correct Answer: D Vote an answer

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

Question 2

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

A. Default Time Travel Retention is set to 7 days.
Maximum Time Travel Retention is 1 day.
Fail Safe retention time is 90 days.

B. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.

C. Default Time Travel Retention is set to 90 days.
Maximum Time Travel Retention is 7 days.
Fail Safe retention time is 356 days.

D. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 30 days.
Fail Safe retention time is 1 day.

E. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.

F. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 365 days.
Fail Safe retention time is 7 days.

Discussion 0

Correct Answer: B Vote an answer

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

Question 3

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A. Warehouses

B. Databases

C. Roles

D. Users

E. Accounts

Discussion 0

Correct Answer: D,E Vote an answer

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

Question 4

What is a characteristic of materialized views in Snowflake?

A. Multiple tables can be joined in the underlying query of a materialized view.

B. Aggregate functions can be used as window functions in materialized views.

C. Clones of materialized views can be created directly by the user.

D. Materialized views do not allow joins.

Discussion 0

Correct Answer: A Vote an answer

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

Question 5

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A. A single join node uses more than 50% of the query time

B. An AggregateOperacor node is present

C. Partitions scanned is equal to partitions total

D. The query is spilling to remote storage

Discussion 0

Correct Answer: D Vote an answer

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

Question 6

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

A. False

B. True

Discussion 0

Correct Answer: A Vote an answer

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

Question 7

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

A. VALUES

B. TABULAR

C. ROW_NUMBER

D. TABLE

Discussion 0

Correct Answer: D Vote an answer

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

Question 8

When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

A. 1 hour

B. 8 hours

C. 4 hours

D. 2 hours

Discussion 0

Correct Answer: C Vote an answer

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

Question 9

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

A. An explain plan will handle queries with temporary tables and the query profiler will not.

B. An explain plan's output will display automatic data skew optimization information.

C. An explain plan can be used to conduct performance analysis without executing a query.

D. The explain plan output is available graphically.

Discussion 0

Correct Answer: C Vote an answer

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

Question 10

A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

A. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

B. Increase the warehouse size from Medium to 2XL.

C. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

D. Configure the warehouse to a multi-cluster warehouse.

Discussion 0

Correct Answer: D Vote an answer

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

Question 11

Which feature allows a user the ability to control the organization of data in a micro-partition?

A. Automatic Clustering

B. Horizontal Partitioning

C. Range Partitioning

D. Search Optimization Service

Discussion 0

Correct Answer: A Vote an answer

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

Question 12

How long is Snowpipe data load history retained?

A. 14 days

B. As configured in the create pipe settings

C. Until the pipe is dropped

D. 64 days

Discussion 0

Correct Answer: D Vote an answer

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

Question 13

How can a Snowflake user post-process the result of SHOW FILE FORMATS?

A. Assign the command to RESULTSET.

B. Put it in the FROM clause in brackets.

C. Use the RESULT_SCAN function.

D. Create a CURSOR for the command.

Discussion 0

Correct Answer: C Vote an answer

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

Question 14

What are characteristics of transient tables in Snowflake? (Select TWO).

A. Transient tables can be altered to make them permanent tables.

B. Transient tables can be cloned to permanent tables.

C. Transient tables have a Fail-safe period of 7 days.

D. Transient tables persist until they are explicitly dropped.

E. Transient tables have Time Travel retention periods of 0 or 1 day.

Discussion 0

Correct Answer: B,D Vote an answer

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

Snowflake SnowPro Core Certification - SnowPro-Core Exam Practice Test

Contact Us

Useful Links

Latest Updated