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

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

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes a Snowflake stored procedure?

• A.They can be created as secure and hide the underlying metadata from the user.
• B.They can only access tables from a single database.
• C.They can contain only a single SQL statement.
• D.They can be created to run with a caller's rights or an owner's rights.

Comment: *

Name: *

Email: *

Verification: *

What information does the Query Profile provide?

• A.Graphical representation of the data model
• B.Statistics for each component of the processing plan
• C.Detailed Information about I he database schema
• D.Real-time monitoring of the database operations

Comment: *

Name: *

Email: *

Verification: *

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

• A.Use multi-clustered warehousing to scale out warehouse capacity.
• B.Scale up the warehouse size to allow Queries to execute faster.
• C.Stop and start the warehouse to clear the queued queries
• D.Migrate some queries to a new warehouse to reduce load
• E.Limit user access to the warehouse so fewer queries are run against it.

Comment: *

Name: *

Email: *

Verification: *

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *