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

Database indexes are like the index of a book; they allow the database to find data quickly. Over time, as data is added, deleted, and modified, these indexes can become fragmented, leading to slower query performance. Rebuilding or reorganizing indexes makes data retrieval more efficient and can reclaim unused space, directly addressing the described symptoms. While other options are valid administrative tasks, they do not target the root cause of slow query performance due to data structure degradation.

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 10 combines the speed of RAID 0 (striping) with the redundancy of RAID 1 (mirroring). This configuration provides excellent read and write performance, which is crucial for a busy PACS cache, while also protecting against the failure of a single drive within a mirrored pair. RAID 0 offers speed but no redundancy. RAID 1 offers redundancy but lacks the performance boost of striping. RAID 5 has a 'write penalty' due to parity calculations, making it less ideal than RAID 10 for write-intensive applications.

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

Server virtualization allows multiple independent virtual machines (VMs), each with its own operating system and applications, to run on a single physical server. This directly addresses the goal of consolidating multiple applications from aging hardware onto fewer, more modern machines, thereby improving resource use, simplifying management, and saving space and power. The other options are related data center technologies but do not primarily serve the function of server consolidation.

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 high-availability failover cluster consists of two or more servers (nodes) that are configured so that if the active node fails, services are automatically and quickly transferred to a passive node. This process, known as failover, ensures minimal service interruption and is the standard for mission-critical applications like PACS. Backups and cold spares require significant manual intervention and result in extended downtime. RAID protects against disk failure, not a complete server failure.

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

The `SELECT` statement is the fundamental SQL command used to query a database and retrieve data from tables. To verify if the study's metadata exists, the administrator would use a `SELECT` query with criteria (e.g., Patient ID, Accession Number) to search the relevant tables. `UPDATE` modifies data, `INSERT` adds new data, and `DELETE` removes data; none of these are appropriate for simply checking for the existence of information.

CIIP - Certified Imaging Informatics Professional Practice Test

CIIP - Certified Imaging Informatics Professional Practice Test

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