Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 521:

  The use of which technique or tool will improve Snowflake query performance on very large tables?

  A. Indexing

  B. Clustering keys

  C. Multi-clustering

  D. Materialized views

  Correct Answer: B

• Question 522:

  Which Snowflake layer is associated with virtual warehouses?

  A. Cloud services

  B. Query processing

  C. Elastic memory

  D. Database storage

  Correct Answer: B

• Question 523:

  Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?

  A. Only while in the ACCOUNTADMIN role

  B. Only while in the SECURITYADMIN role

  C. Only the role with the OWNERSHIP privilege on the network policy

  D. Only Snowflake Support can set the value for this object property

  Correct Answer: D

• Question 524:

  What authentication method does the Kafka connector use within Snowflake?

  A. Key pair authentication

  B. Multi-Factor Authentication (MFA)

  C. OAuth

  D. Username and password

  Correct Answer: A

• Question 525:

  The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)

  A. Views for all the objects contained in the database

  B. Views for all the objects contained in the Snowflake account

  C. Views for historical and usage data across the Snowflake account

  D. Table functions for historical and usage data across the Snowflake account

  E. Table functions for account-level objects, such as roles, virtual warehouses, and databases

  Correct Answer: AD

• Question 526:

  What is the purpose of the Snowflake SPLIT_TO_TABLE function?

  A. To count the number of characters in a string

  B. To split a string into an array of sub-strings

  C. To split a string and flatten the results into rows

  D. To split a string and flatten the results into columns

  Correct Answer: C

• Question 527:

  Which URL provides access to files in Snowflake without authorization?

  A. File URL

  B. Scoped URL

  C. Pre-signed URL

  D. Scoped file URL

  Correct Answer: C

• Question 528:

  What type of NULL values are supported in semi-structured data? (Choose two.)

  A. Avro

  B. JSON

  C. ORC

  D. Parquet

  E. SQL

  Correct Answer: BE

• Question 529:

  What are characteristics of transient tables in Snowflake? (Choose two.)

  A. Transient tables have a Fail-safe period of 7 days.

  B. Transient tables can be cloned to permanent tables.

  C. Transient tables persist until they are explicitly dropped.

  D. Transient tables can be altered to make them permanent tables.

  E. Transient tables have Time Travel retention periods of 0 or 1 day.

  Correct Answer: CE

• Question 530:

  Which function generates a Snowflake hosted file URL to a staged file using the stage name and relative file path as inputs?

  A. BUILD_STAGE_FILE_URL

  B. BUILD_SCOPED_FILE_URL

  C. GET_PRESIGNED_URL

  D. GET_STAGE_LOCATION

  Correct Answer: A