Question 1

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
A) Is available to all Snowflake Editions
B) Is only available to customers with Business Critical Edition
C) Restricts or enables access to specific IP addresses
D) Is activated using an "ALTER DATABASE" command

Accepted Answer

Network policies in Snowflake are available to all editions and are used to restrict or enable access to specific IP addresses.

Question 2

Micro-partition metadata enables some operations to be completed without requiring Compute.

Accepted Answer

Micro-partition metadata in Snowflake allows certain operations, like metadata queries, to be executed without needing to access the actual data, thus not requiring compute resources.

Question 3

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)
A) The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
B) The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
C) The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
D) The "24 hour" timer on the precomputed results gets renewed every time the exact query is executed

Accepted Answer

The answer of A deterministic query is run at 8am,...

Question 4

Which of the following commands are not blocking operations? (Choose two.)
A) UPDATE
B) INSERT
C) MERGE
D) COPY

Accepted Answer

The answer of Which of the following commands are not...

Question 5

A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Accepted Answer

A table in Snowflake can be queried using any Virtual Warehouse, not just the one used to load the data. Snowflake's architecture separates storage and compute, allowing any Virtual Warehouse to access the data stored in the database.

Question 6

Which item in the Data Warehouse migration process does not apply in Snowflake?
A) Migrate Users
B) Migrate Schemas
C) Migrate Indexes
D) Build the Data Pipeline

Accepted Answer

Snowflake does not use traditional indexes as other databases do, so migrating indexes is not applicable in Snowflake.

Question 7

Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)? (Choose two.)
A) SnowSQL
B) ODBC
C) R
D) HIVE

Accepted Answer

SnowSQL and ODBC are available in the Downloads section of the Snowflake Web Interface (UI).

Question 8

Fail-safe is unavailable on which table types? (Choose two.)
A) Temporary
B) Transient
C) Provisional
D) Permanent

Accepted Answer

Fail-safe is unavailable on Temporary and Transient tables. Temporary tables are session-specific and do not persist beyond the session, while Transient tables are designed to avoid the overhead of fail-safe.

Question 9

It is possible to load data into Snowflake without creating a named File Format object.

Accepted Answer

You can load data into Snowflake using the COPY INTO command with file format options specified directly in the command, without needing a named File Format object.

Question 10

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
A) 1 Hour
B) 3 Hours
C) 12 hours
D) 24 hours

Accepted Answer

The answer of Query results are stored in the Result...

Question 11

Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

Accepted Answer

The answer of Query ID's are unique across all Snowflake...

Question 12

Which of the following statements are true of Snowflake data loading? (Choose three.)
A) VARIANT "null" values are not the same as SQL NULL values
B) It is recommended to do frequent, single row DMLs
C) It is recommended to validate the data before loading into the Snowflake target table
D) It is recommended to use staging tables to manage MERGE statements

Accepted Answer

VARIANT "null" values differ from SQL NULL values. Validating data before loading ensures data quality. Staging tables help manage complex operations like MERGE efficiently. Frequent, single row DMLs are not recommended due to performance concerns.

Question 13

What is the maximum compressed row size in Snowflake?
A) 8KB
B) 16MB
C) 50MB
D) 4000GB

Accepted Answer

The answer of What is the maximum compressed row size...

Question 14

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

Accepted Answer

A Medium Warehouse typically consists of 4 servers/cluster, which is double the number of servers in a Small Warehouse.

Question 15

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
A) Configure the Maximum Clusters setting to "Auto-Scale"
B) Set the Warehouse type to "Auto"
C) Set the Minimum Clusters and Maximum Clusters settings to the same value
D) Set the Minimum Clusters and Maximum Clusters settings to the different values

Accepted Answer

To enable auto-scaling, the Minimum Clusters and Maximum Clusters settings must be set to different values, allowing the system to scale the number of clusters between these two values based on workload demand.

Question 16

Which of the following statements are true of Snowflake releases: (Choose two.)
A) They happen approximately weekly
B) They roll up and release approximately monthly, but customers can request early release application
C) During a release, new customer requests/queries/connections transparently move over to the newer version
D) A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

Accepted Answer

The answer of Which of the following statements are true...

Question 17

When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

Accepted Answer

When a user creates a role, they are typically assigned ownership by default, and this ownership remains with them until they choose to transfer it to another user.

Question 18

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

Accepted Answer

The answer of A role is created and owns 2...

Question 19

The Query History in the Snowflake Web Interface (UI) is kept for approximately:
A) 60 minutes
B) 24 hours
C) 14 days
D) 30 days
E) 1 year

Accepted Answer

The answer of The Query History in the Snowflake Web...

Question 20

Which of the following objects is not covered by Time Travel?
A) Tables
B) Schemas
C) Databases
D) Stages

Accepted Answer

Time Travel in Snowflake is a feature that allows you to access historical data for tables, schemas, and databases, but it does not apply to stages.

Exam 1: SnowPro Core

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Micro-partition metadata enables some operations to be completed without requiring Compute.

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

Which of the following commands are not blocking operations? (Choose two.)

A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Which item in the Data Warehouse migration process does not apply in Snowflake?

Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI) ? (Choose two.)

Fail-safe is unavailable on which table types? (Choose two.)

It is possible to load data into Snowflake without creating a named File Format object.

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

Which of the following statements are true of Snowflake data loading? (Choose three.)

What is the maximum compressed row size in Snowflake?

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

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Which of the following statements are true of Snowflake releases: (Choose two.)

When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

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

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

Which of the following objects is not covered by Time Travel?