Free Practice Questions for SCDM CCDM Exam

TheData Manager (DM)plays a critical role in maintaining transparent communication with the clinical study team regardingdata quality and study progress. One of the most essential metrics regularly reported by the DM is thepercentage of data entered and cleaned.

According to theGood Clinical Data Management Practices (GCDMP, Chapter: Communication and Study Reporting), these metrics provide insight into study status, data readiness for interim analysis, and timeline predictability for database lock. Regular communication includes:

Percent of CRFs entered and verified

Percent of queries resolved

Outstanding data issues or missing pages

Other options fall outside the Data Manager’s direct responsibility:

A (Enrollment)is typically reported by clinical operations.

B (Staffing changes)are handled by site management.

D (Safety events)are communicated by the safety/pharmacovigilance team.

Thus,option Ccorrectly reflects the Data Manager’s responsibility for ongoing study communication.

Reference (CCDM-Verified Sources):

SCDM GCDMP, Chapter: Communication and Study Reporting, Section 5.3 – Study Metrics and Status Updates

ICH E6(R2) GCP, Section 5.1.1 – Communication and Oversight in Quality Management

FDA Guidance for Industry: Computerized Systems Used in Clinical Investigations, Section 6.5 – Data Status Reporting

In anElectronic Data Capture (EDC)system, even after a data manager completes all manual queries and marks data as "clean," the data may later appearuncleanifthe site (study coordinator)makes subsequent updates in the system after re-reviewing thesource documents.

According to theGood Clinical Data Management Practices (GCDMP, Chapter: Electronic Data Capture Systems), site users maintain the authority to modify data entries as long as the system remains open for data entry. TheEDC system audit trailcaptures such changes, which can automatically invalidate prior data reviews, triggering new discrepancies or changing system edit-check statuses.

This situation commonly occurs when the site identifies corrections in the source (e.g., wrong date or lab result) and updates the EDC form accordingly. These post-cleaning changes require additional review cycles to ensure the database reflects accurate and verified information before final lock.

Options B, C, and D are incorrect — CRAs and medical monitors cannot directly change EDC data; they can only raise queries or request updates.

Reference (CCDM-Verified Sources):

SCDM Good Clinical Data Management Practices (GCDMP), Chapter: Electronic Data Capture Systems, Section 6.3 – Post-Cleaning Data Changes and Audit Trails

ICH E6 (R2) GCP, Section 5.5.3 – Data Integrity and Change Control

FDA 21 CFR Part 11 – Electronic Records: Change Documentation Requirements

Enrolling subjects before theElectronic Data Capture (EDC) systemis ready poses majordata integrity and compliance risks. The primary issue is thatdata cannot be accurately captured, validated, or monitoredwithout the system in place.

Per theGCDMP (Chapter: Data Management Planning and Study Start-up), data collection systems must befully validated, tested, and releasedbefore enrollment begins to ensure:

Real-time data entry and quality control

Proper tracking of adverse events (AEs/SAEs)

Audit trails and traceability for regulatory compliance

Option A highlights the most critical consequence — without an operational EDC, data collection and verification processes cannot occur, compromising data quality and study oversight.

While options B, C, and D may be partially true, they aresecondary effects. The fundamental consideration is data capture capability and monitoring control, makingoption Acorrect.

Reference (CCDM-Verified Sources):

SCDM GCDMP, Chapter: Data Management Planning and Study Start-up, Section 4.2 – EDC Readiness and System Validation

ICH E6(R2) GCP, Section 5.5.3 – Computerized Systems Validation Before Use

FDA Guidance for Industry: Computerized Systems Used in Clinical Investigations, Section 6.1 – System Qualification Prior to Data Entry

Aprotocol compliance edit checkis designed to ensure that the data collected adheres to thespecific requirements defined in the study protocol, such as visit timing, procedure windows, and eligibility criteria.

The example inoption A— an edit check that triggers when a visit date falls outside the protocol-specified window — directly verifies compliance with the study design. This type of check supports real-time monitoring of protocol adherence, a critical quality and regulatory requirement underGCDMPandICH E6(R2).

Other options are examples of generaldata validation checks, not protocol compliance:

B:Ensures clinical plausibility (data range check).

C:Ensures completeness (missing data check).

D:Ensures format correctness (system validation check).

Thus,option Abest represents aprotocol compliance edit check, confirming that collected data conform to the visit schedule defined in the protocol.

Reference (CCDM-Verified Sources):

SCDM GCDMP, Chapter: Data Validation and Cleaning, Section 5.4 – Protocol Compliance Edit Checks

ICH E6(R2) GCP, Section 5.1.1 – Quality Management and Compliance Controls

FDA Guidance for Industry: Computerized Systems Used in Clinical Investigations, Section 6.3 – Edit Check Design and Validation

The section of theClinical Study Report (CSR)that is most useful for a Data Manager is the one that includes theenumeration and explanation of data errors. This section provides a summary of thedata quality control findings, including error rates, missing data summaries, and any issues identified during data review, validation, or database lock.

According to theGCDMP (Chapter: Data Quality Assurance and Control), post-study reviews of data errors and quality findings are essential for evaluating process performance, identifying recurring issues, and informing continuous improvement in future studies.

