WGU - C175 Data Management Exam test
preparation Questions and Must have
marking scheme Updated version 2024/2025
Key - correct answer one or more attributes that determine other attributes. See also
super key, candidate key, primary key (pk), secondary key, and foreign key.
Key attribute - correct answer the attributes that form a primary key. See also prime
attribute.
Key performance indicators (kpis) - correct answer in business intelligence,
quantifiable numeric or scale-based measurements that assess a company's
effectiveness or success in reaching strategic and operational goals. Examples of ___
are product turnovers, sales by promotion, sales by employee, and earnings per share.
Key-value - correct answer a data model based on a structure composed of two data
elements: a ___, in which every key has a corresponding value or set of values. The
___ data model is also called the associative or attribute-value data model.
Knowledge - correct answer the body of information and facts about a specific subject.
___ implies familiarity, awareness, and understanding of information as it applies to an
environment. A key characteristic is that new ___ can be derived from old ___.
Like - correct answer in sql, a comparison operator used to check whether an
attribute's text value matches a specified string pattern.
Linking table - correct answer in the relational model, a table that implements an m:m
relationship. See also composite entity.
Logical data format - correct answer the way a person views data within the context of
a problem domain.
,Mandatory participation - correct answer a relationship in which one entity occurrence
must have a corresponding occurrence in another entity. For example, an employee
works in a division. (a person cannot be an employee without being assigned to a
company's division.)
Many-to-many (m:n or *..*) relationship - correct answer association among two or
more entities in which one occurrence of an entity is associated with many occurrences
of a related entity and one occurrence of the related entity is associated with many
occurrences of the first entity.
Mapreduce - correct answer an open-source application programming interface (api)
that provides fast data analytics services; one of the main big data technologies that
allows organizations to process massive data stores.
Master data management (mdm) - correct answer in business intelligence, a collection
of concepts, techniques, and processes for the proper identification, definition, and
management of data elements within an organization.
Max - correct answer a sql aggregate function that yields the maximum attribute value
in a given column.
Metadata - correct answer data about data; that is, data about data characteristics and
relationships. See also data dictionary.
Method - correct answer in the object-oriented data model, a named set of instructions
to perform an action. ___ represent real-world actions, and are invoked through
messages.
Min - correct answer a sql aggregate function that yields the minimum attribute value in
a given column.
Multidimensional database management systems (mdbmss) - correct answer a
database management system that uses proprietary techniques to store data in
matrixlike arrays of n dimensions known as cubes.
, Multidimensional online analytical processing (molap) - correct answer an extension of
online analytical processing to multidimensional database management systems.
Multiuser database - correct answer a database that supports multiple concurrent
users.
Multivalued attributes - correct answer an attribute that can have many values for a
single entity occurrence. For example, an emp_degree attribute might store the string
"bba, mba, phd" to indicate three different degrees held.
Name node - correct answer one of three types of nodes used in the hadoop
distributed file system (hdfs). The ___ stores all the metadata about the file system. See
also client node and data node.
Nested query - correct answer in sql, a query that is embedded in another query. See
subquery.
Network model - correct answer an early data model that represented data as a
collection of record types in 1:m relationships.
Non-identifying relationship - correct answer a relationship in which the primary key of
the related entity does not contain a primary key component of the parent entity.
Nonprime attribute - correct answer an attribute that is not part of a key.
Normalization - correct answer a process that assigns attributes to entities so that data
redundancies are reduced or eliminated.
Nosql - correct answer a new generation of database management systems that is not
based on the traditional relational database model.
preparation Questions and Must have
marking scheme Updated version 2024/2025
Key - correct answer one or more attributes that determine other attributes. See also
super key, candidate key, primary key (pk), secondary key, and foreign key.
Key attribute - correct answer the attributes that form a primary key. See also prime
attribute.
Key performance indicators (kpis) - correct answer in business intelligence,
quantifiable numeric or scale-based measurements that assess a company's
effectiveness or success in reaching strategic and operational goals. Examples of ___
are product turnovers, sales by promotion, sales by employee, and earnings per share.
Key-value - correct answer a data model based on a structure composed of two data
elements: a ___, in which every key has a corresponding value or set of values. The
___ data model is also called the associative or attribute-value data model.
Knowledge - correct answer the body of information and facts about a specific subject.
___ implies familiarity, awareness, and understanding of information as it applies to an
environment. A key characteristic is that new ___ can be derived from old ___.
Like - correct answer in sql, a comparison operator used to check whether an
attribute's text value matches a specified string pattern.
Linking table - correct answer in the relational model, a table that implements an m:m
relationship. See also composite entity.
Logical data format - correct answer the way a person views data within the context of
a problem domain.
,Mandatory participation - correct answer a relationship in which one entity occurrence
must have a corresponding occurrence in another entity. For example, an employee
works in a division. (a person cannot be an employee without being assigned to a
company's division.)
Many-to-many (m:n or *..*) relationship - correct answer association among two or
more entities in which one occurrence of an entity is associated with many occurrences
of a related entity and one occurrence of the related entity is associated with many
occurrences of the first entity.
Mapreduce - correct answer an open-source application programming interface (api)
that provides fast data analytics services; one of the main big data technologies that
allows organizations to process massive data stores.
Master data management (mdm) - correct answer in business intelligence, a collection
of concepts, techniques, and processes for the proper identification, definition, and
management of data elements within an organization.
Max - correct answer a sql aggregate function that yields the maximum attribute value
in a given column.
Metadata - correct answer data about data; that is, data about data characteristics and
relationships. See also data dictionary.
Method - correct answer in the object-oriented data model, a named set of instructions
to perform an action. ___ represent real-world actions, and are invoked through
messages.
Min - correct answer a sql aggregate function that yields the minimum attribute value in
a given column.
Multidimensional database management systems (mdbmss) - correct answer a
database management system that uses proprietary techniques to store data in
matrixlike arrays of n dimensions known as cubes.
, Multidimensional online analytical processing (molap) - correct answer an extension of
online analytical processing to multidimensional database management systems.
Multiuser database - correct answer a database that supports multiple concurrent
users.
Multivalued attributes - correct answer an attribute that can have many values for a
single entity occurrence. For example, an emp_degree attribute might store the string
"bba, mba, phd" to indicate three different degrees held.
Name node - correct answer one of three types of nodes used in the hadoop
distributed file system (hdfs). The ___ stores all the metadata about the file system. See
also client node and data node.
Nested query - correct answer in sql, a query that is embedded in another query. See
subquery.
Network model - correct answer an early data model that represented data as a
collection of record types in 1:m relationships.
Non-identifying relationship - correct answer a relationship in which the primary key of
the related entity does not contain a primary key component of the parent entity.
Nonprime attribute - correct answer an attribute that is not part of a key.
Normalization - correct answer a process that assigns attributes to entities so that data
redundancies are reduced or eliminated.
Nosql - correct answer a new generation of database management systems that is not
based on the traditional relational database model.
