SnowPro Core Practice Test

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

Question 136

Which Snowflake feature is used for both querying and restoring data?

  1. Cluster keys
  2. Time Travel
  3. Fail-safe
  4. Cloning

Question 137

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

  1. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
  2. Scaling out adds clusters of varying sizes to a virtual warehouse.
  3. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
  4. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
  5. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
  6. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Question 138

What is the minimum Snowflake edition that has column-level security enabled?

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

Question 139

What parameter controls if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement?

  1. INITIALLY_SUSPENDED = TRUE/FALSE
  2. START_AFTER_CREATE = TRUE/FALSE
  3. START_THE = 60 // (seconds from now)
  4. START_TIME = CURRENT_DATE()

Question 140

When cloning a database, what is cloned with the database? (Choose two.)

  1. Privileges on the database
  2. Existing child objects within the database
  3. Future child objects within the database
  4. Privileges on the schemas within the database
  5. Only schemas and tables within the database