SnowPro Core Practice Test

SnowPro Core Practice Test practice questions, page 10 of 54, with answer review and explanations.

Question 46

Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)

  1. Databases
  2. Tables
  3. Warehouses
  4. Worksheets

Question 47

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

  1. VARCHAR
  2. RAW
  3. LOB
  4. VARIANT

Question 48

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

  1. They happen approximately weekly
  2. They roll up and release approximately monthly, but customers can request early release application
  3. During a release, new customer requests/queries/connections transparently move over to the newer version
  4. 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 49

Which of the following are common use cases for zero-copy cloning? (Choose three.)

  1. Quick provisioning of Dev and Test/QA environments
  2. Data backups
  3. Point in time snapshots
  4. Performance optimization

Question 50

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

  1. 4
  2. 16
  3. 32
  4. 128