WGU D330 DATA SYSTEMS
ADMINISTRATION PRACTICE
EXAMINATION 2026 QUESTIONS WITH
ANSWERS GRADED A+
◍ strong (identifying) relationship.
Answer: A relationship that occurs when two entities are
existence-dependent; from a database design perspective, this relationship
exists whenever the primary key of the related entity contains the primary
key of the parent entity.
◍ Data dictionary.
Answer: A DBMS component that stores metadata - data about data. Thus,
the data dictionary contains the data definition as well as their characteristics
and relationships. A data dictionary may also include data that are external
to the DBMS. Also known as an information resource dictionary.
◍ COBOL.
Answer: The first computer language; developed in the 1950s; still used
today.
◍ Data Administrator.
Answer: Responsible for determining and monitoring employees' access to
the company's database management system (DBMS).
◍ UPDATE.
Answer: A SQL command that allows attribute values to be changed in one
or more rows of a table.
◍ prime attribute.
Answer: A key attribute; that is, an attribute that is part of a key or is the
, whole key.
◍ existence-independent.
Answer: A property of an entity that can exist apart from one or more
related entities. Such a table must be created first when referencing an
existence-dependent table.
◍ Microsoft Visio.
Answer: Helps systems analysts create professional diagrams that simplify
complex information.
◍ weak entity.
Answer: An entity that displays existence dependence and inherits the
primary key of its parent entity. For example, a DEPENDENT requires the
existence of an EMPLOYEE.
◍ Three V's of Big Data.
Answer: Volume, Variety, and Velocity; Volume refers to the amount of
data, variety refers to the number of types of data, and velocity refers to the
speed of data processing (real-time analytics).
◍ ARPANET.
Answer: an early packet switching network and the first network to
implement the protocol suite TCP/IP. Both technologies became the
technical foundation of the Internet.
◍ Wi-Fi Protected Access (WPA).
Answer: A wireless (tunneling) encryption protocol that provides secure
data transmission over an insecure network.
◍ Flat File Database.
Answer: Stores data in plain text, holding one record; cannot contain
multiple tables like a relational database.
◍ Network economics (network-based strategy).
Answer: the cost of adding another business participant to a business venture
is small, the potential gain is great.
,◍ Data, Information, and Knowledge example.
Answer: Data: The number of people below the poverty line in the region is
50,000. Information: The number of people below the poverty line increases
between 2010 and 2018. Knowledge: The number of people below the
poverty line has increased due to stagnating wages and cuts to social
programs.
◍ Risks.
Answer: the potential for loss, commonly associated with the monetary and
non-monetary impact to such a risk, as well as the probability of occurrence.
◍ denormalization.
Answer: A process by which a table is changed from a higher-level normal
form to a lower-level normal form, usually to increase processing speed.
Denormalization potentially yields data anomalies.
◍ CREATE TABLE.
Answer: A SQL command that creates a table's structures using the
characteristics and attributes given.
◍ Class hierarchy.
Answer: The organization of classes in a hierarchical tree in which each
parent class is a superclass and each child class is a subclass.
◍ four phases of the decision-making process.
Answer: intelligence, design, choice, and implementation
◍ Dumb Terminal/Thin Client.
Answer: A terminal that depends on the host computer for its processing
power
◍ slice and dice.
Answer: The ability to focus on slices of a data cube (drill down or roll up)
to perform a more detailed analysis.
◍ Online Analytical processing (OLAP).
Answer: analyze transaction data used for making decisions;
, multidimensional (cubical) data; requires a lengthy, complex loading and
updating phase.
◍ Executive Support Systems (ESS).
Answer: Helps executives make unstructured and semi-structured decisions;
includes internal and external data.
◍ multidimensional database management systems (MDBMSs).
Answer: A database management system that uses proprietary techniques to
store data in matrixlike arrays of n dimensions known as cubes.
◍ Information Policy Administrator.
Answer: Responsible for acquiring, organizing, and distributing
organizational information internally.
◍ Data normalization.
Answer: the reorganization of tables, and attributes within a database to
reduce duplication is especially important during database redesign, but also
when data is imported or merged.
◍ Ad hoc query.
Answer: A spur-of-the-moment question.
◍ Simple Mail Transfer Protocol (SMTP).
Answer: Used to manage and monitor emails that we receive.
◍ cascading order sequence.
Answer: A nested ordering sequence for a set of rows, such as a list in which
all last names are alphabetically ordered and, within the last names, all first
names are ordered.
◍ Scope.
Answer: Elements of a project that include cost, time, quality, and risk.
◍ Foreign Key.
Answer: Field that is a primary key to another table.
◍ Key-value.
Answer: A data model based on a structure composed of two data elements:
ADMINISTRATION PRACTICE
EXAMINATION 2026 QUESTIONS WITH
ANSWERS GRADED A+
◍ strong (identifying) relationship.
Answer: A relationship that occurs when two entities are
existence-dependent; from a database design perspective, this relationship
exists whenever the primary key of the related entity contains the primary
key of the parent entity.
◍ Data dictionary.
Answer: A DBMS component that stores metadata - data about data. Thus,
the data dictionary contains the data definition as well as their characteristics
and relationships. A data dictionary may also include data that are external
to the DBMS. Also known as an information resource dictionary.
◍ COBOL.
Answer: The first computer language; developed in the 1950s; still used
today.
◍ Data Administrator.
Answer: Responsible for determining and monitoring employees' access to
the company's database management system (DBMS).
◍ UPDATE.
Answer: A SQL command that allows attribute values to be changed in one
or more rows of a table.
◍ prime attribute.
Answer: A key attribute; that is, an attribute that is part of a key or is the
, whole key.
◍ existence-independent.
Answer: A property of an entity that can exist apart from one or more
related entities. Such a table must be created first when referencing an
existence-dependent table.
◍ Microsoft Visio.
Answer: Helps systems analysts create professional diagrams that simplify
complex information.
◍ weak entity.
Answer: An entity that displays existence dependence and inherits the
primary key of its parent entity. For example, a DEPENDENT requires the
existence of an EMPLOYEE.
◍ Three V's of Big Data.
Answer: Volume, Variety, and Velocity; Volume refers to the amount of
data, variety refers to the number of types of data, and velocity refers to the
speed of data processing (real-time analytics).
◍ ARPANET.
Answer: an early packet switching network and the first network to
implement the protocol suite TCP/IP. Both technologies became the
technical foundation of the Internet.
◍ Wi-Fi Protected Access (WPA).
Answer: A wireless (tunneling) encryption protocol that provides secure
data transmission over an insecure network.
◍ Flat File Database.
Answer: Stores data in plain text, holding one record; cannot contain
multiple tables like a relational database.
◍ Network economics (network-based strategy).
Answer: the cost of adding another business participant to a business venture
is small, the potential gain is great.
,◍ Data, Information, and Knowledge example.
Answer: Data: The number of people below the poverty line in the region is
50,000. Information: The number of people below the poverty line increases
between 2010 and 2018. Knowledge: The number of people below the
poverty line has increased due to stagnating wages and cuts to social
programs.
◍ Risks.
Answer: the potential for loss, commonly associated with the monetary and
non-monetary impact to such a risk, as well as the probability of occurrence.
◍ denormalization.
Answer: A process by which a table is changed from a higher-level normal
form to a lower-level normal form, usually to increase processing speed.
Denormalization potentially yields data anomalies.
◍ CREATE TABLE.
Answer: A SQL command that creates a table's structures using the
characteristics and attributes given.
◍ Class hierarchy.
Answer: The organization of classes in a hierarchical tree in which each
parent class is a superclass and each child class is a subclass.
◍ four phases of the decision-making process.
Answer: intelligence, design, choice, and implementation
◍ Dumb Terminal/Thin Client.
Answer: A terminal that depends on the host computer for its processing
power
◍ slice and dice.
Answer: The ability to focus on slices of a data cube (drill down or roll up)
to perform a more detailed analysis.
◍ Online Analytical processing (OLAP).
Answer: analyze transaction data used for making decisions;
, multidimensional (cubical) data; requires a lengthy, complex loading and
updating phase.
◍ Executive Support Systems (ESS).
Answer: Helps executives make unstructured and semi-structured decisions;
includes internal and external data.
◍ multidimensional database management systems (MDBMSs).
Answer: A database management system that uses proprietary techniques to
store data in matrixlike arrays of n dimensions known as cubes.
◍ Information Policy Administrator.
Answer: Responsible for acquiring, organizing, and distributing
organizational information internally.
◍ Data normalization.
Answer: the reorganization of tables, and attributes within a database to
reduce duplication is especially important during database redesign, but also
when data is imported or merged.
◍ Ad hoc query.
Answer: A spur-of-the-moment question.
◍ Simple Mail Transfer Protocol (SMTP).
Answer: Used to manage and monitor emails that we receive.
◍ cascading order sequence.
Answer: A nested ordering sequence for a set of rows, such as a list in which
all last names are alphabetically ordered and, within the last names, all first
names are ordered.
◍ Scope.
Answer: Elements of a project that include cost, time, quality, and risk.
◍ Foreign Key.
Answer: Field that is a primary key to another table.
◍ Key-value.
Answer: A data model based on a structure composed of two data elements:
