WGU D426 Data Management Foundations | OA |
Objective Assessment| Actual Questions and
Answers Latest Updated (Graded A+)
Correct
Incorrect
D426 Data Management Foundations
, - Volatility
- Detail
Data is loaded to the data warehouse
- Scope
- History
Don't know?
2 of 104
Term
A pet owner can have many pets; a specific pet is linked to one pet
owner. What is the binary relationship described?
Give this one a try later!
One-To-Many Many-to-many
Many-to-one One-to-one
Don't know?
3 of 104
Term
A table can be logically connected to another table by defining a ___ _.
Give this one a try later!
, unique identifier common data type
common attribute shared relationship
Don't know?
4 of 104
Term
What functions does the DBMS perform to guarantee integrity and
consistency of the data in a database?
Give this one a try later!
- Data Integrity Management Primary Identifier - used for
- Data storage mangagement attribute(s) that uniquely identify the
- Security management whole entity
- Many = Crow's Foot
- One = a bar across the end of a Data is structured in a design that is
relationship (--||--) optimal for analysis
- Zero = Circle
Don't know?
, 5 of 104
Term
An attribute (or group of attributes) that uniquely identifies each entity
in a table is called:
Give this one a try later!
A composite key A superkey
A dependent attribute A determinant
Don't know?
6 of 104
Term
Difference between Unary and Binary:
Give this one a try later!
Maxima is the first letter/number - Unary: One entity involved in
shown (outside of the entity) and relationship (one box, one line)
Minima is the letter next to it in - Binary: Two entities (two boxes
parentheses combined by one line)
Objective Assessment| Actual Questions and
Answers Latest Updated (Graded A+)
Correct
Incorrect
D426 Data Management Foundations
, - Volatility
- Detail
Data is loaded to the data warehouse
- Scope
- History
Don't know?
2 of 104
Term
A pet owner can have many pets; a specific pet is linked to one pet
owner. What is the binary relationship described?
Give this one a try later!
One-To-Many Many-to-many
Many-to-one One-to-one
Don't know?
3 of 104
Term
A table can be logically connected to another table by defining a ___ _.
Give this one a try later!
, unique identifier common data type
common attribute shared relationship
Don't know?
4 of 104
Term
What functions does the DBMS perform to guarantee integrity and
consistency of the data in a database?
Give this one a try later!
- Data Integrity Management Primary Identifier - used for
- Data storage mangagement attribute(s) that uniquely identify the
- Security management whole entity
- Many = Crow's Foot
- One = a bar across the end of a Data is structured in a design that is
relationship (--||--) optimal for analysis
- Zero = Circle
Don't know?
, 5 of 104
Term
An attribute (or group of attributes) that uniquely identifies each entity
in a table is called:
Give this one a try later!
A composite key A superkey
A dependent attribute A determinant
Don't know?
6 of 104
Term
Difference between Unary and Binary:
Give this one a try later!
Maxima is the first letter/number - Unary: One entity involved in
shown (outside of the entity) and relationship (one box, one line)
Minima is the letter next to it in - Binary: Two entities (two boxes
parentheses combined by one line)
