ExpertMedium1 markMultiple Choice
Domain 5: Managing Implementation and Ensuring Solution and Operations ReliabilityBigQueryCost OptimizationPricing Models
GCP PCA · Question 32 · Domain 5: Managing Implementation and Ensuring Solution and Operations Reliability
You are managing a data warehouse in BigQuery. The marketing team runs complex analytical queries at the end of every month, while the sales team runs simple, frequent queries daily. The CFO is concerned about the unpredictable costs of BigQuery. How should you optimize the costs?
You are managing a data warehouse in BigQuery. The marketing team runs complex analytical queries at the end of every month, while the sales team runs simple, frequent queries daily. The CFO is concerned about the unpredictable costs of BigQuery. How should you optimize the costs?
Answer options:
A.
Require all users to use the BigQuery sandbox.
B.
Switch to BigQuery capacity pricing (slots) for the marketing team, and keep on-demand pricing for the sales team.
C.
Export the data to Cloud Storage and use Dataproc to run the queries.
D.
Set a maximum bytes billed limit on the project to 1TB per day.
How to approach this question
Match the pricing model to the workload profile. Heavy/unpredictable = Capacity pricing. Light/frequent = On-demand.
Full Answer
B.Switch to BigQuery capacity pricing (slots) for the marketing team, and keep on-demand pricing for the sales team.✓ Correct
BigQuery offers On-Demand pricing (pay per byte processed) and Capacity pricing (pay for dedicated slots/compute). For heavy, complex queries that cause unpredictable spikes in cost, purchasing dedicated slots provides a fixed, predictable cost. For lightweight queries, on-demand remains the most cost-effective.
Common mistakes
Setting hard limits (D). While it controls cost, it breaks the business process.
Practice the full GCP Professional Cloud Architect Practice Exam 4
50 questions · hints · full answers · grading
More questions from this exam
Q01CASE STUDY: TechStream Gaming
Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...MediumQ02CASE STUDY: TechStream Gaming
Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...MediumQ03CASE STUDY: TechStream Gaming
Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...HardQ04CASE STUDY: TechStream Gaming
Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...HardQ05CASE STUDY: TechStream Gaming
Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...Easy