- (Exam Topic 1)
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

1. A. Bulk copy from an External Stage
2. B. Continuous load using Snowpipe REST API
3. C. The Snowflake Web Interface (UT) data loading wizard
4. D. Bulk copy from an Internal Stage

Correct Answer: ABC
Reference: https://docs.snowflake.com/en/user-guide/data-load-overview.html

- (Exam Topic 3)
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

1. A. Query execution
2. B. Data loading
3. C. Time Travel data
4. D. Security
5. E. Authentication and access control

Correct Answer: BD

- (Exam Topic 1)
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers

1. A. MIN(< < column value>>)
2. B. COPY
3. C. SUM(<< column value >>)
4. D. UPDATE

Correct Answer: BCD

- (Exam Topic 2)
Which cache type is used to cache data output from SQL queries?

1. A. Metadata cache
2. B. Result cache
3. C. Remote cache
4. D. Local file cache

Correct Answer: B
https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

- (Exam Topic 1)
Which interfaces can be used to create and/or manage Virtual Warehouses?

1. A. The Snowflake Web Interface (UI)
2. B. SQL commands
3. C. Data integration tools
4. D. All of the above

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/warehouses.html