Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 301:

  Several users are using the same virtual warehouse. The users report that the queries are running slowly, and that many queries are being queued.

  What is the recommended way to resolve this issue?

  A. Reduce the warehouse STATEMENT_QUEUED_TIMEOUT_IN SECONDS parameter.

  B. Reduce the warehouse AUTO_SUSPEND parameter.

  C. Increase the warehouse MAX_CONCURRENCY_LIMIT parameter.

  D. Increase the warehouse MAX_CLUSTER_COUNT parameter.

  Correct Answer: D

• Question 302:

  What is the default value in the Snowflake Web Interface (UI) for auto suspending a Virtual Warehouse?

  A. 1 minute

  B. 5 minutes

  C. 10 minutes

  D. 15 minutes

  Correct Answer: C

• Question 303:

  How are micro-partitions typically generated in Snowflake?

  A. Automatically

  B. ORDER BY <>;

  C. PARTITION BY <>;

  D. GROUP BY <>;

  Correct Answer: A

• Question 304:

  Which Snowflake object can be accessed in the FROM clause of a query, returning a set of rows having one or more columns?

  A. A User-Defined Table Function (UDTF)

  B. A Scalar User Defined Function (UDF)

  C. A stored procedure

  D. A task

  Correct Answer: A

• Question 305:

  As a best practice, all custom roles should be granted to which system-defined role?

  A. ACCOUNTADMIN

  B. ORGADMIN

  C. SECURITYADMIN

  D. SYSADMIN

  Correct Answer: D

• Question 306:

  What happens when the size of a virtual warehouse is changed?

  A. Queries that are running on the current warehouse configuration are not impacted.

  B. Queries that are running on the current warehouse configuration are aborted and have to be resubmitted by the user.

  C. Queries that are running on the current warehouse configuration are aborted and are automatically resubmitted.

  D. Queries that are running on the current warehouse configuration are moved to the new configuration and finished there.

  Correct Answer: A

• Question 307:

  What technique does Snowflake recommend for determining which virtual warehouse size to select?

  A. Always start with an X-Small and increase the size if the query does not complete in 2 minutes

  B. Experiment by running the same queries against warehouses of different sizes

  C. Use the default size Snowflake chooses

  D. Use X-Large or above for tables larger than 1 GB

  Correct Answer: B

• Question 308:

  Other than ownership what privileges does a user need to view and modify resource monitors in Snowflake? (Choose two.)

  A. ALTER

  B. MONITOR

  C. MODIFY

  D. CREATE

  E. DROP

  Correct Answer: BC

• Question 309:

  What does Snowflake recommend regarding database object ownership? (Choose two.)

  A. Create objects with ACCOUNTADMIN and do not reassign ownership.

  B. Create objects with SYSADMIN.

  C. Create objects with SECURITYADMIN to ease granting of privileges later.

  D. Create objects with a custom role and grant this role to SYSADMIN.

  E. Use only managed access schemas for objects owned by ACCOUNTADMIN.

  Correct Answer: BD

• Question 310:

  How can a Snowflake user share data with another user who does not have a Snowflake account?

  A. Share the data by implementing User-Defined Functions (UDFs)

  B. Create a reader account and create a share of the data

  C. Grant the READER privilege to the database that is going to be shared

  D. Move the Snowflake account to a region where data sharing is enabled

  Correct Answer: B