CTE Database Administration 3

Question 1

A telecom carrier's OLTP database must be separated from its analytics workload. Which architecture pattern BEST addresses this?

Accepted Answer

Implement a data warehouse with ETL pipelines feeding from the OLTP system

Answer

A data warehouse with ETL pipelines isolates analytics queries from OLTP operations, preventing resource contention.

Question 2

Which normal form eliminates transitive dependencies in a telecom subscriber database schema?

Accepted Answer

Third Normal Form (3NF)

Answer

Third Normal Form (3NF) requires that non-key attributes depend only on the primary key, eliminating transitive dependencies.

Question 3

In a high-availability telecom database cluster, what is the purpose of a 'witness' or 'arbiter' node?

Accepted Answer

To provide a tiebreaker vote during failover to prevent split-brain scenarios

Answer

A witness/arbiter node provides an odd quorum vote to prevent split-brain, ensuring only one node assumes the primary role during failover.

Question 4

A DBA discovers that a long-running report query on the telecom billing database is blocking other transactions. Which action is MOST appropriate?

Accepted Answer

Move the report query to a read replica or reporting database

Answer

Routing report queries to a read replica isolates analytics workloads from OLTP transactions, eliminating blocking.

Question 5

Which SQL command is used to reclaim storage and update statistics after a large batch delete of expired CDR records in a telecom database?

Accepted Answer

VACUUM or REORGANIZE INDEX (database-specific)

Answer

VACUUM (PostgreSQL) or REORGANIZE INDEX (SQL Server) reclaims fragmented space and updates statistics after large data deletions.

(CTE) Certified Telecommunications Executive Practice Test