What Google Cloud database solution should you choose for an airline ticketing application that requires transaction support with strong consistency, handles both structured and semi-structured (JSON) data, and can scale seamlessly across multiple global regions as demand increases?