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 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
• B.The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
• C.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
• D.The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period

Comment: *

Name: *

Email: *

Verification: *

Which user object property requires contacting Snowflake Support in order to set a value for it?

• A.MINS TO BYPASS NETWORK POLICY
• B.MINS TO UNLOCK
• C.MINS TO BYPASS MFA
• D.DISABLED

Comment: *

Name: *

Email: *

Verification: *

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

• A.grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
• B.grant SELECT on all tables in database DB1 to role MYROLE;
• C.grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
• D.grant SELECT on future tables in database DB1 to role MYROLE;
• E.grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
• F.grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

Comment: *

Name: *

Email: *

Verification: *

What is the MINIMUM permission needed to access a file URL from an external stage?

• A.MODIFY
• B.READ
• C.SELECT
• D.USAGE

Comment: *

Name: *

Email: *

Verification: *

A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?

• A.When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
• B.When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
• C.When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
• D.When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Comment: *

Name: *

Email: *

Verification: *