Online Access Free ADA-C02 Practice Test

What are benefits of using Snowflake organizations? (Choose two.)

• A.Administrators have the ability to create accounts in any available cloud provider or region.
• B.Administrators can monitor and understand usage across all accounts in the organization.
• C.Administrators can change Snowflake account editions on-demand based on need.
• D.User administration is simplified across all accounts within the organization.
• E.Administrators can simplify data movement across all accounts within the organization.

The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?

• A.Tables created by either user A or user B will be visible to both users.
• B.All existing tables in schema PROD.WORKING will be visible to both users.
• C.Both user A and user B can create tables in the PROD.WORKING schema.
• D.Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.

What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

• A.PRODUCER TEST ACCT
• B.SIMULATED DATA SHARING CONSUMER
• C.MIMIC CONSUMER ACCOUNT
• D.TEST ACCOUNT ID

Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Choose two.)

• A.Adding region availability to the listing
• B.Deleting data from a table
• C.Unpublishing the data listing
• D.Renaming a table
• E.Dropping a column from a table

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks:
At 80% usage notify the account Administrators.
At 100% usage suspend the warehouse and notify the account Administrators.
At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command will meet these requirements?

• A.create or replace resource monitor RM1 with credit_quota=3000
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• B.create or replace resource monitor RM1 with credit_quota=3000
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do notify and suspend
  on 120 percent do notify and suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• C.create or replace resource monitor RM1 with credit_quota=3000
  frequency = yearly
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• D.create or replace resource monitor RM1 with credit_quota=3000
  frequency = yearly
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;