Google Professional Data Engineer Question 245
Select 2Google Cloud PlatformYour organization uses BigQuery for data analysis and is currently running several ad-hoc queries that are unpredictable in terms of frequency and complexity. However, the team is also planning to run scheduled, high-priority reporting queries daily that require consistent performance. What pricing model combination would you recommend to achieve cost efficiency while meeting the performance requirements?
- A
Use flex slots for ad-hoc queries and purchase flat-rate slots for the scheduled reporting queries.
- B
Use on-demand pricing for ad-hoc queries and purchase flat-rate slots for the scheduled reporting queries.
- C
Use flex slots for both ad-hoc and scheduled reporting queries to maximize flexibility.
- D
Use flat-rate slots exclusively for all queries to ensure consistent performance and simplify billing.
- E
Use on-demand pricing for all queries to avoid any commitment.
Show answer and explanation
Correct answers: A, B
Explanation
To achieve cost efficiency and meet specific workload requirements, it is important to use a combination of pricing models. On-demand pricing is well-suited for ad-hoc queries with unpredictable frequency, as it avoids upfront commitments. Flat-rate slots, on the other hand, are ideal for scheduled, high-priority queries that need consistent performance and predictable costs. This combination optimizes both flexibility and efficiency.
- A. Correct.
This option is partially correct. Flex slots provide flexibility for ad-hoc queries and flat-rate slots ensure consistent performance for scheduled queries, but flex slots may not be the most cost-effective option for unpredictable ad-hoc queries compared to on-demand pricing.
- B. Correct.
This option is correct. On-demand pricing is ideal for ad-hoc queries since it does not require prior commitments, while flat-rate slots are suitable for predictable, high-priority scheduled queries that need consistent performance.
- C. Incorrect.
This option is incorrect. While flex slots are flexible, they may not be the most cost-effective or performance-optimized choice for scheduled reporting queries that require consistent performance.
- D. Incorrect.
This option is incorrect. Using flat-rate slots for all workloads could lead to wasted capacity for ad-hoc workloads that do not require consistent slot allocation.
- E. Incorrect.
This option is incorrect. On-demand pricing for all queries can lead to higher costs for scheduled, high-priority queries that run frequently and require predictable performance.