Which statement allows a Snowflake Administrator to retrieve the network policy applied to their Snowflake account?

• A. SHOW PARAMETERS LIKE ‘NETWORK POLICY’ IN ACCOUNT;
• B. SHOW NETWORK POLICIES;
• C. SHOW NETWORK POLICIES IN ACCOUNT;
• D. DESC NETWORK POLICY <policy_name>;

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

• A. Manage system grants
• B. Reset a Snowflake user's password
• C. Create new users
• D. Create new roles

A Snowflake organization MYORG consists of two Snowflake accounts:
Account Name Snowflake Region Snowflake Edition
ACCOUNT1 AWS_EU_WEST_2 ENTERPRISE
ACCOUNT2 AZURE_WESTEUROPE STANDARD
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. No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.
• B. It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.
• C. USE ROLE ORGADMIN;
  SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('MYORG.ACCOUNT1','ENABLE_ACCOUNT_DATABASE_REPLICATION','TRUE');
  SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('MYORG.ACCOUNT2','ENABLE_ACCOUNT_DATABASE_REPLICATION','TRUE');
  USE ROLE ACCOUNTADMIN;
  ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2;
• D. USE ROLE ORGADMIN;
  SELECT SYSTEM$GLOBAL_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;

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? (Choose three.)

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