Who can create network policies within Snowflake? (Select TWO).

• A.SYSADMIN only
• B.ORCADMIN only
• C.SECURITYADMIN or higher roles
• D.A role with the CREATE NETWORK POLICY privilege
• E.A role with the CREATE SECURITY INTEGRATION privilege

Comment: *

Name: *

Email: *

Verification: *

Which cache type is used to cache data output from SQL queries?

• A.Metadata cache
• B.Result cache
• C.Remote cache
• D.Local file cache

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

Comment: *

Name: *

Email: *

Verification: *

What features does Snowflake Time Travel enable?

• A.Querying data-related objects that were created within the past 365 days
• B.Analyzing data usage/manipulation over all periods of time
• C.Restoring data-related objects that have been deleted within the past 90 days
• D.Conducting point-in-time analysis for Bl reporting

Comment: *

Name: *

Email: *

Verification: *

A user wants to access stored in a stage without authenticating into Snowflake.
Which type of URL should be used?

• A.File URL
• B.Staged URL
• C.Scoped URL
• D.Pre-signed URL

Comment: *

Name: *

Email: *

Verification: *