Will data cached in a warehouse be lost when the warehouse is resized?

• A.Yes. became the new compute resource will no longer have access to the cache encryption key
• B.No. because the size of the cache is independent from the warehouse size
• C.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
• D.Yes. because the compute resource is replaced in its entirety with a new compute resource.

Comment: *

Name: *

Email: *

Verification: *

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

• A.Use secure materialized views.
• B.Use dynamic data masking.
• C.Use data encryption.
• D.Revoke all roles for functional managers and end users.

Comment: *

Name: *

Email: *

Verification: *

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

• A.ORC
• B.XML
• C.Avro
• D.Parquet
• E.JSON

Comment: *

Name: *

Email: *

Verification: *

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

• A.Micro-partitions have been reclustered since the query was last run
• B.The query includes a User Defined Function (UDF)
• C.The new query is run using the same virtual warehouse as the previous query
• D.The query has been run within 24 hours of the previously-run query
• E.The user has the appropriate privileges on the objects associated with the query

Comment: *

Name: *

Email: *

Verification: *

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *