IT/DATABASE · 2026/2027 LATEST UPDATE
WGU C170 Data Management Applications Exam
2026 SQL Queries, Database Design,
Normalization - Complete Study Guide
75+ Verified Exam Questions · Rated A+ · Guaranteed Results
SQL Queries (SELECT, JOIN, WHERE, GROUP
Data
BY)Definition Language (DDL) & Data Manipulatio
Database Design & Entity-Relationship (ER) Diagrams
Transaction Management & Indexing
Normalization (1NF, 2NF, 3NF, BCNF)
Instant PDF Download · 100% Verified Answers · Score 90%+
WGU C170 Data Management Applications Exam 2026 SQL Queries, Database Design, Normalization - 2026/2027 | Passing Score: 80% | Page 1 of 41
, BEST SELLER · IT/DATABASE
WGU C170 Data Management Applications Exam
2026 SQL Queries, Database Design,
Normalization 2026/2027 - Q&A with Verified
Answers
Every section. Every topic. 100% correct answers guaranteed. Used by
5,000+ IT/database students to pass on their first attempt.
SQL Queries (SELECT, JOIN, WHERE, GROUP BY)
Database Design & Entity-Relationship (ER) Diagrams
Normalization (1NF, 2NF, 3NF, BCNF)
Data Definition Language (DDL) & Data Manipulation Language (DML)
Transaction Management & Indexing
A+
Rated
Used by 5,000+ students · 100% Verified Answers · 2026/2027 Latest Update
Instant PDF Download
WGU C170 Data Management Applications Exam 2026 SQL Queries, Database Design, Normalization - 2026/2027 | Passing Score: 80% | Page 2 of 41
, SECTION 1 | SQL Queries (SELECT, JOIN, WHERE, GROUP BY) | Q1-Q20 | WGU C170 Data Management Applications Exam 20
Q1 Question 1 of 75
A database analyst at a retail company needs to retrieve the names and email addresses
of all customers who placed an order in the last 30 days. The most appropriate SQL
clause to filter the order dates is:
A. HAVING, because it filters groups after the GROUP BY clause has been applied
B. WHERE, because it filters rows based on a condition before the result set is
returned
C. ORDER BY, because it sorts the results by date before filtering
D. GROUP BY, because it groups orders by customer before selecting the results
Correct Answer: B
Rationale:
The WHERE clause filters individual rows based on specified conditions before the result set is returned,
making it the correct choice for filtering order dates. HAVING (option B) is used to filter groups after
aggregation, not individual rows. ORDER BY (option C) sorts results, and GROUP BY (option D)
aggregates data rather than filtering it.
Q2 Question 2 of 75
A data analyst needs to find the total sales amount for each product category in the
Sales table. The SQL query must include both the GROUP BY clause and:
A. A DISTINCT keyword to remove duplicate product categories from the results
B. An aggregate function such as SUM() to calculate the total sales for each
category
C. A WHERE clause to filter categories with sales greater than zero before grouping
D. A HAVING clause to sort the results by total sales in descending order
Correct Answer: B
Rationale:
When using GROUP BY to find totals per category, an aggregate function like SUM() is required to
calculate the total sales amount for each group. DISTINCT (option B) removes duplicates but does not
perform aggregation. WHERE (option C) filters rows before grouping but does not calculate totals.
HAVING (option D) filters groups after aggregation but does not sort results.
WGU C170 Data Management Applications Exam 2026 SQL Queries, Database Design, Normalization - 2026/2027 | Passing Score: 80% | Page 3 of 41
, Q3 Question 3 of 75
A university registrar needs to produce a report showing student names alongside their
corresponding course enrollments. The Students table and the Courses table are related
through an Enrollment table. The best SQL operation to combine data from all three
tables is:
A. A LEFT JOIN, which returns all rows from the first table regardless of matches
B. An INNER JOIN, which returns only the rows where there is a match in all joined
tables
C. A CROSS JOIN, which produces every possible combination of rows from all tables
D. A UNION, which stacks the results of separate queries vertically
Correct Answer: B
Rationale:
An INNER JOIN returns only rows where the join condition is satisfied in all tables, making it appropriate
when you need matching records across related tables. LEFT JOIN (option B) includes unmatched rows
from the left table, which would show students without enrollments. CROSS JOIN (option C) creates a
Cartesian product, and UNION (option D) stacks results rather than combining columns.
Q4 Question 4 of 75
A business intelligence developer needs to find customers who have placed orders
totaling more than $5,000. The correct SQL approach is to use:
A. WHERE SUM(order_total) > 5000 to filter individual rows based on the aggregate
B. GROUP BY with HAVING SUM(order_total) > 5000 to filter groups based on the
aggregated total
C. GROUP BY with WHERE SUM(order_total) > 5000 to filter rows before grouping
D. ORDER BY order_total DESC LIMIT 1 to find the highest single order
Correct Answer: B
Rationale:
The HAVING clause filters groups after the GROUP BY clause has aggregated the data, making it the
correct choice for filtering on aggregate values like SUM(order_total) > 5000. WHERE (options B and C)
cannot be used with aggregate functions because WHERE filters rows before aggregation. ORDER BY
with LIMIT (option D) only finds a single row, not all qualifying groups.
WGU C170 Data Management Applications Exam 2026 SQL Queries, Database Design, Normalization - 2026/2027 | Passing Score: 80% | Page 4 of 41
WGU C170 Data Management Applications Exam
2026 SQL Queries, Database Design,
Normalization - Complete Study Guide
75+ Verified Exam Questions · Rated A+ · Guaranteed Results
SQL Queries (SELECT, JOIN, WHERE, GROUP
Data
BY)Definition Language (DDL) & Data Manipulatio
Database Design & Entity-Relationship (ER) Diagrams
Transaction Management & Indexing
Normalization (1NF, 2NF, 3NF, BCNF)
Instant PDF Download · 100% Verified Answers · Score 90%+
WGU C170 Data Management Applications Exam 2026 SQL Queries, Database Design, Normalization - 2026/2027 | Passing Score: 80% | Page 1 of 41
, BEST SELLER · IT/DATABASE
WGU C170 Data Management Applications Exam
2026 SQL Queries, Database Design,
Normalization 2026/2027 - Q&A with Verified
Answers
Every section. Every topic. 100% correct answers guaranteed. Used by
5,000+ IT/database students to pass on their first attempt.
SQL Queries (SELECT, JOIN, WHERE, GROUP BY)
Database Design & Entity-Relationship (ER) Diagrams
Normalization (1NF, 2NF, 3NF, BCNF)
Data Definition Language (DDL) & Data Manipulation Language (DML)
Transaction Management & Indexing
A+
Rated
Used by 5,000+ students · 100% Verified Answers · 2026/2027 Latest Update
Instant PDF Download
WGU C170 Data Management Applications Exam 2026 SQL Queries, Database Design, Normalization - 2026/2027 | Passing Score: 80% | Page 2 of 41
, SECTION 1 | SQL Queries (SELECT, JOIN, WHERE, GROUP BY) | Q1-Q20 | WGU C170 Data Management Applications Exam 20
Q1 Question 1 of 75
A database analyst at a retail company needs to retrieve the names and email addresses
of all customers who placed an order in the last 30 days. The most appropriate SQL
clause to filter the order dates is:
A. HAVING, because it filters groups after the GROUP BY clause has been applied
B. WHERE, because it filters rows based on a condition before the result set is
returned
C. ORDER BY, because it sorts the results by date before filtering
D. GROUP BY, because it groups orders by customer before selecting the results
Correct Answer: B
Rationale:
The WHERE clause filters individual rows based on specified conditions before the result set is returned,
making it the correct choice for filtering order dates. HAVING (option B) is used to filter groups after
aggregation, not individual rows. ORDER BY (option C) sorts results, and GROUP BY (option D)
aggregates data rather than filtering it.
Q2 Question 2 of 75
A data analyst needs to find the total sales amount for each product category in the
Sales table. The SQL query must include both the GROUP BY clause and:
A. A DISTINCT keyword to remove duplicate product categories from the results
B. An aggregate function such as SUM() to calculate the total sales for each
category
C. A WHERE clause to filter categories with sales greater than zero before grouping
D. A HAVING clause to sort the results by total sales in descending order
Correct Answer: B
Rationale:
When using GROUP BY to find totals per category, an aggregate function like SUM() is required to
calculate the total sales amount for each group. DISTINCT (option B) removes duplicates but does not
perform aggregation. WHERE (option C) filters rows before grouping but does not calculate totals.
HAVING (option D) filters groups after aggregation but does not sort results.
WGU C170 Data Management Applications Exam 2026 SQL Queries, Database Design, Normalization - 2026/2027 | Passing Score: 80% | Page 3 of 41
, Q3 Question 3 of 75
A university registrar needs to produce a report showing student names alongside their
corresponding course enrollments. The Students table and the Courses table are related
through an Enrollment table. The best SQL operation to combine data from all three
tables is:
A. A LEFT JOIN, which returns all rows from the first table regardless of matches
B. An INNER JOIN, which returns only the rows where there is a match in all joined
tables
C. A CROSS JOIN, which produces every possible combination of rows from all tables
D. A UNION, which stacks the results of separate queries vertically
Correct Answer: B
Rationale:
An INNER JOIN returns only rows where the join condition is satisfied in all tables, making it appropriate
when you need matching records across related tables. LEFT JOIN (option B) includes unmatched rows
from the left table, which would show students without enrollments. CROSS JOIN (option C) creates a
Cartesian product, and UNION (option D) stacks results rather than combining columns.
Q4 Question 4 of 75
A business intelligence developer needs to find customers who have placed orders
totaling more than $5,000. The correct SQL approach is to use:
A. WHERE SUM(order_total) > 5000 to filter individual rows based on the aggregate
B. GROUP BY with HAVING SUM(order_total) > 5000 to filter groups based on the
aggregated total
C. GROUP BY with WHERE SUM(order_total) > 5000 to filter rows before grouping
D. ORDER BY order_total DESC LIMIT 1 to find the highest single order
Correct Answer: B
Rationale:
The HAVING clause filters groups after the GROUP BY clause has aggregated the data, making it the
correct choice for filtering on aggregate values like SUM(order_total) > 5000. WHERE (options B and C)
cannot be used with aggregate functions because WHERE filters rows before aggregation. ORDER BY
with LIMIT (option D) only finds a single row, not all qualifying groups.
WGU C170 Data Management Applications Exam 2026 SQL Queries, Database Design, Normalization - 2026/2027 | Passing Score: 80% | Page 4 of 41
