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

Database Administration 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 Database Administration flashcards as text

  1. A telecom DBA must implement data masking for a test environment that mirrors production subscriber data. Which approach is MOST appropriate?

    Answer: Implement static data masking to anonymize PII before copying to the test environment

    Static data masking replaces PII with realistic but fictitious values before exposing data to non-production environments, maintaining privacy compliance.

  2. In a telecom network management database, which index type is MOST efficient for full-text searches on alarm descriptions?

    Answer: Full-text index

    Full-text indexes are optimized for searching within text content, enabling fast keyword searches across alarm description fields.

  3. What does RTO (Recovery Time Objective) measure in a telecom database disaster recovery plan?

    Answer: The maximum acceptable time to restore database operations after a failure

    RTO defines the maximum tolerable downtime from failure to restoration of normal database operations.

  4. A telecom carrier stores ENUM-coded network event types in a database. Which database design approach avoids hard-coding ENUM values and supports future additions?

    Answer: Use a reference/lookup table to store event types and join to it

    Reference tables externalize enumerated values, allowing new event types to be added via INSERT without schema or code changes.

  5. Which concurrency control mechanism uses version numbers or timestamps to detect conflicts without locking rows, commonly used in telecom self-service portals?

    Answer: Optimistic locking

    Optimistic locking checks for version conflicts only at commit time, avoiding lock contention in high-read, low-conflict workloads like customer portals.

  6. In a telecom data warehouse, what is the difference between a FACT table and a DIMENSION table?

    Answer: Fact tables store measurable metrics and foreign keys to dimensions; dimension tables store descriptive attributes

    Fact tables contain quantitative metrics (call duration, revenue) and foreign keys linking to dimension tables, which hold descriptive context like subscriber and time attributes.

  7. A telecom DBA must schedule database maintenance tasks without impacting business-hours operations. Which SQL Agent feature enables this?

    Answer: Scheduled jobs or maintenance plans with defined time windows

    Scheduled maintenance plans or SQL Agent jobs allow DBAs to define specific off-peak time windows for index rebuilds, statistics updates, and backups.