WGU C724 (Information Systems
Management) Questions with Correct
Answers Passed on First Attempt
|Latest Update with Complete Solution
1. relational database - ANSWER type of database in which multiple
information files are combined into one database in one location, where data
are stored in two-dimensional tables known as relations and contain multiple
entities and attributes
2. Object-Oriented Database - ANSWER A database that is designed to store
mixed media, as opposed to tables in relational databases.
3. Conceptual Data Model - ANSWER a map of concepts and their
relationships used for databases.
4. Logical Data Model - ANSWER Provides foundation for designing a
database
5. Physical Data Model - ANSWER a representation of a data design as
implemented, or intended to be implemented, in a database management
system
,6. Pointers - ANSWER Used to show the relationship between data fields and
tables.
7. Referential Integrity - ANSWER Table relationships must always be
consistent; for an entity or object to exist in a table, an equal value must
exist in the referenced table; the primary and foreign keys must be equal.
8. Types of relationships in a relational database model - ANSWER One-to-
One, One-to-Many, and Many-to-Many
9. Data Manipulation Language - ANSWER A language that allows users to
easily modify the data in a database.
10.Data Warehousing - ANSWER a system used for reporting and data
analysis, and is considered a core component of business intelligence; data is
stored in one place.
11.data mart - ANSWER smaller subset database from a data warehouse
typically focused on a single area or function.
12.Extraction, transformation, and loading (ETL) - ANSWER a process in
which data is extracted from a computer, transformed (or cleansed) into a
format appropriate for the data warehouse, and then transferred to the data
warehouse.
13.Direct Move - ANSWER Data that does not need to be transformed being
transferred to a data warehouse.
,14.Data mining - ANSWER process of identifying hidden patterns and
relationships in structured databases and applying rules to that data in order
to predict future behavior.
15.Web Mining - ANSWER process of identifying hidden patterns and
relationships in non-structured databases, such as the Internet, and applying
rules to that data in order to predict future behavior.
16.Text mining - ANSWER High-quality information is typically derived
through the devising of patterns and trends through means such as statistical
pattern learning.
17.Partitioning - ANSWER Dividing a database into more manageable
segments.
18.Master Data - ANSWER Objects shared across the enterprise; it is key to
accurate business reporting and analysis
19.Data Governance - ANSWER Concerned with the management of data,
including maximizing quality through effective utilization, availability, and
protection.
20.Entity-Relationship Diagram (ERD) - ANSWER Illustrates the relationships
among all of the tables in a database.
21.Database Administrator - ANSWER Responsible for the creation and
management of the entire database management system (DBMS).
, 22.Data Administrator - ANSWER Responsible for determining and
monitoring employees' access to the company's database management
system (DBMS).
23.Information Policy Administrator - ANSWER Responsible for acquiring,
organizing, and distributing organizational information internally.
24.Data Dictionary - ANSWER Stores and manages all of the information
about the database, or the metadata.
25.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).
26.Health Analytics Tools - ANSWER through smartphone sensors or
wearable peripheral devices. Data from these devices is collected, analyzed,
and used to help a user to understand, improve, and maintain, or
automatically report, their health to their health professionals.
27.Geographic Information Systems (GIS) - ANSWER Using connections to
numerous databases containing data concerning locations, crimes, taxes,
traffic, votes, and environmental and life science data, geospatial analysis
can help government administrators to understand demographic trends,
population density changes, attribute concentrations
28.wide area network (WAN) - ANSWER connection b/w small networks that
create a large network that typically connects business campuses consisting
of computer systems across large distances
Management) Questions with Correct
Answers Passed on First Attempt
|Latest Update with Complete Solution
1. relational database - ANSWER type of database in which multiple
information files are combined into one database in one location, where data
are stored in two-dimensional tables known as relations and contain multiple
entities and attributes
2. Object-Oriented Database - ANSWER A database that is designed to store
mixed media, as opposed to tables in relational databases.
3. Conceptual Data Model - ANSWER a map of concepts and their
relationships used for databases.
4. Logical Data Model - ANSWER Provides foundation for designing a
database
5. Physical Data Model - ANSWER a representation of a data design as
implemented, or intended to be implemented, in a database management
system
,6. Pointers - ANSWER Used to show the relationship between data fields and
tables.
7. Referential Integrity - ANSWER Table relationships must always be
consistent; for an entity or object to exist in a table, an equal value must
exist in the referenced table; the primary and foreign keys must be equal.
8. Types of relationships in a relational database model - ANSWER One-to-
One, One-to-Many, and Many-to-Many
9. Data Manipulation Language - ANSWER A language that allows users to
easily modify the data in a database.
10.Data Warehousing - ANSWER a system used for reporting and data
analysis, and is considered a core component of business intelligence; data is
stored in one place.
11.data mart - ANSWER smaller subset database from a data warehouse
typically focused on a single area or function.
12.Extraction, transformation, and loading (ETL) - ANSWER a process in
which data is extracted from a computer, transformed (or cleansed) into a
format appropriate for the data warehouse, and then transferred to the data
warehouse.
13.Direct Move - ANSWER Data that does not need to be transformed being
transferred to a data warehouse.
,14.Data mining - ANSWER process of identifying hidden patterns and
relationships in structured databases and applying rules to that data in order
to predict future behavior.
15.Web Mining - ANSWER process of identifying hidden patterns and
relationships in non-structured databases, such as the Internet, and applying
rules to that data in order to predict future behavior.
16.Text mining - ANSWER High-quality information is typically derived
through the devising of patterns and trends through means such as statistical
pattern learning.
17.Partitioning - ANSWER Dividing a database into more manageable
segments.
18.Master Data - ANSWER Objects shared across the enterprise; it is key to
accurate business reporting and analysis
19.Data Governance - ANSWER Concerned with the management of data,
including maximizing quality through effective utilization, availability, and
protection.
20.Entity-Relationship Diagram (ERD) - ANSWER Illustrates the relationships
among all of the tables in a database.
21.Database Administrator - ANSWER Responsible for the creation and
management of the entire database management system (DBMS).
, 22.Data Administrator - ANSWER Responsible for determining and
monitoring employees' access to the company's database management
system (DBMS).
23.Information Policy Administrator - ANSWER Responsible for acquiring,
organizing, and distributing organizational information internally.
24.Data Dictionary - ANSWER Stores and manages all of the information
about the database, or the metadata.
25.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).
26.Health Analytics Tools - ANSWER through smartphone sensors or
wearable peripheral devices. Data from these devices is collected, analyzed,
and used to help a user to understand, improve, and maintain, or
automatically report, their health to their health professionals.
27.Geographic Information Systems (GIS) - ANSWER Using connections to
numerous databases containing data concerning locations, crimes, taxes,
traffic, votes, and environmental and life science data, geospatial analysis
can help government administrators to understand demographic trends,
population density changes, attribute concentrations
28.wide area network (WAN) - ANSWER connection b/w small networks that
create a large network that typically connects business campuses consisting
of computer systems across large distances
