@Oliver Angelil​ Usually Data in databricks is stored in either managed /external tables.

managed tables store metadata and data related meta data in same location which is hive_metastore (DBFS) that is part of your root storage configured during databricks configuration.

where as external tables, table meta data stores in hive_metastore and data gets store in external storage (any external storage s3/azure blob, gcs) that you will be mounting

As Governance came into picture which is unity catalog, DBFS is not recommended due to security reasons.

you can create your own metastore and link to databricks account--> link to databricks workspace--> catalog --> table data and meta data

if you already have any data in hive metastore, you can migrate them into data bricks unity catalog (which is newly created your own metastore)

there are few limitations in UC, if you are preferring to go with UC which is best option __> databricks recommends managed tables