WGU D075 Information Technology Management
Pre-Assessment (Answered) Complete Solution
Pre-Assessment_U_2
What is the purpose of a universal serial bus (USB) on a laptop or desktop
computer?
Pre-Assessment_U_2
It allows the computer to connect peripheral devices.
Which part of a computer executes the computations required by the software?
The central processing unit
Which category of software includes programs such as word processors and PDF
document readers?
Application software
What is the major function of a computer operating system?
Computer resource management
Within a productivity suite, which method of selecting static data from one
application and copying it to another application requires the use of temporary
memory?
Cut and paste
Which type of device is an ethernet card?
Network interface controller (NIC)
What is the purpose of a MAC address?
To uniquely identify a computer on a network
Which topology implements a network where if the central hub fails, all nodes
attached to the hub will also fail?
A star topology
A local drafting firm has a secured local area network that uses Ethernet cables
to connect to client computers.
After ensuring that the computer is connected to the network, what must a user
provide to in order to be authenticated?
A password
Many websites keep track of a user's actions and information. They store much of
this information on the user's computer in a private folder on the hard drive.
What are these very small files called?
Tracking cookies
A discussion board facilitates communication between geographically dispersed
group members.
What is the correct term to describe an initial post and its subsequent
comments?
A thread
, How does a Gantt chart facilitate project management?
It identifies and sequences the tasks of a project.
A business organization can increase collaboration if it has a database of its
internal reports, articles, documents, policies, and decisions.
Which tool helps manage this type of information?
A knowledge management system
On a day-to-day basis, what is the major focus and responsibility of a chief
technology officer?
Managing the IT group and designing the IT architecture
What is the title of the person within an IT department whose responsibility is to
set policies for passwords, create rules for backup and recovery, and facilitate
the protection of the data center and computers with the data and information?
Chief information security officer
What is the title of the person in the organization who is directly responsible for
the setup and operation of the organization's networks, including hardware and
software?
Network administrator
Pre-Assessment_U_3
What is the distinguishing feature that differentiates data from information?
Pre-Assessment_U_3
Data that have been given context become information.
What is the purpose of a dashboard in business intelligence (BI) software?
It is a visual presentation of graphs, charts, and diagrams.
What is the standard programming language that is used to extract and update
data in most relational databases?
Structured Query Language (SQL)
When using extract, transform, and load (ETL), what is done during the
"transform" step?
The data are normalized and structured.
When a company spends money on data management, it uses a metric to
measure the benefit of this spending relative to the cost.
What is this metric called?
Return on investment
One perpetual issue with corporate data is ensuring the data are accurate and
valid. Procedures that apply to end users, managers, and IT personnel are often
put in place to ensure good data.
What is the term that describes this effort?
Data governance
What is the purpose of the primary key in a database?
It uniquely identifies the records in a specific table.
What is the purpose of a foreign key in a database?
Pre-Assessment (Answered) Complete Solution
Pre-Assessment_U_2
What is the purpose of a universal serial bus (USB) on a laptop or desktop
computer?
Pre-Assessment_U_2
It allows the computer to connect peripheral devices.
Which part of a computer executes the computations required by the software?
The central processing unit
Which category of software includes programs such as word processors and PDF
document readers?
Application software
What is the major function of a computer operating system?
Computer resource management
Within a productivity suite, which method of selecting static data from one
application and copying it to another application requires the use of temporary
memory?
Cut and paste
Which type of device is an ethernet card?
Network interface controller (NIC)
What is the purpose of a MAC address?
To uniquely identify a computer on a network
Which topology implements a network where if the central hub fails, all nodes
attached to the hub will also fail?
A star topology
A local drafting firm has a secured local area network that uses Ethernet cables
to connect to client computers.
After ensuring that the computer is connected to the network, what must a user
provide to in order to be authenticated?
A password
Many websites keep track of a user's actions and information. They store much of
this information on the user's computer in a private folder on the hard drive.
What are these very small files called?
Tracking cookies
A discussion board facilitates communication between geographically dispersed
group members.
What is the correct term to describe an initial post and its subsequent
comments?
A thread
, How does a Gantt chart facilitate project management?
It identifies and sequences the tasks of a project.
A business organization can increase collaboration if it has a database of its
internal reports, articles, documents, policies, and decisions.
Which tool helps manage this type of information?
A knowledge management system
On a day-to-day basis, what is the major focus and responsibility of a chief
technology officer?
Managing the IT group and designing the IT architecture
What is the title of the person within an IT department whose responsibility is to
set policies for passwords, create rules for backup and recovery, and facilitate
the protection of the data center and computers with the data and information?
Chief information security officer
What is the title of the person in the organization who is directly responsible for
the setup and operation of the organization's networks, including hardware and
software?
Network administrator
Pre-Assessment_U_3
What is the distinguishing feature that differentiates data from information?
Pre-Assessment_U_3
Data that have been given context become information.
What is the purpose of a dashboard in business intelligence (BI) software?
It is a visual presentation of graphs, charts, and diagrams.
What is the standard programming language that is used to extract and update
data in most relational databases?
Structured Query Language (SQL)
When using extract, transform, and load (ETL), what is done during the
"transform" step?
The data are normalized and structured.
When a company spends money on data management, it uses a metric to
measure the benefit of this spending relative to the cost.
What is this metric called?
Return on investment
One perpetual issue with corporate data is ensuring the data are accurate and
valid. Procedures that apply to end users, managers, and IT personnel are often
put in place to ensure good data.
What is the term that describes this effort?
Data governance
What is the purpose of the primary key in a database?
It uniquely identifies the records in a specific table.
What is the purpose of a foreign key in a database?
