A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTS rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTS that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

• A. The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.
• B. The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
• C. There should be another 2XL warehouse deployed to handle a portion of the load queries.
• D. The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.

A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?

• A. Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
• B. Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
• C. Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.
• D. Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.

What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)

• A. The account name must be unique within the organization.
• B. The account name must be unique among all Snowflake customers.
• C. The account name is immutable and cannot be changed.
• D. The account name must be specified when the account is created.
• E. The account requires at least one ORGADMIN role within one of the organization's accounts.

A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema:
Table Name: VWH_META
Column 1: SNAPSHOT_TIME TIMESTAMP_NTZ
Column 2: CONFIG VARIANT
Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH_META?

• A. SHOW WAREHOUSES;
  INSERT INTO VWH_META
  SELECT CURRENT_TIMESTAMP(),
  FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(1)));
• B. SHOW WAREHOUSES;
  INSERT INTO VWH_META
  SELECT CURRENT_TIMESTAMP(), *
  FROM TABLE(RESULT_SCAN(SELECT LAST_QUERY_ID(-1)));
• C. SHOW WAREHOUSES;
  INSERT INTO VWH_META
  SELECT CURRENT_TIMESTAMP(),
  OBJECT_CONSTRUCT(*)
  FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
• D. SHOW WAREHOUSES;
  INSERT INTO VWH_META
  SELECT CURRENT_TIMESTAMP(), *
  FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

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

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