Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 18 Topic 2 Discussion

Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 18 Topic 2 Discussion

DEA-C01 Exam Topic 2 Question 18 Discussion:
Question #: 18
Topic #: 2

A Data Engineer is investigating a query that is taking a long time to return The Query Profile shows the following:

DEA-C01 Question 18

What step should the Engineer take to increase the query performance?


A.

Add additional virtual warehouses.


B.

increasethe size of the virtual warehouse.


C.

Rewrite the query using Common Table Expressions (CTEs)


D.

Change the order of the joins and start with smaller tables first


Get Premium DEA-C01 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.