Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 221:

  What is the recommended compressed file size range for continuous data loads using Snowpipe?

  A. 8-16 MB

  B. 16-24 MB

  C. 10-99 MB

  D. 100-250 MB

  Correct Answer: D

• Question 222:

  Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

  A. Query execution

  B. Data loading

  C. Time Travel data

  D. Security

  E. Authentication and access control

  Correct Answer: DE

  all the rest are not mentioned as a cloud services service https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

• Question 223:

  A running virtual warehouse is suspended.

  What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

  A. 1 second

  B. 60 seconds

  C. 5 minutes

  D. 60 minutes

  Correct Answer: B

• Question 224:

  What are common issues found by using the Query Profile? (Choose two.)

  A. Identifying queries that will likely run very slowly before executing them

  B. Locating queries that consume a high amount of credits

  C. Identifying logical issues with the queries

  D. Identifying inefficient micro-partition pruning

  E. Data spilling to a local or remote disk

  Correct Answer: DE

• Question 225:

  What impacts the credit consumption of maintaining a materialized view? (Choose two.)

  A. Whether or not it is also a secure view

  B. How often the underlying base table is queried

  C. How often the base table changes

  D. Whether the materialized view has a cluster key defined

  E. How often the materialized view is queried

  Correct Answer: CD

• Question 226:

  Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

  A. Amazon Web Services

  B. Docker

  C. IBM Cloud

  D. Microsoft Azure Cloud

  E. Google Cloud Platform

  F. Oracle Cloud

  Correct Answer: ADE

• Question 227:

  How are serverless features billed?

  A. Per second multiplied by an automatic sizing for the job

  B. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

  C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

  D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

  Correct Answer: A

• Question 228:

  Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

  A. Schemas

  B. Roles

  C. Secure Views

  D. Stored Procedures

  E. Tables

  F. Secure User-Defined Functions (UDFs)

  Correct Answer: CEF

• Question 229:

  How can a user change which columns are referenced in a view?

  A. Modify the columns in the underlying table

  B. Use the ALTER VIEW command to update the view

  C. Recreate the view with the required changes

  D. Materialize the view to perform the changes

  Correct Answer: C

  https://docs.snowflake.com/en/sql-reference/sql/alter-view.html#alter-view

• Question 230:

  Which of the following objects are contained within a schema? (Choose two.)

  A. Role

  B. Stream

  C. Warehouse

  D. External table

  E. User

  F. Share

  Correct Answer: BD