Examkin

Question

Difficulty: HardQuantitative Data Reconciliation Across Sources

Tab 1: Cloud Provider Tiered Pricing Policy

CloudOps Enterprise Tier charges a flat base rate of $10,000\$10,000 per month, which includes up to 50,00050,000 Compute Hours (CH). Additional compute hours beyond 50,00050,000 CH up to 100,000100,000 CH are billed at a discounted overage rate of $0.15\$0.15 per CH. Compute hours exceeding 100,000100,000 CH in a given month are billed at the standard overage rate of $0.25\$0.25 per CH. Furthermore, a data egress surcharge of $0.02\$0.02 per Gigabyte (GB) is applied to all egress data exceeding 1010 Terabytes (TB) in a month (where 1 TB=1,000 GB1\text{ TB} = 1,000\text{ GB}).

Tab 2: Q3 Server Log Summary (Region Alpha)

- August 2026: Region Alpha logged a total of 85,00085,000 Compute Hours and transferred 15 TB15\text{ TB} of egress data.
- September 2026: Region Alpha logged a total of 110,000110,000 Compute Hours and transferred 8 TB8\text{ TB} of egress data.

Based on the pricing policy in Tab 1 and the usage logs in Tab 2, evaluate whether the following statement is True or False:

"The total combined cloud infrastructure invoice for Region Alpha for August 2026 and September 2026 combined exceeds $33,000\$33,000."

Answer: Answer

Answer

True. Reconciling the tiered pricing policy with the usage logs yields an August invoice of 15,350andaSeptemberinvoiceof15,350 and a September invoice of 20,000, giving a combined total of 35,350,whichexceeds35,350, which exceeds 33,000.
The correct answer is True because calculated billing for August 2026 is 15,350(15,350 ( 10,000 base + 5,250Tier1overage+5,250 Tier 1 overage + 100 egress surcharge) and for September 2026 is 20,000(20,000 ( 10,000 base + 7,500Tier1overage+7,500 Tier 1 overage + 2,500 Tier 2 overage + 0egresssurcharge).Thecombinedtotalof0 egress surcharge). The combined total of 35,350 exceeds the target threshold of $33,000.

Step-by-Step Solution

1
Calculate August 2026 compute cost and data egress surcharge.
August compute cost = 10,000+(35,000∗10,000 + (35,000 * 0.15) = 15,250.Egressexcess=15,000GB−10,000GB=5,000GB,sosurcharge=5,000∗15,250. Egress excess = 15,000 GB - 10,000 GB = 5,000 GB, so surcharge = 5,000 * 0.02 = 100.TotalAugustinvoice=100. Total August invoice = 15,350.
Compute usage of 85,000 CH fills the base 50,000 CH plus 35,000 CH in Tier 1 overage ($0.15/CH). Egress of 15 TB exceeds the 10 TB allowance by 5 TB (5,000 GB).
2
Calculate September 2026 compute cost and data egress surcharge.
September compute cost = 10,000+(50,000∗10,000 + (50,000 * 0.15) + (10,000 * 0.25)=0.25) = 20,000. Egress surcharge = 0.TotalSeptemberinvoice=0. Total September invoice = 20,000.
Compute usage of 110,000 CH fills the base 50,000 CH, the maximum 50,000 CH in Tier 1 overage (7,500),and10,000CHinTier2overage(7,500), and 10,000 CH in Tier 2 overage ( 0.25/CH = $2,500). Egress of 8 TB does not exceed the 10 TB threshold.
3
Reconcile combined invoice total and compare against the $33,000 threshold.
Combined total = 15,350+15,350 + 20,000 = 35,350.Since35,350. Since 35,350 > $33,000, the statement is True.
Summing both monthly totals reconciles data across both tabs to evaluate the benchmark condition.

Key Concept

Quantitative Data Reconciliation Across Multi-Tier Pricing Policies and Usage Logs
Rate this question

Topics

Quantitative Data Reconciliation Across Sources

More questions from this topic