CAIC Database Administration 5

Question 1

An AI model serving system requires sub-millisecond feature lookups. Which database architecture best satisfies this latency requirement?

Accepted Answer

An in-memory key-value store (e.g., Redis) with pre-computed features

Answer

In-memory key-value stores like Redis serve pre-computed features in microseconds from RAM, making them the standard choice for low-latency online feature serving.

Question 2

When designing a database schema for A/B testing AI model variants, which schema design correctly associates each prediction with its serving model version?

Accepted Answer

Create a foreign key from predictions.model_version_id to a model_versions table

Answer

A foreign key to a normalized model_versions table enforces referential integrity, enables joins for performance analysis, and avoids schema changes when new versions are added.

Question 3

A PostgreSQL database supporting AI workloads shows high I/O wait due to frequent random reads. Which configuration change most directly addresses this for read-heavy analytical queries?

Accepted Answer

Increasing effective_cache_size and shared_buffers to better utilize RAM

Answer

Increasing shared_buffers allows PostgreSQL to cache more data in memory, and setting effective_cache_size correctly guides the planner to prefer index scans, both reducing random disk reads.

Question 4

An AI application stores user interaction logs at 10,000 events per second. Which database design decision prevents write performance degradation as the table grows past 1 billion rows?

Accepted Answer

Declarative table partitioning by time range with automatic partition creation

Answer

Time-range partitioning keeps each partition small, so inserts target only the current partition, maintaining consistent write latency regardless of total historical data volume.

Question 5

A fintech AI system must ensure that two database operations — debiting a source account and crediting a destination account — always succeed or fail together. Which database property guarantees this?

Accepted Answer

Atomicity

Answer

Atomicity ensures that all operations within a transaction are treated as a single unit — either all are committed or all are rolled back if any step fails.

(CAIC) Certified AI Consultant Practice Test

(CAIC) Certified AI Consultant Practice Test

CAIC Database Administration 5