- (Exam Topic 2)
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

1. A. The ability to scale up warehouses
2. B. The use of warehouse auto scaling
3. C. The ability to resize warehouses
4. D. Use of multi-clustered warehouses
5. E. The use of warehouse indexing

Correct Answer: BD

- (Exam Topic 2)
When is the result set cache no longer available? (Select TWO)

1. A. When another warehouse is used to execute the query
2. B. When another user executes the query
3. C. When the underlying data has changed
4. D. When the warehouse used to execute the query is suspended
5. E. When it has been 24 hours since the last query

Correct Answer: CE

- (Exam Topic 3)
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

1. A. CONTENT
2. B. PATH
3. C. BYTE_SIZE
4. D. INDEX
5. E. DATATYPE

Correct Answer: BC

- (Exam Topic 1)
Which of the following statement is true of Snowflake? Select one.

1. A. It was built specifically for the cloud
2. B. it was built as an on-premises solution and then potted to the cloud
3. C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
4. D. It was built for Hadoop architecture
5. E. It's based on an Oracle Architecture

Correct Answer: A

- (Exam Topic 3)
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

1. A. Schema Stage
2. B. User Stage
3. C. Database Stage
4. D. Table Stage
5. E. External Named Stage
6. F. Internal Named Stage

Correct Answer: AEF