Practice Test Geeks(CTE) Certified Telecommunications Executive Practice Test
← All CTE Flashcard Decks

Data Analytics Flashcards

7 cards from real CTE practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Analytics flashcards as text

  1. What is the primary advantage of real-time streaming analytics over batch analytics in a telecom NOC environment?

    Answer: Enables immediate detection and response to network anomalies as they occur

    Streaming analytics processes data in-flight (e.g., via Apache Kafka/Flink), allowing operators to trigger automated or human responses within seconds of an anomaly.

  2. A CTE executive is evaluating two churn models: Model A has 85% accuracy; Model B has 70% accuracy but 90% recall on churners. Which model is preferable for a retention campaign?

    Answer: Model B, because it catches more actual churners even at the cost of some false positives

    In churn prevention, missing a churner (false negative) is costlier than contacting a non-churner (false positive), so higher recall on the target class is preferred.

  3. What is 'data lakehouse' architecture, and why is it gaining adoption in large telecom operators?

    Answer: A hybrid storage layer combining the scalability of a data lake with the ACID transactions and schema enforcement of a data warehouse

    Lakehouse platforms (e.g., Delta Lake, Apache Iceberg) let telecoms store raw and curated data together while supporting BI tools and ML workloads without duplication.

  4. In telecom revenue assurance analytics, what does 'revenue leakage' refer to?

    Answer: Billable usage that is correctly generated but fails to be invoiced due to system or process gaps

    Revenue leakage occurs when the network registers usage but downstream billing, mediation, or rating processes fail to capture and charge it.

  5. Which SQL window function is most useful for calculating a rolling 7-day average of daily active users in a telecom analytics query?

    Answer: AVG() OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW)

    A ROWS BETWEEN 6 PRECEDING AND CURRENT ROW frame computes the average across the current day and the six preceding days, yielding a true 7-day rolling average.

  6. What is 'Simpson's Paradox' and why is it particularly relevant to telecom executive dashboards?

    Answer: A trend that appears in aggregated data reverses when the data is broken down by subgroups, leading to misleading conclusions

    Telecom KPIs can reverse direction when segmented (e.g., overall ARPU rising while declining in every individual region due to mix shift), so executives must always validate aggregated trends.

  7. A carrier deploys a self-service analytics portal for enterprise customers. Which security control is most critical for multi-tenant data isolation?

    Answer: Row-level security policies that enforce each tenant can only query their own data

    Row-level security (RLS) enforced at the database layer ensures that even if a query is misconfigured, one tenant cannot access another's data.