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 activities are included in the Cloud Services layer? (Choose two.)
Answer: DE
The Cloud Services layer in Snowflake is responsible for critical data-related activities1. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control
Source: Adapted from community discussion — Heetec
When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)
Answer: BC
From snowflake documentation : You might want to consider disabling auto-suspend for a warehouse if: You have a heavy, steady workload for the warehouse. You require the warehouse to be available with no delay or lag time. Warehouse provisioning is generally very fast (e.g. 1 or 2 seconds); however, depending on the size of the warehouse and the availability of compute resources to provision, it can take longer.
Source: Adapted from community discussion — arpit_dataguy
What does the “percentage scanned from cache” represent in the Query Profile?
Answer: D
D Percentage scanned from cache — the percentage of data scanned from the local disk cache. https://docs.snowflake.com/en/user-guide/ui-query-profile Result cache looks differently: it would just say "QUERY RESULT REUSE"
Source: Adapted from community discussion — 0e504b5
Which role has the ability to create a share from a shared database by default?
Answer: A
Which object-level parameters can be set to help control query processing and concurrency? (Choose two).
Answer: DE
D correct - Snowflake provides some object-level parameters that can be set to help control query processing and concurrency: STATEMENT_QUEUED_TIMEOUT_IN_SECONDS STATEMENT_TIMEOUT_IN_SECONDS https://docs.snowflake.com/en/user-guide/warehouses-overview
Source: Adapted from community discussion — Heetec
What metadata does Snowflake store for rows in micro-partitions? (Choose two.)
Answer: AB
What are valid sub-clauses to the OVER clause for a window function? (Choose two.)
Answer: CD
Which kind of Snowflake table stores file-level metadata for each file in a stage?
Answer: A
Which privileges apply to stored procedures? (Choose two.)
Answer: DE
USAGE Enables calling a stored procedure. ALL [ PRIVILEGES ] Grants all privileges, except OWNERSHIP, on the stored procedure. OWNERSHIP Grants full control over the stored procedure; required to alter the stored procedure. Only a single role can hold this privilege on a specific object at a time. Note that in a managed access schema, only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant or revoke privileges on objects in the schema, including future grants.
Source: Adapted from community discussion — romega2
What column type does a Kafka connector store formatted information in a single column?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 981. 1323 questions available.
Version 1.0.0. How we source questions