Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
D: SELECT ORDER_AMT * ORDER_QTY FROM SALES involves a simple operation of multiplying the values of two columns. This operation can be performed solely by scanning the data and does not require a Compute Engine.
I believe it's C, since once the METADATA stores it, it will know what's the DETERMINISTIC value without having to perform any calculation as suggested by A and B or run over all micro-partitions as it would occur in D.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
tejarun
Highly Voted 2 years, 8 months agontechkuma
Highly Voted 2 years, 5 months agoVLMBL_94
11 months, 3 weeks agojhfather
Most Recent 5 months agovivekmani2021
12 months agoMallikharjuna452
1 year agoYoshiSamoZou
1 year, 1 month agopranalig
1 year, 1 month agoPrashantGupta1616
1 year, 1 month ago_yyukta
1 year, 5 months agoGaurangvp44
1 year, 9 months agoMarge23
1 year, 10 months agosinghks
1 year, 11 months agobonniezl
2 years, 2 months agoshyemko
2 years, 4 months agoJosa2
2 years, 5 months agoKarBiswa
2 years, 5 months agothejeby
2 years, 5 months ago