GCP Professional Cloud Architect Practice Question

Your company has migrated its on-premises MySQL-based analytics platform to BigQuery to achieve two explicit business goals:

Reduce the total cost of ownership (infrastructure and operational labor) for analytics by at least 40 percent within the first year.
Increase analyst productivity by cutting average dashboard query runtime.

Executive leadership will review a quarterly scorecard to decide whether to fund additional cloud modernization. As the lead architect, you must recommend which key performance indicators (KPIs) to track on that scorecard.

Which KPI pair most directly demonstrates whether the migration is meeting the stated success criteria?

Average BigQuery slot utilization percentage, and Cloud Storage Nearline retrieval operations per month.
Mean dashboard query execution time versus the pre-migration baseline, and monthly total cost of ownership (compute, storage, and operational labor) for the analytics workload.
Number of BigQuery datasets created each quarter, and total volume of data loaded into BigQuery.
Percentage of jobs completing without errors, and number of new Looker Studio reports published.

Report Issue

Answer Description

To evaluate success, the KPIs must map directly to the stated business outcomes.

Business goal 1 is cost reduction. The comprehensive way to show this is the total cost of ownership (TCO) for the analytics workload, which combines cloud resource charges (compute, storage, networking) with ongoing operational labor costs. Point metrics such as slot-hour consumption or data volume do not capture the full financial picture that executives require.
Business goal 2 is improved analyst productivity through faster dashboards. The clearest, measurable proxy is the mean dashboard query execution time compared with the pre-migration baseline. Counting datasets or reports does not say whether analysts actually work faster.

Therefore, the pair of KPIs that best align with both business objectives is monthly TCO for the analytics workload and mean dashboard query execution time. Other options list operational or activity metrics that do not directly reflect either cost savings or user productivity improvements.

Ask Bash

Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.