PL-300 Question 104

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose AB2

  Option C would result in a longer query with opposite result (as it would take even more time to retrieve data, itwould easier would resut in a TimeOut error) Not sure about the effect of option D but reducing rows and columns as suggested in option A and split queries as in option B (to retrieve small datasets in each resulting querie) would definitively help to prevent the TimeOut error

• 1

  Query Folding D speeds up the process, disabling it would defeat the purpose

• 1

  I'm not sure why A is marked as a correct answer - what if you needed all of those rows instead of arbitrarily filtering them out? Agree with B. C looked like it may have been part of the procedure achieved by B