Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 411:

  For a multi-cluster virtual warehouse, which parameters are used to calculate the number of credits billed? (Choose two.)

  A. Cache size

  B. Warehouse size

  C. Number of clusters

  D. Volume of data processed

  E. Number of queries executed

  Correct Answer: BC

• Question 412:

  Which privileges are required for a user to restore an object? (Choose two.)

  A. UPDATE

  B. OWNERSHIP

  C. MODIFY

  D. UNDROP

  E. CREATE

  Correct Answer: BE

• Question 413:

  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 414:

  What is the abbreviated form to get all the files in the stage for the current user?

  A. LIST @~;

  B. LS @~;

  C. LS @usr;

  D. SHOW @%;

  Correct Answer: B

• Question 415:

  When unloading data from Snowflake, what is the default file size of each file?

  A. 16 MB

  B. 32 MB

  C. 64 MB

  D. 5 GB

  Correct Answer: A

• Question 416:

  What happens when the values for both an ALLOWED_IP_LIST and a BLOCKED_IP_LIST are used in a network policy?

  A. Snowflake ignores the BLOCKED_IP_LIST first.

  B. Snowflake applies the BLOCKED_IP_LIST first.

  C. Snowflake applies the ALLOWED_IP_LIST first.

  D. Snowflake ignores the ALLOWED_IP_LIST first.

  Correct Answer: B

• Question 417:

  There are 300 concurrent users on a production Snowflake account using a single cluster virtual warehouse. The queries are small, but the response time is very slow.

  What is causing this to occur?

  A. The warehouse is queuing the queries, increasing the overall query execution time.

  B. The warehouse parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set too low.

  C. The application is not using the latest native ODBC driver which is causing latency.

  D. The queries are not taking advantage of the data cache.

  Correct Answer: A

• Question 418:

  What is the MAXIMUM number of days that Snowflake resets the 24-hour retention period for a query result every time the result is used?

  A. 1 day

  B. 10 days

  C. 31 days

  D. 60 days

  Correct Answer: C

• Question 419:

  Which programming languages are supported for Snowflake User-Defined Functions (UDFs)? (Choose two.)

  A. C#

  B. JavaScript

  C. PHP

  D. Python

  E. TypeScript

  Correct Answer: BD

• Question 420:

  How does a Snowflake user reference a directory table created on stage mystage in a SQL query?

  A. SELECT * FROM @mystage::DIRECTORY

  B. SELECT * FROM DIRECTORY (@mystage)

  C. SELECT * FROM TO_TABLE (DIRECTORY @mystage)

  D. SELECT * FROM TABLE (@mystage DIRECTORY)

  Correct Answer: B