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
  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 suspend
  on 120 percent do 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 notify and suspend
  on 120 percent do notify and suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• D. 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;

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

What steps are required to set up OKTAAPI token integration in Snowflake?

• A. use role ACCOUNTADMIN;
  select system$ generate_scim_access_token ('OKTA PROVISIONING');
  Update these steps every 12 months.
• B. create or replace security integration okta_provisioning
  type = scim
  scim_client = 'okta'
  run_as_role = 'OKTA PROVISIONER';
  Update this step every 6 months.
• C. use role ACCOUNTADMIN;
  select system$ generate_scim_access_token ('OKTA PROVISIONING');
  Update these steps every 6 months.
• D. grant role okta_provisioner to role ACCOUNTADMIN;
  create or replace security integration okta_provisioning
  type = scim
  scim_client = 'okta'
  run_as_role = 'OKTA PROVISIONER';
  Update these steps every 12 months.

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

A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

• A. To keep the query result cache warm for good performance on repeated queries
• B. To save costs on warehouse shutdowns and startups for different queries
• C. To keep the data cache warm to support good performance of similar queries
• D. To save costs by running the warehouse as little as possible

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

An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER.
CREATE TABLE customer_data (
customer_first_name string,
customer_last_name string,
customer_address string,
customer_email string,
... some other columns,
);
The application team would like to access the customer data, but the email field must be obfuscated.
How can the Administrator protect the sensitive information, while maintaining the usability of the data?

• A. Create a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view.
• B. Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.
• C. Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.
• D. Create a separate table for all the non-PII columns and grant the role DEVELOPER access to the new table.

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

A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP_DB containing only one schema, APP_SCHEMA. The company's time Travel retention policy is currently set for 30 days for both accounts. An Administrator has been asked to extend the time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?

• A. Set the data retention policy on the secondary database to 60 days.
• B. Set the data retention policy on the primary database to 30 days and the schemas to 60 days.
• C. Set the data retention policy on the schemas in the secondary database to 60 days.
• D. Set the data retention policy on the primary database to 60 days.

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