Question 1

What is the only supported character set for loading and unloading data from all supported file formats?

Options :

A : UTF-8

B : UTF-16

C : ISO-8859-1

D : WINDOWS-1253

Answer: A

Question 2

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Options :

A : Each Snowflake account can be hosted in a different cloud vendor and region.

B : Each Snowflake account must be hosted in a different cloud vendor and region

C : All Snowflake accounts must be hosted in the same cloud vendor and region

D : Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Answer: A

Question 3

What feature can be used to reorganize a very large table on one or more columns?

Options :

A : Micro-partitions

B : Clustering keys

C : Key partitions

D : Clustered partitions

Answer: B

Question 4

Which Snowflake technique can be used to improve the performance of a query?

Options :

A : Clustering

B : Indexing

C : Fragmenting

D : Using INDEX__HINTS

Answer: A

Question 5

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

Options :

A : Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

B : Scaling out adds clusters of varying sizes to a virtual warehouse.

C : Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

D : Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

E : Scaling up resizes a virtual warehouse so it can handle more complex workloads.

F : Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Answer: A,E

Free SnowPro-Core Mock Exam – Practice Online Confidently