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 result shows efficient pruning?
Answer: B
https://docs.snowflake.com/en/user-guide/ui-query-profile#inefficient-pruning ... The efficiency of pruning can be observed by comparing Partitions scanned and Partitions total statistics in the TableScan operators. If the former is a small fraction of the latter, pruning is efficient. If not, the pruning did not have an effect. ...
Source: Adapted from community discussion — gizzamo
Which clustering indicator will show if a large table in Snowflake will benefit from explicitly defining a clustering key?
Answer: B
Clustering Depth The clustering depth for a populated table measures the average depth (1 or greater) of the overlapping micro-partitions for specified columns in a table. The smaller the average depth, the better clustered the table is with regards to the specified columns. Clustering depth can be used for a variety of purposes, including: Monitoring the clustering “health” of a large table, particularly over time as DML is performed on the table. Determining whether a large table would benefit from explicitly defining a clustering key.
Source: Adapted from community discussion — nexerSnow
Which file format is MOST performant in Snowflake for data loading?
Answer: B
Loading from Gzipped CSV is several times faster than loading from ORC and Parquet at an impressive 15 TB/Hour. While 5-6 TB/hour is decent if your data is originally in ORC or Parquet, don’t go out of your way to CREATE ORC or Parquet files from CSV in the hope that it will load Snowflake faster. https://community.snowflake.com/s/article/How-to-Load-Terabytes-Into-Snowflake-Speeds-Feeds-and-Techniques#:~:text=Loading%20data%20into%20Snowflake%20is,into%20fully%20structured%20Snowflake%20tables.
Source: Adapted from community discussion — SV1122
What is to be expected when sharing worksheets in Snowsight?
Answer: B
Worksheets in Snowsight use unique sessions with specific roles and warehouses assigned in the context of the worksheet. To view shared query results, the Snowflake user must use the same role as the session context for the worksheet. https://docs.snowflake.com/en/user-guide/ui-snowsight-worksheets-gs.html#sharing-worksheets-and-folders
Source: Adapted from community discussion — SV1122
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Answer: B
Which table type is automatically deleted after a session is closed and has no Fail-safe or Time Travel cost?
Answer: A
Which constraint type is enforced in Snowflake from the ANSI SQL standard?
Answer: D
Snowflake supports defining and maintaining constraints, but does not enforce them, except for NOT NULL constraints, which are always enforced. https://docs.snowflake.com/en/sql-reference/constraints-overview.html
Source: Adapted from community discussion — SnowProCertDec22
What is the maximum compressed row size in Snowflake?
Answer: B
MAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.
Source: Adapted from community discussion — arpit_dataguy
Which function is used to profile warehouse credit usage?
Answer: D
What is a characteristic of the Snowflake query profiler?
Answer: B
Query Profile is a feature in the Snowflake UI that gives you detailed insights into the execution of a query. It contains a visual representation of the query plan, with all nodes and links represented. Execution details and statistics are provided for each node as well as the overall query.
Source: Adapted from community discussion — muks86
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 641. 1323 questions available.
Version 1.0.0. How we source questions