Question 1081 · 1323 in bank
Select 2What are key characteristics of virtual warehouses in Snowflake? (Choose two.)
Show answer
Answer: BC
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
What are key characteristics of virtual warehouses in Snowflake? (Choose two.)
Answer: BC
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
Answer: A
Answer: A A. Concurrency is the primary benefit when scaling out by adding clusters to a multi-cluster warehouse. By adding more clusters, you increase the number of compute resources available, which allows the warehouse to handle more queries and users concurrently. This can help prevent bottlenecks and improve overall query performance, but the primary goal of adding clusters is to increase concurrency. B. Performance can also improve as a result of scaling out, but it is not the primary benefit. The main focus is on improving concurrency by enabling more users and queries to be processed simultaneously.
Source: Adapted from community discussion — SteveCrown
What strategies can be used to optimize the performance of a virtual warehouse? (Choose two.)
Answer: AD
AD is correct. Optimizing Warehouses for Performance: 1-Reduce queues (if WH is not multi cluster make it multi cluster else add another WH) 2-Resolve memory spillage ( scale up or convert it to Snowpark-optimized WH) 3-Increase warehouse size (Scale up) 4-Trying Query Acceleration - set ENABLE_QUERY_ACCELERATION = true 5-Optimizing the Warehouse Cache (by increasing Auto-suspension) 6-Limiting Concurrently Running Queries (Decrease the MAX_CONCURRENCY_LEVEL) https://docs.snowflake.com/en/user-guide/performance-query-warehouse
Source: Adapted from community discussion — BobFar
How are privileges inherited in a role hierarchy in Snowflake?
Answer: A
The privileges associated with a role are inherited by any roles above that role in the hierarchy. Do not spam with wrong answer votes
Source: Adapted from community discussion — [Removed]
At what level can the ALLOW_CLIENT_MFA_CACHING parameter be set?
Answer: A
What entity is responsible for hosting and sharing data in Snowflake?
Answer: A
Which function will provide the proxy information needed to protect Snowsight?
Answer: C
C correct To determine the fully qualified URL and port for Snowsight, review the SNOWSIGHT_DEPLOYMENT entry in the return value of the SYSTEM$ALLOWLIST function. https://docs.snowflake.com/en/user-guide/ui-snowsight-gs#accessing-sf-web-interface-through-a-proxy-or-firewall
Source: Adapted from community discussion — BobFar
The property MINS_TO_BYPASS_NETWORK_POLICY is set at which level?
Answer: A
When unloading the data for file format type specified (TYPE = 'CSV'), SQL NULL can be converted to string ‘null’ using which file format option?
Answer: C
Which table function should be used to view details on a Directed Acyclic Graph (DAG) run that is presently scheduled or is executing?
Answer: C
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1081. 1323 questions available.
Version 1.0.0. How we source questions