SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 43

- (Exam Topic 2)
Where would a Snowflake user find information about query activity from 90 days ago?

A. Account___usage . query history view

B. account___usage.query___history___archive View

C. information___schema . cruery_history view

D. information___schema - query history_by_ses s i on view

Correct Answer:A

Question 44

- (Exam Topic 3)
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

A. Files

B. External tables

C. Secure User-Defined Functions (UDFs)

D. Sequences

E. Streams

Correct Answer:BC

Question 45

- (Exam Topic 3)
Which minimum Snowflake edition allows for a dedicated metadata store?

A. Standard

B. Enterprise

C. Business Critical

D. Virtual Private Snowflake

Correct Answer:D
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html

Question 46

- (Exam Topic 1)
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

A. True

B. False

Correct Answer:A
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

Question 47

- (Exam Topic 2)
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

A. Bytes scanned

B. Bytes sent over the network

C. Number of partitions scanned

D. Percentage scanned from cache

E. External bytes scanned

Correct Answer:AC

Question 48

- (Exam Topic 3)
What is the purpose of multi-cluster virtual warehouses?

A. To create separate data warehouses to increase query optimization

B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

C. To eliminate or reduce Queuing of concurrent queries

D. To allow the warehouse to resize automatically

Correct Answer:C
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi-cluster warehous

START SnowPro-Core EXAM