Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 191:

  Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

  A. Management of metadata

  B. Computing the data

  C. Maintaining Availability Zones

  D. Infrastructure security

  E. Parsing and optimizing queries

  Correct Answer: AE

• Question 192:

  What actions will prevent leveraging of the ResultSet cache? (Choose two.)

  A. Removing a column from the query SELECT list

  B. Stopping the virtual warehouse that the query is running against

  C. Clustering of the data used by the query

  D. Executing the RESULTS_SCAN() table function

  E. Changing a column that is not in the cached query

  Correct Answer: AC

• Question 193:

  A user has a standard multi-cluster warehouse auto-scaling policy in place. Which condition will trigger a cluster to shut-down?

  A. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

  B. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

  C. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

  D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

  Correct Answer: D

• Question 194:

  Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

  A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

  B. A Data Exchange allows groups of accounts to share data privately among the accounts.

  C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.

  D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

  E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

  Correct Answer: BE

• Question 195:

  How would a user execute a series of SQL statements using a task?

  A. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..

  B. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();

  C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

  D. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

  Correct Answer: C

  https://community.snowflake.com/s/question/0D53r00009kC6WhCAK/can-a-task-have-multiple-sql-queries

• Question 196:

  Which of the following statements describe features of Snowflake data caching? (Choose two.)

  A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

  B. When the data cache is full, the least-recently used data will be cleared to make room.

  C. A user can only access their own queries from the query result cache.

  D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

  E. The RESULT_SCAN table function can access and filter the contents of the query result cache.

  Correct Answer: BE

• Question 197:

  A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

  How can this worksheet be shared?

  A. Create a zero-copy clone of the worksheet and grant permissions to teammates

  B. Create a private Data Exchange so that any teammate can use the worksheet

  C. Share the worksheet with teammates within Snowsight

  D. Create a database and grant all permissions to teammates

  Correct Answer: C

• Question 198:

  What happens to historical data when the retention period for an object ends?

  A. The data is cloned into a historical object.

  B. The data moves to Fail-safe

  C. Time Travel on the historical data is dropped.

  D. The object containing the historical data is dropped.

  Correct Answer: D

• Question 199:

  How many resource monitors can be assigned at the account level?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: A

• Question 200:

  In a Snowflake role hierarchy, what is the top-level role?

  A. SYSADMIN

  B. ORGADMIN

  C. ACCOUNTADMIN

  D. SECURITYADMIN

  Correct Answer: C