Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 131:

  What is a best practice after creating a custom role?

  A. Create the custom role using the SYSADMIN role.

  B. Assign the custom role to the SYSADMIN role

  C. Assign the custom role to the PUBLIC role

  D. Add__CUSTOM to all custom role names

  Correct Answer: B

  When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

• Question 132:

  What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

  A. Data is hashed by the cluster key to facilitate fast searches for common data values

  B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

  C. Smaller micro-partitions are created for common data values to allow for more parallelism

  D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

  Correct Answer: D

• Question 133:

  In which use cases does Snowflake apply egress charges?

  A. Data sharing within a specific region

  B. Query result retrieval

  C. Database replication

  D. Loading data into Snowflake

  Correct Answer: C

  nowflake charges a per-byte fee for data egress when users transfer data from a Snowflake account into a different region on the same cloud platform or into a completely different cloud platform. Data transfers within the same region are free.

• Question 134:

  What happens when a virtual warehouse is resized?

  A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

  B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

  C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

  D. Users who are trying to use the warehouse will receive an error message until the resizing is complete

  Correct Answer: B

• Question 135:

  What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

  A. Data can be filtered by an optional where clause

  B. Incoming data can be joined with other tables

  C. Columns can be reordered

  D. Columns can be omitted

  E. Row level access can be defined

  Correct Answer: CD

• Question 136:

  Which stage type can not be altered and dropped?

  A. Database stage

  B. External stage

  C. Table stage

  D. User stage

  Correct Answer: B

• Question 137:

  How long is Snowpipe data load history retained?

  A. As configured in the create pipe settings

  B. Until the pipe is dropped

  C. 64 days

  D. 14 days

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/functions/pipe_usage_history.html

• Question 138:

  When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

  A. 10-50 MB

  B. 100-250 MB

  C. 300-500 MB

  D. 1000-1500 MB

  Correct Answer: B

• Question 139:

  What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

  A. The warehouse size does not change until all queries currently running in the warehouse have completed.

  B. The warehouse size does not change until all queries currently in the warehouse queue have completed.

  C. The warehouse size does not change until the warehouse is suspended and restarted.

  D. It does not return from the command until the warehouse has finished changing its size.

  Correct Answer: D

• Question 140:

  What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

  A. 30 days

  B. 7 days

  C. 48 hours

  D. 24 hours

  Correct Answer: D