Examkin

Question

Difficulty: Very hardConditional Filtering and Selection

The table below presents technical specifications and operational parameters for seven Earth-observation satellites in a commercial constellation:

Satellite IDOperational StatusOrbital Altitude (km)Sensor Resolution (m)Downlink Speed (Gbps)
Sat-01Active4200.410
Sat-02Active5801.120
Sat-03Active6400.516
Sat-04Active4900.912
Sat-05Standby5100.618
Sat-06Active5500.514
Sat-07Active4501.58

What is the average (arithmetic mean) Downlink Speed, in Gbps, of all satellites that are currently Active, have an Orbital Altitude of at most 600 km, and satisfy AT LEAST ONE of the following criteria: a Sensor Resolution of less than 0.8 m OR a Downlink Speed of at least 15 Gbps?

  1. A
    12.00
  2. B
    12.80
  3. 14.67Answer
  4. D
    15.00
  5. E
    15.50

Answer

14.67 Gbps
The correct response identifies the three satellites (Sat-01, Sat-02, and Sat-06) that satisfy all mandatory criteria (Active status and altitude ≤600\leq 600 km) as well as at least one of the secondary criteria (resolution <0.8< 0.8 m or downlink ≥15\geq 15 Gbps). Their downlink speeds are 10, 20, and 14 Gbps respectively, yielding an arithmetic mean of 10+20+143=14.67\frac{10 + 20 + 14}{3} = 14.67 Gbps.

Step-by-Step Solution

1
Evaluate mandatory conditions (Operational Status = Active AND Orbital Altitude ≤600\leq 600 km).
Satellites meeting these two conditions are Sat-01 (420 km), Sat-02 (580 km), Sat-04 (490 km), Sat-06 (550 km), and Sat-07 (450 km). Sat-03 is excluded due to altitude (640 km >600> 600 km), and Sat-05 is excluded due to status (Standby).
Conjunctive criteria require all mandatory parameters to be met simultaneously.
2
Evaluate the disjunctive condition (Sensor Resolution <0.8< 0.8 m OR Downlink Speed ≥15\geq 15 Gbps) among the candidate satellites.
- Sat-01: Resolution =0.4= 0.4 m (<0.8< 0.8) →\rightarrow QUALIFIES
- Sat-02: Downlink =20= 20 Gbps (≥15\geq 15) →\rightarrow QUALIFIES
- Sat-04: Resolution =0.9= 0.9 m and Downlink =12= 12 Gbps →\rightarrow FAILS
- Sat-06: Resolution =0.5= 0.5 m (<0.8< 0.8) →\rightarrow QUALIFIES
- Sat-07: Resolution =1.5= 1.5 m and Downlink =8= 8 Gbps →\rightarrow FAILS
An OR condition requires a candidate to satisfy at least one of the sub-criteria.
3
Calculate the arithmetic mean Downlink Speed for the qualifying satellites (Sat-01, Sat-02, Sat-06).
Sum of downlink speeds = 10+20+14=4410 + 20 + 14 = 44 Gbps.
Mean = 443≈14.67\frac{44}{3} \approx 14.67 Gbps.
The mean is the total sum of downlink speeds divided by the count of filtered rows.

Key Concept

Multi-column compound filtering combining conjunctive AND and disjunctive OR conditions prior to aggregation.
Estimated Time:2m 30s
Rate this question

Topics

Conditional Filtering and Selection

More questions from this topic