CCDM Data Validation 4 — Questions and Answers
Question 1: What is the primary regulatory expectation for audit trails in clinical database systems under 21 CFR Part 11?
- Audit trails must be reviewed by the FDA before database lock
- Audit trails must be computer-generated, time-stamped, and capture all changes to electronic records (Correct answer)
- Audit trails are only required for safety data fields
- Audit trails must be printed and stored with the paper CRFs
Correct answer: Audit trails must be computer-generated, time-stamped, and capture all changes to electronic records
21 CFR Part 11 requires that electronic systems maintain secure, computer-generated, time-stamped audit trails that record all data creation, modification, and deletion events.
Question 2: In clinical data validation, what does 'referential integrity' mean in the context of relational databases?
- That all references cited in the protocol are accurate
- That relationships between linked database tables remain consistent and valid (Correct answer)
- That all data references to published literature are verified
- That the database version referenced in the DMP matches the production system
Correct answer: That relationships between linked database tables remain consistent and valid
Referential integrity ensures that relationships between tables in a relational database are maintained, preventing orphaned records or broken foreign key links.
Question 3: A validation check flags a subject whose date of death is recorded before their last known alive date. This is an example of which category of error?
- Range error
- Completeness error
- Temporal inconsistency error (Correct answer)
- Uniqueness error
Correct answer: Temporal inconsistency error
A temporal inconsistency error occurs when dates or time sequences are recorded in an order that is logically impossible, such as a death date preceding a survival date.
Question 4: What is the term for the process of comparing data entered into the clinical database against the original source documents at the investigative site?
- Data reconciliation
- Source Data Verification (SDV) (Correct answer)
- Data transformation validation
- Central monitoring
Correct answer: Source Data Verification (SDV)
Source Data Verification (SDV) is the process by which a monitor compares data in the clinical database or CRF against original source documents at the site to confirm accuracy.
Question 5: Which approach to data validation involves applying statistical methods to identify data patterns that suggest errors or fraud without visiting the site?
- On-site monitoring
- Risk-Based Monitoring (RBM) with centralized monitoring (Correct answer)
- Source document verification
- Manual discrepancy management
Correct answer: Risk-Based Monitoring (RBM) with centralized monitoring
Risk-Based Monitoring uses centralized statistical and analytical techniques to detect unusual data patterns, potential fraud, or systematic errors remotely.
Question 6: In validation of clinical data systems, what is the purpose of an Installation Qualification (IQ) test?
- To verify that the software performs its intended functions correctly
- To confirm that the system was installed correctly and meets design specifications (Correct answer)
- To validate user access controls and security settings
- To test the system under peak load conditions
Correct answer: To confirm that the system was installed correctly and meets design specifications
Installation Qualification (IQ) verifies that the system has been installed correctly in its intended environment and that it matches the approved design specifications.
Question 7: What does a 'completeness check' in clinical data validation verify?
- That all required fields contain data values and are not left blank (Correct answer)
- That the entire study has completed enrollment
- That all edit checks have been resolved before database lock
- That the complete list of coding terms has been applied
Correct answer: That all required fields contain data values and are not left blank
A completeness check verifies that all mandatory fields in a CRF or dataset have been populated with a value, flagging any required fields that are blank.
CCDM Data Validation 4
What is the primary regulatory expectation for audit trails in clinical database systems under 21 CFR Part 11?