CCDM Data Standards & Database Design 3 — Questions and Answers
Question 1: In ADaM dataset design, what is the key distinguishing feature of a BDS (Basic Data Structure) dataset?
- One record per subject
- One or more records per subject per analysis parameter per timepoint (Correct answer)
- One record per adverse event
- One record per visit across all subjects
Correct answer: One or more records per subject per analysis parameter per timepoint
ADaM BDS datasets have one or more records per subject per analysis parameter per timepoint, supporting a wide variety of statistical analyses.
Question 2: What is the purpose of the SUPPQUAL (Supplemental Qualifiers) dataset in SDTM?
- To store adverse event supplemental data only
- To hold additional non-standard variables that cannot be accommodated in the parent domain (Correct answer)
- To provide quality control flags for all domains
- To capture laboratory reference ranges separately
Correct answer: To hold additional non-standard variables that cannot be accommodated in the parent domain
SUPPQUAL datasets store additional qualifier variables for a parent domain when standard domain variables are insufficient.
Question 3: When designing a database edit check, what is the difference between a 'range check' and a 'cross-field check'?
- Range checks validate dates; cross-field checks validate lab values
- Range checks verify a single value against defined limits; cross-field checks compare two or more fields for consistency (Correct answer)
- Range checks are automated; cross-field checks require manual review
- Range checks apply to numeric data only; cross-field checks apply to text data only
Correct answer: Range checks verify a single value against defined limits; cross-field checks compare two or more fields for consistency
A range check validates that a single field value falls within predefined acceptable bounds, while a cross-field check verifies logical relationships between multiple fields.
Question 4: Which MedDRA hierarchy level is used as the primary endpoint coding level in most adverse event analyses?
- System Organ Class (SOC)
- High Level Group Term (HLGT)
- Preferred Term (PT) (Correct answer)
- Lowest Level Term (LLT)
Correct answer: Preferred Term (PT)
The Preferred Term (PT) is the primary level for MedDRA coding in adverse event analyses, as it represents a distinct medical concept.
Question 5: A study team finds that the same adverse event is coded differently across two clinical sites. Which root cause is MOST likely?
- Incorrect database schema design
- Inconsistent application of coding dictionaries or versions (Correct answer)
- Network connectivity issues during data transfer
- Missing primary key constraints
Correct answer: Inconsistent application of coding dictionaries or versions
Inconsistent coding occurs when different sites use different versions of MedDRA or apply coding conventions differently without centralized oversight.
Question 6: In database design for clinical trials, what is the primary advantage of using a metadata-driven approach?
- It eliminates the need for data validation entirely
- It allows the system to generate forms, edits, and reports from a central specification, reducing hard-coding (Correct answer)
- It automatically maps data to SDTM domains without human intervention
- It replaces the need for a data management plan
Correct answer: It allows the system to generate forms, edits, and reports from a central specification, reducing hard-coding
A metadata-driven system uses a central repository of specifications to dynamically drive form generation, edit checks, and reporting, improving consistency and efficiency.
Question 7: What is the role of the DEFINE-XML document in a regulatory submission package?
- A protocol summary submitted alongside datasets
- A machine-readable metadata file describing all datasets, variables, and controlled terminology in the submission (Correct answer)
- An XML version of the clinical study report
- A validation report generated by Pinnacle 21
Correct answer: A machine-readable metadata file describing all datasets, variables, and controlled terminology in the submission
Define-XML (based on CDISC ODM) provides a comprehensive, machine-readable data dictionary for all datasets in a regulatory submission.
CCDM Data Standards & Database Design 3
In ADaM dataset design, what is the key distinguishing feature of a BDS (Basic Data Structure) dataset?