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

A Snowflake organization MYORG consists of two Snowflake accounts:

The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.
Management wants to have the PROD_DB database replicated to ACCOUNT2.
Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?

• A. It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.
• B. USE ROLE ORGADMIN;
  SELECT SYSTEMSGLOBAL ACCOUNT SET_PARAMETER ( 'MYORG. ACCOUNT1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE'); USE ROLE ACCOUNTADMIN; ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2 IGNORE EDITION CHECK;
• C. USE ROLE ORGADMIN;
  SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE'); SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT2', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE'); USE ROLE ACCOUNTADMIN; ALTER DATABASE PROD DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2;
• D. No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.

An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be accessible for Analysts who work in these regions. Some Analysts need very specific access control depending on their functional roles in the organization. Following Snowflake recommended practice, how should these requirements be met? (Select TWO).

• A. Use zero-copy cloning to replicate the database schema and provide access as needed.
• B. Implement row access policies and Dynamic Data Masking policies.
• C. Implement views on top of base tables that exclude or mask sensitive data.
• D. Include masking rules as part of data ingestion and transformation pipelines.
• E. Use a third-party tool to share the data.

MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is
'8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries will allow the user to view the historical data that was in the table before this query was executed? (Select THREE).

• A. SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30);
• B. SELECT * FROM my_table BEFORE (STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
• C. SELECT * FROM TIME_TRAVEL ('MY_TABLE', 2021-01-01 07:00:00);
• D. SELECT * FROM my_table AT (OFFSET => -60*30);
• E. SELECT * FROM my table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';
• F. SELECT * FROM my_table AT (TIMESTAMP => '2021-01-01 07:00:00' :: timestamp);

What are benefits of creating and maintaining resource monitors in Snowflake? (Select THREE).

• A. Multiple triggers can be configured across various virtual warehouse thresholds.
• B. Resource monitors add no additional load to virtual warehouse compute.
• C. Resource monitors can be applied to more than one virtual warehouse.
• D. The cost of running a resource monitor is only 10% of a credit, per day of operation.
• E. Multiple resource monitors can be applied to a single virtual warehouse.
• F. Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.