A resource monitor named MONTHLY_FINANCE_LIMIT has been created and applied to two virtual warehouses (fin_wh1 and fin_wh2) using the following SQL:

Given that the combined total of credits consumed by fin_wh1 and fin_wh2 (including cloud services) has reached 800 credits and both warehouses are suspended, what should the ACCOUNTADMIN execute to allow both warehouses to be resumed? (Select TWO).

• A. ALTER WAREHOUSE fin_wh2 RESUME;
• B. ALTER WAREHOUSE fin_wh2 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;
• C. ALTER WAREHOUSE fin_wh1 RESUME;
• D. ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT SET CREDIT_QUOTA = 1500;
• E. ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;
• F. ALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITORS;
• G. ALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;

Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

• A. alter user userl set DISABLE_MFA=1440;
• B. alter user userl set HOURS_TO_BYPASS_MFA=24;
• C. alter user userl set TEMPORARY_MFA_BYPASS=1440;
• D. alter user userl set MINS_TO_BYPASS_MFA=1440;

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 primary database to 30 days and the schemas to 60 days.
• B. Set the data retention policy on the secondary database 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.

The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, what roles in Account 123 are allowed to request and get data?

• A. Any role with IMPORT SHARE and CREATE DATABASE privileges
• B. Any role that the listing provider has designated as authorized
• C. Only the ACCOUNTADMIN role, and no other roles
• D. Any role with USAGE privilege on the Data Exchange

An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transient copy of this table and wants the transient table to have all the same permissions as the original table.
How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the requirements? (Select TWO).

• A. Use the following SQL commands:
  create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;
• B. Transient tables will persist until explicitly dropped and contribute to overall storage costs.
• C. Use the following SQL command:
  create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;
• D. Transient tables will be purged at the end of the user session and do not have any Fail-safe period.
• E. Use the following SQL command:
  create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;