Yes, for certain database types, Cube will need to create tables in your database. You can read more about Cube pre-aggregation strategies here.
If you want to check which strategy your database type uses, go to the data sources page, select your database type and scroll down to ‘Pre-aggregation build strategies’.