In general, the monthly billing for database replication is proportional to which variables? (Choose two.)

• A. The amount of table data in the primary database that changes as a result of data loading or DML operations
• B. The frequency of the secondary database refreshes from the primary database
• C. The frequency of changes to the primary database as a result of data loading or DML operations
• D. The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts
• E. The number and size of warehouses defined in the primary account

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 = medium
  auto_suspend = 600
  auto_resume = true;
• B. create or replace warehouse reporting_wh
  warehouse_size = medium
  max_cluster_count = 10
  scaling_policy = standard
  auto_suspend = 600
  auto_resume = true;
• C. create or replace warehouse reporting_wh
  warehouse_size = xxxlarge
  max_cluster_count = 10
  scaling_policy = standard
  auto_suspend = 600
  auto_resume = false;
• D. create or replace warehouse reporting_wh
  warehouse_size = xxxlarge
  auto_suspend = 60
  auto_resume = true;

A large international company with many operating regions requires data to be shared bi-directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe.
How can this data be shared bi-directionally, while MINIMIZING costs?

• A. Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.
• B. Move all the Snowflake accounts to a single region, and implement data sharing.
• C. Use data replication everywhere to reduce costs associated with same-region sharing.
• D. Use bi-directional data sharing among offices in the same region and replication among offices across the continents.

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

• A. Increase the minimum number of clusters started in the multi-cluster configuration to 5.
• B. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
• C. Increase the multi-cluster maximum to 20 or more clusters.
• D. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.
• E. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.

An organization's sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONE_NO
FROM CUSTOMERS
WHERE LAST_UPDATED BETWEEN TO_DATE(CURRENT_TIMESTAMP) AND (TO_DATE(CURRENT_TIMESTAMP)-7);
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?

• A. Leverage the CURRENT_DATE function for date calculations.
• B. Assign everyone on the sales team to the same security role.
• C. Assign everyone on the sales team to the same virtual warehouse.
• D. Wrap the query in a User-Defined Function (UDF) to match syntax execution.