C724 WGU INFORMATION SYSTEMS MANAGEMENT TEST
PAPER QUESTIONS AND ANSWERS GRADED A++
✔✔There are five rules that pertain to the relational database model. Which one of the
following examples breaks one of the rules? - ✔✔The primary key of the orders table is
the video title.
✔✔The decision to implement a relational database system depends mostly on two
factors. The first factor to consider is the ______________. - ✔✔data
✔✔The second factor to consider when implementing a relational database
is______________. - ✔✔users
✔✔Relational database models were first developed in the 1970s. It has become the
most widely used database model in business. Which one of the following traits is NOT
one of the benefits leading to widespread use of relational database? - ✔✔tree-like
structure
✔✔relational databases are so widely used because - ✔✔they allow the use of
transactions
✔✔Consumers use data warehouses everyday, many times without even knowing it.
Facebook is an example of a data warehouse that most consumers use on a daily
basis. Which of the following best defines a data warehouse? - ✔✔A data warehouse is
a collection of business data from multiple systems used for data analysis and mining.
✔✔What is the process to update or backup a data warehouse? - ✔✔Extract,
Transform, Load (ETL)
✔✔Which term describes the procedure in ETL (extract, transform, and load) that
correlates the data with the data warehouse format? - ✔✔Consolidation Algorithm
✔✔Why does the ETL process run in parallel and not in sequential order? - ✔✔The ETL
process to update a data warehouse runs in parallel because the extraction step is
lengthy.
✔✔What is a required process in implementing and maintaining a data warehouse? -
✔✔partitioning
✔✔It is critical to build a data integrity check algorithm to ensure the quality of data in a
database before the Hint, displayed below
___________
phase in the ETL process. - ✔✔Load
, ✔✔d - ✔✔
✔✔Relational database-as-a-service lets you quickly create, extend, and scale
relational applications into the cloud. What cloud-based version of a relational database
management system deals with both structured and unstructured data? - ✔✔Microsoft
SQL Azure
✔✔Specific databases are used for organizing and indexing social media messages
and emails. Which item below contains information collected from the Internet? -
✔✔Textual Databases
✔✔Insurance companies have a variety of tools for analyzing data. Which tool is used
to analyze big data to find a niche target for their insurance products? - ✔✔Customer
Relationship Management
✔✔SCM stands for ________ - ✔✔Supply Chain Management
✔✔The energy management system (EMS) transforms energy data into information so
businesses can understand energy consumption and patterns. What does EMS do? -
✔✔Technically, the EMS does not manage energy usage; it identifies ways that users
can optimally manage the usage of energy.
✔✔Which of the following best describes a computer network? - ✔✔A computer
network is a data communications system that uses cable or wireless media to transmit
and receive signals.
✔✔What does TCP/IP stand for? - ✔✔Transmission Control Protocol/Internet Protocol
✔✔A network protocol designed to handle broadband integrated services such as voice
and video is - ✔✔ATM (Asynchronous Transfer Mode)
✔✔What is a network host? This is also known as data terminal equipment in computer
networking hardware. - ✔✔A network host is a physical node with an IP address.
✔✔What information is enclosed in transmission packets? Select the most accurate
statement. - ✔✔Data packets include destination address, relay information, and error
detection.
✔✔True or False. Data packet switching is more efficient than circuit switching because
it leverages the entire computer network capacity. - ✔✔True
PAPER QUESTIONS AND ANSWERS GRADED A++
✔✔There are five rules that pertain to the relational database model. Which one of the
following examples breaks one of the rules? - ✔✔The primary key of the orders table is
the video title.
✔✔The decision to implement a relational database system depends mostly on two
factors. The first factor to consider is the ______________. - ✔✔data
✔✔The second factor to consider when implementing a relational database
is______________. - ✔✔users
✔✔Relational database models were first developed in the 1970s. It has become the
most widely used database model in business. Which one of the following traits is NOT
one of the benefits leading to widespread use of relational database? - ✔✔tree-like
structure
✔✔relational databases are so widely used because - ✔✔they allow the use of
transactions
✔✔Consumers use data warehouses everyday, many times without even knowing it.
Facebook is an example of a data warehouse that most consumers use on a daily
basis. Which of the following best defines a data warehouse? - ✔✔A data warehouse is
a collection of business data from multiple systems used for data analysis and mining.
✔✔What is the process to update or backup a data warehouse? - ✔✔Extract,
Transform, Load (ETL)
✔✔Which term describes the procedure in ETL (extract, transform, and load) that
correlates the data with the data warehouse format? - ✔✔Consolidation Algorithm
✔✔Why does the ETL process run in parallel and not in sequential order? - ✔✔The ETL
process to update a data warehouse runs in parallel because the extraction step is
lengthy.
✔✔What is a required process in implementing and maintaining a data warehouse? -
✔✔partitioning
✔✔It is critical to build a data integrity check algorithm to ensure the quality of data in a
database before the Hint, displayed below
___________
phase in the ETL process. - ✔✔Load
, ✔✔d - ✔✔
✔✔Relational database-as-a-service lets you quickly create, extend, and scale
relational applications into the cloud. What cloud-based version of a relational database
management system deals with both structured and unstructured data? - ✔✔Microsoft
SQL Azure
✔✔Specific databases are used for organizing and indexing social media messages
and emails. Which item below contains information collected from the Internet? -
✔✔Textual Databases
✔✔Insurance companies have a variety of tools for analyzing data. Which tool is used
to analyze big data to find a niche target for their insurance products? - ✔✔Customer
Relationship Management
✔✔SCM stands for ________ - ✔✔Supply Chain Management
✔✔The energy management system (EMS) transforms energy data into information so
businesses can understand energy consumption and patterns. What does EMS do? -
✔✔Technically, the EMS does not manage energy usage; it identifies ways that users
can optimally manage the usage of energy.
✔✔Which of the following best describes a computer network? - ✔✔A computer
network is a data communications system that uses cable or wireless media to transmit
and receive signals.
✔✔What does TCP/IP stand for? - ✔✔Transmission Control Protocol/Internet Protocol
✔✔A network protocol designed to handle broadband integrated services such as voice
and video is - ✔✔ATM (Asynchronous Transfer Mode)
✔✔What is a network host? This is also known as data terminal equipment in computer
networking hardware. - ✔✔A network host is a physical node with an IP address.
✔✔What information is enclosed in transmission packets? Select the most accurate
statement. - ✔✔Data packets include destination address, relay information, and error
detection.
✔✔True or False. Data packet switching is more efficient than circuit switching because
it leverages the entire computer network capacity. - ✔✔True
