SnowPro Core Practice Test

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

Question 51

True or False: When a data share is established between a Data Provider and a Data Consumer, the Data Consumer can extend that data share to other Data Consumers.

  1. True
  2. False

Question 52

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

  1. Is available to all Snowflake Editions
  2. Is only available to customers with Business Critical Edition
  3. Restricts or enables access to specific IP addresses
  4. Is activated using an ג€ALTER DATABASEג€ command

Question 53

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

  1. True
  2. False

Question 54

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

Question 55

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