database-engineer-pro video for your company uses a Cloud SQL database for transactional operations. A new requirement arises to generate daily reports on
Your company uses a Cloud SQL database for transactional operations. A new requirement arises to generate daily reports on historical data, which involves complex analytical queries. You must ensure that these queries do not impact the performance of the transactional workload. What should you do?