Questions with 100% Verified Answers
This WGU D427 (Data Management - Applications) Pre-Assessment features 66
conceptual and practical questions pulled directly from the course material. The actual exam
is split into roughly 1/3 multiple-choice conceptual questions and 2/3 live SQL
programming simulations.
A breakdown of the highest-yield questions, answer keys, and structural concepts from the official
pre-assessment resource and student test banks follows below.
Sample Core Conceptual Questions & Answers
• Address Attributes
o Question: How many attributes are present in the address fragment "San Francisco,
CA 94110. USA"?
o Answer: 4 (City, State, ZipCode, Country).
• Primary Key Selection
o Question: Given a table with Weight (decimal), Description (text), LastChangedDate
(date), and TrackingNumber (integer), which should be the primary key?
o Answer: TrackingNumber (it is the only inherently unique identifier).
• Temporal Data Types
o Question: Which data type will store "2022-01-10 14:22:12" as a temporal value
without loss of information?
1
, o Answer: DATETIME (DATE only stores the calendar day, while
TIMESTAMP/DATETIME preserves the time structure).
• SQL Languages Categories
o Question: Which SQL commands represent Data Definition Language (DDL)?
o Answer: CREATE, ALTER, DROP (they modify the structure, not the data).
o Question: Which commands represent Data Manipulation Language (DML)?
o Answer: INSERT, UPDATE, DELETE.
• Referential Integrity Constraints
o Question: How would a database engine process an update that violates a
RESTRICT referential integrity constraint?
o Answer: The update would be rejected by the database.
• Materialized Views
o Question: What restriction applies when using a materialized view?
o Answer: The underlying data must be periodically refreshed (data is
physically stored and can fall out of sync with base tables).
• Database Normalization
o Question: Which normal form removes partial dependencies (where a non-key
column depends on only part of a composite primary key)?
o Answer: Second Normal Form (2NF).
Quiz_________________?
1. Portland, OR 97212
How many attributes are present in the address fragment?
-1
-2
-3
-4-
2
, ANSWER✅
3
Quiz_________________?
2. The Patient table has the following columns:
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 -
ANSWER✅
patient_id
Quiz_________________?
3. The Exam table has the following columns:
exam_id int
exam_date date
exam_reason varchar(100)
patient_number int
3
, Which column should be designated as the foreign key for the Exam table?
- exam_id
- exam_date
- exam_reason
- patient_id -
ANSWER✅
patient_id
Quiz_________________?
4. Which data type represents numbers with fractional values:
- varchar
- integer
- binary
- decimal -
ANSWER✅
decimal
Quiz_________________?
5. Which of the following is a DDL (Data Definition Language) command?
- INSERT
- SELECT
- CREATE INDEX
- UPDATE -
ANSWER✅
4
This WGU D427 (Data Management - Applications) Pre-Assessment features 66
conceptual and practical questions pulled directly from the course material. The actual exam
is split into roughly 1/3 multiple-choice conceptual questions and 2/3 live SQL
programming simulations.
A breakdown of the highest-yield questions, answer keys, and structural concepts from the official
pre-assessment resource and student test banks follows below.
Sample Core Conceptual Questions & Answers
• Address Attributes
o Question: How many attributes are present in the address fragment "San Francisco,
CA 94110. USA"?
o Answer: 4 (City, State, ZipCode, Country).
• Primary Key Selection
o Question: Given a table with Weight (decimal), Description (text), LastChangedDate
(date), and TrackingNumber (integer), which should be the primary key?
o Answer: TrackingNumber (it is the only inherently unique identifier).
• Temporal Data Types
o Question: Which data type will store "2022-01-10 14:22:12" as a temporal value
without loss of information?
1
, o Answer: DATETIME (DATE only stores the calendar day, while
TIMESTAMP/DATETIME preserves the time structure).
• SQL Languages Categories
o Question: Which SQL commands represent Data Definition Language (DDL)?
o Answer: CREATE, ALTER, DROP (they modify the structure, not the data).
o Question: Which commands represent Data Manipulation Language (DML)?
o Answer: INSERT, UPDATE, DELETE.
• Referential Integrity Constraints
o Question: How would a database engine process an update that violates a
RESTRICT referential integrity constraint?
o Answer: The update would be rejected by the database.
• Materialized Views
o Question: What restriction applies when using a materialized view?
o Answer: The underlying data must be periodically refreshed (data is
physically stored and can fall out of sync with base tables).
• Database Normalization
o Question: Which normal form removes partial dependencies (where a non-key
column depends on only part of a composite primary key)?
o Answer: Second Normal Form (2NF).
Quiz_________________?
1. Portland, OR 97212
How many attributes are present in the address fragment?
-1
-2
-3
-4-
2
, ANSWER✅
3
Quiz_________________?
2. The Patient table has the following columns:
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 -
ANSWER✅
patient_id
Quiz_________________?
3. The Exam table has the following columns:
exam_id int
exam_date date
exam_reason varchar(100)
patient_number int
3
, Which column should be designated as the foreign key for the Exam table?
- exam_id
- exam_date
- exam_reason
- patient_id -
ANSWER✅
patient_id
Quiz_________________?
4. Which data type represents numbers with fractional values:
- varchar
- integer
- binary
- decimal -
ANSWER✅
decimal
Quiz_________________?
5. Which of the following is a DDL (Data Definition Language) command?
- INSERT
- SELECT
- CREATE INDEX
- UPDATE -
ANSWER✅
4
