WGU - D427 - (Latest 2025/2026 Update) Data Management - Applications – Pre-Assessment Study Guide with Questions and Certified Answers | 100% Correct | A Grade - WGU

1

WGU - D427 - (Latest 2025/2026
Update) Data Management -
Applications – Pre-Assessment Study
Guide with Questions and Certified
Answers | 100% Correct | A Grade -
WGU


Quiz_________________?
San Francisco, CA 94110
USA
How many attributes are present in the address fragment?


-1
-2
-3
-4-

Answer☑️

4


Quiz_________________?
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?
2


- Weight
- Description
- LastChangedDate
- TrackingNumber -

Answer☑️

Tracking Number
Quiz_________________?
22. Which query illustrates performing an outer join of the Movie table with a different table?


- SELECT M.Title, A.Name FROM Movie M, Actor A
WHERE M.ActorID = A.ActorID;
- SELECT M.Title, A.Name FROM Movie M, Actor A
WHERE M.ActorID = A.MovieID;
- SELECT M.Title, A.Name FROM Movie M RIGHT JOIN Actor A
ON M.ActorID = A.ActorID;
- SELECT M.Title, A.Actor FROM Movie M
INNER JOIN Actor A ON M.ActorID = A.ActorID -

Answer☑️
SELECT M.Title, A.Name
FROM Movie M
RIGHT JOIN Actor A ON M.ActorID = A.ActorID;


Quiz_________________?
23. 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?


a. Only rows in Tables A and B that share the join condition

, b. All rows in Table B
3
c. All rows in Table A
d. Only rows in Tables A and B that do not share the join condition. -

Answer☑️
Only rows in Tables A and B that share the join condition


Quiz_________________?
24. The database contains a table named Book.
Write a SQL query to return all data from the Book table without directly referencing any column
names. -

Answer☑️
SELECT *
FROM Book;


Quiz_________________?
25. The Book table has the following columns:


ID—integer, primary key, auto_increment
Title—variable-length string
Genre—variable-length string
Year—integer


Write a SQL query to retrieve the Title and Genre values for all records in the Book table with a Year
value of 2020. Ensure your result set returns the columns in the order indicated. -

Answer☑️
SELECT Title, Genre
FROM Book
WHERE Year = 2020;


Quiz_________________?

, 26. The Book table has the following columns:
4


ID—integer, primary key, auto_increment
Title—variable-length string
Genre—variable-length string
Year—integer


Write a SQL query to display all Title values in alphabetical order A-Z. -

Answer☑️
SELECT Title
FROM Book
ORDER BY Title ASC;


Quiz_________________?
27. The Book table has the following columns:


ID—integer, primary key, auto_increment
Title—variable-length string
Genre—variable-length string
Year—integer


Write a SQL query to output the unique Genre values and the number of books with each genre value
from the Book table as GenreCount. Sort the results by the Genre in alphabetical order A-Z. Ensure
your result set returns the columns in the order indicated. -

Answer☑️

SELECT Genre, COUNT(*) AS GenreCount
FROM Book
GROUP BY Genre,
ORDER BY Genre ASC;