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

Accepted Answer

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.

Accepted Answer

False

Question 3

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

Accepted Answer

The COPY command requires a File Format specification to define the structure and format of the data being copied. Without a File Format, the command cannot determine how to interpret and process the data.

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.

Accepted Answer

Access to the Snowflake Web Interface (UI) is independent of using SnowSQL or native connectors, and does not require explicit granting by support.

Question 5

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

Accepted Answer

A single database cannot exist in more than one Snowflake account. Each Snowflake account is isolated, and databases are specific to the account they are created in.

Question 6

Snowflake charges a premium for storing semi-structured data.

Accepted Answer

Snowflake does not charge a premium for storing semi-structured data; it uses the same pricing model for structured and 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

Accepted Answer

The answer of Which of the following statements describes a...

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

Accepted Answer

The answer of Why would a customer size a Virtual...

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.

Accepted Answer

Snowflake requires a Snowflake-specific driver to connect to its database.

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

Accepted Answer

The answer of When a Pipe is recreated using the...

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

Accepted Answer

Clustering keys in Snowflake allow customers to define how data should be clustered, overriding the default automatic clustering.

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

Accepted Answer

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

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.

Accepted Answer

The answer of Snowflake's data warehouse was built from the...

Question 14

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

Accepted Answer

Structured data can be converted and stored in semi-structured formats like JSON and Parquet, which allow for flexible schema and data representation.

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

Accepted Answer

The answer of What are the three layers that make...

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

Accepted Answer

The Snowflake Web Interface (UI) in the Account -> Billing & Usage section provides a way to monitor account-level storage usage.

Question 17

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

Accepted Answer

Fail-safe is a data recovery feature in Snowflake that cannot be bypassed or manually deleted by users or the Snowflake team before its expiration period.

Question 18

Which type of table corresponds to a single Snowflake session?
A) Temporary
B) Transient
C) Provisional
D) Permanent

Accepted Answer

Temporary tables are specific to a single Snowflake session and are automatically dropped at the end of the session.

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

Accepted Answer

Snowflake stores its metadata statistics in the Cloud Services Layer, which manages metadata, security, and optimization.

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

Accepted Answer

The Business Critical Edition of Snowflake is designed to meet regulatory compliance requirements for storing protected information, offering enhanced security features such as HIPAA support and encryption.

Exam 1: SnowPro Core

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

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

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

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.

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

Snowflake charges a premium for storing semi-structured data.

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

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

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

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

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

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

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.

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

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

Account-level storage usage can be monitored via:

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

Which type of table corresponds to a single Snowflake session?

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

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