Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 201:

  Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

  A. A directory table is a separate database object.

  B. Directory tables store data file metadata.

  C. A directory table will be automatically added to a stage.

  D. Directory tables do not have their own grantable privileges.

  E. Directory table data can not be refreshed manually.

  Correct Answer: BD

• Question 202:

  Using variables in Snowflake is denoted by using which SQL character?

  A. @

  B. and

  C. $

  D. #

  Correct Answer: C

• Question 203:

  True or False: Snowpipe via REST API can only reference External Stages as source.

  A. True

  B. False

  Correct Answer: B

  Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

• Question 204:

  Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

  A. Tri-Secret Secure

  B. Time Travel

  C. Fail-safe

  D. Data encryption

  E. External stages

  Correct Answer: BC

• Question 205:

  What is the minimum Snowflake edition that has column-level security enabled?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake

  Correct Answer: B

• Question 206:

  Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

  A. Bytes sent over network

  B. Percentage scanned from cache

  C. Partitions total

  D. Bytes spilled to local storage

  E. Partitions scanned

  Correct Answer: CE

• Question 207:

  What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

  A. Reader

  B. Consumer

  C. Vendor

  D. Standard

  E. Personalized

  Correct Answer: DE

• Question 208:

  What is the default file size when unloading data from Snowflake using the COPY command?

  A. 5 MB

  B. 8 GB

  C. 16 MB

  D. 32 MB

  Correct Answer: C

• Question 209:

  Which feature allows a user the ability to control the organization of data in a micro-partition?

  A. Range Partitioning

  B. Search Optimization Service

  C. Automatic Clustering

  D. Horizontal Partitioning

  Correct Answer: C

• Question 210:

  Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

  A. STRIP_NULL_VALUES

  B. SKIP_BYTE_ORDER_MARK

  C. REPLACE_INVALID_CHARACTERS

  D. VALIDATION_MODE

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified: