Free SnowPro-Core Exam Dumps

Question 51

- (Exam Topic 2)
A sales table FCT_SALES has 100 million records. The following Query was executed
SELECT COUNT (1) FROM FCT___SALES;
How did Snowflake fulfill this query?

A. Query against the result set cache
B. Query against a virtual warehouse cache
C. Query against the most-recently created micro-partition
D. Query against the metadata excite

Correct Answer:D

Question 52

- (Exam Topic 1)
Which of the following objects is not covered by Time Travel?

A. Tables
B. Schemas
C. Databases
D. Stages

Correct Answer:D
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

Question 53

- (Exam Topic 1)
Which of the following statements about data sharing are true? choose 2 answers

A. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts
B. All database objects can be included In a shared database
C. Reader Accounts are created and funded by Data Prowlers
D. Shared databases are read-only

Correct Answer:CD

Question 54

- (Exam Topic 1)
When can a Virtual Warehouse start running queries?

A. 12am-5am
B. Only during administrator defined time slots
C. When its provisioning is complete
D. After replication

Correct Answer:C
https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Question 55

- (Exam Topic 2)
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

A. Each Snowflake account can be hosted in a different cloud vendor and region.
B. Each Snowflake account must be hosted in a different cloud vendor and region
C. All Snowflake accounts must be hosted in the same cloud vendor and region
D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Correct Answer:B
https://docs.snowflake.com/en/user-guide/intro-regions.html