ADA-C02 Exam Question 6

Which Snowflake objects can be managed using SCIM integration? (Choose two.)
  • ADA-C02 Exam Question 7

    What are characteristics of data replication in Snowflake? (Choose three.)
  • ADA-C02 Exam Question 8

    An Administrator needs to configure a virtual warehouse in Snowflake for a new use case with these details:
    1. There will be 50-100 concurrent users running reports
    2. Minimize costs based on the number of active users at a given time
    3. The virtual warehouse should suspend and resume automatically based on user activity
    Which configuration will meet these requirements?
  • ADA-C02 Exam Question 9

    A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business-Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
    Which solutions will address the issues happening once a month? (Choose two.)
  • ADA-C02 Exam Question 10

    A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
    An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
    What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)