- (Exam Topic 3)
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

1. A. SELECT SUM (ORDER_AMT) FROM SALES;
2. B. SELECT AVG(ORDER_QTY) FROM SALES;
3. C. SELECT MIN(ORDER_AMT) FROM SALES;
4. D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Correct Answer: B

- (Exam Topic 2)
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

1. A. Okta Verify
2. B. Duo Mobile
3. C. Microsoft Authenticator
4. D. Google Authenticator

Correct Answer: B
https://docs.snowflake.com/en/user-guide/security-mfa.html

- (Exam Topic 2)
True or False: A Virtual Warehouse can be resized while suspended.

1. A. True
2. B. False

Correct Answer: A
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse

- (Exam Topic 3)
What is the minimum Snowflake edition required for row level security?

1. A. Standard
2. B. Enterprise
3. C. Business Critical
4. D. Virtual Private Snowflake

Correct Answer: B

- (Exam Topic 1)
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

1. A. True
2. B. False

Correct Answer: A
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.