When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

• A.Partitions scanned is equal to partitions total
• B.The query is spilling to remote storage
• C.A single join node uses more than 50% of the query time
• D.An AggregateOperacor node is present

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.Increase the warehouse size from Medium to 2XL.
• D.Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Comment: *

Name: *

Email: *

Verification: *

What is the minimum Snowflake edition that provides data sharing?

• A.Business Critical Edition
• B.Standard
• C.Enterprise
• D.Premier

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

• A.The validation_mode option is used when creating an Internal Stage
• B.validation_mode=return_all_errors is a parameter of the copy command
• C.The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
• D.The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Comment: *

Name: *

Email: *

Verification: *

What SQL command would be used to view all roles that were granted to user.1?

• A.show grants of user USER1;
• B.show grants to user USER1;
• C.describe user USER1;
• D.show grants on user USER1;

Comment: *

Name: *

Email: *

Verification: *