SnowPro Core Practice Test

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

Question 56

Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)? (Choose two.)

  1. SnowSQL
  2. ODBC
  3. R
  4. HIVE

Question 57

Which of the following DML commands isn't supported by Snowflake?

  1. UPSERT
  2. MERGE
  3. UPDATE
  4. TRUNCATE TABLE

Question 58

Which of the following statements is true of zero-copy cloning?

  1. Zero-copy clones increase storage costs as cloning the table requires storing its data twice
  2. All zero-copy clone objects inherit the privileges of their original objects
  3. Zero-copy cloning is licensed as an additional Snowflake feature
  4. At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared

Question 59

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

  1. True
  2. False

Question 60

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

  1. 60 minutes
  2. 24 hours
  3. 14 days
  4. 30 days
  5. 1 year