Question 1

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

Accepted Answer

A)  Migrate Users 
B)  Migrate Schemas 
C)  Migrate Indexes 
D)  Build the Data Pipeline 
A)  Migrate Users 
B)  Migrate Schemas 
C)  Migrate Indexes 
D)  Build the Data Pipeline

Question 2

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Accepted Answer

A)  Customers can change the size of the Warehouse after creation 
B)  A Warehouse can be resized while running 
C)  A Warehouse can be configured to suspend after a period of inactivity 
D)  A Warehouse can be configured to auto-resume when new queries are submitted 
A)  Customers can change the size of the Warehouse after creation 
B)  A Warehouse can be resized while running 
C)  A Warehouse can be configured to suspend after a period of inactivity 
D)  A Warehouse can be configured to auto-resume when new queries are submitted

Question 3

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

Accepted Answer

A)  The tables are now orphaned 
B)  The user that deleted the role 
C)  SYSADMIN 
D)  The assumed role that dropped the role 
A)  The tables are now orphaned 
B)  The user that deleted the role 
C)  SYSADMIN 
D)  The assumed role that dropped the role

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):

Accepted Answer

A)  SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN 
B)  SECURITYADMIN, ACCOUNTADMIN, SYSADMIN 
C)  SECURITYADMIN, ACCOUNTADMIN 
D)  ACCOUNTADMIN 
A)  SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN 
B)  SECURITYADMIN, ACCOUNTADMIN, SYSADMIN 
C)  SECURITYADMIN, ACCOUNTADMIN 
D)  ACCOUNTADMIN

Question 7

Users are able to see the result sets of queries executed by other users that share their same role.

Accepted Answer

A) True 
 B)False

Question 8

Account-level storage usage can be monitored via:

Accepted Answer

A)  The Snowflake Web Interface (UI) in the Databases section 
B)  The Snowflake Web Interface (UI) in the Account -> Billing & Usage section 
C)  The Information Schema -> ACCOUNT_USAGE_HISTORY View 
D)  The Account Usage Schema -> ACCOUNT_USAGE_METRICS View 
A)  The Snowflake Web Interface (UI) in the Databases section 
B)  The Snowflake Web Interface (UI) in the Account -> Billing & Usage section 
C)  The Information Schema -> ACCOUNT_USAGE_HISTORY View 
D)  The Account Usage Schema -> ACCOUNT_USAGE_METRICS View

Question 9

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

Accepted Answer

A)  Tables 
B)  Schemas 
C)  Databases 
D)  Stages 
A)  Tables 
B)  Schemas 
C)  Databases 
D)  Stages

Question 10

What is the maximum compressed row size in Snowflake?

Accepted Answer

A)  8KB 
B)  16MB 
C)  50MB 
D)  4000GB 
A)  8KB 
B)  16MB 
C)  50MB 
D)  4000GB

Question 11

A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  4 
B)  16 
C)  32 
D)  128 
A)  4 
B)  16 
C)  32 
D)  128

Question 13

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

Accepted Answer

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

Question 14

Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)

Accepted Answer

A)  Growth of storage and compute are tightly coupled together 
B)  Storage expands without the requirement to add more compute 
C)  Compute can be scaled up or down without the requirement to add more storage 
D)  Multiple compute clusters can access stored data without contention 
A)  Growth of storage and compute are tightly coupled together 
B)  Storage expands without the requirement to add more compute 
C)  Compute can be scaled up or down without the requirement to add more storage 
D)  Multiple compute clusters can access stored data without contention

Question 15

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

Accepted Answer

A)  1 Hour 
B)  3 Hours 
C)  12 hours 
D)  24 hours 
A)  1 Hour 
B)  3 Hours 
C)  12 hours 
D)  24 hours

Question 16

A customer using SnowSQL / native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.

Accepted Answer

A) True 
 B)False

Question 17

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Accepted Answer

A)  Standard 
B)  Premier 
C)  Enterprise 
D)  Business Critical Edition 
A)  Standard 
B)  Premier 
C)  Enterprise 
D)  Business Critical Edition

Question 18

Which type of table corresponds to a single Snowflake session?

Accepted Answer

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

Question 19

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

Accepted Answer

A)  The Pipe load history is reset to empty 
B)  The REFRESH parameter is set to TRUE 
C)  Previously loaded files will be ignored 
D)  All of the above 
A)  The Pipe load history is reset to empty 
B)  The REFRESH parameter is set to TRUE 
C)  Previously loaded files will be ignored 
D)  All of the above

Question 20

Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

Accepted Answer

A) True 
 B)False

Exam 1: SnowPro Core

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

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

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

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

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

Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):

Users are able to see the result sets of queries executed by other users that share their same role.

Account-level storage usage can be monitored via:

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

What is the maximum compressed row size in Snowflake?

A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to 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 describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)

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

A customer using SnowSQL / native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Which type of table corresponds to a single Snowflake session?

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

Filters