Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 151:

  The is the minimum Fail-safe retention time period for transient tables?

  A. 1 day

  B. 7 days

  C. 12 hours

  D. 0 days

  Correct Answer: D

• Question 152:

  Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

  A. Caching query results

  B. Running EXPLAIN and SHOW commands

  C. Cloning a database

  D. Running a custom query

  E. Running COPY commands

  Correct Answer: DE

  A warehouse provides the required resources, such as CPU, memory, and temporary storage, to perform the following operations in a Snowflake session:

  Executing SQL SELECT statements that require compute resources (e.g. retrieving rows from tables and views).

  Performing DML operations, such as:

  Updating rows in tables (DELETE , INSERT , UPDATE).

  Loading data into tables (COPY INTO [table]).

  Unloading data from tables (COPY INTO ).

  Note - To perform these operations, a warehouse must be running and in use for the session. While a warehouse is running, it consumes Snowflake credits.

  https://docs.snowflake.com/en/user-guide/warehouses.html

• Question 153:

  Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

  A. Pre-signed URL

  B. Scoped URL

  C. Signed URL

  D. File URL

  Correct Answer: A

  Pre-signed URLs are used to download or access files, via a web browser for example, without authenticating into Snowflake or passing an authorization token. These URLs are ideal for business intelligence applications or reporting tools that need to display the unstructured file contents.

• Question 154:

  A virtual warehouse is created using the following command:

  Create warehouse my_WH with

  warehouse_size = MEDIUM

  min_cluster_count = 1

  max_cluster_count = 1

  auto_suspend = 60

  auto_resume = true;

  The image below is a graphical representation of the warehouse utilization across two days.

  

  What action should be taken to address this situation?

  A. Increase the warehouse size from Medium to 2XL.

  B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

  C. Configure the warehouse to a multi-cluster warehouse.

  D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

  Correct Answer: C

• Question 155:

  What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

  A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

  B. Scaling out adds clusters of varying sizes to a virtual warehouse.

  C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

  D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

  E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.

  F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

  Correct Answer: AE

• Question 156:

  How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

  A. Configure the warehouse to a size larger than generally required

  B. Set the minimum and maximum clusters to autoscale

  C. Use the standard warehouse scaling policy

  D. Use the economy warehouse scaling policy

  Correct Answer: C

• Question 157:

  Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

  A. Configure the user to be initially disabled.

  B. Force an immediate password change.

  C. Set a default role for the user.

  D. Set the number of minutes to unlock to 15 minutes.

  E. Set the user's access to expire within a specified timeframe.

  Correct Answer: BC

• Question 158:

  Which of the following accurately describes shares?

  A. Tables, secure views, and secure UDFs can be shared

  B. Shares can be shared

  C. Data consumers can clone a new table from a share

  D. Access to a share cannot be revoked once granted

  Correct Answer: A

• Question 159:

  Which formats does Snowflake store unstructured data in? (Choose two.)

  A. GeoJSON

  B. Array

  C. XML

  D. Object

  E. BLOB

  Correct Answer: BD

• Question 160:

  Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

  A. Files

  B. External tables

  C. Secure User-Defined Functions (UDFs)

  D. Sequences

  E. Streams

  Correct Answer: BC