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

Comment: *

Name: *

Email: *

Verification: *

Using variables in Snowflake is denoted by using which SQL character?

• A.$
• B.#
• C.@
• D.&

Comment: *

Name: *

Email: *

Verification: *

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

• A.Economy
• B.Custom
• C.Optimized
• D.Standard

Comment: *

Name: *

Email: *

Verification: *

Which cache type is used to cache data output from SQL queries?

• A.Metadata cache
• B.Result cache
• C.Remote cache
• D.Local file cache

Comment: *

Name: *

Email: *

Verification: *

Which item in the Data Warehouse migration process does not apply in Snowflake>

• A.Migrate Indexes
• B.Migrate Users
• C.Migrate Schemas
• D.Build the Data pipeline

Comment: *

Name: *

Email: *

Verification: *