Describe the purpose of database filegroups and examine the key ways it helps with minimizing administration to backups or with multiple databases within an organization.
Suppose you managed a server with 200 terabytes of data, determine whether you would use full backup, transaction or file groups. Provide a rationale for your response.