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
  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;
• 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
  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;
• 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;

Explanation: Only visible for ExamDumpsVCE members. You can sign-up / login (it's free).

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?

• A. create or replace warehouse reporting_wh
  warehouse_size = xxxlarge
  max_cluster_count = 10
  scaling_policy = standard
  auto_suspend = 600
  auto_resume = false;
• B. create or replace warehouse reporting_wh
  warehouse_size = medium
  auto_suspend = 600
  auto_resume = true;
• C. create or replace warehouse reporting_wh
  warehouse_size = medium
  max_cluster_count = 10
  scaling_policy = standard
  auto_suspend = 600
  auto_resume = true;
• D. create or replace warehouse reporting_wh
  warehouse_size = xxxlarge
  auto_suspend = 60
  auto_resume = true;

Explanation: Only visible for ExamDumpsVCE members. You can sign-up / login (it's free).

If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

• A. No, because the materialized view may not be up-to-date.
• B. No, because joins are not supported by materialized views.
• C. No, because the optimizer might decide against it.
• D. Yes, because materialized views are always faster.

Explanation: Only visible for ExamDumpsVCE members. You can sign-up / login (it's free).

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.)

• A. MONITOR
• B. MODIFY
• C. USAGE
• D. OPERATE
• E. OWNERSHIP

Explanation: Only visible for ExamDumpsVCE members. You can sign-up / login (it's free).

What are characteristics of data replication in Snowflake? (Choose three.)

• A. Databases created from shares can be replicated.
• B. Users must be granted REPLICATIONADMIN privileges in order to enable replication.
• C. Replication can only occur within the same cloud provider.
• D. To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.
• E. Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.
• F. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

Explanation: Only visible for ExamDumpsVCE members. You can sign-up / login (it's free).