CCDM Database Management 4 — Questions and Answers
Question 1: In CDISC standards, what does the SDTM model primarily define?
- The format for submitting clinical trial data to regulatory agencies (Correct answer)
- The statistical methods for analyzing primary endpoints
- The structure of informed consent forms
- The requirements for electronic signatures in EDC systems
Correct answer: The format for submitting clinical trial data to regulatory agencies
The Study Data Tabulation Model (SDTM) defines a standard structure for organizing and formatting clinical study data for submission to regulatory agencies like the FDA.
Question 2: What is a primary key in a clinical trial database table?
- The most important variable used in the primary efficacy analysis
- A unique identifier for each record within a table (Correct answer)
- The encryption key used to protect sensitive data
- The first column entered in each CRF page
Correct answer: A unique identifier for each record within a table
A primary key is a unique identifier assigned to each record in a database table, ensuring no two records have the same key value.
Question 3: Which of the following best describes a 'flat file' in the context of clinical data exchange?
- A compressed database backup stored on a secure server
- A simple text-based file where data is organized in rows and columns without relational structure (Correct answer)
- An XML file used for CDISC data submission
- A database view that displays summarized data
Correct answer: A simple text-based file where data is organized in rows and columns without relational structure
A flat file is a simple text-based file (such as CSV or TXT) that stores data in a two-dimensional format without the relational structure of a database.
Question 4: When a clinical database undergoes a significant amendment mid-study, what is required before implementation?
- Approval from the data safety monitoring board only
- Revalidation and documentation of the changes according to change control procedures (Correct answer)
- Immediate notification to all site investigators via email
- Submission of the amendment to the FDA prior to any changes
Correct answer: Revalidation and documentation of the changes according to change control procedures
Any significant changes to a validated clinical database must follow formal change control procedures, including documentation, impact assessment, revalidation, and approval before implementation.
Question 5: What is a 'derived variable' in clinical database management?
- A variable whose value is computed from other collected data rather than directly entered (Correct answer)
- A variable carried forward from the previous visit
- A field that stores the investigator's clinical assessment
- A randomly assigned identifier replacing the patient's name
Correct answer: A variable whose value is computed from other collected data rather than directly entered
A derived variable is calculated from other variables in the database (e.g., BMI derived from height and weight) rather than being directly entered by site staff.
Question 6: In the context of clinical trials, what is the purpose of a 'query management system'?
- To search the medical literature for relevant publications
- To track, issue, and resolve data clarification requests between data management and sites (Correct answer)
- To manage database user access requests and permissions
- To generate statistical queries for endpoint analysis
Correct answer: To track, issue, and resolve data clarification requests between data management and sites
A query management system tracks all data clarification requests (DCFs/queries) issued to investigative sites and documents their resolution to ensure data accuracy.
Question 7: Which regulatory guidance emphasizes risk-based approaches to data quality management in clinical trials?
- ICH E6(R2) Good Clinical Practice (Correct answer)
- 21 CFR Part 50 (Informed Consent)
- ICH E3 (Clinical Study Reports)
- HIPAA Privacy Rule
Correct answer: ICH E6(R2) Good Clinical Practice
ICH E6(R2) GCP guidance emphasizes a risk-based approach to clinical trial conduct and data quality management, focusing resources on critical data and processes.
CCDM Database Management 4
In CDISC standards, what does the SDTM model primarily define?