I believe the following question’s model answer is wrong.
I’ve checked the model answer and it says the correct choices are options 2 and 3 as ordered in the attached screenshot above. How can columnar storage be the best storage for transactional workloads?
P.S., also note the typo in “withrow” in option 1 in the screenshot
Edit: Hid my answer with a spoiler tag.