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
Which common query problems are identified by the Query Profile? (Choose two.)
Answer: BD
Choose two. So best two. From https://docs.snowflake.com/en/user-guide/ui-query-profile. Pruning - information on the effects of table pruning. Spilling — information about disk usage for operations where intermediate results do not fit in memory.
Source: Adapted from community discussion — Mike722
While running a query on a virtual warehouse in auto-scale mode, additional clusters are started immediately if which setting is configured?
Answer: C
Auto-scale: ↑ max If new_max_clusters > running_clusters, no changes until additional clusters are needed. ↓ max If new_max_clusters running_clusters, additional clusters immediately started to meet the minimum. ↓ min If new_min_clusters < running_clusters, excess clusters shut down when they finish executing statements and the scaling policy conditions are met.
Source: Adapted from community discussion — Gudref
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
Answer: D
SECURITYADMIN (Security Administrator): -This role can manage any object grant globally. -It has the ability to create, monitor, and manage users and roles. -It is granted the MANAGE GRANTS security privilege to be able to modify any grant, including revoking it. -It inherits the privileges of the USERADMIN role via the system role hierarchy.
Source: Adapted from community discussion — Mike722
What is the MINIMUM permission needed to access a file URL from an external stage?
Answer: D
A security review identified several roles that are no longer being used. Which of the roles can be dropped?
Answer: C
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
Answer: C
In the Data Exchange, who can get or request data from the listings? (Choose two.)
Answer: AD
All users can browse listings in the Data Exchange, but only users with the ACCOUNTADMIN role or the IMPORT SHARE privilege can get or request data.
Source: Adapted from community discussion — nexerSnow
How can a Snowflake user automate virtual warehouse operations for optimal credit consumption? (Choose two.)
Answer: AE
What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?
Answer: A
Answer A If any of the compute resources for the warehouse fail to provision during start-up, Snowflake attempts to repair the failed resources. https://docs.snowflake.com/en/user-guide/warehouses-tasks
Source: Adapted from community discussion — tidz
Which data protection feature should only be used when all other data recovery options have been attempted?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1211. 1323 questions available.
Version 1.0.0. How we source questions