SnowPro Core Practice Test

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

Question 261

What is a responsibility of Snowflake’s virtual warehouses?

  1. Infrastructure management
  2. Metadata management
  3. Query execution
  4. Query parsing and optimization
  5. Management of the storage layer

Question 262

Which data type is supported by Snowflake data classification?

  1. Binary
  2. Float
  3. Geography
  4. Variant

Question 263

When unloading data to an external stage, which compression format can be used for Parquet files with the COPY INTO command?

  1. BROTLI
  2. GZIP
  3. LZO
  4. ZSTD

Question 264

Which SQL command can be used to verify the privileges that are granted to a role?

  1. SHOW GRANTS ON ROLE [Role Name]
  2. SHOW ROLES [Role Name]
  3. SHOW GRANTS TO ROLE [Role Name]
  4. SHOW GRANTS FOR ROLE [Role Name]

Question 265

Which Query Profile result indicates that a warehouse is sized too small?

  1. There are a lot of filter nodes.
  2. Bytes are spilling to external storage.
  3. The number of processed rows is very high.
  4. The number of partitions scanned is the same as partitions total.