Other sections, such as clinical narratives (A) or statistical methods (C), are outside the core scope of data management responsibilities. Thedata error enumeration sectiondirectly reflects the quality and integrity of the data management process and is therefore the most relevant for review.

Reference (CCDM-Verified Sources):

SCDM GCDMP, Chapter: Data Quality Assurance and Control, Section 6.4 – Quality Reporting and Error Analysis

ICH E3 – Structure and Content of Clinical Study Reports, Section 14.3 – Data Quality Evaluation

In aSQL (Structured Query Language)database, theSELECTstatement specifies which columns to display from a table. In this query, only three columns —Pt_ID,MRN, andSSN— are being selected from thepatienttable.

This means the resulting dataset will contain:

The same number ofrows (records)as the original table (assuming noWHEREfilter), and

Fewer columnsthan 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 isnarrower than the patient table, makingoption Dcorrect.

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

Theinner joinoperation retrievesonly the records that exist in both tables, which is theintersectionof two datasets.

In clinical data management, relational databases often store related data in multiple tables—for example, demographic data in one table and lab results in another. When a Data Manager needs to extract records that exist in both (e.g., subjects appearing in both demographics and labs), aninner joinis used.

According to theGCDMP (Chapter: Database Design and Build), joins are fundamental relational operations ensuring data consistency and integrity across multiple data domains.

Inner join:Returns matching records from both tables (intersection).

Left/right outer joins:Return all records from one table and matching records from the other (preserving nonmatches).

Full outer join:Returns all records from both tables, whether matched or not.

Therefore, to select only the50 records commonto both tables, the correct operation is aninner join.

Reference (CCDM-Verified Sources):

SCDM Good Clinical Data Management Practices (GCDMP), Chapter: Database Design and Build, Section 4.3 – Relational Database Concepts and Joins

ICH E6 (R2) Good Clinical Practice, Section 5.5.3 – Data Processing and Validation

To monitorsite variability in eligibility screening, you must analyzethe number of subjects screenedversusthe number of subjects enrolledat each site. This allows identification of sites that are over- or under-screening relative to their enrollment yield.

TheGCDMP (Chapter: Data Quality Assurance and Metrics)emphasizes thatscreening-to-enrollment ratiosare critical indicators of protocol compliance and data quality. Sites with unusually low conversion rates may have unclear understanding of inclusion/exclusion criteria, requiring targeted training or monitoring.

Other options (A, C, D) provide enrollment metrics but do not revealscreening efficiency or variability, which depend on bothscreening and enrollment data.

Thus,option Bcorrectly identifies the data necessary for monitoring eligibility screening performance across sites.

Reference (CCDM-Verified Sources):

SCDM GCDMP, Chapter: Data Quality Assurance and Metrics, Section 5.4 – Site Performance Metrics

ICH E6(R2) GCP, Section 5.18 – Monitoring and Site Oversight Requirements

In Structured Query Language (SQL), theWHEREclause is used to filter records based on specified criteria. The query retrievesall columnsfrom thepatienttable (SELECT *) but onlythose rowswhere themedical_record_numbervalue is greater than 9000.

This means:

Thenumber of columns (fields)remains the same as the original table.

Thenumber of rows (records)will beequal to or less thanthe number of rows in thepatienttable, depending on how many patients meet the filter condition.

Hence, the result set can only beshorter or equal in lengthcompared to the original table. It cannot be longer, wider, or narrower, since no new rows or columns are created.

Therefore,option B—“Shorter or of equal length than the patient table”— is correct.

Reference (CCDM-Verified Sources):

SCDM GCDMP, Chapter: Database Design and Build, Section 5.2 – Relational Database Queries and Filtering Logic

ICH E6(R2) GCP, Section 5.5.3 – Data Retrieval, Filtering, and Storage Principles

FDA Guidance for Industry: Computerized Systems Used in Clinical Investigations, Section 6.4 – Query Logic and Record Subsetting

Whenlaboratory dataare missing from a paper-based clinical study, theData Managershould directdata-entry personnel to issue a queryto the investigative site for clarification or correction.

According to theGood Clinical Data Management Practices (GCDMP, Chapter: Data Validation and Cleaning), every missing, inconsistent, or out-of-range data point must be reviewed and, if necessary, resolved through the formalquery management process. This ensures that all discrepancies between the source documents and database entries are properly documented, traceable, and auditable.

Data-entry staff arenot authorizedto infer or fill in missing information. They must escalate such discrepancies to the site via query, preservingdata integrityandregulatory compliancewithICH E6 (R2)andFDA 21 CFR Part 11. Calling the patient directly (option B) would violate confidentiality and site communication protocol, while simply flagging or ignoring the issue (options A and D) would not meet GCDMP query resolution standards.

Reference (CCDM-Verified Sources):

SCDM Good Clinical Data Management Practices (GCDMP), Chapter: Data Validation and Cleaning, Section 5.2 – Query Management and Resolution

ICH E6 (R2) Good Clinical Practice, Section 5.18.4 – Communication of Data Discrepancies

FDA 21 CFR Part 11 – Electronic Records; Query Audit Trails Requirements