Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 111:

  What is a limitation of a Materialized View?

  A. A Materialized View cannot support any aggregate functions

  B. A Materialized View can only reference up to two tables

  C. A Materialized View cannot be joined with other tables

  D. A Materialized View cannot be defined with a JOIN

  Correct Answer: D

  There are several limitations to using materialized views:

  A materialized view can query only a single table.

  Joins, including self-joins, are not supported.

• Question 112:

  True or False: Fail-safe can be disabled within a Snowflake account.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

  Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .

• Question 113:

  True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

  A. True

  B. False

  Correct Answer: A

• Question 114:

  Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

  A. Pipes

  B. Streams

  C. Tasks

  D. Procedures

  Correct Answer: B

  https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20change.

• Question 115:

  What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

  A. Via the Snowflake Web Interface (Ul)

  B. Via the data_share=true parameter

  C. Via SQL commands

  D. Via Virtual Warehouses

  Correct Answer: AC

  Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html

• Question 116:

  Which of the following describes how clustering keys work in Snowflake?

  A. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

  B. Clustering keys sort the designated columns over time, without blocking DML operations

  C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

  D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

  Correct Answer: B

• Question 117:

  Will data cached in a warehouse be lost when the warehouse is resized?

  A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

  B. Yes. because the compute resource is replaced in its entirety with a new compute resource.

  C. No. because the size of the cache is independent from the warehouse size

  D. Yes. became the new compute resource will no longer have access to the cache encryption key

  Correct Answer: A

• Question 118:

  Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

  A. Internal stages

  B. Incremental backups

  C. Time Travel

  D. Zero-copy clones

  E. Fail-safe

  Correct Answer: CE

  Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.

  Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):

  Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel. Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.

  https://docs.snowflake.com/en/user-guide/data-availability.html

• Question 119:

  What are value types that a VARIANT column can store? (Select TWO)

  A. STRUCT

  B. OBJECT

  C. BINARY

  D. ARRAY

  E. CLOB

  Correct Answer: BD

  Characteristics of a VARIANT

  A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

  https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.

• Question 120:

  A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?

  A. Create a task that runs a copy into operation from an external stage every 5 minutes

  B. Create a task that puts the files in an internal stage and automate the data loading wizard

  C. Create a task that runs a GET operation to intermittently check for new files

  D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html