Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

SnowPro Core by Snowflake - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

What is the most granular object that the Time Travel retention period can be defined on?

A Account
B Database
C Schema
D Table

Question 4

Which task is supported by the use of Access History in Snowflake?

A Data backups
B Cost monitoring
C Compliance auditing
D Performance optimization

Question 5

Which feature of Snowflake’s Continuous Data Protection (CDP) has associated costs?

A Fail-safe
B Network policies
C End-to-end encryption
D Multi-Factor Authentication (MFA)

Question 6

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

A File URL
B Scoped URL
C Relative URL
D Pre-Signed URL

Question 7

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

A Column compression
B Data clustering
C Micro-partitioning
D Metadata management

Question 8

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

A CREATE TABLE [table_name] LIKE TABLE_A;
B CREATE VIEW [view_name] AS SELECT * FROM TABLE_A;
C CREATE TABLE [table_name] AS SELECT * FROM TABLE_A;
D CREATE MATERIALIZED VIEW [view_name] AS SELECT * FROM TABLE_A;

Question 9

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

Question 10

Which function can be used with the COPY INTO [LOCATION] statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file?

A FLATTEN
B OBJECT_AS
C OBJECT_CONSTRUCT
D TO_VARIANT

Question 11

Which type of role can be granted to a share?

A Account role
B Custom role
C Database role
D Secondary role

Question 12

When unloading data with the COPY INTO [location] command, what is the purpose of the PARTITION BY parameter option?

A To sort the contents of the output file by the specified expression.
B To delimit the records in the output file using the specified expression.
C To include a new column in the output using the specified window function expression.
D To split the output into multiple files, one for each distinct value of the specified expression.

Question 13

What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?

A Faster query performance and increased storage consumption
B Slower query performance and increased storage consumption
C Faster query performance and decreased storage consumption
D Slower query performance and decreased storage consumption

Question 14

Which of the following statements is true of Snowflake micro-partitioning?

A Micro-partitioning has been known to introduce data skew
B Micro-partitioning: requires a partitioning schema to be defined up front
C Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
D Micro-partitioning can be disabled within a Snowflake account

Question 15

Which views are included in the DATA_SHARING_USAGE schema? (Choose two.)

A ACCESS_HISTORY
B DATA_TRANSFER_HISTORY
C WAREHOUSE_METERING_HISTORY
D MONETIZED_USAGE_DAILY
E LISTING_TELEMETRY_DAILY

Question 16

What does a table with a clustering depth of 1 mean in Snowflake?

A The table has only 1 micro-partition.
B The table has 1 overlapping micro-partition.
C The table has no overlapping micro-partitions.
D The table has no micro-partitions.

Question 17

Which Snowflake object contains all the information required to share a database?

A Private listing
B Secure view
C Sequence
D Share

Question 18

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

Question 19

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

Question 20

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.

Question 21

A user creates a stage using the following command:

CREATE STAGE mystage -
DIRECTORY = (ENABLE = TRUE)
FILE_FORMAT = myformat;

What will be the outcome?

A A stage with a directory table set to automatically refresh will be created.
B A stage with a directory table that has metadata that must be manually refreshed will be created.
C An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.
D The command will fail to run because the name of the directory table is not specified.

Question 22

Which statistics on a Query Profile reflect the efficiency of the query pruning? (Choose two.)

A Partitions scanned
B Partitions total
C Bytes scanned
D Bytes spilled
E Bytes written

Question 23

Which operation can be performed on Snowflake external tables?

A INSERT
B JOIN
C RENAME
D ALTER

Question 24

A user wants to access files stored in a stage without authenticating into Snowflake.

Which type of URL should be used?

A File URL
B Staged URL
C Scoped URL
D Pre-signed URL

Question 25

True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

A True
B False

Page 1 of 53 • Questions 1-25 of 1320

1 2 3 4 5

→

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

Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:

A Micro-partitions
B Clustering keys
C Key partitions
D Clustered partitions

Which statement best describes clustering?

A Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
B The database administrator must define the clustering methodology for each Snowflake table
C The clustering key must be included on the COPY command when loading data into Snowflake
D Clustering can be disabled within a Snowflake account

SnowPro CorePreview