Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 121:

  Which command can be used to load data into an internal stage?

  A. LOAD

  B. copy

  C. GET

  D. PUT

  Correct Answer: D

  https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

• Question 122:

  Which of the following compute resources or features are managed by Snowflake? (Select TWO).

  A. Execute a COPY command

  B. Updating data

  C. Snowpipe

  D. AUTOMATIC__CLUSTERING

  E. Scaling up a warehouse

  Correct Answer: CD

• Question 123:

  The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

  A. Users

  B. Tables

  C. Databases

  D. Internal Stages

  Correct Answer: BCD

• Question 124:

  How often are encryption keys automatically rotated by Snowflake?

  A. 30 Days

  B. 60 Days

  C. 90 Days

  D. 365 Days

  Correct Answer: A

  All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is

  automatically destroyed.

  https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is%20automatically%20destroyed.

• Question 125:

  When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

  A. A single join node uses more than 50% of the query time

  B. Partitions scanned is equal to partitions total

  C. An AggregateOperacor node is present

  D. The query is spilling to remote storage

  Correct Answer: D

• Question 126:

  What are the default Time Travel and Fail-safe retention periods for transient tables?

  A. Time Travel-1 day. Fail-safe-1 day

  B. Time Travel-0 days. Fail-safe-1 day

  C. Time Travel-1 day. Fail-safe-0 days

  D. Transient tables are retained in neither Fail-safe nor Time Travel

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help%20manageandtext=Temporary%20tables%20can%20also%20have,have%20no%20Fail%2Dsafe% 20period.

• Question 127:

  What can be used to view warehouse usage over time? (Select Two).

  A. The load HISTORY view

  B. The Query history view

  C. The show warehouses command

  D. The WAREHOUSE_METERING__HISTORY View

  E. The billing and usage tab in the Snowflake web Ul

  Correct Answer: DE

• Question 128:

  Which command can be used to stage local files from which Snowflake interface?

  A. SnowSQL

  B. Snowflake classic web interface (Ul)

  C. Snowsight

  D. .NET driver

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/snowsql-use.html

• Question 129:

  Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

  A. The table contains a column that has very low cardinality

  B. DML statements that are being issued against the table are blocked

  C. The table has a small number of micro-partitions

  D. Queries on the table are running slower than expected

  E. The clustering depth for the table is large

  Correct Answer: DE

• Question 130:

  What is the default File Format used in the COPY command if one is not specified?

  A. CSV

  B. JSON

  C. Parquet

  D. XML

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html