Thanks Jeff. I got it.

On another note for the sake curiosity,

What would be your recommendation had it been a Standard OR Enterprise version of SQL Server (not Azure)?

Single Large table with multiple filegroups for better maintenance and a good archival process?

Thanks,

Rahul