A company's table, employees, was accidentally replaced with a new version.

How can the original table be recovered with the LEAST operational overhead?

• A. Revert to the original employees table using this command:
  UNDROP TABLE employees;
• B. Use Time Travel with a timestamp to recover the data using this command:
  SELECT *
  FROM employees
  AT (TIMESTAMP => '2022-07-22 16:35:00.000 -0700'::TIMESTAMP_TZ);
• C. Rename the new employees table and undrop the original table using these commands:
  ALTER TABLE employees RENAME TO employees_bad;
  UNDROP TABLE employees;
• D. Use Time Travel to recover the data using this command:
  SELECT *
  FROM employees
  BEFORE (STATEMENT => '01a5c8b3-0601-ad2b-0067-a503000a1312');

An Architect needs to improve the performance of reports that pull data from multiple Snowflake tables, join, and then aggregate the data. Users access the reports using several dashboards. There are performance issues on Monday mornings between 9:00am-11:00am when many users check the sales reports.
The size of the group has increased from 4 to 8 users. Waiting times to refresh the dashboards has increased significantly. Currently this workload is being served by a virtual warehouse with the following parameters:
AUTO-RESUME = TRUE AUTO_SUSPEND = 60 SIZE = Medium
What is the MOST cost-effective way to increase the availability of the reports?

• A. Use a multi-cluster warehouse in auto-scale mode with 1 size Medium cluster, and set min_cluster_count = 1 and max_cluster_count = 4.
• B. Increase the warehouse to size Large and set auto_suspend = 600.
• C. Use a multi-cluster warehouse in maximized mode with 2 size Medium clusters.
• D. Use materialized views and pre-calculate the data.

An Architect is defining transaction rules to adhere to ACID properties to ensure that executed statements are either committed or rolled back. Based on this scenario, what characteristics of transactions should be considered? (Select TWO).

• A. An explicit transaction can be started by executing a BEGIN WORK statement and can be ended by executing a COMMIT WORK statement.
• B. The autocommit setting can be changed inside a stored procedure.
• C. Explicit transactions should contain only DML statements and query statements. All DDL statements implicitly commit active transactions.
• D. Explicit transactions should contain DDL, DML, and query statements.
• E. An explicit transaction can be started by executing a BEGIN TRANSACTION statement and can be ended by executing an END TRANSACTION statement.

An Architect wants to stream website logs near real time to Snowflake using the Snowflake Connector for Kafka.
What characteristics should the Architect consider regarding the different ingestion methods? (Select TWO).

• A. Snowpipe Streaming supports schema detection.
• B. Snowpipe Streaming is the default ingestion method.
• C. Snowpipe Streaming automatically flushes data every one second.
• D. Snowpipe has lower latency than Snowpipe Streaming.
• E. Snowflake can handle jumps or resetting offsets by default.