Question 1

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

Accepted Answer

A)  SnowSQL 
B)  ODBC 
C)  R 
D)  HIVE 
A)  SnowSQL 
B)  ODBC 
C)  R 
D)  HIVE A,B

Question 2

It is possible to unload structured data to semi-structured formats such as JSON and Parquet.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

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 
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

Question 5

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

Accepted Answer

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

Question 6

The user has to specify which cluster a query will run on in a multi-cluster Warehouse.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  60 minutes 
B)  24 hours 
C)  14 days 
D)  30 days 
E)  1 year 
A)  60 minutes 
B)  24 hours 
C)  14 days 
D)  30 days 
E)  1 year

Question 8

The COPY command must specify a File Format in order to execute.

Accepted Answer

A) True 
 B)False

Question 9

What are the three layers that make up Snowflake's architecture? (Choose three.)

Accepted Answer

A)  Compute 
B)  Tri-Secret Secure 
C)  Storage 
D)  Cloud Services 
A)  Compute 
B)  Tri-Secret Secure 
C)  Storage 
D)  Cloud Services

Question 10

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

A) True 
 B)False

Question 11

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

Accepted Answer

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 
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

Question 12

Data in fail-safe can be deleted by a user or the Snowflake team before it expires.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  UPDATE 
B)  INSERT 
C)  MERGE 
D)  COPY 
A)  UPDATE 
B)  INSERT 
C)  MERGE 
D)  COPY

Question 14

Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

In which layer of its architecture does Snowflake store its metadata statistics?

Accepted Answer

A)  Storage Layer 
B)  Compute Layer 
C)  Database Layer 
D)  Cloud Services Layer 
A)  Storage Layer 
B)  Compute Layer 
C)  Database Layer 
D)  Cloud Services Layer

Question 17

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

Accepted Answer

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 
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

Question 18

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

Accepted Answer

A)  Temporary 
B)  Transient 
C)  Provisional 
D)  Permanent 
A)  Temporary 
B)  Transient 
C)  Provisional 
D)  Permanent

Question 19

Pipes can be suspended and resumed.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 1: SnowPro Core

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

It is possible to unload structured data to semi-structured formats such as JSON and Parquet.

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

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

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

The user has to specify which cluster a query will run on in a multi-cluster Warehouse.

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

The COPY command must specify a File Format in order to execute.

What are the three layers that make up Snowflake's architecture? (Choose three.)

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.

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

Data in fail-safe can be deleted by a user or the Snowflake team before it expires.

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

Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

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

In which layer of its architecture does Snowflake store its metadata statistics?

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

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

Pipes can be suspended and resumed.

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

Filters