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 actions will prevent leveraging of the ResultSet cache? (Choose two.)
Answer: AE
Re-clustering data does not invalidate the ResultSet cache. The cache is based on query text and the state of the data, not how the data is physically stored. Answer: AE
Source: Adapted from community discussion — NPass
Which statement is true about running tasks in Snowflake?
Answer: B
A task can execute any one of the following types of SQL code: Single SQL statement Call to a stored procedure Procedural logic using Snowflake Scripting Developer Guide https://docs.snowflake.com/en/user-guide/tasks-intro.html
Source: Adapted from community discussion — SV1122
Which data types does Snowflake support when querying semi-structured data? (Choose two.)
Answer: AD
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
Answer: B
Only if the system estimates there’s enough query load to keep the cluster busy for at least 6 minutes https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
Source: Adapted from community discussion — miadiesel
What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));
Answer: D
Validates the files loaded in a past execution of the COPY INTO command and returns all the errors encountered during the load, rather than just the first error. https://docs.snowflake.com/en/sql-reference/functions/validate.html
Source: Adapted from community discussion — SV1122
A sales table FCT_SALES has 100 million records. The following query was executed: SELECT COUNT (1) FROM FCT_SALES; How did Snowflake fulfill this query?
Answer: D
The COUNT(1) function is used to count all rows in the specified table. In Snowflake, using COUNT(1) is equivalent to using COUNT(*), as both provide a count of all rows without filtering based on any specific column. The number 1 is simply a placeholder; it does not affect the result. Snowflake optimizes this operation by using metadata statistics, allowing for quick retrieval of row counts without scanning every row.
Source: Adapted from community discussion — kolossal
True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
Answer: A
'in lieu of' == 'instead of'. Yes, Snowflake was built from the ground up, without using something else as a base. So the statement is true and the answer is A.
Source: Adapted from community discussion — sdnv89
What happens when a virtual warehouse is resized?
Answer: B
B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
Source: Adapted from community discussion — Kate0204
What tasks can be completed using the COPY command? (Choose two.)
Answer: CD
yes CD, Note that COPY transformations do not support the FLATTEN function, or JOIN or GROUP BY (aggregate) syntax. https://docs.snowflake.com/en/user-guide/data-load-transform
Source: Adapted from community discussion — girgir
Which Snowflake layer can be configured?
Answer: C
I think answer should be B (Cloud Services) layer can be configured. Ex: Cloud Services layer to use a different network topology. For example, you can configure Snowflake to use a virtual private cloud (VPC) to isolate your data from other users on the Snowflake platform.
Source: Adapted from community discussion — chatrisrinu
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 421. 1323 questions available.
Version 1.0.0. How we source questions