A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.
How can this be achieved?

• A.Flatten the data and store it in structured data types in a flattened table. Query the table.
• B.Store the data in a table with a variant data type. Query the table.
• C.Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.
• D.Store the data in an external stage and create views on top of it. Query the views.

Comment: *

Name: *

Email: *

Verification: *

What is a limitation of a Materialized View?

• A.A Materialized View cannot support any aggregate functions
• B.A Materialized View can only reference up to two tables
• C.A Materialized View cannot be joined with other tables
• D.A Materialized View cannot be defined with a JOIN

Comment: *

Name: *

Email: *

Verification: *

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

• A.Extended time travel
• B.Database replication and failover
• C.Customer managed keys (Tri-secret secure)
• D.Automated index management
• E.Native support for geospatial data

Comment: *

Name: *

Email: *

Verification: *

True or False: Once created, a micro-partition will never be changed.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

What is the default character set used when loading CSV files into Snowflake?

• A.UTF-8
• B.UTF-16
• C.ISO S859-1
• D.ANSI_X3.A

Comment: *

Name: *

Email: *

Verification: *