WGU C170 – Data Management Applications – Objective Assessment 2026/2027 | Over 200 Questions & Answers
WGU C170 — DATA MANAGEMENT APPLICATIONS EXAM
Western Governors University — Objective Assessment — 2026/2027
Over 200 Questions & Answers — 100% Verified with Detailed Rationales
Total Questions 220 (Q1–Q220)
Number of Sections 9
Cognitive Levels ~30% Recall · ~50% Application · ~20% Analysis
Question Style 70% Application/scenario (SQL, design) · 30% Direct recall
Answer Format 4-option multiple choice (A–D), one correct answer
Coverage SQL, ER modeling, normalization, queries, admin, security, DW, NoSQL, cloud
Verification Each rationale confirms the answer against SQL standards and relational theory
This exam is aligned with the current Western Governors University (WGU) C170 Data Management Applications
objective assessment blueprint and reflects 2026/2027 SQL standards, modern cloud database concepts, and NoSQL
technologies. Questions are sequenced across nine sections covering database fundamentals and the relational model,
entity-relationship modeling and normalization, SQL Data Definition Language (DDL), Data Manipulation Language
(DML), Data Query Language (DQL), advanced querying (joins, subqueries, aggregates, set operators), views/stored
procedures/functions/triggers, database administration/security/transactions, and data warehousing/business
intelligence/emerging trends. Each question includes a detailed rationale explaining why the correct answer is right and
why each distractor is wrong, citing the relevant SQL syntax rule, relational theory principle, normalization concept, or
query execution logic. Distractors are constructed to surface common database and SQL errors, including: incorrect
JOIN type selection (INNER vs. LEFT vs. RIGHT vs. FULL OUTER); improper WHERE vs. HAVING usage; NULL
handling mistakes (= NULL vs. IS NULL); syntax errors in CREATE/ALTER/DROP; incorrect normalization form
identification (1NF vs. 2NF vs. 3NF vs. BCNF); misapplied constraints; wrong aggregate function usage; and incorrect
transaction isolation behavior (dirty reads, non-repeatable reads, phantom reads). Use this exam as both an objective
assessment preparation tool and a comprehensive study guide for the WGU C170 competency blueprint.
Section 1: Database Fundamentals and Relational Model
Q1–Q25 — Database Concepts, RDBMS, Tables, Rows, Columns, Keys, & Relationships (DBMS, relational model,
keys, integrity rules, schemas).
WGU C170 – Verified Answers Page 1
,WGU C170 – Data Management Applications – Objective Assessment 2026/2027 | Over 200 Questions & Answers
Q1: A university is migrating from a spreadsheet-based system to a database system. Which advantage of a
Database Management System (DBMS) BEST addresses the issue of multiple users editing the same data
simultaneously? [Competency: Fundamentals – DBMS]
A. Concurrency control ensures data integrity when multiple users access and modify data simultaneously.
[CORRECT]
B. Data redundancy is increased to provide backup copies of data.
C. The file system approach automatically enforces data integrity.
D. Database systems eliminate the need for any data validation.
Correct Answer: A
Rationale: Concurrency control is a core DBMS feature that manages simultaneous access to prevent conflicts like lost
updates, dirty reads, and inconsistent reads. Data redundancy is reduced, not increased, in a DBMS (B). File systems do
not automatically enforce integrity (C). Database systems still require data validation through constraints (D). Verified
against WGU C170 Module 1 – DBMS Fundamentals.
Q2: Which of the following BEST describes the difference between a database and a DBMS? [Competency:
Fundamentals – Database vs. DBMS]
A. A database is the organized collection of data; a DBMS is the software that manages access to that data.
[CORRECT]
B. A database is the software; a DBMS is the data itself.
C. A database and a DBMS are identical terms.
D. A DBMS stores data in flat files only.
Correct Answer: A
Rationale: A database is the organized collection of related data; a DBMS (Database Management System) is the
software application that enables users to define, create, maintain, and control access to the database. The other options
incorrectly reverse or conflate the terms (B, C, D). Verified against WGU C170 – Database Concepts.
Q3: A retail company stores customer information in a relational database. In the relational model
terminology, what does a single row in the Customer table represent? [Competency: Fundamentals –
Relational Model]
A. A tuple representing one entity instance. [CORRECT]
B. An attribute of the entity.
C. The schema of the table.
D. A domain constraint.
Correct Answer: A
Rationale: In the relational model, a row (also called a tuple) represents a single entity instance — one complete record
describing one customer. An attribute is a column (B). The schema defines the structure of the table (C). A domain
defines the set of allowable values for an attribute (D). Verified against WGU C170 – Relational Model.
WGU C170 – Verified Answers Page 2
,WGU C170 – Data Management Applications – Objective Assessment 2026/2027 | Over 200 Questions & Answers
Q4: Which type of key uniquely identifies each row in a table and cannot contain NULL values?
[Competency: Fundamentals – Primary Key]
A. Primary key. [CORRECT]
B. Foreign key.
C. Candidate key that was not selected as primary.
D. Surrogate key without a unique constraint.
Correct Answer: A
Rationale: A primary key uniquely identifies each row and, by definition, cannot contain NULL values (entity
integrity). A foreign key references a primary key in another table and can contain NULL (B). A candidate key not
selected as primary could allow NULL (C). A surrogate key without a unique constraint does not guarantee uniqueness
(D). Verified against WGU C170 – Keys.
Q5: An Orders table contains a column CustomerID that references CustomerID in the Customers table.
What type of key is CustomerID in the Orders table? [Competency: Fundamentals – Foreign Key]
A. Foreign key. [CORRECT]
B. Primary key.
C. Candidate key.
D. Composite key.
Correct Answer: A
Rationale: A foreign key is a column (or set of columns) in one table that references the primary key of another table,
establishing a relationship between the two tables. CustomerID in Orders references the primary key of Customers,
making it a foreign key. A primary key uniquely identifies rows in its own table (B). A candidate key could be a primary
key but isn’t necessarily (C). A composite key consists of multiple columns (D). Verified against WGU C170 – Foreign
Keys.
Q6: Which integrity rule ensures that a foreign key value must either match a primary key value in the
referenced table or be NULL? [Competency: Fundamentals – Referential Integrity]
A. Referential integrity. [CORRECT]
B. Entity integrity.
C. Domain integrity.
D. User-defined integrity.
Correct Answer: A
Rationale: Referential integrity ensures that foreign key values match primary key values in the referenced table or are
NULL. Entity integrity requires primary keys to be unique and non-NULL (B). Domain integrity restricts values to a
defined set or range (C). User-defined integrity involves business rules (D). Verified against WGU C170 – Integrity
Rules.
WGU C170 – Verified Answers Page 3
, WGU C170 – Data Management Applications – Objective Assessment 2026/2027 | Over 200 Questions & Answers
Q7: A database designer is defining a column Gender with allowable values ‘M’, ‘F’, and ‘O’. Which type
of integrity is this? [Competency: Fundamentals – Domain Integrity]
A. Domain integrity, restricting values to an allowed set. [CORRECT]
B. Entity integrity, ensuring unique rows.
C. Referential integrity, ensuring valid foreign keys.
D. Transaction integrity, ensuring ACID properties.
Correct Answer: A
Rationale: Domain integrity restricts the allowable values for a column to a defined set, range, or type. Restricting
Gender to specific values is domain integrity. Entity integrity concerns primary keys (B). Referential integrity concerns
foreign keys (C). Transaction integrity concerns ACID (D). Verified against WGU C170 – Integrity Types.
Q8: Which term describes a set of allowable values for one or more attributes in the relational model?
[Competency: Fundamentals – Domain]
A. Domain. [CORRECT]
B. Tuple.
C. Cardinality.
D. Degree.
Correct Answer: A
Rationale: A domain is the set of allowable values for an attribute. A tuple is a single row (B). Cardinality is the number
of tuples in a relation (C). Degree is the number of attributes in a relation (D). Verified against WGU C170 – Relational
Terminology.
Q9: A table has 5 columns and 100 rows. What is the degree and cardinality of this relation? [Competency:
Fundamentals – Degree/Cardinality]
A. Degree = 5, Cardinality = 100. [CORRECT]
B. Degree = 100, Cardinality = 5.
C. Degree = 5, Cardinality = 5.
D. Degree = 100, Cardinality = 100.
Correct Answer: A
Rationale: Degree is the number of attributes (columns) in a relation; cardinality is the number of tuples (rows). With 5
columns and 100 rows, degree = 5 and cardinality = 100. The other options reverse or mismatch the values (B, C, D).
Verified against WGU C170 – Relational Terminology.
Q10: Which of the following is NOT a characteristic of a relational database? [Competency: Fundamentals
– Relational Characteristics]
A. Data is stored in hierarchical tree structures with parent-child relationships. [CORRECT]
B. Data is organized into tables with rows and columns.
C. Tables can be linked through common attributes (keys).
D. Data integrity is enforced through constraints.
Correct Answer: A
Rationale: Hierarchical tree structures are characteristic of hierarchical databases, not relational databases. Relational
databases organize data into tables (relations) with rows (tuples) and columns (attributes), linked through keys, with
integrity enforced by constraints. Verified against WGU C170 – Database Models.
WGU C170 – Verified Answers Page 4
WGU C170 — DATA MANAGEMENT APPLICATIONS EXAM
Western Governors University — Objective Assessment — 2026/2027
Over 200 Questions & Answers — 100% Verified with Detailed Rationales
Total Questions 220 (Q1–Q220)
Number of Sections 9
Cognitive Levels ~30% Recall · ~50% Application · ~20% Analysis
Question Style 70% Application/scenario (SQL, design) · 30% Direct recall
Answer Format 4-option multiple choice (A–D), one correct answer
Coverage SQL, ER modeling, normalization, queries, admin, security, DW, NoSQL, cloud
Verification Each rationale confirms the answer against SQL standards and relational theory
This exam is aligned with the current Western Governors University (WGU) C170 Data Management Applications
objective assessment blueprint and reflects 2026/2027 SQL standards, modern cloud database concepts, and NoSQL
technologies. Questions are sequenced across nine sections covering database fundamentals and the relational model,
entity-relationship modeling and normalization, SQL Data Definition Language (DDL), Data Manipulation Language
(DML), Data Query Language (DQL), advanced querying (joins, subqueries, aggregates, set operators), views/stored
procedures/functions/triggers, database administration/security/transactions, and data warehousing/business
intelligence/emerging trends. Each question includes a detailed rationale explaining why the correct answer is right and
why each distractor is wrong, citing the relevant SQL syntax rule, relational theory principle, normalization concept, or
query execution logic. Distractors are constructed to surface common database and SQL errors, including: incorrect
JOIN type selection (INNER vs. LEFT vs. RIGHT vs. FULL OUTER); improper WHERE vs. HAVING usage; NULL
handling mistakes (= NULL vs. IS NULL); syntax errors in CREATE/ALTER/DROP; incorrect normalization form
identification (1NF vs. 2NF vs. 3NF vs. BCNF); misapplied constraints; wrong aggregate function usage; and incorrect
transaction isolation behavior (dirty reads, non-repeatable reads, phantom reads). Use this exam as both an objective
assessment preparation tool and a comprehensive study guide for the WGU C170 competency blueprint.
Section 1: Database Fundamentals and Relational Model
Q1–Q25 — Database Concepts, RDBMS, Tables, Rows, Columns, Keys, & Relationships (DBMS, relational model,
keys, integrity rules, schemas).
WGU C170 – Verified Answers Page 1
,WGU C170 – Data Management Applications – Objective Assessment 2026/2027 | Over 200 Questions & Answers
Q1: A university is migrating from a spreadsheet-based system to a database system. Which advantage of a
Database Management System (DBMS) BEST addresses the issue of multiple users editing the same data
simultaneously? [Competency: Fundamentals – DBMS]
A. Concurrency control ensures data integrity when multiple users access and modify data simultaneously.
[CORRECT]
B. Data redundancy is increased to provide backup copies of data.
C. The file system approach automatically enforces data integrity.
D. Database systems eliminate the need for any data validation.
Correct Answer: A
Rationale: Concurrency control is a core DBMS feature that manages simultaneous access to prevent conflicts like lost
updates, dirty reads, and inconsistent reads. Data redundancy is reduced, not increased, in a DBMS (B). File systems do
not automatically enforce integrity (C). Database systems still require data validation through constraints (D). Verified
against WGU C170 Module 1 – DBMS Fundamentals.
Q2: Which of the following BEST describes the difference between a database and a DBMS? [Competency:
Fundamentals – Database vs. DBMS]
A. A database is the organized collection of data; a DBMS is the software that manages access to that data.
[CORRECT]
B. A database is the software; a DBMS is the data itself.
C. A database and a DBMS are identical terms.
D. A DBMS stores data in flat files only.
Correct Answer: A
Rationale: A database is the organized collection of related data; a DBMS (Database Management System) is the
software application that enables users to define, create, maintain, and control access to the database. The other options
incorrectly reverse or conflate the terms (B, C, D). Verified against WGU C170 – Database Concepts.
Q3: A retail company stores customer information in a relational database. In the relational model
terminology, what does a single row in the Customer table represent? [Competency: Fundamentals –
Relational Model]
A. A tuple representing one entity instance. [CORRECT]
B. An attribute of the entity.
C. The schema of the table.
D. A domain constraint.
Correct Answer: A
Rationale: In the relational model, a row (also called a tuple) represents a single entity instance — one complete record
describing one customer. An attribute is a column (B). The schema defines the structure of the table (C). A domain
defines the set of allowable values for an attribute (D). Verified against WGU C170 – Relational Model.
WGU C170 – Verified Answers Page 2
,WGU C170 – Data Management Applications – Objective Assessment 2026/2027 | Over 200 Questions & Answers
Q4: Which type of key uniquely identifies each row in a table and cannot contain NULL values?
[Competency: Fundamentals – Primary Key]
A. Primary key. [CORRECT]
B. Foreign key.
C. Candidate key that was not selected as primary.
D. Surrogate key without a unique constraint.
Correct Answer: A
Rationale: A primary key uniquely identifies each row and, by definition, cannot contain NULL values (entity
integrity). A foreign key references a primary key in another table and can contain NULL (B). A candidate key not
selected as primary could allow NULL (C). A surrogate key without a unique constraint does not guarantee uniqueness
(D). Verified against WGU C170 – Keys.
Q5: An Orders table contains a column CustomerID that references CustomerID in the Customers table.
What type of key is CustomerID in the Orders table? [Competency: Fundamentals – Foreign Key]
A. Foreign key. [CORRECT]
B. Primary key.
C. Candidate key.
D. Composite key.
Correct Answer: A
Rationale: A foreign key is a column (or set of columns) in one table that references the primary key of another table,
establishing a relationship between the two tables. CustomerID in Orders references the primary key of Customers,
making it a foreign key. A primary key uniquely identifies rows in its own table (B). A candidate key could be a primary
key but isn’t necessarily (C). A composite key consists of multiple columns (D). Verified against WGU C170 – Foreign
Keys.
Q6: Which integrity rule ensures that a foreign key value must either match a primary key value in the
referenced table or be NULL? [Competency: Fundamentals – Referential Integrity]
A. Referential integrity. [CORRECT]
B. Entity integrity.
C. Domain integrity.
D. User-defined integrity.
Correct Answer: A
Rationale: Referential integrity ensures that foreign key values match primary key values in the referenced table or are
NULL. Entity integrity requires primary keys to be unique and non-NULL (B). Domain integrity restricts values to a
defined set or range (C). User-defined integrity involves business rules (D). Verified against WGU C170 – Integrity
Rules.
WGU C170 – Verified Answers Page 3
, WGU C170 – Data Management Applications – Objective Assessment 2026/2027 | Over 200 Questions & Answers
Q7: A database designer is defining a column Gender with allowable values ‘M’, ‘F’, and ‘O’. Which type
of integrity is this? [Competency: Fundamentals – Domain Integrity]
A. Domain integrity, restricting values to an allowed set. [CORRECT]
B. Entity integrity, ensuring unique rows.
C. Referential integrity, ensuring valid foreign keys.
D. Transaction integrity, ensuring ACID properties.
Correct Answer: A
Rationale: Domain integrity restricts the allowable values for a column to a defined set, range, or type. Restricting
Gender to specific values is domain integrity. Entity integrity concerns primary keys (B). Referential integrity concerns
foreign keys (C). Transaction integrity concerns ACID (D). Verified against WGU C170 – Integrity Types.
Q8: Which term describes a set of allowable values for one or more attributes in the relational model?
[Competency: Fundamentals – Domain]
A. Domain. [CORRECT]
B. Tuple.
C. Cardinality.
D. Degree.
Correct Answer: A
Rationale: A domain is the set of allowable values for an attribute. A tuple is a single row (B). Cardinality is the number
of tuples in a relation (C). Degree is the number of attributes in a relation (D). Verified against WGU C170 – Relational
Terminology.
Q9: A table has 5 columns and 100 rows. What is the degree and cardinality of this relation? [Competency:
Fundamentals – Degree/Cardinality]
A. Degree = 5, Cardinality = 100. [CORRECT]
B. Degree = 100, Cardinality = 5.
C. Degree = 5, Cardinality = 5.
D. Degree = 100, Cardinality = 100.
Correct Answer: A
Rationale: Degree is the number of attributes (columns) in a relation; cardinality is the number of tuples (rows). With 5
columns and 100 rows, degree = 5 and cardinality = 100. The other options reverse or mismatch the values (B, C, D).
Verified against WGU C170 – Relational Terminology.
Q10: Which of the following is NOT a characteristic of a relational database? [Competency: Fundamentals
– Relational Characteristics]
A. Data is stored in hierarchical tree structures with parent-child relationships. [CORRECT]
B. Data is organized into tables with rows and columns.
C. Tables can be linked through common attributes (keys).
D. Data integrity is enforced through constraints.
Correct Answer: A
Rationale: Hierarchical tree structures are characteristic of hierarchical databases, not relational databases. Relational
databases organize data into tables (relations) with rows (tuples) and columns (attributes), linked through keys, with
integrity enforced by constraints. Verified against WGU C170 – Database Models.
WGU C170 – Verified Answers Page 4
