AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: Your organization operates two separate BigQuery gcp video

Question 1 Be Honest
« Back   Next data-engineer-pro Certification Question »
Answer

Full Certification Question

Your organization operates two separate BigQuery projects : Project A handles production workloads with strict SLA requirements . These jobs are high-priority and must always have sufficient compute capacity. The project consistently uses at least 300 slots , and can occasionally spike to an additional 500 slots during peak periods. Project B is used for ad-hoc analytical queries by business users. This project typically uses no more than 200 slots , and you want billing to be based on the volume of data scanned , not on dedicated slot capacity. You need to ensure that each project has access to the appropriate compute resources, while optimizing cost and meeting workload requirements. Which configuration should you implement?