A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous IoT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.
According to best practices, how should these requirements be met? (Choose two.)

• A. The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data.
• B. Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.
• C. The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).
• D. Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.
• E. The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_DAYS.

A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ('1.1.1.0/24', '2.2.2.0/24', '3.3.3.0/24')
BLOCKED_IP_LIST = ('1.1.1.1')
COMMENT = 'Account level policy';
ALTER ACCOUNT SET NETWORK_POLICY=foo_policy;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = ('3.3.3.0/24')
BLOCKED_IP_LIST = ('3.3.3.10')
COMMENT = 'user level policy';
ALTER USER user1 SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?

• A. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
• B. No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
• C. No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.
• D. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.

What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

• A. MIMIC CONSUMER ACCOUNT
• B. SIMULATED DATA SHARING CONSUMER
• C. PRODUCER TEST ACCT
• D. TEST ACCOUNT ID

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;