Key details for this exam, checked against the published exam outline
Each question shows the correct answer and an explanation of why it is right
The result set from the query below would be which of the following?
SELECT Pt_ID, MRN, SSN FROM patient
In a SQL (Structured Query Language) database, the SELECT statement specifies which columns to display from a table. In this query, only three columns --- Pt_ID, MRN, and SSN --- are being selected from the patient table.
This means the resulting dataset will contain:
The same number of rows (records) as the original table (assuming no WHERE filter), and
Fewer columns than the full table.
In database terminology:
''Wider'' refers to more columns (fields).
''Narrower'' refers to fewer columns (fields).
Since this query retrieves only 3 columns (out of potentially many in the original table), the result set is narrower than the patient table, making option D correct.
Reference (CCDM-Verified Sources):
SCDM GCDMP, Chapter: Database Design and Build, Section 5.1 -- Relational Databases and Query Logic
ICH E6(R2) GCP, Section 5.5.3 -- Data Retrieval and Integrity Principles
FDA Guidance for Industry: Computerized Systems Used in Clinical Investigations, Section 6.4 -- Database Query Controls
Which of the following statements would be BEST included in a data management plan describing the process for making self-evident corrections in a clinical database?
A self-evident correction (SEC) refers to a data correction that is obvious, logical, and unambiguous --- such as correcting an impossible date (e.g., 31-APR-2024) or standardizing a known abbreviation (e.g., ''BP'' to ''Blood Pressure''). According to the Good Clinical Data Management Practices (GCDMP), SECs can be applied by data management staff following pre-approved conventions defined in the Data Management Plan (DMP).
The DMP should explicitly describe the criteria for SECs, including the types of errors eligible for this correction method, the required documentation, and the communication procedure to inform the investigative site. The process must maintain audit trail transparency and ensure that all changes are traceable and justified.
Options A and B suggest unauthorized or informal change procedures, which violate audit and compliance standards. Option C is too restrictive, as it prevents the efficient correction of non-clinical transcription or formatting errors.
Therefore, option D is correct: ''Self-evident changes may be made per the listed conventions and documented to the investigative site.'' This approach aligns with CCDM expectations for balancing efficiency, accuracy, and regulatory compliance.
Reference (CCDM-Verified Sources):
SCDM GCDMP, Chapter: Data Validation and Cleaning, Section 6.2 -- Self-Evident Corrections
FDA 21 CFR Part 11 -- Electronic Records; Audit Trails and Traceability Requirements
A study has an expected enrollment period of one year but has subject recruitment issues. Twelve new sites are added toward the end of the expected enrollment period to help boost enrollment. What is the most likely impact on data flow?
Adding multiple new sites late in the enrollment period creates a concentrated influx of new data near the end of the study. These sites typically start enrolling patients later, resulting in a ''bolus'' of Case Report Forms (CRFs) that must be entered, validated, and cleaned within a shorter timeframe to meet database lock deadlines.
According to the Good Clinical Data Management Practices (GCDMP, Chapter: Project Management and Data Flow), late site activation compresses the timeline for data management tasks, necessitating increased resources for data entry, query management, and cleaning. Data management teams must anticipate this surge and plan accordingly---either by increasing staffing or revising timelines to prevent bottlenecks and maintain quality.
While option D (increased query rates) can occur, it is a secondary effect. The most direct and consistent impact is the surge in data volume requiring expedited processing near study end.
Reference (CCDM-Verified Sources):
SCDM GCDMP, Chapter: Project Management, Section 5.3 -- Managing Changes in Site Activation and Data Flow
ICH E6(R2) GCP, Section 5.1 -- Quality Management and Oversight
For ease of data processing, the study team would like the database codes for a copyrighted rating scale preprinted on the CRF. What is the most critical task that the CRF designer must do to ensure the data collected on the CRF for the scale are reliable and will support the results of the final analysis?
When using a copyrighted or validated rating scale (e.g., Hamilton Depression Scale, Visual Analog Pain Scale), any modification to the original instrument, including preprinting database codes on the CRF, must be approved by the instrument's owner or licensing authority to ensure the validity and reliability of the instrument are not compromised.
According to the GCDMP (Chapter: CRF Design and Data Collection), validated rating scales are psychometrically tested tools. Any visual or structural modification (such as adding codes, changing layout, or rewording questions) can invalidate prior validation results. Therefore, the CRF designer must consult the independent source (copyright holder) for approval and document that the validity of the tool remains intact.
Merely consulting statisticians (option B) or verifying database alignment (option D) does not ensure compliance. Thus, Option C ensures scientific and regulatory integrity.
Reference (CCDM-Verified Sources):
SCDM Good Clinical Data Management Practices (GCDMP), Chapter: CRF Design and Data Collection, Section 6.1 -- Use of Validated Instruments and Rating Scales
ICH E6 (R2) GCP, Section 5.5.3 -- Validation of Instruments and Data Capture Tools
FDA Guidance for Industry: Patient-Reported Outcome Measures -- Use in Medical Product Development to Support Labeling Claims, Section 4 -- Instrument Modification and Validation
A study uses commercially available activity monitors and collects data for each patient weekly by selecting and downloading the data from the manufacturer's website. There are 100 patients in the study and it takes the Data Manager 20 minutes per file to download, import, and process the dat
a. Assuming that the distribution of work is uniform over the six-month trial, how many Data Managers are needed for the activity data alone?
This question tests workload estimation and resource planning, which are fundamental competencies outlined in the Good Clinical Data Management Practices (GCDMP, Chapter on Project Management in Data Management). The task is to determine the Data Manager effort required based on the frequency and duration of data collection and processing activities.
Let's calculate step by step:
Number of patients: 100
Frequency: Weekly (once per week)
Duration: 6 months 26 weeks
Time per file: 20 minutes
Total time per week:
100 patients 20 minutes = 2,000 minutes per week
= 2,000 60 = 33.3 hours per week
Total hours over 6 months:
33.3 hours/week 26 weeks = 866 hours total
A full-time Data Manager typically works ~160 hours per month, so over six months:
160 6 = 960 hours total full-time capacity.
Therefore, the workload of 866 hours is approximately equivalent to one full-time Data Manager working across the six-month period:
866 960 0.9 FTE (Full-Time Equivalent).
This aligns most closely with Option D: One Data Manager per month (i.e., a full-time resource is required throughout the duration of the trial).
According to the GCDMP Project Management chapter, accurate resource estimation is critical in ensuring data management timelines are met without overloading staff or compromising data quality. The estimation process must consider not just the raw data download time but also associated data processing, verification, and upload into the clinical database.
Other options underestimate the effort significantly:
A (10%) and B (50%) do not account for cumulative weekly workload across multiple patients.
C (Two Data Managers) overestimates, as one Data Manager working full-time can manage the load efficiently.
Therefore, Option D is correct --- approximately one full-time Data Manager (1.0 FTE) is required for the activity data alone during the six-month trial.
Reference (CCDM-Verified Sources):
Society for Clinical Data Management (SCDM), Good Clinical Data Management Practices (GCDMP), Chapter: Project Management in Data Management, Section 5.3 -- Workload Estimation and Resource Allocation
SCDM GCDMP, Chapter: Data Handling and Processing -- Effort Estimation for Repetitive Data Tasks
ICH E6 (R2) Good Clinical Practice, Section 5.1 -- Quality Management and Resource Planning
FDA Guidance for Industry: Electronic Source Data in Clinical Investigations, Section 4.3 -- Operational Considerations for Data Management Activities
An organization conducts over fifty studies per year. Currently each study is specified and set-up from scratch. Which of the following organizational infrastructure options would streamline database set-up and study-to-study consistency?
To improve efficiency and ensure consistency across multiple studies, the most effective infrastructure solution is to maintain a centralized library of standardized forms or screen modules (e.g., CRF/eCRF templates).
According to the Good Clinical Data Management Practices (GCDMP, Chapter: Database Design and Build), using a form library allows reuse of validated data collection modules for commonly collected domains such as demographics, adverse events, and vital signs. This reduces database setup time, enhances uniformity in data definitions, and ensures alignment with standards such as CDISC CDASH and SDTM.
While adopting ODM (A) provides standardized data exchange and interoperability, it does not inherently reduce setup workload. Improving design processes (C) enhances efficiency but doesn't guarantee consistency, and implementing controlled terminology (D) helps with coding standardization, not database structure.
Therefore, option B --- maintaining a library of form or screen modules --- provides the most direct and sustainable improvement for scalability and quality.
Reference (CCDM-Verified Sources):
SCDM GCDMP, Chapter: Database Design and Build, Section 5.3 -- Use of Standard Libraries and Templates
CDISC CDASH Implementation Guide, Section 3.2 -- Reusable CRF Modules and Standardization
ICH E6(R2) GCP, Section 5.5.3 -- Standardization and Reuse in Data Collection Systems
Which competency is necessary for EDC system use in a study using the medical record as the source?
In studies where the medical record serves as the source document, the Electronic Data Capture (EDC) system users (typically study coordinators or site personnel) must have appropriate training on how to access and log into the medical record system. This competency ensures that data abstracted from the electronic medical record (EMR) are complete, accurate, and verifiable in compliance with Good Clinical Practice (GCP) and Good Clinical Data Management Practices (GCDMP).
According to the GCDMP (Chapter: EDC Systems and Data Capture) and ICH E6(R2), all personnel involved in data entry and verification must be trained in both the EDC and the primary source systems (e.g., EMR). This ensures that the integrity of data flow---from source to EDC---is maintained, and that personnel understand system access controls, audit trails, and proper documentation of source verification.
While resolving discrepant data (C) and screening subjects (A) are part of study operations, the competency directly related to EDC system use in EMR-based studies is the ability to properly log into and navigate the medical records system to extract source data.
Reference (CCDM-Verified Sources):
SCDM GCDMP, Chapter: Electronic Data Capture (EDC), Section 5.1 -- Source Data and System Access Requirements
ICH E6(R2) Good Clinical Practice, Section 4.9 -- Source Documents and Data Handling
FDA Guidance: Use of Electronic Health Record Data in Clinical Investigations, Section 3 -- Investigator Responsibilities
Exam domains verified against: Official SCDM CCDM exam guide, last checked October 2026.
Plan and construct the technical infrastructure for a clinical study. This includes identifying what data to collect, defining data elements, designing case report forms and their completion guidelines, annotating forms, designing workflows and data flows, writing procedures that support auditability, maintaining data management plans, specifying database tables and entry screens, defining edit checks and reports, and writing data transfer specifications. You will also select, implement, and manage data standards, and respond to audit findings.
Educate cross-functional teams and spread knowledge of data management processes across the organization. This covers designing and delivering training that follows instructional design principles and evaluating its effectiveness. The goal is to build shared understanding of data management best practices throughout your study team and wider organization.
Sample question from this domain above: Q7
Manage the day-to-day flow and quality of study data from collection through archive. This includes collecting and entering data, importing and exporting information between systems, linking data from different sources, reconciling externally sourced data, transforming and coding data, identifying discrepancies, querying sites to resolve issues, updating the database, measuring data quality, and applying analytics to spot problems and opportunities. You also manage system access and archive or share study data.
Sample question from this domain above: Q4
Build and run comprehensive tests to verify the data system works as designed. You will draft test plans and test data for database tables, user interfaces, workflows, reports, and data transformations. Testing covers system validation, user acceptance, and usability. After testing, you execute the tests, document the results, and track any issues discovered.
Sample question from this domain above: Q5
Direct and oversee the work of clinical data managers, data processing staff, and computer programmers. This involves assigning work, monitoring quality, providing feedback, and ensuring the team has the guidance and resources needed to complete data management activities on schedule and to specification.
Lead the operational side of data management on a study. You will define the scope of work, select and manage vendors, estimate workload and manage timelines, coordinate the start of data management activities, oversee data collection and processing, lock the database when complete, track data metrics, identify and manage risk, prepare for audits, plan and run project meetings, and maintain the project communication plan.
Check and validate data and documentation to catch errors before they propagate. You will review study documents like protocols and consent forms to identify what impact they have on data collection, review data in tables, listings, and figures as well as clinical study reports for accuracy and proper documentation of data handling, and review the work of junior data managers and processors.
Common questions about the exam itself
