Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 401:

  What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?

  A. 1 Kilobyte (KB)

  B. 1 Megabyte (MB)

  C. 1 Gigabyte (GB)

  D. 1 Terabyte (TB)

  Correct Answer: D

• Question 402:

  Which function will return a row for each for each object in a VARIANT, OBJECT, or ARRAY column?

  A. CAST

  B. FLATTEN

  C. GET

  D. PARSE_JSON

  Correct Answer: B

• Question 403:

  What is the default period of time the Warehouse Activity section provides a graph of Snowsight activity?

  A. 2 hours

  B. 1 week

  C. 2 weeks

  D. 1 month

  Correct Answer: C

• Question 404:

  How do managed access schemas help with data governance?

  A. They log all operations and enable fine-grained auditing.

  B. They provide centralized privilege management with the schema owner.

  C. They enforce identical privileges across all tables and views in a schema.

  D. They require the use of masking and row access policies across every table and view in the schema.

  Correct Answer: B

• Question 405:

  What command would a user execute to load unstructured data files into a Snowflake internal stage?

  A. PUT

  B. GET

  C. LIST

  D. COPY INTO

  Correct Answer: A

• Question 406:

  What is a characteristic of a role in Snowflake?

  A. Roles cannot be granted to other roles.

  B. System-defined roles can be dropped.

  C. Privileges granted to system roles by Snowflake can be revoked.

  D. Privileges on securable objects can be granted and revoked to a role.

  Correct Answer: D

• Question 407:

  Which Snowflake URL type is used by directory tables?

  A. File

  B. Pre-signed

  C. Scoped

  D. Virtual-hosted style

  Correct Answer: A

• Question 408:

  What is required for a query execution to be served from the result cache?

  A. The user is the same.

  B. The SQL texts the same.

  C. The SQL query profile is the same.

  D. The virtual warehouse is the same.

  Correct Answer: B

• Question 409:

  How is the MANAGE GRANTS privilege applied?

  A. Globally

  B. At the database level

  C. At the schema level

  D. At the table level

  Correct Answer: A

• Question 410:

  A Snowflake user wants to unload data from a relational table sized 5 GB using CSV. The extract needs to be as performant as possible.

  What should the user do?

  A. Use Parquet as the unload file format, using Parquet's default compression feature.

  B. Use a regular expression in the stage specification of the COPY command to restrict parsing time.

  C. Increase the default MAX_FILE_SIZE to 5 GB and set SINGLE = true to produce a single file.

  D. Leave the default MAX_FILE_SIZE to 16 MB to take advantage of parallel operations.

  Correct Answer: D