SnowPro Core Practice Test

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

Question 161

Which semi-structured file formats are supported when unloading data from a table? (Choose two.)

  1. ORC
  2. XML
  3. Avro
  4. Parquet
  5. JSON

Question 162

A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

  1. 1 second
  2. 60 seconds
  3. 5 minutes
  4. 60 minutes

Question 163

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

  1. Authentication
  2. Resource management
  3. Virtual warehouse caching
  4. Query parsing and optimization
  5. Query execution
  6. Physical storage of micro-partitions

Question 164

How long is the Fail-safe period for temporary and transient tables?

  1. There is no Fail-safe period for these tables.
  2. 1 day
  3. 7 days
  4. 31 days
  5. 90 days

Question 165

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

  1. PUT
  2. GET
  3. COPY
  4. SELECT