In which layer of its architecture does Snowflake store its metadata statistics?

• A.Storage Layer
• B.Compute Layer
• C.Database Layer
• D.Cloud Services Layer

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

True or False: Snowflake charges additional fees to Data providers for each share they create.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

• A.Access history
• B.Data classification
• C.Dynamic Data Masking
• D.Object tagging

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

• A.Growth of storage and compute are tightly coupled together
• B.Storage expands without the requirement to add more compute
• C.Compute can be scaled up or down without the requirement to add more storage
• D.Multiple compute clusters can access stored data without contention

Comment: *

Name: *

Email: *

Verification: *