WGU C175 DATA MANAGEMENT FOUNDATIONS OA FINAL
EXAM 2024/2025 QUESTIONS AND VERIFIED CORRECT
ANSWERS/ ALREADY GRADED A++
ad hoc query - ANSWER A "spur-of-the-moment" question
analytical database - ANSWER A database focused primarily on storing
historical data and business metrics used for tactical or strategic decision
making
availability - ANSWER In the context of data security, it refers to the
accessibility of data whenever required by authorized users and for
authorized purposes
centralized database - ANSWER A database located at a single site
cloud database - ANSWER A database that is created and maintained
using cloud services, such as Microsoft Azure or Amazon AWS
data - ANSWER Raw facts, or facts that have not yet been processed to
reveal their meaning to the end user
data anomaly - ANSWER An abnormality of the data in which inconsistent
changes have been made to a database (For example, an employee
moves, but the address changes is not corrected in all files in the database)
data dependence - ANSWER A data condition in which data representation
and manipulation are dependent on the physical data storage
characteristics
data dictionary - ANSWER A DBMS component that stores metadata.
Contains the data definition, as well as their characteristics and
relationships
data inconsistency - ANSWER A condition in which different versions of the
same data yield different results
data independence - ANSWER A condition in which data access is
unaffected by changes in the physical data storage characteristics
,data integrity - ANSWER In a relational database, a condition in which the
data in the database complies with all entity and referential integrity
constraints
data management - ANSWER A process that focuses on data collection,
storage, and retrieval.
data processing (DP) specialist - ANSWER The person responsible for
developing and managing a computerized file processing system
data redundancy - ANSWER Exists when the same data is stored
unnecessarily at different places
database - ANSWER A shared, integrated computer structure that houses
a collection of related data including end-user data (raw facts) and
metadata (data about the data)
database design - ANSWER The process that yields the description of the
database structure and determines the database components. The second
phase of the database life cycle
database management system (DBMS) - ANSWER The collection of
programs that manages the database structure and controls access to the
data stored in the database
database system - ANSWER An organization of components that defines
and regulates the collection, storage, management, and use of data in a
database environment
desktop database - ANSWER A single-user database that runs on a
personal computer
discipline-specific database - ANSWER A database that contains data
focused on specific subject areas
enterprise database - ANSWER The overall company data representation,
which provides support for present and expected future needs
,field - ANSWER An alphabetic or numeric character or group of characters
that defines a characteristic of a person, place, or thing. (for example, a
person's SSN, address, phone number, and bank balance all constitute
fields)
file - ANSWER A named collection of related records
general-purpose database - ANSWER A database that contains a wide
variety of data used in multiple disciplines
hub - ANSWER A warehouse of data packets housed in a central location
on a local area network. It contains multiple ports that copy the data in the
data packets to make it accessible to selected or all segments of the
network
information - ANSWER The result of processing raw data to reveal its
meaning. It consists of transformed data and facilitates decision making
islands of information - ANSWER In the old file system environment, pools
of independent, often duplicated, and inconsistent data created and
managed by different departments
knowledge - ANSWER The body of information and facts about a specific
subject. It implies familiarity, awareness, and understanding of information
as it applies to an environment
logical data format - ANSWER The way a person views data within the
context of a problem domain
metadata - ANSWER Data about data
multiuser database - ANSWER A database that supports multiple
concurrent users
NoSQL - ANSWER A new generation of database management systems
that is not based on the traditional relational database model. It stores
structured and unstructured data in efficient ways.
online analytical processing (OLAP) - ANSWER Decision support system
(DSS) tools that use multidimensional data analysis techniques. It creates
, an advanced data analysis environment that supports decision making,
business modeling, and operations research
operational database - ANSWER A database designed primarily to support
a company's day-to-day operations. (Also known as a transactional
database, OLTP database, or production database)
performance tuning - ANSWER Activities that make a database perform
more efficiently in terms of storage and access speed
physical data format - ANSWER The way a computer "sees" (stores) data
query - ANSWER A question or task asked by an end user of a database in
the form of SQL code. A specific request for data manipulation issued by
the end user or the application to the DBMS
query language - ANSWER A nonprocedural language that is used by a
DBMS to manipulate its data (such as SQL)
query result set - ANSWER The collection of data rows returned by a query
record - ANSWER A collection of related (logically connected) fields
role - ANSWER In Oracle, a named collection of database access
privileges that authorize a user to connect to a database and use its system
resources
router - ANSWER 1) An intelligent devise used to connect dissimilar
networks
2) Hardware/software equipment that connects multiple and diverse
networks
semistructured data - ANSWER Data that has already been processed to
some extent
single-user database - ANSWER A database that supports only one user at
a time
social media - ANSWER Web and mobile technologies that enable
"anywhere, anytime, always on" human interactions
EXAM 2024/2025 QUESTIONS AND VERIFIED CORRECT
ANSWERS/ ALREADY GRADED A++
ad hoc query - ANSWER A "spur-of-the-moment" question
analytical database - ANSWER A database focused primarily on storing
historical data and business metrics used for tactical or strategic decision
making
availability - ANSWER In the context of data security, it refers to the
accessibility of data whenever required by authorized users and for
authorized purposes
centralized database - ANSWER A database located at a single site
cloud database - ANSWER A database that is created and maintained
using cloud services, such as Microsoft Azure or Amazon AWS
data - ANSWER Raw facts, or facts that have not yet been processed to
reveal their meaning to the end user
data anomaly - ANSWER An abnormality of the data in which inconsistent
changes have been made to a database (For example, an employee
moves, but the address changes is not corrected in all files in the database)
data dependence - ANSWER A data condition in which data representation
and manipulation are dependent on the physical data storage
characteristics
data dictionary - ANSWER A DBMS component that stores metadata.
Contains the data definition, as well as their characteristics and
relationships
data inconsistency - ANSWER A condition in which different versions of the
same data yield different results
data independence - ANSWER A condition in which data access is
unaffected by changes in the physical data storage characteristics
,data integrity - ANSWER In a relational database, a condition in which the
data in the database complies with all entity and referential integrity
constraints
data management - ANSWER A process that focuses on data collection,
storage, and retrieval.
data processing (DP) specialist - ANSWER The person responsible for
developing and managing a computerized file processing system
data redundancy - ANSWER Exists when the same data is stored
unnecessarily at different places
database - ANSWER A shared, integrated computer structure that houses
a collection of related data including end-user data (raw facts) and
metadata (data about the data)
database design - ANSWER The process that yields the description of the
database structure and determines the database components. The second
phase of the database life cycle
database management system (DBMS) - ANSWER The collection of
programs that manages the database structure and controls access to the
data stored in the database
database system - ANSWER An organization of components that defines
and regulates the collection, storage, management, and use of data in a
database environment
desktop database - ANSWER A single-user database that runs on a
personal computer
discipline-specific database - ANSWER A database that contains data
focused on specific subject areas
enterprise database - ANSWER The overall company data representation,
which provides support for present and expected future needs
,field - ANSWER An alphabetic or numeric character or group of characters
that defines a characteristic of a person, place, or thing. (for example, a
person's SSN, address, phone number, and bank balance all constitute
fields)
file - ANSWER A named collection of related records
general-purpose database - ANSWER A database that contains a wide
variety of data used in multiple disciplines
hub - ANSWER A warehouse of data packets housed in a central location
on a local area network. It contains multiple ports that copy the data in the
data packets to make it accessible to selected or all segments of the
network
information - ANSWER The result of processing raw data to reveal its
meaning. It consists of transformed data and facilitates decision making
islands of information - ANSWER In the old file system environment, pools
of independent, often duplicated, and inconsistent data created and
managed by different departments
knowledge - ANSWER The body of information and facts about a specific
subject. It implies familiarity, awareness, and understanding of information
as it applies to an environment
logical data format - ANSWER The way a person views data within the
context of a problem domain
metadata - ANSWER Data about data
multiuser database - ANSWER A database that supports multiple
concurrent users
NoSQL - ANSWER A new generation of database management systems
that is not based on the traditional relational database model. It stores
structured and unstructured data in efficient ways.
online analytical processing (OLAP) - ANSWER Decision support system
(DSS) tools that use multidimensional data analysis techniques. It creates
, an advanced data analysis environment that supports decision making,
business modeling, and operations research
operational database - ANSWER A database designed primarily to support
a company's day-to-day operations. (Also known as a transactional
database, OLTP database, or production database)
performance tuning - ANSWER Activities that make a database perform
more efficiently in terms of storage and access speed
physical data format - ANSWER The way a computer "sees" (stores) data
query - ANSWER A question or task asked by an end user of a database in
the form of SQL code. A specific request for data manipulation issued by
the end user or the application to the DBMS
query language - ANSWER A nonprocedural language that is used by a
DBMS to manipulate its data (such as SQL)
query result set - ANSWER The collection of data rows returned by a query
record - ANSWER A collection of related (logically connected) fields
role - ANSWER In Oracle, a named collection of database access
privileges that authorize a user to connect to a database and use its system
resources
router - ANSWER 1) An intelligent devise used to connect dissimilar
networks
2) Hardware/software equipment that connects multiple and diverse
networks
semistructured data - ANSWER Data that has already been processed to
some extent
single-user database - ANSWER A database that supports only one user at
a time
social media - ANSWER Web and mobile technologies that enable
"anywhere, anytime, always on" human interactions
