WGU C175 Data management Essential Test
Toolkit Exam Questions and Approved with
Distinction Marking Scheme Latest
2024/2025
Big data - correct answer · movement to find new and better ways to manage large
amounts of web/ sensor-generated data and derive business insight from it, while
simultaneously providing high performance and scalability at a reasonable cost
Intersection data - correct answer · describes the relationship between two entities
O associative entity - correct answer · indicates a relationship between one entity and
another
· specifically, that an entity has been involved in an action that involves another
· includes any intersection data that describes the relationship in its information
Logical view of data - correct answer · relational model enables you to view data
logically rather than physically.
O logical view facilitated by relationships based on logical construct call a relation
Domain - correct answer · in data modeling, the construct used to organize and
describe an attribute's set of possible values.
Functional dependency - correct answer · value of one or more attributes determines
the value of one or more other attributes
Full functional dependance - correct answer · functional dependencies that the entire
collection of attributes in the determinant is necessary for the relationship
Composite key - correct answer · key that is composed of more than one attribute
, Key attribute - correct answer attribute that is a part of a key
Super key - correct answer any key that uniquely identifies each row
Candidate key - correct answer · a specific type of super key that is a minimal super
key
· without any unnecessary attributes
· based on a full functional dependency
Foreign key - correct answer · primary key of one table that has been placed into
another table to create a common attribute
· used to ensure referential integrity
Null values - correct answer · absence of any data value
· never allowed in any part of the primary key
Referential integrity - correct answer · used to enforce rules associated with referential
constraints
Rules: insert, update, delete
· insert rule - correct answer o non-null insert value of foreign key must match some
value of parent key of parent table
O implicit rule when foreign key is specified
Toolkit Exam Questions and Approved with
Distinction Marking Scheme Latest
2024/2025
Big data - correct answer · movement to find new and better ways to manage large
amounts of web/ sensor-generated data and derive business insight from it, while
simultaneously providing high performance and scalability at a reasonable cost
Intersection data - correct answer · describes the relationship between two entities
O associative entity - correct answer · indicates a relationship between one entity and
another
· specifically, that an entity has been involved in an action that involves another
· includes any intersection data that describes the relationship in its information
Logical view of data - correct answer · relational model enables you to view data
logically rather than physically.
O logical view facilitated by relationships based on logical construct call a relation
Domain - correct answer · in data modeling, the construct used to organize and
describe an attribute's set of possible values.
Functional dependency - correct answer · value of one or more attributes determines
the value of one or more other attributes
Full functional dependance - correct answer · functional dependencies that the entire
collection of attributes in the determinant is necessary for the relationship
Composite key - correct answer · key that is composed of more than one attribute
, Key attribute - correct answer attribute that is a part of a key
Super key - correct answer any key that uniquely identifies each row
Candidate key - correct answer · a specific type of super key that is a minimal super
key
· without any unnecessary attributes
· based on a full functional dependency
Foreign key - correct answer · primary key of one table that has been placed into
another table to create a common attribute
· used to ensure referential integrity
Null values - correct answer · absence of any data value
· never allowed in any part of the primary key
Referential integrity - correct answer · used to enforce rules associated with referential
constraints
Rules: insert, update, delete
· insert rule - correct answer o non-null insert value of foreign key must match some
value of parent key of parent table
O implicit rule when foreign key is specified
