SnowPro Core Practice Test

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

Question 176

What is the minimum Snowflake edition required to create a materialized view?

  1. Standard Edition
  2. Enterprise Edition
  3. Business Critical Edition
  4. Virtual Private Snowflake Edition

Question 177

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

  1. parse_json()
  2. json_extract_path_text()
  3. object_construct()
  4. flatten

Question 178

How are serverless features billed?

  1. Per second multiplied by an automatic sizing for the job
  2. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
  3. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
  4. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Question 179

Which Snowflake architectural layer is responsible for a query execution plan?

  1. Compute
  2. Data storage
  3. Cloud services
  4. Cloud provider

Question 180

When unloading to a stage, which of the following is a recommended practice or approach?

  1. Set SINGLE = TRUE for larger files.
  2. Use OBJECT_CONSTRUCT(*) when using Parquet.
  3. Avoid the use of the CAST function.
  4. Define an individual file format.