Google Professional Data Engineer Question 246
Select 3Google Cloud PlatformYour company is running multiple workloads on BigQuery with unpredictable query patterns. Some workloads are high-priority and need consistent performance, while others are low-priority and can tolerate delays. The company wants to optimize costs without compromising critical workloads. Which slot pricing options should you choose for this scenario?
- A
On-demand pricing for workloads with unpredictable query patterns and critical performance needs.
- B
Flat-rate pricing for workloads with consistent and predictable query patterns.
- C
Flex slot pricing for workloads with unpredictable query patterns and low-priority needs.
- D
Flex slot pricing for workloads with consistent and predictable query patterns.
- E
Flat-rate pricing for workloads with unpredictable query patterns and critical performance needs.
Show answer and explanation
Correct answers: A, B, C
Explanation
To meet the company's requirements, on-demand pricing is used for critical workloads with unpredictable patterns to ensure consistent performance. Flat-rate pricing optimizes costs for predictable workloads with consistent needs. Flex slot pricing is a cost-effective option for low-priority workloads with unpredictable patterns as it allows short-term commitments while tolerating delays.
- A. Correct.
On-demand pricing is ideal for workloads with unpredictable query patterns and critical performance needs because it provides the flexibility to handle unexpected spikes in demand without requiring upfront commitments.
- B. Correct.
Flat-rate pricing is suitable for workloads with consistent and predictable query patterns as it provides a fixed capacity at a predictable cost, optimizing expenses for workloads with steady requirements.
- C. Correct.
Flex slot pricing is appropriate for workloads with unpredictable query patterns and low-priority needs because it offers a lower-cost option with a short-term commitment, making it suitable for workloads that can tolerate some delay.
- D. Incorrect.
Flex slot pricing is less ideal for workloads with consistent and predictable query patterns, as flat-rate pricing provides better cost optimization for steady workloads.
- E. Incorrect.
Flat-rate pricing is not suitable for workloads with unpredictable query patterns and critical performance needs because it assumes a predictable capacity, which may not accommodate unexpected spikes in demand.