How can a Snowflake user access a JSON object, given the following table? (Select TWO).

• A.src:salesperson.name
• B.SRC:salesperson.Name
• C.SRC:salesperson.name
• D.src:salesperson.Name
• E.src:sa1esPerson. name

Comment: *

Name: *

Email: *

Verification: *

A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

• A.Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
• B.Configure the warehouse to a multi-cluster warehouse.
• C.Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
• D.Increase the warehouse size from Medium to 2XL.

Comment: *

Name: *

Email: *

Verification: *

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

• A.The listing is replicated into all selected regions automatically, the data is not.
• B.For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
• C.Shares attached to listings in remote regions can be viewed from any account in an organization.
• D.The user must have the ORGADMIN role available in at least one account to link accounts for replication.
• E.There is no need to have a Snowflake account in the target region, a share will be created for each user.

Comment: *

Name: *

Email: *

Verification: *

Network policies can be set at which Snowflake levels? (Choose two.)

• A.Role
• B.Schema
• C.User
• D.Database
• E.Account
• F.Tables

Comment: *

Name: *

Email: *

Verification: *

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

• A.Load files that are approximately 25 MB or smaller.
• B.Remove all dates and timestamps.
• C.Load files that are approximately 100-250 MB (or larger)
• D.Avoid using embedded characters such as commas for numeric data types
• E.Remove semi-structured data types

Comment: *

Name: *

Email: *

Verification: *