Deck 1: SnowPro Core

Question 1

Which of the following roles is recommended to be used to create and manage users and roles?

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

Answer 1

D

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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.

Question 5

A single database can exist in more than one Snowflake account.

Question 6

Snowflake charges a premium for storing semi-structured data.

Question 7

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

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 8

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

A) To accommodate more queries
B) To accommodate more users
C) To accommodate fluctuations in workload
D) To accommodate a more complex workload

Question 9

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

Question 10

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

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 11

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

Question 12

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

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 13

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.

Question 14

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

Question 15

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

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

Question 16

Account-level storage usage can be monitored via:

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 17

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

Question 18

Which type of table corresponds to a single Snowflake session?

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

Question 19

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

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

Question 20

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

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

What is the maximum compressed row size in Snowflake?

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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.

Question 38

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

Question 39

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

Question 40

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

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

Question 41

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

Question 42

Pipes can be suspended and resumed.

Question 43

Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? (Choose two.)

A) Java
B) Javascript
C) SQL
D) Python

Question 44

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

Question 45

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

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