Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

• A.Load files that are approximately 25 MB or smaller.
• B.Remove all dates and timestamps.
• C.Load files that are approximately 100-250 MB (or larger)
• D.Avoid using embedded characters such as commas for numeric data types
• E.Remove semi-structured data types

Comment: *

Name: *

Email: *

Verification: *

What are common issues found by using the Query Profile? (Choose two.)

• A.Identifying queries that will likely run very slowly before executing them
• B.Locating queries that consume a high amount of credits
• C.Identifying logical issues with the queries
• D.Identifying inefficient micro-partition pruning
• E.Data spilling to a local or remote disk

Comment: *

Name: *

Email: *

Verification: *

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which categories are included in the execution time summary in a Query Profile? (Select TWO).

• A.Pruning
• B.Spilling
• C.Initialization
• D.Local Disk I/O
• E.Percentage of data read from cache

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