SnowPro Core Practice Test

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

Question 251

What tasks can be completed using the COPY command? (Choose two.)

  1. Columns can be aggregated.
  2. Columns can be joined with an existing table.
  3. Columns can be reordered.
  4. Columns can be omitted.
  5. Data can be loaded without the need to spin up a virtual warehouse.

Question 252

Which Snowflake layer can be configured?

  1. Database Storage
  2. Cloud Services
  3. Query Processing
  4. Application Services

Question 253

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  1. Compute layer
  2. Storage layer
  3. Cloud infrastructure layer
  4. Cloud services layer

Question 254

If a size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

  1. 4
  2. 8
  3. 16
  4. 32

Question 255

A clustering key was defined on a table, but it is no longer needed. How can the key be removed?

  1. ALTER TABLE [TABLE NAME] PURGE CLUSTERING KEY
  2. ALTER TABLE [TABLE NAME] DELETE CLUSTERING KEY
  3. ALTER TABLE [TABLE NAME] DROP CLUSTERING KEY
  4. ALTER TABLE [TABLE NAME] REMOVE CLUSTERING KEY