SnowPro Core Certification Questions: Intermediate-Level Quiz

SnowPro Core Certification Questions

The SnowPro Core certification demonstrates your ability to manage and utilize the Snowflake platform efficiently. This quiz covers a range of topics, ensuring you are well-prepared for the certification exam.

1 / 20

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

Customers can change the size of the Warehouse after creation

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

A Warehouse can be resized while running

2 / 20

Which interfaces can be used to create and/or manage Virtual Warehouses?

Data integration tools

The Snowflake Web Interface (UI)

SQL commands

All of the above

3 / 20

Among the options listed, which is not a valid Snowflake Warehouse Size?

XXS

4 / 20

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

To accommodate a more complex workload

To accommodate more queries

To accommodate more users

To accommodate fluctuations in workload

5 / 20

Which of the following commands sets the Virtual Warehouse for a session?

SET WAREHOUSE = <>;

USE VIRTUAL_WAREHOUSE <>;

COPY WAREHOUSE FROM <>;

USE WAREHOUSE <>;

6 / 20

Which object allows you to limit the number of credits consumed within a Snowflake account?

Resource Monitor

Account Usage Tracking

Credit Consumption Tracker

Warehouse Limit Parameter

7 / 20

Snowflake is designed for which type of workloads? (You can choose more than one option)

Concurrent workloads

OLAP (Analytics) workloads

On-premise workloads

OLTP (Transactional) workloads

8 / 20

A single database can exist in more than one Snowflake account. True or False?

True

False

9 / 20

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. True or False?

True

False

10 / 20

How many predecessor tasks can a child task have?

100

11 / 20

Account-level storage usage can be monitored via:

The Snowflake Web Interface (UI) in the Account -> Billing & Usage section

The Information Schema -> ACCOUNT_USAGE_HISTORY View

The Snowflake Web Interface (UI) in the Databases section

The Account Usage Schema -> ACCOUNT_USAGE_METRICS View

12 / 20

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

Key partitions

Clustered partitions

Micro-partitions

Clustering keys

13 / 20

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

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

The Pipe load history is reset to empty

All of the above

14 / 20

Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (You can choose more than one option)

Storage expands without the requirement to add more compute

Growth of storage and compute are tightly coupled together

Multiple compute clusters can access stored data without contention

Compute can be scaled up or down without the requirement to add more storage

15 / 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. True or False?

True

False

16 / 20

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

Cloud Services Layer

Storage Layer

Database Layer

Compute Layer

17 / 20

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (You can choose more than one answer)

Standard

Optimized

Economy

Custom

18 / 20

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

True

False

19 / 20

Select the different types of Internal Stages. (You can select more than one option)

User Stage

Named Stage

Schema Stage

Table Stage

20 / 20

Bulk unloading of data from Snowflake supports the use of a SELECT statement. True or False?

True

False

Your score is

The average score is 0%

SnowPro core certification questions focus on preparing individuals for the Snowflake SnowPro core certification exam.

It encompasses topics like Snowflake architecture, data storage, querying, security, data sharing, and best practices for performance optimization.

This quiz will test your foundational understanding of Snowflake’s features and practical applications, making it ideal for those aiming to validate their expertise as Snowflake practitioners.

All the best!