SnowPro Core Practice Test

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

Question 206

Which command can be used to load data files into a Snowflake stage?

  1. JOIN
  2. COPY INTO
  3. PUT
  4. GET

Question 207

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

  1. Reader
  2. Consumer
  3. Vendor
  4. Standard
  5. Personalized

Question 208

What is the maximum Time Travel retention period for a temporary Snowflake table?

  1. 90 days
  2. 1 day
  3. 7 days
  4. 45 days

Question 209

When should a multi-cluster warehouse be used in auto-scaling mode?

  1. When it is unknown how much compute power is needed
  2. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
  3. If the runtime of the executed query is very slow
  4. When a large number of concurrent queries are run on the same warehouse

Question 210

What happens when a cloned table is replicated to a secondary database? (Choose two.)

  1. A read-only copy of the cloned tables is stored.
  2. The replication will not be successful.
  3. The physical data is replicated.
  4. Additional costs for storage are charged to a secondary account.
  5. Metadata pointers to cloned tables are replicated.