SCDM Database Design and Development 2 — Questions and Answers
Question 1: What is the purpose of a 'database lock' in clinical data management?
- To prevent further data changes after all queries are resolved and data is verified as clean (Correct answer)
- To restrict site access during a scheduled maintenance window
- To archive old study data to an external server
- To freeze database design before UAT begins
Correct answer: To prevent further data changes after all queries are resolved and data is verified as clean
Database lock occurs after all data issues are resolved and the database is declared clean, preventing any further modifications before statistical analysis and reporting.
Question 2: Which CDISC standard is used to define CRF data collection fields and their mapping to database variables?
- CDASH (Clinical Data Acquisition Standards Harmonization) (Correct answer)
- SDTM
- ADaM
- HL7 FHIR
Correct answer: CDASH (Clinical Data Acquisition Standards Harmonization)
CDASH provides standardized field names and collection methodologies for CRFs, facilitating consistent data collection and easier mapping to SDTM submission datasets.
Question 3: What is the function of a 'back-end edit check' in a clinical EDC system?
- A programmatic check run against the database to identify inconsistencies across records or visits (Correct answer)
- A manual review of data by a data manager after site entry
- A check performed by the site coordinator before form submission
- A real-time alert sent to the monitor during site visits
Correct answer: A programmatic check run against the database to identify inconsistencies across records or visits
Back-end edit checks run programmatically against the database at defined intervals, identifying cross-form, cross-visit, or cross-subject inconsistencies that front-end checks may miss.
Question 4: In clinical database development, what is a 'test environment'?
- A separate copy of the database used for validation testing without affecting production data (Correct answer)
- The server hardware used to run the live production database
- A staging area where subjects are randomized during UAT
- A backup copy of the database stored off-site
Correct answer: A separate copy of the database used for validation testing without affecting production data
A test environment is an isolated replica of the production system used exclusively for validation, testing, and training without risking the integrity of live study data.
Question 5: What is 'data normalization' in the context of clinical trial database design?
- Organizing data into tables to reduce redundancy and improve data integrity (Correct answer)
- Transforming raw data into standardized SDTM domains
- Converting continuous variables into categorical ranges
- Applying statistical transformations before analysis
Correct answer: Organizing data into tables to reduce redundancy and improve data integrity
Normalization organizes a relational database into well-defined tables and relationships to eliminate data redundancy, reduce anomalies, and improve overall data integrity.
Question 6: What is the significance of a 'change control' process in clinical database management?
- It ensures all modifications to the database after go-live are documented, reviewed, and approved before implementation (Correct answer)
- It tracks changes to the informed consent form at study sites
- It monitors real-time data entry rates across all sites
- It controls who has access to the final locked dataset
Correct answer: It ensures all modifications to the database after go-live are documented, reviewed, and approved before implementation
Change control is a formal process requiring that any post-go-live database changes be documented, impact-assessed, tested, approved, and tracked to maintain compliance and audit trails.
SCDM Database Design and Development 2
What is the purpose of a 'database lock' in clinical data management?