CIIP - Certified Imaging Informatics Professional Systems and Database Administration Questions and Answers

Question 1

Over several months, a PACS administrator notices that study query times are gradually increasing, and the database server is showing higher than normal disk activity.
Which routine database maintenance task is MOST likely to improve query performance and reclaim fragmented space?

Accepted Answer

Rebuilding or reorganizing database indexes

Answer

Performing daily full backups

Answer

Defragmenting the server's operating system drive

Answer

Increasing the server's allocated RAM

Question 2

An imaging informatics administrator is configuring a new storage array for the PACS short-term cache, where both high read/write performance and protection against a single disk failure are critical. Which RAID level BEST meets these requirements?

Accepted Answer

RAID 10 (Striping and Mirroring)

Answer

RAID 0 (Striping)

Answer

RAID 1 (Mirroring)

Answer

RAID 5 (Striping with Parity)

Question 3

A hospital's data center has multiple aging physical servers dedicated to various imaging applications, such as a RIS broker, an HL7 interface engine, and a dictation system. To improve resource utilization, centralize management, and reduce the hardware footprint, which technology should the administrator implement?

Accepted Answer

Server virtualization

Answer

Network load balancing

Answer

A Storage Area Network (SAN)

Answer

A clustered file system

Question 4

To ensure that the primary PACS application remains available to clinicians with minimal interruption in the event of a catastrophic hardware failure of a single server, which system configuration is MOST appropriate?

Accepted Answer

A high-availability failover cluster

Answer

A cold spare server stored offsite

Answer

A RAID 6 storage configuration

Answer

Nightly full system backups to tape

Question 5

A technologist reports that a specific CT study sent to PACS an hour ago is not visible on the radiologist's worklist. The PACS administrator needs to verify if the study's metadata was successfully received and stored in the application database. Which of the following SQL commands is the MOST direct and appropriate tool for this investigation?

Accepted Answer

SELECT

Answer

UPDATE

Answer

INSERT

Answer

DELETE

Question 6

Which of the following is a key proactive activity for a systems administrator to identify potential PACS performance bottlenecks BEFORE they impact clinical users?

Accepted Answer

Routinely monitoring server CPU, memory, and network I/O metrics

Answer

Resolving help desk tickets within the agreed-upon service level agreement (SLA)

Answer

Restoring archived studies to fulfill a physician's request

Answer

Documenting system configuration changes in a change management log

Over several months, a PACS administrator notices that study query times are gradually increasing, and the database server is showing higher than normal disk activity.Which routine database maintenance task is MOST likely to improve query performance and reclaim fragmented space?

Over several months, a PACS administrator notices that study query times are gradually increasing, and the database server is showing higher than normal disk activity.
Which routine database maintenance task is MOST likely to improve query performance and reclaim fragmented space?