DIS Database Administration 2

Question 1

In a digital imaging database, which indexing strategy best supports range queries on image capture dates?

Accepted Answer

B-tree index

Answer

B-tree indexes maintain sorted order, making them ideal for range queries on date fields.

Question 2

A DIS database stores EXIF metadata alongside image files. Which normal form violation occurs when camera model and manufacturer are stored in the same image record without a separate camera table?

Accepted Answer

3NF

Answer

Storing manufacturer derived from camera model in the same table violates 3NF due to a transitive dependency.

Question 3

Which PostgreSQL feature allows querying image metadata stored as JSON without extracting it into separate columns?

Accepted Answer

JSONB operators

Answer

PostgreSQL's JSONB operators like -> and ->> allow direct querying of JSON fields without restructuring the schema.

Question 4

When archiving high-resolution images, a DBA implements table partitioning by year. What is the primary benefit for query performance?

Accepted Answer

Enables partition pruning to scan only relevant data

Answer

Partition pruning allows the query planner to skip irrelevant partitions entirely, reducing I/O for date-filtered queries.

Question 5

A digital imaging database uses a connection pool. What happens when all pool connections are in use and a new request arrives?

Accepted Answer

The request waits in queue until a connection is released

Answer

Connection pools queue incoming requests until an active connection is returned to the pool.

(DIS) Digital Imaging Specialist Certification Practice Test

(DIS) Digital Imaging Specialist Certification Practice Test

DIS Database Administration 2