WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA 2025 UPDATED
EXAM | ACTUAL EXAM 2 LATEST
VERSIONS 400 QUESTIONS AND
CORRECT VERIFIED ANSWERS WITH
RATIONALES (100% CORRECT) A+
GRADED ASSURED
, In what two ways does a DBMS environment increase effectiveness in working with
data? - ANSWER- Enables Data Sharing
- Storage of vast volumes of data
A company posts an internet-based newsletter about their products. What advantage
will this company gain from the relational database management system that will store
customer information? - ANSWERImproved query response time
What is the method of organizing attributes into tables? - ANSWERData
NORMALIZATION
What should a company expect from implementing a business intelligence system? -
ANSWER- Financial: Increased profitability
- Productivity: Increased throughput, decreased workloads
- Trust: greater satisfaction
- Risk: improved visibility
What is a relational model? - ANSWERA database model based on mathematical
principles
What are the 3 mathematical concepts of the relational model? - ANSWER- Domain
- Tuple
- Relation
Define: Domain - ANSWERSet of values = 'Data Type'
Define: Tuple - ANSWERFinite sequence of values pulled from a fixed domain = 'Row'
Define: Relation - ANSWERA named set of tuples, all from same domain = 'Table'
A tuple position is called a: - ANSWERAttribute
How is cardinality depicted in a diagram for many, one, and zero? - ANSWER- Many =
Crow's Foot
- One = a bar across the end of a relationship (--||--)
- Zero = Circle
Difference between Unary and Binary: - ANSWER- Unary: One entity involved in
relationship (one box, one line)
- Binary: Two entities (two boxes combined by one line)
If an entity is mandatory, how is it depicted in an ER diagram? - ANSWERWith a single
vertical line through the relationship line
FOUNDATIONS OA 2025 UPDATED
EXAM | ACTUAL EXAM 2 LATEST
VERSIONS 400 QUESTIONS AND
CORRECT VERIFIED ANSWERS WITH
RATIONALES (100% CORRECT) A+
GRADED ASSURED
, In what two ways does a DBMS environment increase effectiveness in working with
data? - ANSWER- Enables Data Sharing
- Storage of vast volumes of data
A company posts an internet-based newsletter about their products. What advantage
will this company gain from the relational database management system that will store
customer information? - ANSWERImproved query response time
What is the method of organizing attributes into tables? - ANSWERData
NORMALIZATION
What should a company expect from implementing a business intelligence system? -
ANSWER- Financial: Increased profitability
- Productivity: Increased throughput, decreased workloads
- Trust: greater satisfaction
- Risk: improved visibility
What is a relational model? - ANSWERA database model based on mathematical
principles
What are the 3 mathematical concepts of the relational model? - ANSWER- Domain
- Tuple
- Relation
Define: Domain - ANSWERSet of values = 'Data Type'
Define: Tuple - ANSWERFinite sequence of values pulled from a fixed domain = 'Row'
Define: Relation - ANSWERA named set of tuples, all from same domain = 'Table'
A tuple position is called a: - ANSWERAttribute
How is cardinality depicted in a diagram for many, one, and zero? - ANSWER- Many =
Crow's Foot
- One = a bar across the end of a relationship (--||--)
- Zero = Circle
Difference between Unary and Binary: - ANSWER- Unary: One entity involved in
relationship (one box, one line)
- Binary: Two entities (two boxes combined by one line)
If an entity is mandatory, how is it depicted in an ER diagram? - ANSWERWith a single
vertical line through the relationship line
