Which of the following statements describe features of Snowflake data caching? (Choose two.)

• A.When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
• B.The RESULT_SCAN table function can access and filter the contents of the query result cache.
• C.A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
• D.A user can only access their own queries from the query result cache.
• E.When the data cache is full, the least-recently used data will be cleared to make room.

Comment: *

Name: *

Email: *

Verification: *

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

• A.SELECT SUM (ORDER_AMT) FROM SALES;
• B.SELECT AVG(ORDER_QTY) FROM SALES;
• C.SELECT MIN(ORDER_AMT) FROM SALES;
• D.SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Comment: *

Name: *

Email: *

Verification: *

Which of the following can be used when unloading data from Snowflake? (Choose two.)

• A.When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
• B.Use the ENCODING file format option to change the encoding from the default UTF-8.
• C.The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
• D.By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
• E.Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Comment: *

Name: *

Email: *

Verification: *

What is a best practice after creating a custom role?

• A.Create the custom role using the SYSADMIN role.
• B.Assign the custom role to the SYSADMIN role
• C.Assign the custom role to the PUBLIC role
• D.Add__CUSTOM to all custom role names

Comment: *

Name: *

Email: *

Verification: *

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *