Free Access Snowflake.SnowPro-Core.v2022-05-06.q56 Practice Test (Page 2)

Question 1

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

A.14 days

B.1 year

C.60 minutes

D.24 hours

E.30 days

Question 2

True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

A.False

B.True

Question 3

What is the recommended Snowflake data type to store semi-structured data like JSON?

A.VARIANT

B.VARCHAR

C.RAW

D.LOB

Question 4

Which of the following statements are true of Snowflake releases: (Choose two.)

A.They happen approximately weekly

B.They roll up and release approximately monthly, but customers can request early release application

C.During a release, new customer requests/queries/connections transparently move over to the newer version

D.A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

Question 5

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.