SnowPro-Core Exam - SnowPro Core Certification Exam

NEW QUESTION 1

What can be used to view warehouse usage over time? (Select Two).

• A. The load HISTORY view
• B. The Query history view
• C. The show warehouses command
• D. The WAREHOUSE_METERING HISTORY View
• E. The billing and usage tab in the Snowflake web Ul

Answer: DE

NEW QUESTION 2

What happens when a cloned table is replicated to a secondary database? (Select TWO)

• A. A read-only copy of the cloned tables is stored.
• B. The replication will not be successful.
• C. The physical data is replicated
• D. Additional costs for storage are charged to a secondary account
• E. Metadata pointers to cloned tables are replicated

Answer: CD

Explanation:
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.
https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and

NEW QUESTION 3

What is the purpose of multi-cluster virtual warehouses?

• A. To create separate data warehouses to increase query optimization
• B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
• C. To eliminate or reduce Queuing of concurrent queries
• D. To allow the warehouse to resize automatically

Answer: C

Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehous

NEW QUESTION 4

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

• A. Materialized views
• B. Sequences
• C. Procedures
• D. Tables
• E. Secure User Defined Functions (UDFs)

Answer: DE

Explanation:
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

NEW QUESTION 5

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

• A. True
• B. False

Answer: A

Explanation:
Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

NEW QUESTION 6

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

• A. Schema Stage
• B. User Stage
• C. Database Stage
• D. Table Stage
• E. External Named Stage
• F. Internal Named Stage

Answer: AEF

NEW QUESTION 7

Which command can be used to stage local files from which Snowflake interface?

• A. SnowSQL
• B. Snowflake classic web interface (Ul)
• C. Snowsight
• D. .NET driver

Answer: A

Explanation:
https://docs.snowflake.com/en/user-guide/snowsql-use.html

NEW QUESTION 8

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

NEW QUESTION 9

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

• A. SHOW GRANTS ON ROLE DATA_SCIENCE
• B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
• C. SHOW GRANTS TO USER INQUISITIVE_PERSON
• D. SHOW GRANTS OF ROLE DATA_SCIENCE

Answer: B

NEW QUESTION 10

How long is the Fail-safe period for temporary and transient tables?

• A. There is no Fail-safe period for these tables.
• B. 1 day
• C. 7 days
• D. 31 days
• E. 90 days

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

NEW QUESTION 11

User-level network policies can be created by which of the following roles? (Select TWO).

• A. ROLEADMIN
• B. ACCOUNTADMIN
• C. SYSADMIN
• D. SECURITYADMIN
• E. USERADMIN

Answer: DE

Explanation:
By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can create a network policy to allow or deny access to a single IP address or a list of addresses. Network policies currently support only Internet Protocol version 4 (i.e. IPv4) addresses.
An administrator with sufficient permissions can create any number of network policies. https://docs.snowflake.com/en/user-guide/network-policies.html#:~:text=A%20security%20administrator%20(o

NEW QUESTION 12

True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

NEW QUESTION 13

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

• A. Execute a COPY command
• B. Updating data
• C. Snowpipe
• D. AUTOMATIC__CLUSTERING
• E. Scaling up a warehouse

Answer: AD

NEW QUESTION 14

When should a multi-cluster warehouse be used in auto-scaling mode?

• A. When it is unknown how much compute power is needed
• B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
• C. If the runtime of the executed query is very slow
• D. When a large number of concurrent queries are run on the same warehouse

Answer: D

NEW QUESTION 15

True or False: Users are able to see the result sets of queries executed by other users that share their same role.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

NEW QUESTION 16

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

• A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
• B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
• C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
• D. A user cannot specify a default warehouse when using the ODBC driver.
• E. The default virtual warehouse size can be changed at any time.

Answer: A

NEW QUESTION 17

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?

• A. PURGE
• B. MODIFY
• C. REMOVE
• D. DELETE

Answer: D

Explanation:
Reference:
https://www.simplilearn.com/tutorials/sql-tutorial/delete-in-sql#:~:text=The%20Delete%20command%20in%20

NEW QUESTION 18

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

Answer: C

Explanation:
Bulk data load
Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as
the statement output.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%20da

NEW QUESTION 19
......