Question 1

How would you determine the size of the virtual warehouse used for a task?

Options :

A : Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B : Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C : If using the stored procedure to execute multiple SQL statements, it-s best to test run the stored procedure separately to size the compute resource first

D : Since task infrastructure is based on running the task body on schedule, it-s recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Answer: C

Question 2

Which type of table corresponds to a single Snowflake session?

Options :

A : Temporary

B : Translent

C : Provisional

D : Permanent

Answer: A

Question 3

Which of the following statements are true of Snowflake releases: (Choose two.)

Options :

A : They happen approximately weekly

B : They roll up and release approximately monthly, but customers can request early release application

C :

During a release, new customer requests/queries/connections transparently move over to the newer

version

D :

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which

the

system will be unavailable and customer is upgraded

Answer: A,C

Question 4

What affects whether the query results cache can be used?

Options :

A : If the query contains a deterministic function

B : If the virtual warehouse has been suspended

C : If the referenced data in the table has changed

D : If multiple users are using the same virtual warehouse

Answer: B

Question 5

When loading data into Snowflake, how should the data be organized?

Options :

A : Into single files with 100-250 MB of compressed data per file

B : Into single files with 1-100 MB of compressed data per file

C : Into files of maximum size of 1 GB of compressed data per file

D : Into files of maximum size of 4 GB of compressed data per file

Answer: A

Confidently Practice Online with Free COF-R02 Exam Cram

Buying Options: