SCDM Database Design and Development 1 — Questions and Answers
Question 1: What is the primary purpose of a clinical trial database validation plan?
- To document the approach and criteria for validating the database before data collection begins (Correct answer)
- To describe how data will be analyzed statistically
- To outline the schedule for database lock
- To assign roles to data management staff
Correct answer: To document the approach and criteria for validating the database before data collection begins
A database validation plan outlines the strategy, scope, test cases, and acceptance criteria to confirm that the clinical database functions correctly and meets study requirements.
Question 2: In clinical database design, what is the purpose of a 'data dictionary'?
- To define and document all variables, formats, and allowable values in the database (Correct answer)
- To list all adverse events observed during the trial
- To map CRF field labels to SAE reporting categories
- To store the statistical analysis dataset
Correct answer: To define and document all variables, formats, and allowable values in the database
A data dictionary provides a comprehensive reference that defines each variable's name, label, type, format, allowable values, and derivation rules used in the clinical database.
Question 3: What does 'user acceptance testing' (UAT) involve in EDC system development?
- End users verifying that the system meets business requirements before go-live (Correct answer)
- Software engineers testing code logic before deployment
- A regulatory agency reviewing the system design
- Database administrators validating server performance
Correct answer: End users verifying that the system meets business requirements before go-live
UAT is performed by intended end users (e.g., data managers and clinical staff) to confirm that the EDC system meets functional requirements and is fit for purpose prior to production use.
Question 4: Which CDISC standard defines the structure for tabulation datasets submitted to regulatory agencies?
- SDTM (Study Data Tabulation Model) (Correct answer)
- ODM (Operational Data Model)
- ADaM (Analysis Data Model)
- CDASH (Clinical Data Acquisition Standards Harmonization)
Correct answer: SDTM (Study Data Tabulation Model)
SDTM defines the structure and organization of datasets for submission to regulatory agencies like the FDA, organizing data into standardized domain models.
Question 5: What is a 'range check' in clinical database design?
- An edit check that flags values outside a predefined acceptable range for a variable (Correct answer)
- A process to verify subject ID ranges across sites
- A review of date ranges for all visit windows
- A comparison of data across parallel database versions
Correct answer: An edit check that flags values outside a predefined acceptable range for a variable
A range check is a programmed edit check that automatically flags data values falling outside predefined minimum and maximum limits, triggering a query for resolution.
Question 6: In relational database design for clinical trials, what is the purpose of a foreign key?
- To establish a link between records in two related tables and enforce referential integrity (Correct answer)
- To encrypt sensitive subject data in the database
- To define the primary identifier for each record
- To store protocol visit schedule information
Correct answer: To establish a link between records in two related tables and enforce referential integrity
A foreign key in a relational database links records in one table to a related record in another table, enforcing referential integrity and preventing orphan records.
SCDM Database Design and Development 1
What is the primary purpose of a clinical trial database validation plan?