A great compression number means little if the index rejects one column. Here is how to test both questions on your own server.
Reading a Backup File Before You Restore With RESTORE HEADERONLY
Use RESTORE HEADERONLY to identify backup sets, source versions and finish dates before selecting a restore and checking the media.
XML Compression in SQL Server 2022
Use XML compression in SQL Server 2022 to reduce XML storage, inspect partition settings, and compare CPU costs on your own workload.