Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

• A.REFERENCE_USAGE on databases
• B.CREATE_SHARE on the account
• C.SHARE on databases and schemas
• D.SELECT on tables used by the secure view

Comment: *

Name: *

Email: *

Verification: *

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: *

Which common query problems are identified by the Query Profile? (Select TWO.)

• A.Inefficient pruning
• B.Syntax error
• C.Ambiguous column names
• D.Object does not exist or not authorized
• E.Queries too large to fit in memory

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake native tool can be used to diagnose and troubleshoot network connections?

• A.SnowSQL
• B.Snowflake Python connector
• C.Snowsight
• D.SnowCD

Comment: *

Name: *

Email: *

Verification: *

What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?

• A.Use Snowflake's native API.
• B.Use a custom-built connector.
• C.Contact Snowflake Support for a new driver.
• D.Connect through Snowflake's JDBC or ODBC drivers

Comment: *

Name: *

Email: *

Verification: *