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

Can a single storage integration support multiple external stages?

Yes

Not sure

2 / 20

Snowflake charges a premium for storing semi-structured data. True or False?

True

False

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

4 / 20

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

Standard

Optimized

Economy

Custom

5 / 20

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

True

False

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

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

SET WAREHOUSE = <>;

USE VIRTUAL_WAREHOUSE <>;

COPY WAREHOUSE FROM <>;

USE WAREHOUSE <>;

8 / 20

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

True

False

9 / 20

What are the three layers that make up Snowflake's architecture?

Tri-Secret Secure

Cloud Services

Compute

Storage

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

11 / 20

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

XXS

12 / 20

Which type of table corresponds to a single Snowflake session?

Transient

Provisional

Temporary

Permanent

13 / 20

Which statement best describes `clustering`?

Clustering can be disabled within a Snowflake account

The database administrator must define the clustering methodology for each Snowflake table

Clustering represents the way data is grouped together and stored within Snowflakeג€™s micro-partitions

The clustering key must be included on the COPY command when loading data into Snowflake

14 / 20

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

Cloud Services Layer

Storage Layer

Database Layer

Compute Layer

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

16 / 20

Are shared databases exclusively read-only databases?

Yes

Not sure

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

18 / 20

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

True

False

19 / 20

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

ACCOUNTADMIN

PUBLIC

SYSADMIN

SECURITYADMIN

20 / 20

Which of the following scenarios represents scaling out for a Snowflake virtual Warehouse?

Adding more EC2 instances for SQS

Adding more data storage to your Snowflake account

Adding a new virtual warehouse of the same size

Changing the size of a warehouse from L to XL

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!