A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

• A.The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
• B.The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
• C.The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
• D.The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed

Comment: *

Name: *

Email: *

Verification: *

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

• A.SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
  FROM ACCOUNT_USAGE.USERS;
• B.SELECT EVENT_TIMESTAMP, USER_NAME
  FROM table(information_schema.login_history_by_user())
• C.SELECT EVENT_TIMESTAMP, USER_NAME
  FROM ACCOUNT_USAGE.ACCESS_HISTORY;
• D.SELECT EVENT_TIMESTAMP, USER_NAME
  FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Comment: *

Name: *

Email: *

Verification: *

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

What is the minimum Snowflake edition required to create a materialized view?

• A.Standard Edition
• B.Enterprise Edition
• C.Business Critical Edition
• D.Virtual Private Snowflake Edition

Comment: *

Name: *

Email: *

Verification: *