WGU – D427 Data Management – Applications PreAssessment Q&A 2026 Updated Complete Study Guide

WGU - D427 - Data Management - Applications - PreAssessment Q&A
WGU - D427 - Data Management - Applications - PreAssessment Q&A 2/18/2026




1. Portland, OR 97212 3
How many attributes are present in the address
fragment?


-1
-2
-3
-4


2. The Patient table has the following columns: patient_id


first_name varchar(20)
last_name varchar (30)
birthdate date
patient_id int


Which column should be designated as the
primary key for the Patient table?


- first_name
- last_name
- birthdate
- patient_id




Page 1 WGU - D427 - Data Management - Applications - PreAssessment Q&A.pdf

,WGU - D427 - Data Management - Applications - PreAssessment Q&A
WGU - D427 - Data Management - Applications - PreAssessment Q&A 2/18/2026




3. The Exam table has the following columns: patient_id
exam_id int
exam_date date
exam_reason varchar(100)
patient_number int


Which column should be designated as the
foreign key for the Exam table?


- exam_id
- exam_date
- exam_reason
- patient_id


4. Which data type represents numbers with decimal
fractional values:


- varchar
- integer
- binary
- decimal




Page 2 WGU - D427 - Data Management - Applications - PreAssessment Q&A.pdf

,WGU - D427 - Data Management - Applications - PreAssessment Q&A
WGU - D427 - Data Management - Applications - PreAssessment Q&A 2/18/2026




5. Which of the following is a DDL (Data CREATE INDEX
Definition Language) command?
CREATE, ALTER, DROP
- INSERT
- SELECT
- CREATE INDEX
- UPDATE


6. Which of the following is a DML (Data INSERT
Manipulation Language) command?


- CREATE VIEW
- CREATE TABLE
- INSERT
- ALTER INDEX




Page 3 WGU - D427 - Data Management - Applications - PreAssessment Q&A.pdf

, WGU - D427 - Data Management - Applications - PreAssessment Q&A
WGU - D427 - Data Management - Applications - PreAssessment Q&A 2/18/2026




7. Patient Table Those exams would be deleted also
PK patient id
first name
last name
birthdate


Exam Table
PK exam id
exam date
exam reason
FK patient id


CREATE TABLE Exam (
exam_id INT NOT NULL AUTO_INCREMENT,
exam_date DATE NOT NULL,
exam_reason VARCHAR(100),
patient_id INT NOT NULL,
PRIMARY KEY (exam_id),
FOREIGN KEY (patient_id) REFERENCES Patient
(patient_id) ON DELETE CASCADE
);


What would happen to exams in the Exam table
that are linked to a patient if that patient is
deleted?



Page 4 WGU - D427 - Data Management - Applications - PreAssessment Q&A.pdf