CTE Database Administration 2

Question 1

A telecom OSS database experiences slow query performance on a table with 50 million CDR records. Which indexing strategy is MOST appropriate?

Accepted Answer

Add a composite index on frequently filtered columns like call_date and subscriber_id

Answer

Composite indexes on high-cardinality filter columns dramatically reduce scan rows for CDR queries.

Question 2

In a telecom billing database, which isolation level prevents dirty reads while allowing non-repeatable reads?

Accepted Answer

READ COMMITTED

Answer

READ COMMITTED prevents dirty reads by only reading committed data, but allows non-repeatable reads if another transaction commits between reads.

Question 3

A DBA at a telecom carrier needs to partition a large subscriber table. Which partitioning method is BEST for range-based monthly billing cycles?

Accepted Answer

Range partitioning on bill_date

Answer

Range partitioning on bill_date aligns naturally with monthly billing cycles, enabling efficient partition pruning for period-based queries.

Question 4

Which database object is used in telecom OSS/BSS systems to enforce referential integrity between subscriber accounts and their associated service orders?

Accepted Answer

Foreign key constraint

Answer

Foreign key constraints enforce referential integrity by ensuring service order records cannot reference non-existent subscriber accounts.

Question 5

A telecom DBA must ensure the billing database can recover to any point in the last 24 hours. Which backup strategy supports this requirement?

Accepted Answer

Daily full backups with continuous transaction log backups

Answer

Continuous transaction log backups combined with full backups enable point-in-time recovery to any moment within the retention window.

(CTE) Certified Telecommunications Executive Practice Test

(CTE) Certified Telecommunications Executive Practice Test

CTE Database Administration 2