I think this post should help explain some of what is going on:
Is the data in columnstore or rowstore tables?