Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 61:

  The Snowflake Search Optimization Services supports improved performance of which kind of query?

  A. Queries against large tables where frequent DML occurs

  B. Queries against tables larger than 1 TB

  C. Selective point lookup queries

  D. Queries against a subset of columns in a table

  Correct Answer: C

  Reference: https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimization%20service%20can%20improve%20the%20performance%20of%20point,OBJECT%2C%20and%20ARRAY% 20columns)

• Question 62:

  When should a multi-cluster warehouse be used in auto-scaling mode?

  A. When it is unknown how much compute power is needed

  B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

  C. If the runtime of the executed query is very slow

  D. When a large number of concurrent queries are run on the same warehouse

  Correct Answer: D

• Question 63:

  What is the maximum Time Travel retention period for a temporary Snowflake table?

  A. 90 days

  B. 1 day

  C. 7 days

  D. 45 days

  Correct Answer: B

• Question 64:

  User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

  Which command will show all privileges granted to that schema?

  A. SHOW GRANTS ON ROLE DATA_SCIENCE

  B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

  C. SHOW GRANTS TO USER INQUISITIVE_PERSON

  D. SHOW GRANTS OF ROLE DATA_SCIENCE

  Correct Answer: B

• Question 65:

  Which of the following statements apply to Snowflake in terms of security? (Choose two.)

  A. Snowflake leverages a Role-Based Access Control (RBAC) model.

  B. Snowflake requires a user to configure an IAM user to connect to the database.

  C. All data in Snowflake is encrypted.

  D. Snowflake can run within a user's own Virtual Private Cloud (VPC).

  E. All data in Snowflake is compressed.

  Correct Answer: AC

• Question 66:

  Which of the following are best practices for loading data into Snowflake? (Choose three.)

  A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

  B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

  C. Enclose fields that contain delimiter characters in single or double quotes.

  D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

  E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

  F. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

  Correct Answer: ACD

• Question 67:

  When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

  A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.

  B. An error will occur, as views with qualified references cannot be cloned.

  C. An error will occur, as stored objects cannot be cloned.

  D. The stored procedures and views will refer to tables in the source database.

  Correct Answer: D

• Question 68:

  What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/replication-intro.html#business-continuity-and-disaster-recovery

• Question 69:

  Which of the following can be used when unloading data from Snowflake? (Choose two.)

  A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

  B. Use the ENCODING file format option to change the encoding from the default UTF-8.

  C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

  D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

  E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

  Correct Answer: CD

• Question 70:

  The Snowflake Cloud Data Platform is described as having which of the following architectures?

  A. Shared-disk

  B. Shared-nothing

  C. Multi-cluster shared data

  D. Serverless query engine

  Correct Answer: C