Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
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 1 year, 11 months agontechkuma
Highly Voted 1 year, 9 months agoVLMBL_94
3 months, 1 week agovivekmani2021
Most Recent 3 months, 2 weeks agoMallikharjuna452
4 months agoYoshiSamoZou
4 months, 3 weeks agopranalig
5 months agoPrashantGupta1616
5 months, 2 weeks ago_yyukta
8 months, 3 weeks agoGaurangvp44
1 year, 1 month agoMarge23
1 year, 2 months agosinghks
1 year, 3 months agobonniezl
1 year, 5 months agoshyemko
1 year, 8 months agoJosa2
1 year, 8 months agoKarBiswa
1 year, 9 months agothejeby
1 year, 9 months agoSV1122
1 year, 10 months ago