SnowPro Core Practice Test

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

Question 231

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

  1. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
  2. An error will occur, as views with qualified references cannot be cloned.
  3. An error will occur, as stored objects cannot be cloned.
  4. The stored procedures and views will refer to tables in the source database.

Question 232

When loading data into Snowflake, how should the data be organized?

  1. Into single files with 100-250 MB of compressed data per file
  2. Into single files with 1-100 MB of compressed data per file
  3. Into files of maximum size of 1 GB of compressed data per file
  4. Into files of maximum size of 4 GB of compressed data per file

Question 233

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

  1. Schema
  2. View
  3. Internal stage
  4. Table
  5. User
  6. Role

Question 234

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

  1. SHOW GRANTS OF ROLE MY_ROLE
  2. SHOW GRANTS TO ROLE MY_ROLE
  3. SHOW GRANTS FOR ROLE MY_ROLE
  4. SHOW GRANTS ON ROLE MY_ROLE

Question 235

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

  1. Business Critical Edition
  2. Standard Edition
  3. Virtual Private Snowflake (VPS)
  4. Enterprise Edition