SnowPro Core Practice Test

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

Question 181

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

  1. UPDATE TABLE FROM STREAM
  2. SELECT FROM STREAM
  3. INSERT INTO TABLE SELECT FROM STREAM
  4. ALTER TABLE AS SELECT FROM STREAM
  5. BEGIN COMMIT

Question 182

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

  1. Use the DROP [file] command after the load completes.
  2. Specify the TEMPORARY option when creating the file format.
  3. Specify the PURGE copy option in the COPY INTO [table] command.
  4. Use the REMOVE command after the load completes.
  5. Use the DELETE LOAD HISTORY command after the load completes.

Question 183

On which of the following cloud platforms can a Snowflake account be hosted? (Choose three.)

  1. Amazon Web Services
  2. Private Virtual Cloud
  3. Oracle Cloud
  4. Microsoft Azure Cloud
  5. Google Cloud Platform
  6. Alibaba Cloud

Question 184

What Snowflake role must be granted for a user to create and manage accounts?

  1. ACCOUNTADMIN
  2. ORGADMIN
  3. SECURITYADMIN
  4. SYSADMIN

Question 185

Assume there is a table consisting of five micro-partitions with values ranging from A to Z. Which diagram indicates a well-clustered table?