SnowPro Core Practice Test

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

Question 246

Which data types does Snowflake support when querying semi-structured data? (Choose two.)

  1. VARIANT
  2. VARCHAR
  3. XML
  4. ARRAY
  5. BLOB

Question 247

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

  1. When the system has enough load for 2 minutes
  2. When the system has enough load for 6 minutes
  3. When the system has enough load for 8 minutes
  4. When the system has enough load for 10 minutes

Question 248

What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));

  1. To validate external table files in table t1 across all sessions
  2. To validate task SQL statements against table t1 in the last 14 days
  3. To validate a file for errors before it gets executed using a COPY command
  4. To return errors from the last executed COPY command into table t1 in the current session

Question 249

A sales table FCT_SALES has 100 million records. The following query was executed: SELECT COUNT (1) FROM FCT_SALES; How did Snowflake fulfill this query?

  1. Query against the result set cache
  2. Query against a virtual warehouse cache
  3. Query against the most-recently created micro-partition
  4. Query against the metadata cache

Question 250

What happens when a virtual warehouse is resized?

  1. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected.
  2. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
  3. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
  4. Users who are trying to use the warehouse will receive an error message until the resizing is complete.