SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 67

- (Exam Topic 2)
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

A. True

B. False

Correct Answer:A

Question 68

- (Exam Topic 3)
How are serverless features billed?

A. Per second multiplied by an automatic sizing for the job

B. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Correct Answer:D

Question 69

- (Exam Topic 1)
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

A. True

B. False

Correct Answer:A
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

Question 70

- (Exam Topic 2)
Which of the following are benefits of micro-partitioning? (Select TWO)

A. Micro-partitions cannot overlap in their range of values

B. Micro-partitions are immutable objects that support the use of Time Travel.

C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

D. Rows are automatically stored in sorted order within micro-partitions

E. Micro-partitions can be defined on a schema-by-schema basis

Correct Answer:AD
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

Question 71

- (Exam Topic 3)
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
* 1. Created a user called "CONSUMER"
* 2. Created a database to hold the share and an extra-small warehouse to query the data
* 3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share
Based on this configuration what is true of the reader account?

A. The reader account will automatically use the Standard edition of Snowflake.

B. The reader account compute will be billed to the provider account.

C. The reader account can clone data the provider has shared, but cannot re-share it.

D. The reader account can create a copy of the shared data using CREATE TABLE AS...

Correct Answer:C

Question 72

- (Exam Topic 3)
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

A. VIEWS_HISTORY

B. OBJECT_HISTORY

C. ACCESS_HISTORY

D. LOGIN_HISTORY

Correct Answer:C

START SnowPro-Core EXAM