SnowPro Core Recertification Practice Exam

Join Us Among the Stars

Sign Up & unlock 100% of Exam Questions

Log in / Sign up

No Strings Attached!

60Practice Questions

3Study Modes

Free

TopicSort

Question 1

Data Loading and Transformation

Streams can be configured to query change data on which Snowflake objects? (Choose two.)

A Pipe
B Stage
C Secure view
D Materialized view
E Shared table

Question 2

Data Engineering

Question 3

Account and Security

Question 4

Data Protection

Question 5

SQL

Question 6

Data Engineering

Question 7

Account and Security

Question 8

Data Protection

Question 9

Data Loading and Transformation

Question 10

SQL

Question 11

Account and Security

Question 12

Account and Security

Question 13

Account and Security

Question 14

Account and Security

Question 15

Data Loading and Transformation

Question 16

SQL

Question 17

SQL

Question 18

Account and Security

Question 19

Data Protection

Question 20

Data Engineering

Question 21

Data Engineering

Question 22

Account and Security

Question 23

Data Loading and Transformation

Question 24

Data Engineering

That's the end of the Preview

This exam has 60 community-verified practice questions. Create a free account to access all questions, comments, and explanations.

Topics covered:

Data EngineeringData Loading and TransformationSQLData ProtectionAccount and Security

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 60

1 2 3

→

Know a question that should be here? Contribute to this exam

Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

A Area chart
B Box plot
C Heat grid
D Pie chart

What does a Notify & Suspend action for a resource monitor do?

A Send an alert notification to all account users who have notifications enabled.
B Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.
C Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
D Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?

A READ
B REFERENCES
C REFERENCE_USAGE
D USAGE

Which types of subqueries does Snowflake support? (Choose two.)

A Uncorrelated scalar subqueries in WHERE clauses
B Uncorrelated scalar subqueries in any place that a value expression can be used
C EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only
D EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated only
E EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

Question 6

Data Engineering

Question 7

Account and Security

Question 8

Data Protection

Question 9

Data Loading and Transformation

Question 10

SQL

Question 11

Account and Security

Question 12

Account and Security

Question 13

Account and Security

Question 14

Account and Security

Question 15

Data Loading and Transformation

Question 16

SQL

Question 17

SQL

Question 18

Account and Security

Question 19

Data Protection

Question 20

Data Engineering

Question 21

Data Engineering

Question 22

Account and Security

Question 23

Data Loading and Transformation

Question 24

Data Engineering

What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

A The type of SQL statements executed
B The number of tables or databases queried
C The amount of data stored in the warehouse
D The length of time the compute resources in each cluster run

Which governance feature is supported by all Snowflake editions?

A Object tags
B Masking policies
C Row access policies
D OBJECT_DEPENDENCIES view

A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.
What table type should be used?

A Permanent
B Transient
C Temporary
D External

When does a materialized view get suspended in Snowflake?

A When a column is added to the base table
B When a column is dropped from the base table
C When a DML operation is run on the base table
D When the base table is reclustered

Which function returns the URL of a stage using the stage name as the input?

A BUILD_STAGE_FILE_URL
B BUILD_SCOPED_FILE_URL
C GET_PRESIGNED_URL
D GET_STAGE_LOCATION

What happens when a suspended virtual warehouse is resized in Snowflake?

A It will return an error.
B It will return a warning.
C The suspended warehouse is resumed and new compute resources are provisioned immediately.
D The additional compute resources are provisioned when the warehouse is resumed.

How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

A ACCESS_HISTORY
B LOAD_HISTORY
C QUERY_HISTORY
D REST_EVENT_HISTORY

The property MINS_TO_BYPASS_NETWORK_POLICY is set at which level?

A User
B Role
C Account
D Organization

Which pages are included in the Activity area of Snowsight? (Choose two.)

A Contacts
B Sharing settings
C Copy History
D Query History
E Automatic Clustering History

What command is used to export or unload data from Snowflake?

A PUT @mystage
B GET @mystage
C COPY INTO @mystage
D INSERT @mystage

Which Query Profile category displays the time spent setting up the query processing?

A Initialization
B Processing
C Synchronization
D Local Disk IO

Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?

A BUILD_SCOPED_FILE_URL
B BUILD_STAGE_FILE_URL
C GET_ABSOLUTE_PATH
D GET_PRESIGNED_URL

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

A DATA_RETENTION_TIME_IN_DAYS
B MAX_DATA_EXTENSION_TIME_IN_DAYS
C MIN_DATA_RETENTION_TIME_IN_DAYS
D MAX_CONCURRENCY_LEVEL

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

A Account
B Database
C Schema
D Table

What type of function returns one value for each invocation?

A Aggregate
B Scalar
C Table
D Window

What persistent data structures are used by the search optimization service to improve the performance of point lookups?

A Micro-partitions
B Clustering keys
C Equality searches
D Search access paths

A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.
What will Snowflake do if the user's IP address does not match the user-level network policy rules?

A Log the user out.
B Deactivate the network policy.
C Prevent the user from executing additional queries.
D Allow the user to continue until the session or login token expires.

When a Snowflake user loads CSV data from a stage, which COPY INTO <table> command guideline should they follow?

A The CSV field delimiter must be a comma character (',').
B The number of columns in each row should be consistent.
C The data file in the stage must be in a compressed format.
D The data file must have the same number of columns as the target table.

Which statements describe benefits of Snowflake's separation of compute and storage? (Choose two.)

A The separation allows independent scaling of computing resources.
B The separation ensures consistent data encryption across all virtual data warehouses.
C The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
D Storage volume growth and compute usage growth can be tightly coupled.
E Compute can be scaled up or down without the requirement to add more storage.

Join Us Among the Stars

SnowPro Core RecertificationPreview

About the SnowPro Core Recertification Exam

Mode Selection

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

That's the end of the Preview

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24