Free SnowPro Core Certification Exam SnowPro-Core Exam Practice Test

- (Exam Topic 1) Which data type can be used to store geospatial data in Snowflake?

• Variant
• Object
• Geometry
• Geography

- (Exam Topic 2) A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?

• Organize files into logical paths
• Store the files on the external stage to ensure caching is maintained
• Use pattern matching for regular expression execution
• Load the data in one large file

- (Exam Topic 2) What is the purpose of multi-cluster virtual warehouses?

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

- (Exam Topic 2) What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

• The Pipe load history is reset to empty.
• The REFRESH command is executed.
• The stage will be purged.
• The destination table is truncated.

- (Exam Topic 3) Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).

• Search optimization service
• Automatic clustering
• Row access policies
• Multi-cluster virtual warehouses
• Secure views

- (Exam Topic 3) What action can a user take to address query concurrency issues?

• Enable the query acceleration service.
• Enable the search optimization service.
• Add additional clusters to the virtual warehouse
• Resize the virtual warehouse to a larger instance size.

- (Exam Topic 2) By default, which Snowflake role is required to create a share?

• ORGADMIN
• SECURITYADMIN
• SHAREADMIN
• ACCOUNTADMIN

- (Exam Topic 1) Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

• Customer-managed encryption keys through Tri-Secret Secure
• Automatic encryption of all data
• Up to 90 days of data recovery through Time Travel
• Object-level access control
• Column-level security to apply data masking policies to tables and views

- (Exam Topic 3) How do Snowflake data providers share data that resides in different databases?

• External tables
• Secure views
• Materialized views
• User-Defined Functions (UDFs)

- (Exam Topic 1) The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

• Users
• Tables
• Databases
• Internal Stages