Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 541:

  What can a Snowflake user do with the information included in the details section of a Query Profile?

  A. Determine the total duration of the query.

  B. Determine the role of the user who ran the query.

  C. Determine the source system that the queried table is from.

  D. Determine if the query was on structured or semi-structured data.

  Correct Answer: A

• Question 542:

  Which commands support a multiple-statement request to access and update Snowflake data? (Choose two.)

  A. CALL

  B. COMMIT

  C. GET

  D. PUT

  E. ROLLBACK

  Correct Answer: BE

• Question 543:

  Why should a Snowflake user implement a secure view? (Choose two.)

  A. To store unstructured data

  B. To increase query performance

  C. To limit access to sensitive data

  D. To optimize query concurrency and queuing

  E. To hide view definition and details from unauthorized users

  Correct Answer: CE

• Question 544:

  How do Snowflake data providers share data that resides in different databases?

  A. External tables

  B. Secure views

  C. Materialized views

  D. User-Defined Functions (UDFs)

  Correct Answer: B

• Question 545:

  What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Choose two.)

  A. Performing aggregate calculations

  B. Reordering the columns

  C. Grouping by operations

  D. Converting the datatypes

  E. Selecting the first few rows

  Correct Answer: BD

• Question 546:

  What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Choose two.)

  A. Bytes spilled to local cache.

  B. Bytes spilled to local storage.

  C. Bytes spilled to remote cache.

  D. Bytes spilled to remote storage.

  E. Bytes spilled to remote metastore.

  Correct Answer: BD

• Question 547:

  What type of columns does Snowflake recommend to be used as clustering keys? (Choose two.)

  A. A VARIANT column

  B. A column with very low cardinality

  C. A column with very high cardinality

  D. A column that is most actively used in selective filters

  E. A column that is most actively used in join predicates

  Correct Answer: DE

• Question 548:

  Which objects together comprise a namespace in Snowflake? (Choose two.)

  A. Account

  B. Database

  C. Schema

  D. Table

  E. Virtual warehouse

  Correct Answer: BC

• Question 549:

  At which point is data encrypted when using a PUT command?

  A. When it reaches the virtual warehouse

  B. When it gets micro-partitioned

  C. Before it is sent from the user's machine

  D. After it reaches the internal stage

  Correct Answer: C

• Question 550:

  How does Snowflake reorganize data when it is loaded? (Choose two.)

  A. Binary format

  B. Columnar format

  C. Compressed format

  D. Raw format

  E. Zipped format

  Correct Answer: BC