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(),
  OBJECT_CONSTRUCT(*)
  FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
• B. SHOW WAREHOUSES;
  INSERT INTO VWH_META
  SELECT CURRENT_TIMESTAMP(), *
  FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
• C. SHOW WAREHOUSES;
  INSERT INTO VWH_META
  SELECT CURRENT_TIMESTAMP(), *
  FROM TABLE(RESULT_SCAN(SELECT LAST_QUERY_ID(-1)));
• D. SHOW WAREHOUSES;
  INSERT INTO VWH_META
  SELECT CURRENT_TIMESTAMP(),
  FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(1)));

What steps are required to set up OKTAAPI token integration in Snowflake?

• A. create or replace security integration okta_provisioning
  type = scim
  scim_client = 'okta'
  run_as_role = 'OKTA PROVISIONER';
  Update this step every 6 months.
• B. grant role okta_provisioner to role ACCOUNTADMIN;
  create or replace security integration okta_provisioning
  type = scim
  scim_client = 'okta'
  run_as_role = 'OKTA PROVISIONER';
  Update these steps every 12 months.
• C. use role ACCOUNTADMIN;
  select system$ generate_scim_access_token ('OKTA PROVISIONING');
  Update these steps every 12 months.
• D. use role ACCOUNTADMIN;
  select system$ generate_scim_access_token ('OKTA PROVISIONING');
  Update these steps every 6 months.

An organization's sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONE_NO
FROM CUSTOMERS
WHERE LAST_UPDATED BETWEEN TO_DATE(CURRENT_TIMESTAMP) AND (TO_DATE(CURRENT_TIMESTAMP)-7);
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?

• A. Assign everyone on the sales team to the same security role.
• B. Leverage the CURRENT_DATE function for date calculations.
• C. Assign everyone on the sales team to the same virtual warehouse.
• D. Wrap the query in a User-Defined Function (UDF) to match syntax execution.

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

• A. ACCOUNTADMIN and SECURITYADMIN
• B. ACCOUNTADMIN and SYSADMIN
• C. ACCOUNTADMIN only
• D. Any role with GRANT USAGE on SECURITY INTEGRATION