nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #148

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #148: Real Exam Question with Answer & Explanation

The correct answer is B: Query execution and index upkeep costs. Workload driven charges such as query execution and index upkeep are the most variable across services and are tightly coupled to how your application actually uses the database. In Firestore every document write can update multiple indexes which increases index upkeep costs and

Managing and Optimizing Google Cloud Database Solutions

Question

When comparing Google Cloud managed NoSQL services, which cost component should you consistently emphasize for a precise TCO analysis?

Options

  • AStorage capacity costs
  • BQuery execution and index upkeep costs
  • CCMEK for data at rest

Explanation

Workload driven charges such as query execution and index upkeep are the most variable across services and are tightly coupled to how your application actually uses the database. In Firestore every document write can update multiple indexes which increases index upkeep costs and every read or query incurs operation charges that fall under query execution. In Bigtable you provision for throughput which still maps to demand from query execution. Centering comparisons on query execution and index upkeep costs produces a more accurate and comparable total cost of ownership across architectures.

Topics

#Google Cloud NoSQL#Cost Analysis#TCO#Database Billing Models

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions