I usually look this up everytime someone tells me to check a database back from the cpanel daily/weekly backup routine. By default cpanel backs up to the /backup folder.
So you can use the following command to copy the back tar.gz to the accounts folder
cp /backup/2020-11-27/accounts/account_name.tar.gz /home/account_name/backup/account_name.2020-11-27.tar.gz
Then I will need to search the tar.gz archive for *.sql files to locate the backup database. So would use this.
tar -tvf /home/account_name/backup/account_name.2020-11-27.tar.gz '*.sql'
This will list the files I want and I can then just extract the single file I need.
tar -xvf account_name.2020-11-27.tar.gz account_name/mysql/dbname.sql