Domain 5: Managing Implementation and Ensuring Solution and Operations Reliability — GCP PCA Practice Question 32

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

Switch to BigQuery capacity pricing (slots) for the marketing team, and keep on-demand pricing for the sales team.

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.

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?

How to approach this question

Full Answer

Common mistakes

Practice the full GCP Professional Cloud Architect Practice Exam 4

More questions from this exam