In SQL Server, the database can be stored in different files and filegroups ... But if you have a large database (in several GBs or TBs), separating the data into different files help you to optimize ...

If you store this information as plain text, unscrupulous users can easily steal the data either through online SQL queries or by scanning the files on the database server's hard drive.