Partitioning & File LayoutColumnar format (Lesson 4) decides how much of each row a query reads; file…