Snowflake SnowPro Core Exam Questions in PDF and Online

QUESTION: 17

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

To accommodate more queries
To accommodate more users
To accommodate fluctuations in workload
To accommodate a more complex workload

Answer(s): D

QUESTION: 18

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

True
False

Answer(s): B

Reference:

https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

Reveal Solution Next Question

QUESTION: 19

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

JDBC
SnowSQL
Snowflake Web Interface (UI)
ODBC
Python

Answer(s): A,B,C,D,E

Reference:

https://docs.snowflake.com/en/user-guide/security-mfa.html

Reveal Solution Next Question

QUESTION: 20

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

True
False

Answer(s): B

Reference:

https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflake-charges-premium-for-storing-semi-structured-data

Reveal Solution Next Question

QUESTION: 21

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

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

Answer(s): B,C,D

Reveal Solution Next Question

QUESTION: 22

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

True
False

Answer(s): A

Reference:

https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

Reveal Solution Next Question

QUESTION: 23

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

Storage Layer
Compute Layer
Database Layer
Cloud Services Layer

Answer(s): D

Reference:

https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

Reveal Solution Next Question

QUESTION: 24

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

True
False

Answer(s): B

Reference:

https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

Reveal Solution Next Question

Snowflake SnowPro Core SnowPro Core Exam Questions in PDF

Free Snowflake SnowPro Core Dumps Questions (page: 3)

QUESTION: 17

QUESTION: 18

Reference:

QUESTION: 19

Reference:

QUESTION: 20

Reference:

QUESTION: 21

QUESTION: 22

Reference:

QUESTION: 23

Reference:

QUESTION: 24

Reference: