CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. SnowPro Core

Free SnowPro Core Exam Braindumps (page: 60)

Page 59 of 287
PDF with 1270 Questions

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

Answer(s): A,D



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

Answer(s): A



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

Answer(s): B



A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

  1. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
  2. The transient table version cannot be retrieved after 24 hours.
  3. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
  4. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Answer(s): B






Post your Comments and Discuss Snowflake SnowPro Core exam with other Community members:

SnowPro Core Exam Discussions & Posts