WGU D322 Intro to IT Practice Test B 68 Questions with
Verified Answers
What is a primary difference between a modern handheld computer and a
modern desktop computer? - CORRECT ANSWER C. A desktop has more
processing power.
There are how many tiers of ISPs? - CORRECT ANSWER C. Three
The selection operation takes rows from one table and creates a new table? -
CORRECT ANSWER A. True
Which classification for documents is used when the unauthorized disclosure,
alteration, or destruction of data would result in little or no risk? - CORRECT
ANSWER A. Public
A monitor is a peripheral device for what system? - CORRECT ANSWER A. I/O
What two types of software licenses are free? - CORRECT ANSWER C. Freeware
and Open source
A petabytes consists of how many terabytes? - CORRECT ANSWER 1000
Which factors should Mike NOT consider when choosing a file organization
system? - CORRECT ANSWER Hierarchy
Which of the following statements describes why network protocols are
necessary. - CORRECT ANSWER Network protocols are necessary for computers to
communicate with each other.
Which of the following describes the knowledge stage in the DIKW model? -
CORRECT ANSWER A management decision on how many people to hire after
observing current employee levels and upcoming marketing promotions.
, _____________ are system development methodologies that propose
incremental implementations, respond to rapidly changing requirements, and
reduce the emphasis on rigorous requirements. - CORRECT ANSWER Agile
methods
Which device receives a message, examines its destination IP address, and sends
the message on to the next location in the network (could also be called a
gateway)? - CORRECT ANSWER Router
What is one probable advantage of outsourcing? - CORRECT ANSWER Reliance
can be placed on the expertise of outsourcing vendors.
Which statement is NOT true of compilers and interpreters? - CORRECT ANSWER
Compilers do not translate source code into machine code.
SQL (Structured Query Language), a query for databases, was invented by? -
CORRECT ANSWER IBM
What does GUI stand for? - CORRECT ANSWER Graphical User Interface
Read the following scenario, and then select the job title that most accurately
depicts the descriptions.
Javier starts the day by checking his e-mails. Sandra in payroll would like him to
print a report detailing how much money has been spent on training new
employees. She would like a comparison of the training dollars spent over the last
five years. Javier spends the morning retrieving the appropriate information from
the database and e-mails a report to Sandra. In the afternoon, Javier begins a
performance analysis of the new database management system that he installed
last week. He also double-checks that the old data has properly transferred to the
new system. He then develops a list of procedures for those who work under him
so they can also run performance analyses. Finally, he heads upstairs to the Chief
Operating Officer's office to make a brief presentation on the new database
system and how it can be us - CORRECT ANSWER Database administrator
Which statement describes the role of a systems administrator? - CORRECT
ANSWER Systems administrators are responsible for supporting, monitoring, and
maintaining workplace technology and end users.
Verified Answers
What is a primary difference between a modern handheld computer and a
modern desktop computer? - CORRECT ANSWER C. A desktop has more
processing power.
There are how many tiers of ISPs? - CORRECT ANSWER C. Three
The selection operation takes rows from one table and creates a new table? -
CORRECT ANSWER A. True
Which classification for documents is used when the unauthorized disclosure,
alteration, or destruction of data would result in little or no risk? - CORRECT
ANSWER A. Public
A monitor is a peripheral device for what system? - CORRECT ANSWER A. I/O
What two types of software licenses are free? - CORRECT ANSWER C. Freeware
and Open source
A petabytes consists of how many terabytes? - CORRECT ANSWER 1000
Which factors should Mike NOT consider when choosing a file organization
system? - CORRECT ANSWER Hierarchy
Which of the following statements describes why network protocols are
necessary. - CORRECT ANSWER Network protocols are necessary for computers to
communicate with each other.
Which of the following describes the knowledge stage in the DIKW model? -
CORRECT ANSWER A management decision on how many people to hire after
observing current employee levels and upcoming marketing promotions.
, _____________ are system development methodologies that propose
incremental implementations, respond to rapidly changing requirements, and
reduce the emphasis on rigorous requirements. - CORRECT ANSWER Agile
methods
Which device receives a message, examines its destination IP address, and sends
the message on to the next location in the network (could also be called a
gateway)? - CORRECT ANSWER Router
What is one probable advantage of outsourcing? - CORRECT ANSWER Reliance
can be placed on the expertise of outsourcing vendors.
Which statement is NOT true of compilers and interpreters? - CORRECT ANSWER
Compilers do not translate source code into machine code.
SQL (Structured Query Language), a query for databases, was invented by? -
CORRECT ANSWER IBM
What does GUI stand for? - CORRECT ANSWER Graphical User Interface
Read the following scenario, and then select the job title that most accurately
depicts the descriptions.
Javier starts the day by checking his e-mails. Sandra in payroll would like him to
print a report detailing how much money has been spent on training new
employees. She would like a comparison of the training dollars spent over the last
five years. Javier spends the morning retrieving the appropriate information from
the database and e-mails a report to Sandra. In the afternoon, Javier begins a
performance analysis of the new database management system that he installed
last week. He also double-checks that the old data has properly transferred to the
new system. He then develops a list of procedures for those who work under him
so they can also run performance analyses. Finally, he heads upstairs to the Chief
Operating Officer's office to make a brief presentation on the new database
system and how it can be us - CORRECT ANSWER Database administrator
Which statement describes the role of a systems administrator? - CORRECT
ANSWER Systems administrators are responsible for supporting, monitoring, and
maintaining workplace technology and end users.
