A great compression number means little if the index rejects one column. Here is how to test both questions on your own server.
Star Schema Queries and How SQL Server Runs Them
Star schema queries join a large fact table to focused dimensions; learn bitmap filters, columnstore, and indexes that support the real workload.
Ordered Columnstore Indexes in SQL Server 2022
Build an ordered columnstore index in SQL Server 2022, inspect segment bounds, and compare range-query reads on your own data.