Question 1

A virtual warehouse is created using the following command:Create warehouse my_WH withwarehouse_size = MEDIUMmin_cluster_count = 1max_cluster_count = 1auto_suspend = 60auto_resume = true;The image below is a graphical representation of the warehouse utilization across two days.What action should be taken to address this situation?

Options :

A : Increase the warehouse size from Medium to 2XL.

B : Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C : Configure the warehouse to a multi-cluster warehouse.

D : Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Answer: C

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

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?

Options :

A : No virtual warehouse will be used, data will be read from the result cache.

B : No virtual warehouse will be used, data will be read from the local disk cache.

C : The default virtual warehouse will be used to read all data.

D : The virtual warehouse that is defined at the session level will be used to read all data.

Answer: A

Question 4

What is the primary purpose of a directory table in Snowflake?

Options :

A : To store actual data from external stages

B : To automatically expire file URLs for security

C : To manage user privileges and access control

D : To store file-level metadata about data files in a stage

Answer: D

Question 5

What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

Options :

A : Reorder the rows in a relational table and then unload the rows into a file

B : Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

C : Reorder the data columns according to a target table definition and then unload the rows into the table.

D : Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

Answer: B

Free SnowPro-Core Mock Exam – Practice Online Confidently

Buying Options: