A user runs a query on a large table using a Medium virtual warehouse. The same query is then run on the same table by a different user using a different warehouse.
Which caches will be used?

• A.Local disk cache and metadata cache
• B.Query result cache and warehouse cache
• C.Warehouse cache and metadata cache
• D.Metadata cache and query result cache

Comment: *

Name: *

Email: *

Verification: *

How does Snowflake ensure the integrity and consistency of data stored in tables?

• A.Dynamic Data Masking
• B.Row-level encryption
• C.Constraints
• D.Time Travel

Comment: *

Name: *

Email: *

Verification: *

Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

• A.Binary file in Avro
• B.Binary file in Parquet
• C.Comma-separated JSON
• D.Newline Delimited JSON
• E.Plain text file containing XML elements

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

What is the recommended compressed file size range for continuous data loads using Snowpipe?

• A.8-16 MB
• B.16-24 MB
• C.10-99 MB
• D.100-250 MB

Comment: *

Name: *

Email: *

Verification: *