Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

• A.Each Snowflake account can be hosted in a different cloud vendor and region.
• B.Each Snowflake account must be hosted in a different cloud vendor and region
• C.All Snowflake accounts must be hosted in the same cloud vendor and region
• D.Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Comment: *

Name: *

Email: *

Verification: *

What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

• A.SKIP BYTE ORDER MARK
• B.FIELD_OPTIONALLY_ENCLOSED_BY
• C.ESCAPE_UNENCLOSED_FIELD
• D.BINARY_FORMAT

Comment: *

Name: *

Email: *

Verification: *

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

• A.Sequences
• B.Materialized views
• C.Secure User Defined Functions (UDFs)
• D.Procedures
• E.Tables

Comment: *

Name: *

Email: *

Verification: *

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

• A.The REFRESH command is executed.
• B.The Pipe load history is reset to empty.
• C.The destination table is truncated.
• D.The stage will be purged.

Comment: *

Name: *

Email: *

Verification: *

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

• A.Whether or not it is also a secure view
• B.How often the underlying base table is queried
• C.How often the base table changes
• D.Whether the materialized view has a cluster key defined
• E.How often the materialized view is queried

Comment: *

Name: *

Email: *

Verification: *