- (Exam Topic 3)
Which statement is true about running tasks in Snowflake?

1. A. A task can be called using a CALL statement to run a set of predefined SQL commands.
2. B. A task allows a user to execute a single SQL statement/command using a predefined schedule.
3. C. A task allows a user to execute a set of SQL commands on a predefined schedule.
4. D. A task can be executed using a SELECT statement to run a predefined SQL command.

Correct Answer: C

- (Exam Topic 2)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

1. A. SCIM
2. B. Federated authentication
3. C. TLS 1.2
4. D. Key-pair authentication
5. E. OAuth
6. F. OCSP authentication

Correct Answer: BDE

- (Exam Topic 2)
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).

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

Correct Answer: AD

- (Exam Topic 3)
What are common issues found by using the Query Profile? (Choose two.)

1. A. Identifying queries that will likely run very slowly before executing them
2. B. Locating queries that consume a high amount of credits
3. C. Identifying logical issues with the queries
4. D. Identifying inefficient micro-partition pruning
5. E. Data spilling to a local or remote disk

Correct Answer: AD

- (Exam Topic 3)
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

1. A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
2. B. Scaling out adds clusters of varying sizes to a virtual warehouse.
3. C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
4. D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
5. E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
6. F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Correct Answer: AE