What internal stages are available in Snowflake? (Choose three.)

• A.Table stage
• B.Named stage
• C.Database stage
• D.Schema stage
• E.Stream stage
• F.User stage

Comment: *

Name: *

Email: *

Verification: *

True or False: Data Providers can share data with only the Data Consumer.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which data type can be used to store geospatial data in Snowflake?

• A.Variant
• B.Object
• C.Geometry
• D.Geography

Comment: *

Name: *

Email: *

Verification: *

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

• A.It removes the last element of the outer array.
• B.It removes the outer array structure and loads the records into separate table rows,
• C.It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
• D.It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Comment: *

Name: *

Email: *

Verification: *

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