Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 21:

  Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

  A. Number of users

  B. Warehouse size

  C. Amount of data processed

  D. # of clusters for the Warehouse

  Correct Answer: BD

  https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage

  "Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."

• Question 22:

  Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

  A. Is available to all Snowflake Editions

  B. Is only available to customers with Business Critical Edition

  C. Restricts or enables access to specific IP addresses

  D. Is activated using an "ALTER DATABASE" command

  Correct Answer: AC

  Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

• Question 23:

  Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

  A. To accommodate more queries

  B. To accommodate more users

  C. To accommodate fluctuations in workload

  D. To accommodate a more complex workload

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html

• Question 24:

  True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

  A. True

  B. False

  Correct Answer: A

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

• Question 25:

  The PUT command: (Choose two.)

  A. Automatically creates a File Format object

  B. Automatically uses the last Stage created

  C. Automatically compresses files using Gzip

  D. Automatically encrypts files

  Correct Answer: CD

  Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html

• Question 26:

  Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

  A. Scaling rhythmically

  B. Scaling max

  C. Scaling out

  D. Scaling Up

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out "Scale out by adding warehouses to a multi-cluster warehouse"

• Question 27:

  True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/ui-worksheet.html

• Question 28:

  True or False: Snowflake charges a premium for storing semi-structured data.

  A. True

  B. False

  Correct Answer: B

  Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data

• Question 29:

  True or False: Pipes can be suspended and resumed.

  A. True

  B. False

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes

  Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:

• Question 30:

  If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

  A. All Snowflake sessions using the warehouse are terminated.

  B. The last query using the warehouse completes.

  C. There are no users loaned into Snowflake.

  D. The Warehouse is inactive for a specified period of time.

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html