Clinical Data Management practice questions

An Extract-Transform-Load job derives age at consent in the warehouse; auditors request per-record evidence of reproducibility during review—what should be recorded with every derived age?

1. A.Link to birthdate and consent date identifiers without algorithm version details
2. B.Data Management Plan section documenting derivations for the current study
3. C.Program repository hyperlink recorded without a tag for exact script
4. D.Algorithm name and precise version associated with each derived age value

Site teams chart all care in the Electronic Health Record; what EDC skill most directly keeps the study database aligned with that authoritative record?

1. A.Configuring user roles and granting permissions within the EDC application securely
2. B.Recognizing inconsistencies and driving query resolution to match source charts exactly
3. C.Conducting eligibility screening and confirming inclusion and exclusion criteria at sites
4. D.Issuing ePRO devices and training participants to complete diaries and questionnaires

You join PATIENT to MEDICATION_DOSES where the dose table’s key is patient, cycle, and day; joining only on patient identifier, which row pattern will appear in the output?

1. A.One record per patient per cycle per day in output.
2. B.One record per patient because cycles and days collapse during join.
3. C.One record per patient per cycle aggregated across all days.
4. D.One record per cycle across all patients and days combined.

An audit readiness exercise focuses on query handling quality for a blinded oncology trial using Electronic Data Capture (EDC); which approach best demonstrates independent verification of the correctness of closed queries?

1. A.Calculating average open queries per subject and overdue rates per site monthly
2. B.Verifying closed queries during routine Source Data Verification by clinical monitors only
3. C.Reviewing EDC audit trail completeness monthly as the primary quality control activity
4. D.Randomly sampling resolved queries for independent review against source and system logs

At screening, technicians recorded three-lead electrocardiograms even though the protocol required twelve-lead tracings, and the monitor documented the issue in their visit report.

1. A.Ask the monitor to create and file the official deviation documentation
2. B.Update site training materials and close the matter without additional documentation
3. C.Send a query requesting the site record a protocol deviation entry
4. D.Report directly to the Ethics Committee before any site-generated documentation exists

A vendor's biomarker shipment arrives overnight; before import, what should be the initial gate to prevent malformed files from polluting downstream Extract, Transform, Load pipelines and reconciliation activities later?

1. A.Counting rows at subject and visit levels prior to any schema checks.
2. B.Validating structure against the agreed data transfer specification prior to processing actions.
3. C.Trusting vendor validation status and skipping structural intake checks to save time.
4. D.Matching vendor subjects to EDC visit windows before performing structure checks first.

During a kickoff workshop, you must anchor Case Report Form mapping decisions to the protocol. Which section provides the authoritative detail on variables required for the primary endpoint analysis?

1. A.The Statistical Analysis Plan translating endpoints into derivations and dataset specifications
2. B.The schedule of events listing visits, procedures, and assessment timing only
3. C.The study endpoints section specifying outcomes, timing windows, and analysis populations
4. D.The Data Management Plan outlining processes, roles, and general data controls

In a small study where data currency is high and vendor files are matched, which timing best reflects a realistic database lock after the final participant’s last visit?

1. A.A lock window of a few months after Last Patient Last Visit
2. B.A lock window of a few weeks after Last Patient Last Visit
3. C.A lock window of a few hours after Last Patient Last Visit
4. D.A lock window of a few days after Last Patient Last Visit

A protocol requires weekly home blood pressure readings for the primary endpoint across 200 sites. To ensure comparability and defensibility, what is the most appropriate data collection approach?

1. A.Allowing bring-your-own devices meeting minimal features specified in the protocol for measurements
2. B.Using provisioned sphygmomanometers, validated, with duplicate readings and documentation of calibration procedures
3. C.Extracting values from electronic medical records regardless of device or procedure used
4. D.Using clinician recollection to estimate baseline values when devices are temporarily unavailable

During planning of Electronic Data Capture (EDC) rollout, the team debates why validation is required. What is the overarching goal they should anchor their validation activities around?

1. A.Treating User Acceptance Testing alone as complete validation for production readiness
2. B.Relying solely on vendor documents to declare the solution fully validated
3. C.Objective proof the computerized system consistently functions as intended in operation
4. D.Authorizing production deployment and user access provisioning for the live system