Free SNOWPRO-ADVANCED-ADMINISTRATOR – Snowflake SNOWPRO-ADVANCED-ADMINISTRATOR Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–2 of 2 questions

Question 1 (Topic 1)

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

Select an option, then click Submit answer.

  • ○ Any role with GRANT USAGE on SECURITY INTEGRATION
  • ○ ACCOUNTADMIN and SYSADMIN
  • ○ ACCOUNTADMIN and SECURITYADMIN
  • ○ ACCOUNTADMIN only
Question 2 (Topic 2)

What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

Select an option, then click Submit answer.

  • ○ The cost of running a resource monitor is only 10% of a credit, per day of operation.
  • ○ Multiple resource monitors can be applied to a single virtual warehouse.
  • ○ Resource monitors add no additional load to virtual warehouse compute.
  • ○ Multiple triggers can be configured across various virtual warehouse thresholds.
  • ○ Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
  • ○ Resource monitors can be applied to more than one virtual warehouse.