CCDM Database Management 5 — Questions and Answers
Question 1: What is the significance of 'metadata' in a clinical trial database?
- It refers to the actual patient-level efficacy data collected during the trial
- It describes the structure, context, and properties of the data stored in the database (Correct answer)
- It contains the statistical analysis results from the primary endpoints
- It stores the audit trail of all database modifications
Correct answer: It describes the structure, context, and properties of the data stored in the database
Metadata in a clinical trial database describes the data itself — including field names, data types, validation rules, and relationships — providing context for the actual collected data.
Question 2: In clinical database validation, what is the purpose of a 'traceability matrix'?
- To map source data to final analysis datasets
- To link user requirements to test cases, demonstrating that all requirements have been tested (Correct answer)
- To trace adverse events back to their causative medications
- To document the lineage of data from collection to archiving
Correct answer: To link user requirements to test cases, demonstrating that all requirements have been tested
A traceability matrix maps each user requirement to corresponding test cases, ensuring every requirement has been tested and verified during database validation.
Question 3: What is the difference between a 'hard lock' and a 'soft lock' in clinical trial database management?
- A hard lock is temporary; a soft lock is permanent
- A soft lock restricts editing pending query resolution; a hard lock prevents all modifications after final clean (Correct answer)
- A hard lock requires IRB approval; a soft lock requires sponsor approval only
- A soft lock applies to individual fields; a hard lock applies to entire CRF pages
Correct answer: A soft lock restricts editing pending query resolution; a hard lock prevents all modifications after final clean
A soft lock prevents data changes until outstanding queries are resolved, while a hard lock permanently freezes all data after the database has been fully cleaned and reviewed.
Question 4: Which CDISC standard is used for the exchange of individual patient data between sponsors and regulatory agencies, specifying dataset metadata?
- CDASH
- ODM (Operational Data Model) (Correct answer)
- ADaM
- SEND
Correct answer: ODM (Operational Data Model)
The CDISC ODM (Operational Data Model) is an XML-based standard for the interchange of clinical data and metadata between different systems and organizations.
Question 5: In a clinical EDC system, what is the function of a 'visit schedule' configuration?
- To automatically schedule patient appointments at the investigative site
- To define which CRF pages and data fields are available or required at each study visit (Correct answer)
- To track investigator availability for monitoring visits
- To generate visit summary reports for the DSMB
Correct answer: To define which CRF pages and data fields are available or required at each study visit
A visit schedule configuration in an EDC system defines which CRF modules and fields are presented, required, or conditionally available at each protocol-specified visit.
Question 6: What is 'data warehousing' in the context of clinical development programs?
- The physical storage of paper CRFs in a secure archive facility
- A system for integrating and storing large volumes of data from multiple studies for cross-study analysis (Correct answer)
- The process of encrypting database backups before offsite transfer
- A method for compressing database files to reduce storage costs
Correct answer: A system for integrating and storing large volumes of data from multiple studies for cross-study analysis
A clinical data warehouse integrates data from multiple studies and sources into a central repository, enabling cross-study analysis, trend identification, and portfolio-level reporting.
Question 7: Which action is most appropriate when a discrepancy is found between source document data and EDC data during site monitoring?
- The monitor should correct the EDC data directly without documentation
- A data query should be raised so the site can review and correct the discrepancy with an audit trail (Correct answer)
- The sponsor should amend the protocol to accept the EDC data as correct
- The site should rewrite the source document to match the EDC entry
Correct answer: A data query should be raised so the site can review and correct the discrepancy with an audit trail
When a discrepancy is identified, a formal query should be raised so the site can investigate and correct the data in the EDC system with a documented audit trail, preserving data integrity.
CCDM Database Management 5
What is the significance of 'metadata' in a clinical trial database?