Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 371:

  Which URL type does Snowflake recommend to use when providing unstructured data to other accounts through a share?

  A. File

  B. Pre-signed

  C. Scoped

  D. Staged

  Correct Answer: C

• Question 372:

  What is the difference between a stored procedure and a User-Defined Function (UDF)?

  A. Stored procedures can execute database operations while UDFs cannot.

  B. Returning a value is required in a stored procedure while returning values in a UDF is optional.

  C. Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

  D. Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

  Correct Answer: A

• Question 373:

  What information is included in the display in the Query Profile? (Choose two.)

  A. Index hints used in query

  B. Credit usage details

  C. Clustering keys details

  D. Details and statistics for the overall query

  E. Graphical representation of the query processing plan

  Correct Answer: DE

• Question 374:

  How does Snowflake handle the bulk unloading of data into single or multiple files?

  A. It assigns each unloaded data file a unique name.

  B. It uses the PUT command to download the data by default.

  C. It uses COPY INTO for bulk unloading where the default option is SINGLE = TRUE.

  D. It uses COPY INTO to copy the data from a table into one or more files in an external stage only.

  Correct Answer: A

• Question 375:

  A Snowflake user wants to share data with someone who does not have a Snowflake account.

  How can the Snowflake user share the data?

  A. Use the Snowflake Marketplace.

  B. Create a reader account.

  C. Create a consumer account.

  D. Use a Snowflake share.

  Correct Answer: B

• Question 376:

  What command is used to export or unload data from Snowflake?

  A. PUT @mystage

  B. GET @mystage

  C. Copy INTO @mystage

  D. INSERT @mystage

  Correct Answer: C

• Question 377:

  A user wants to add additional privileges to the system-defined roles for their virtual warehouse.

  How does Snowflake recommend they accomplish this?

  A. Grant the additional privileges to a custom role.

  B. Grant the additional privileges to the ACCOUNTADMIN role.

  C. Grant the additional privileges to the SYSADMIN role.

  D. Grant the additional privileges to the ORGADMIN role.

  Correct Answer: C

• Question 378:

  What is the MAXIMUM number of days a Snowflake-managed encryption key can be used before it gets automatically rotated?

  A. 1 day

  B. 14 days

  C. 30 days

  D. 120 days

  Correct Answer: C

• Question 379:

  How does Snowflake store a table's underlying data? (Choose two.)

  A. Columnar file format

  B. Micro-partitions

  C. Text file format

  D. Uncompressed

  E. User-defined partitions

  Correct Answer: AB

• Question 380:

  Which user object property requires contacting Snowflake Support in order to set a value for it?

  A. DISABLED

  B. MINS_TO_BYPASS MFA

  C. MINS_TO_BYPASS_NETWORK_POLICY

  D. MINS_TO_UNLOCK

  Correct Answer: C