WGU - D427 - Data Management - Applications – PreAssessment 2024/2025

WGU - D427 - Data Management - Applications – PreAssessment
2024/2025
1. San Francisco, CA 94110
USA
How many attributes are present in the address fragment?

-1
-2
-3
- 4: 4
2. The Package table has the following columns:
Weight—decimal
Description—optional variable length string
LastChangedDate—date
TrackingNumber—integer
Which column should be designated the primary key for the Package table?

- Weight
- Description
- LastChangedDate
- TrackingNumber: Tracking Number
3. Which data type will store "2022-01-10 14:22:12" as a temporal value without
loss of information?

- DATE
- DATETIME
- DECIMAL
- BIGINT: DATETIME
4. Which SQL command is an example of data definition language (DDL)?

- UPDATE
- ALTER
- SELECT
- DELETE: CREATE, ALTER, OR DROP
5. How would a database engine process an update that violates a RESTRICT
referential integrity constraint?

- The offending value would be set to the database default.
- The update would be rejected by the database.
- The offending value would be changed to NULL.

, WGU - D427 - Data Management - Applications – PreAssessment
2024/2025
- The updated value would flow to the primary key.: The update would be rejected
by the database.
6. Which restriction applies when using a materialized view?

- The users of the view must provide search terms.
- The underlying data must be periodically refreshed.
- The tables referenced in the view must be indexed.
- The rows in the table must be compressed.: The underlying data must be
periodically refreshed.
7. Which query illustrates performing an outer join of the Movie table with a
different table?

- SELECT M.Title, A.Actor FROM Movie M, Actor A
WHERE M.ActorID = A.ID

- SELECT M.Title, A.Actor FROM Movie M
LEFT JOIN Movie MB ON M.ID, Actor A

- SELECT M.Title, A.Actor FROM Movie M
RIGHT JOIN Actor A ON M.ActorID = A.Id

- SELECT M.Title, A.Actor FROM Movie M
INNER JOIN Actor A ON M.ActorID = A.ID: SELECT M.Title, A.Actor FROM Movie
M
LEFT JOIN Movie MB ON M.ID Actor A
8. Assume there are two tables, A and B.
Which rows will always be included in the result set if Table A is inner joined
with Table B?

- Only rows in Tables A and B that share the join condition
- all rows in Table B
- All rows in Table A
- Only rows in Tables A and B that do not share the join condition: Only rows
in Table A and B that share the join condition
9. 1. Portland, OR 97212
How many attributes are present in the address fragment?

-1
-2

, WGU - D427 - Data Management - Applications – PreAssessment
2024/2025
-3
- 4: 3
10. 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: patient_id
11. 3. The Exam table has the following columns:
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: patient_id
12. 4. Which data type represents numbers with fractional values:

- varchar
- integer
- binary
- decimal: decimal
13. 5. Which of the following is a DDL (Data Definition Language) command?

- INSERT
- SELECT
- CREATE INDEX
- UPDATE: CREATE INDEX