Yes the data of the tableau changes as per the data changes on backend.
There are two type of connections : Live and Extract
Live is a snapshot of the database. Whenever the data changes it's reflects to the dashboard
the extract will need to be refreshed to receive updates from the original data source, whether it is a local file or an on-premise database.
Please refer the link for more information :
Please let me know if this helps.