Examkin

Soru

Zorluk: OrtaConditional Filtering and Selection

The table below shows performance and operational metrics for six regional fulfillment hubs operated by a global logistics network:

Hub IDRegionAutomation LevelOn-Time Delivery Rate (%)Daily Order Volume (thousands)
H-101North AmericaHigh94.5%120
H-102EuropeMedium91.0%85
H-103Asia-PacificHigh96.2%150
H-104North AmericaHigh89.5%110
H-105EuropeHigh95.0%95
H-106Asia-PacificMedium92.8%140

A fulfillment hub qualifies for an operational excellence award if it meets all of the following three conditions:
- Its Automation Level is 'High'.
- Its On-Time Delivery Rate is at least 93.0%.
- Its Daily Order Volume is greater than 100 thousand orders.

What is the total combined Daily Order Volume (in thousands) of the fulfillment hubs that qualify for the operational excellence award?

  1. 270Cevap
  2. B
    365
  3. C
    380
  4. D
    475
  5. E
    615

Cevap

270 thousand orders
To qualify for the award, a hub must satisfy three conditions simultaneously: Automation Level must be 'High', On-Time Delivery Rate must be at least 93.0%, and Daily Order Volume must exceed 100 thousand. Evaluating each hub row by row:
- H-101 meets all three criteria (High, 94.5% ≥ 93.0%, 120 > 100).
- H-102 fails on all criteria.
- H-103 meets all three criteria (High, 96.2% ≥ 93.0%, 150 > 100).
- H-104 fails the delivery rate condition (89.5% < 93.0%).
- H-105 fails the order volume condition (95 ≤ 100).
- H-106 fails the automation and delivery rate conditions.

The only qualifying hubs are H-101 and H-103. Summing their order volumes gives 120 + 150 = 270 thousand.

Adım Adım Çözüm

1
Identify the compound filter criteria
Hubs must simultaneously satisfy: (1) Automation Level = 'High', (2) On-Time Delivery Rate ≥ 93.0%, and (3) Daily Order Volume > 100.
The stem specifies that a hub must meet all three conditions to qualify.
2
Evaluate each hub against all three criteria
H-101: High (Yes), 94.5% ≥ 93.0% (Yes), 120 > 100 (Yes) -> Qualifies.
H-102: Medium (No), 91.0% < 93.0% (No), 85 ≤ 100 (No) -> Does not qualify.
H-103: High (Yes), 96.2% ≥ 93.0% (Yes), 150 > 100 (Yes) -> Qualifies.
H-104: High (Yes), 89.5% < 93.0% (No), 110 > 100 (Yes) -> Does not qualify.
H-105: High (Yes), 95.0% ≥ 93.0% (Yes), 95 ≤ 100 (No) -> Does not qualify.
H-106: Medium (No), 92.8% < 93.0% (No), 140 > 100 (Yes) -> Does not qualify.
A row is excluded if even one conjunctive condition is violated.
3
Aggregate the target attribute for qualifying rows
Qualifying Hubs: H-101 (120 thousand) and H-103 (150 thousand).
Total Daily Order Volume = 120 + 150 = 270 thousand.
The question asks for the sum of Daily Order Volume for the qualifying subset.

Anahtar Kavram

Multi-Column Conjunctive Table Filtering
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Conditional Filtering and Selection

Bu konudan daha fazla soru