SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

1. A. PUT
2. B. GET
3. C. COPY
4. D. SELECT

Correct Answer: B
Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html

- (Exam Topic 1)
What happens when a Data Provider revokes privileges to a Share on an object in their source database?

1. A. The object immediately becomes unavailable for all Data Consumers
2. B. Any additional data arriving after this point in time will not be visible to Data Consumers
3. C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
4. D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

Correct Answer: A

- (Exam Topic 1)
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

1. A. True
2. B. False

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

- (Exam Topic 3)
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

1. A. 4
2. B. 8
3. C. 16
4. D. 32

Correct Answer: B
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

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

- (Exam Topic 1)
Which of the following statement is true of Snowflake? Select one.

1. A. It was built specifically for the cloud
2. B. it was built as an on-premises solution and then potted to the cloud
3. C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
4. D. It was built for Hadoop architecture
5. E. It's based on an Oracle Architecture

Correct Answer: A