Free SnowPro Core Exam Braindumps (page: 15)

Page 14 of 287

True or False: Snowflake charges additional fees to Data Providers for each Share they create.

  1. True
  2. False

Answer(s): B


Reference:

https://1amiydhcmj36tz3733v94f15-wpengine.netdna-ssl.com/wp-content/uploads/2017/08/Enabling-new-products-and-services-with-Snowflake-Data-
Sharing.pdf



Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

  1. 1 Hour
  2. 3 Hours
  3. 12 hours
  4. 24 hours

Answer(s): D


Reference:

https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse



A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

  1. The tables are now orphaned
  2. The user that deleted the role
  3. SYSADMIN
  4. The assumed role that dropped the role

Answer(s): D


Reference:

https://docs.snowflake.com/en/sql-reference/sql/drop-role.html



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

Answer(s): A,B


Reference:

https://docs.snowflake.com/en/user-guide/connecting.html






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

SnowPro Core Discussions & Posts