How we can persist 300 million records? What is the best option to persist data databricks hive metastore/Azure storage/Delta table?

What is the limitations we have for deltatables of databricks in terms of data?

We have usecase where testers should be able to see data in table and query them.