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 governance feature is supported by all Snowflake editions?
Answer: D
D is correct answer Object tags, Masking Policies and Row Access Policies are for Enterprise and above editions. The only option remaining is Object Dependency Source: https://docs.snowflake.com/en/user-guide/intro-editions
Source: Adapted from community discussion — VenkataPhaniPavanKumar
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
Answer: C
True or False: You can resize a Virtual Warehouse while queries are running.
Answer: A
At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Answer: A
Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
Answer: B
Computes the Jaro-Winkler similarity between two input strings. The function returns an integer between 0 and 100, where 0 indicates no similarity and 100 indicates an exact match.
Source: Adapted from community discussion — nexerSnow
Which Snowflake data governance feature can support auditing when a user query reads column data?
Answer: A
What is the MINIMUM Snowflake edition that supports data sharing?
Answer: A
Which categories are included in the execution time summary in a Query Profile? (Choose two.)
Answer: CD
https://docs.snowflake.com/en/user-guide/ui-query-profile Execution Time Execution time provides information about “where the time was spent” during the processing of a query. Time spent can be broken down into the following categories, displayed in the following order: Processing — time spent on data processing by the CPU. Local Disk IO — time when the processing was blocked by local disk access. Remote Disk IO — time when the processing was blocked by remote disk access. Network Communication — time when the processing was waiting for the network data transfer. Synchronization — various synchronization activities between participating processes. Initialization — time spent setting up the query processing.
Source: Adapted from community discussion — 0e504b5
Which command can be used to list all network policies available in an account?
Answer: D
Which type of loop requires a BREAK statement to stop executing?
Answer: B
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1271. 1323 questions available.
Version 1.0.0. How we source questions