Important SCDM CCDM Exam Questions

Answer: D

Explanation:

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

Answer: A

Explanation:

Standard Operating Procedures (SOPs) are formal, controlled documents that define standardized processes to ensure clinical trials are conducted in compliance with Good Clinical Practice (GCP), the study protocol, and regulatory requirements (such as ICH and FDA).

According to Good Clinical Data Management Practices (GCDMP) and ICH E6(R2) GCP, SOPs are fundamental to quality management systems. They describe how tasks are performed, ensuring consistency, accountability, and traceability across all studies and team members. Proper adherence to SOPs guarantees that data are accurately generated, documented, and reported in compliance with ethical and regulatory standards.

Other options serve different purposes:

SAP (B) defines statistical methodology, not compliance control.

DMP (C) focuses on study-specific data handling, not organizational compliance.

CRFs (D) are tools for data collection but do not enforce compliance by themselves.

Therefore, option A (SOP) is correct.

Reference (CCDM-Verified Sources):

SCDM GCDMP, Chapter: Quality Management and Compliance, Section 5.1 -- Role of SOPs in Regulatory Compliance

ICH E6(R2) GCP, Section 2.13 and 5.1.1 -- Quality Management Systems and SOP Requirements

FDA 21 CFR Part 312.50 -- Sponsor Responsibilities and Compliance Systems

Answer: A

Explanation:

When the primary efficacy endpoint in a clinical trial is 3-month survival, the key data element required is the death date. This is because the survival endpoint is determined by calculating whether the subject lived or died within a defined time frame from study enrollment or randomization.

According to the GCDMP (Chapter: Data Management Planning and Study Start-up), the Clinical Data Manager (CDM) must identify and ensure the capture of all critical data elements necessary to evaluate the study endpoints. For time-to-event analyses (e.g., survival studies), accurate event dates (death date) are essential for endpoint derivation and statistical analysis.

Other data elements such as cause of death or date of autopsy (options B and C) may support secondary analyses or safety reviews but are not necessary to determine the survival endpoint itself. Similarly, birth date (option D) contributes to demographic data but is unrelated to the primary efficacy outcome.

Reference (CCDM-Verified Sources):

SCDM Good Clinical Data Management Practices (GCDMP), Chapter: Data Management Planning and Study Start-up, Section 4.4 -- Critical Data Identification for Endpoints

ICH E9 -- Statistical Principles for Clinical Trials, Section 2.2.3 -- Time-to-Event Data Considerations

FDA Guidance for Industry: Clinical Trial Endpoints for Drug Development

Answer: B

Explanation:

In Structured Query Language (SQL), the WHERE clause is used to filter records based on specified criteria. The query retrieves all columns from the patient table (SELECT *) but only those rows where the medical_record_number value is greater than 9000.

This means:

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

The number of rows (records) will be equal to or less than the number of rows in the patient table, depending on how many patients meet the filter condition.

Hence, the result set can only be shorter or equal in length compared 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

Answer: A

Explanation:

The best metric to identify malfunctioning or ineffective edit checks is the count by edit check of the number of times the check fired. This allows data managers to assess whether specific edit checks are performing as intended.

According to the GCDMP, Chapter: Data Validation and Cleaning, edit checks are programmed logic conditions that identify data inconsistencies or potential errors during data entry. A properly functioning edit check should trigger only when data falls outside acceptable or logical limits. If an edit check fires too frequently or not at all, it may indicate a logic error in the check's programming or configuration.

By analyzing counts by individual edit checks, data managers can:

Identify checks that never trigger (potentially inactive or incorrectly written),

Detect overactive checks (poorly designed parameters causing excessive false positives), and

Optimize system performance and review efficiency.

This metric supports continuous improvement in data validation logic and contributes to cleaner, higher-quality clinical databases.

Reference (CCDM-Verified Sources):

SCDM Good Clinical Data Management Practices (GCDMP), Chapter: Data Validation and Cleaning, Section 6.2 -- Edit Check Design and Performance Metrics

FDA Guidance: Computerized Systems Used in Clinical Investigations -- Section on Validation of Electronic Data Systems