Which Snowflake object does not consume any storage costs?

• A.Secure view
• B.Materialized view
• C.Temporary table
• D.Transient table

Comment: *

Name: *

Email: *

Verification: *

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

• A.Optimizes the virtual warehouse size and multi-cluster setting to economy mode
• B.Allows a user to import the files in a sequential order
• C.Increases the latency staging and accuracy when loading the data
• D.Allows optimization of parallel operations

Comment: *

Name: *

Email: *

Verification: *

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

• A.Clone the data from the production account to the non-production account.
• B.Create a data share from the production account to the non-production account.
• C.Create a subscription in the production account and have it publish to the non-production account.
• D.Create a reader account using the production account and link the reader account to the non-production account.

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements are true of Snowflake data loading? (Choose three.)

• A.It is recommended to use staging tables to manage MERGE statements
• B.VARIANT "null" values are not the same as SQL NULL values
• C.It is recommended to validate the data before loading into the Snowflake target table
• D.It is recommended to do frequent, single row DMLs

Comment: *

Name: *

Email: *

Verification: *

How long does Snowflake retain information in the ACCESS HISTORY view?

• A.7 days
• B.365 days
• C.14 days
• D.28 days

Comment: *

Name: *

Email: *

Verification: *