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 interfaces can be used to create and/or manage Virtual Warehouses?
Answer: D
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html A warehouse can be created through the web interface or using SQL: Classic Web Interface Click on Warehouses Warehouses tab » Create SQL Execute a CREATE WAREHOUSE command.
Source: Adapted from community discussion — Graghu
What are the benefits of the replication feature in Snowflake? (Choose two.)
Answer: AD
Which of the following roles are recommended to create and manage users and roles? (Choose two.)
Answer: BE
When can a newly configured virtual warehouse start running SQL queries?
Answer: C
Answer - C. Snowflake does not begin executing SQL statements submitted to a warehouse until all of the compute resources for the warehouse are successfully provisioned, unless any of the resources fail to provision. Ref: https://docs.snowflake.com/en/user-guide/warehouses-tasks# A would be correct for a warehouse that is repaired.
Source: Adapted from community discussion — isolated_sniper
What actions will prevent leveraging of the ResultSet cache?
Answer: A
Which of the following are benefits of micro-partitioning? (Choose two.)
Answer: BC
As wrote here: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html#benefits-of-micro-partitioning - In contrast to traditional static partitioning, Snowflake micro-partitions are derived automatically; they don’t need to be explicitly defined up-front or maintained by users. - As the name suggests, micro-partitions are small in size (50 to 500 MB, before compression), which enables extremely efficient DML and fine-grained pruning for faster queries. - Micro-partitions can overlap in their range of values, which, combined with their uniformly small size, helps prevent skew. - Columns are stored independently within micro-partitions, often referred to as columnar storage. This enables efficient scanning of individual columns; only the columns referenced by a query are scanned. So - A is False (3rd point) - D is False because the sort is decided from "how the data is inserted" - E is False (1st point)
Source: Adapted from community discussion — BigDataBB
Which data type can be used to store geospatial data in Snowflake?
Answer: D
Snowflake provides the following data types for geospatial data: The GEOGRAPHY data type, which models Earth as though it were a perfect sphere. The GEOMETRY data type, which represents features in a planar (Euclidean, Cartesian) coordinate system.
Source: Adapted from community discussion — Kate0204
If all virtual warehouse resources are maximized while processing a query workload, what will happen to new queries that are submitted to the warehouse?
Answer: D
Masking policies can be applied to which of the following Snowflake objects? (Choose two.)
Answer: AC
Creates a new masking policy in the current/specified schema or replaces an existing masking policy. After creating a masking policy, apply the masking policy to a column in a table using an ALTER TABLE … ALTER COLUMN command or a view using an ALTER VIEW command. https://docs.snowflake.com/en/sql-reference/sql/create-masking-policy.html#normal-masking-policy
Source: Adapted from community discussion — halol
What actions are supported by Snowflake resource monitors? (Choose two.)
Answer: BC
Resource monitors support the following actions: Notify & Suspend Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses after all statements being executed by the warehouse(s) have completed. Notify & Suspend Immediately Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses immediately, which cancels any statements being executed by the warehouses at the time. Notify Perform no action, but send an alert notification (to all account administrators with notifications enabled).
Source: Adapted from community discussion — learner2023
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 471. 1323 questions available.
Version 1.0.0. How we source questions