Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 611:

  Which of the following are true of multi-cluster Warehouses? Select all that apply below.

  A. A multi-cluster Warehouse can add clusters automatically based on query activity

  B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

  C. A multi-cluster Warehouse can scale down when query activity slows

  D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

  Correct Answer: ABCD

• Question 612:

  which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

  A. Bulk copy from an External Stage

  B. Continuous load using Snowpipe REST API

  C. The Snowflake Web Interface (UT) data loading wizard

  D. Bulk copy from an Internal Stage

  Correct Answer: ABCD

  Reference: https://docs.snowflake.com/en/user-guide/data-load-overview.html

• Question 613:

  A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

  A. The tables are now orphaned

  B. The user that deleted the role

  C. SYSADMIN

  D. The assumed role that dropped the role

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html

• Question 614:

  True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

  A. True

  B. False

  Correct Answer: B

  Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

• Question 615:

  What is the maximum compressed row size in Snowflake?

  A. 8KB

  B. 16MB

  C. 50MB

  D. 4000GB

  Correct Answer: B

  MAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.

• Question 616:

  Which object allows you to limit the number of credits consumed within a Snowflake account? Select one.

  A. Account usage Tracking

  B. Resource Monitor

  C. Warehouse Limit Parameter

  D. Credit Consumption Tracker

  Correct Answer: B

  The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."

• Question 617:

  True or False: Snowpipe via RFST API can only reference External Stages as source.

  A. True

  B. False

  Correct Answer: B

  Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

• Question 618:

  If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

  A. 4

  B. 16

  C. 32

  D. 128

  Correct Answer: A

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

• Question 619:

  What happens when a Data Provider revokes privileges to a Share on an object in their source database?

  A. The object immediately becomes unavailable for all Data Consumers

  B. Any additional data arriving after this point in time will not be visible to Data Consumers

  C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object

  D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

  Correct Answer: A

• Question 620:

  True or False: A single database can exist in more than one Snowflake account.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html