DATA MANAGEMENT - FOUNDATION – D426 WGU EXAM WITH QUESTIONS AND
CORRECT VERIFIED ANSWERS GRADED A+ GUARANTEED 100% PASS
file structure - (answer)the format that data is arranged and stored in a file.
flat files - (answer)Files having no internal hierarchy
heap files - (answer)Files containing an unsorted set of records that are uniquely identified by a record
id which allows them to be inserted or deleted using that id.
index files - (answer)Files containing an unsorted set of records that are uniquely identified by a record
id which allows them to be inserted or deleted using that id.
hashed files - (answer)Files which use a hash function to decide where a record should be placed on a
disk. This allows for faster data lookup without the use of an index file.
data - (answer)Raw facts, or facts that have not yet been processed to reveal their meaning to the end
user.
information - (answer)The result of processing raw data to reveal its meaning. Information consists of
transformed data and facilitates decision making.
knowledge - (answer)The body of information and facts about a specific subject. A key characteristic is
that new knowledge can be derived from old knowledge.
database management - (answer)A process that focuses on data collection, storage, and retrieval.
Common data management functions include addition, deletion, modification, and listing.
database - (answer)A shared, integrated computer structure that houses a collection of related data. A
database contains two types of data: end-user data (raw facts) and metadata.
DBMS - (answer)The collection of programs that manages the database structure and controls access to
the data stored in the database.
,DATA MANAGEMENT - FOUNDATION – D426 WGU EXAM WITH QUESTIONS AND
CORRECT VERIFIED ANSWERS GRADED A+ GUARANTEED 100% PASS
data inconsistency - (answer)A condition in which different versions of the same data yield different
(inconsistent) results.
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.
ad hoc query - (answer)A "spur-of-the-moment" question.
query results set - (answer)The collection of data rows returned by a query.
data quality - (answer)A comprehensive approach to ensuring the accuracy, validity, and timeliness of
data.
DBMS advantages (7) - (answer)- improved data sharing
- improved data security
- better data integration
- minimized data inconsistency
- improved data access
- improved decision making
- increased end-user productivity
single vs multiuser database - (answer)supports single or multiple users
desktop database - (answer)A single-user database that runs on a personal computer.
workgroup database - (answer)A multiuser database that usually supports fewer than 50 users or is used
for a specific department in an organization.
, DATA MANAGEMENT - FOUNDATION – D426 WGU EXAM WITH QUESTIONS AND
CORRECT VERIFIED ANSWERS GRADED A+ GUARANTEED 100% PASS
enterprise database - (answer)The overall company data representation, which provides support for
present and expected future needs.
centralized vs distributed database - (answer)- A database located at a single site.
- A logically related database that is stored in two or more physically independent sites.
cloud database - (answer)A database that is created and maintained using cloud services, such as
Microsoft Azure or Amazon AWS.
general purpose vs discipline specific database - (answer)- variety of data used in multiple disciplines.
- data focused on specific subject areas.
OLTP database - (answer)online transaction processing
AKA operational database
AKA transactional database
AKA production database
A database designed primarily to support a company's day-to-day operations
analytical database - (answer)A database focused primarily on storing historical data and business
metrics used for tactical or strategic decision making.
data warehouse - (answer)A specialized database that stores historical and aggregated data in a format
optimized for decision support
OLAP - (answer)online analytical processing
A set of tools that provide advanced data analysis for retrieving, processing, and modeling data from the
data warehouse.
CORRECT VERIFIED ANSWERS GRADED A+ GUARANTEED 100% PASS
file structure - (answer)the format that data is arranged and stored in a file.
flat files - (answer)Files having no internal hierarchy
heap files - (answer)Files containing an unsorted set of records that are uniquely identified by a record
id which allows them to be inserted or deleted using that id.
index files - (answer)Files containing an unsorted set of records that are uniquely identified by a record
id which allows them to be inserted or deleted using that id.
hashed files - (answer)Files which use a hash function to decide where a record should be placed on a
disk. This allows for faster data lookup without the use of an index file.
data - (answer)Raw facts, or facts that have not yet been processed to reveal their meaning to the end
user.
information - (answer)The result of processing raw data to reveal its meaning. Information consists of
transformed data and facilitates decision making.
knowledge - (answer)The body of information and facts about a specific subject. A key characteristic is
that new knowledge can be derived from old knowledge.
database management - (answer)A process that focuses on data collection, storage, and retrieval.
Common data management functions include addition, deletion, modification, and listing.
database - (answer)A shared, integrated computer structure that houses a collection of related data. A
database contains two types of data: end-user data (raw facts) and metadata.
DBMS - (answer)The collection of programs that manages the database structure and controls access to
the data stored in the database.
,DATA MANAGEMENT - FOUNDATION – D426 WGU EXAM WITH QUESTIONS AND
CORRECT VERIFIED ANSWERS GRADED A+ GUARANTEED 100% PASS
data inconsistency - (answer)A condition in which different versions of the same data yield different
(inconsistent) results.
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.
ad hoc query - (answer)A "spur-of-the-moment" question.
query results set - (answer)The collection of data rows returned by a query.
data quality - (answer)A comprehensive approach to ensuring the accuracy, validity, and timeliness of
data.
DBMS advantages (7) - (answer)- improved data sharing
- improved data security
- better data integration
- minimized data inconsistency
- improved data access
- improved decision making
- increased end-user productivity
single vs multiuser database - (answer)supports single or multiple users
desktop database - (answer)A single-user database that runs on a personal computer.
workgroup database - (answer)A multiuser database that usually supports fewer than 50 users or is used
for a specific department in an organization.
, DATA MANAGEMENT - FOUNDATION – D426 WGU EXAM WITH QUESTIONS AND
CORRECT VERIFIED ANSWERS GRADED A+ GUARANTEED 100% PASS
enterprise database - (answer)The overall company data representation, which provides support for
present and expected future needs.
centralized vs distributed database - (answer)- A database located at a single site.
- A logically related database that is stored in two or more physically independent sites.
cloud database - (answer)A database that is created and maintained using cloud services, such as
Microsoft Azure or Amazon AWS.
general purpose vs discipline specific database - (answer)- variety of data used in multiple disciplines.
- data focused on specific subject areas.
OLTP database - (answer)online transaction processing
AKA operational database
AKA transactional database
AKA production database
A database designed primarily to support a company's day-to-day operations
analytical database - (answer)A database focused primarily on storing historical data and business
metrics used for tactical or strategic decision making.
data warehouse - (answer)A specialized database that stores historical and aggregated data in a format
optimized for decision support
OLAP - (answer)online analytical processing
A set of tools that provide advanced data analysis for retrieving, processing, and modeling data from the
data warehouse.
