WGU C182 Practice Tests-questions and answers (2022/2023)
What is the definition of information technology?
It is the technology used to create,
... [Show More] maintain, and make information accessible.
Which IT position has the responsibillity of working with routers and switches?
Network Administrator
In which generation were silicon chips first used in computers?
Third generation
Which low-level language corresponds one to one with assembly?
machine language
What allows an organization to use software through the internet?
Saas or Software as a Service
What is one of IT's role in golobalization?
It allows companies to reach a wider customer base.
Which category of computer has an external flat screen monitor, optical disk drive, and a large capacity hard drive?
Desktop
Which two software application packages would be classified as productivity software?
Spreadsheet program and word processor
Which two computer peripherals are connected to the computer through a port?
External microphone and USB flash drive
Which term is defined as a collection of information used to support management of an organization? Information system
A website logs the timestamp, location, and browser of every visitor. It then aggregates this content into peak traffic times and days,minimum and maximum hits for each country and region, and popularity of certain browsers among visitors. What is the timestamp considered in this scenerio?
Data
A dept. manager is creating a budget estimate for the upcoming year. The manager would like to determine whether the data will be available when the decision for the next year have to be made. Which characteristic of valuable data is the manager considering?
Timely
Which two are parts of an information system?
Databases and Networks.
What is the difference between processing and storage?
Processing collects and translates data into useful information, while storage places the translated data in specific locations.
Which is a benefit of multiple interconnected computers (distributed) versus mainframes or large computers?
Costs for hardware resources are decreased
A software emulator program that permits a computer user to use multiple computers and multiple platforms without the expense of purchasing multiple computers.
Virtual machines
Each computer is roughly equal to every other computer.
Peer-to-peer
One computer will request information from another computer, which responds with requested information. Client-server
Allows the user to control the actions of the software, and through the software, to access hardware. Operating System
Which action by application programs requires support from a networked operating system?
An Internet browser displays a web page.
The chief information officer wants to update the network server to improve Internet access while also blocking certain social media websites. What type of server will meet this need?
Proxy server
Which characteristic identifies application software that is cloud-based?
Provided by third-party providers
What type of software permits free temporary use followed by long-term activation for a fee?
Shareware
What is the purpose of an End User License Agreement for a commercial software package?
Establishes the customer's right to use the software.
What is the difference between proprietary and open-source software license?
Proprietary software has a cost whereas open-source software is free.
What gives the author of a software package the ability to prevent unauthorized duplication for at least 35 years?
A copyright
Which two components are parts of a central processing unit (CPU)?
Control unit (CU), and Arithmetic logic unit (ALU)
An employee needs to edit a contract and prepare a hard copy for the project team. Which two peripheral devices should be used?
Printer and Monitor
Which item is a storage device?
flash drive
What indicates a specific Internet location?
IP address
Which description explains the role of a domain name system (DNS)?
Translates human-readable aliases into IP addresses
Which part of a Uniform Resource Locator (URL) identifies the location of the document on the server? Resource path ID
Which goal of Information Assurance (IA) requires that information is accessible when needed?
Availability
Which technique uses all possible combinations of letters and numbers to crack a password?
Brute force
Which is a type of two-factor authentication?
Smart Card
In which type of network topology is each networked device directly connected to every other networked device?
Mesh
Which communication medium is should be used when sending data transmissions from Singapore to Mexico City?
Radio signals
Which is a characteristic of high-level languages?
The source code has to be complied.
How does a compiler work?
It takes the most recent instructions and translates them into machine language What is true of compiled and interpreted computer language?
A compiler translates an entire program into executable program, which can be run at a later time, while the interpreter does this incrementally.
Which language is often used for rapid prototyping and the creation of GUIs?
TCL
What is true of databases and the applications that interact with them?
Applications are interdependent of the database.
What is another term for a formula that outlines how to execute a task?
Algorithm
Which data type is used to represent product order code that comprises alphanumeric characters? String data
Armando is a freelance graphic designer. He has decided to create a database of the artwork he has done throughout the years. Each of his pieces of art is sorted using an assigned name and number. Which data type will be required in order to create his database?
Character string
Why is it important to ensure that data support business goals?
To aid in making strategic decisions.
In which category of the Data, Information, Knowledge, Wisdom (DIKW) hierarchy would business intelligence be located?
Knowledge
Which field must contain a unique value in order for a relational database table to function? primary key
What are the three main categories of databases?
Flat file, relational, hierarchal
What is the database administrators role in security?
To institute protocols to protect the databases from external threats.
Which part of a Uniform Resource Locator (URL) identifies the location of the document on the server?
...
What type of information processing allows input data to be accepted as a set of
records and processed as a unit?
Batch
What is the role of drivers in facilitating communication between applications and databases?
They allow the application to interact with the database.
Which SQL clause is used to inform the database management system (DBMS) which tables should be interrogated by the query?
FROM
What is the role of the systems administrator?
To install and maintain network resources.
What is the purpose of an IT department?
It helps the organization achieve strategic goals.
Which action would be important for the IT department to take in order to help their business meet the goal of increased expansion?
Expanding the infrasturcture to support additional locations.
What step should be taken by a business when a third-party solution is found that will benefit a project?
Contact the group to arrange a demo of their product.
Which risk assessment question is part of the initiation phase?
Could the end users reject the outcome of the project?
In what phase of a project does time estimation occur?
Planning
What effect does scope creep have on a project?
It increases unplanned costs for the project.
Which system requirement is an example of considering user needs in the design of an information system?
Allowing secure access to customer account information.
Which type of systems testing includes having the customer test the system in an operational setting to see if it is useful?
User Acceptance
Which type of systems conversion involves starting the conversion with a portion of end users?
Pilot
What are two necessary elements of business continutiy planning?
Identifying risks that may occur.
Assessing key organizational activities.
Which action would support confidentiality?
Updating security software.
Which disaster recovery strategy is used to save information to multiple hard drives at the same time? Data mirroring
Which regulation governs the actions of a company in case of data records being compromised, lost, or stolen? Security Breach Notification laws
How can an organization assist employees with the ethical use of information
technology?
By developing policies for information usage.
What is part of the role of an It professional?
Provides professional standards for ethical behavior.
Engages in best practices for information systems
Marcus has a summer job working at a real estate agency. He is entering client addresses into the company's computer system. At which stage of the DIKW hierarchy is Marcus working?
Data
Which software is run automatically rather than by the end user?
System software
Which account is also referred to as root or superuser?
The Administrator Account
Which of the following best describes a hierarchical database format?
Data are modeled using parent-child relationships.
What are the responsibilities of the system administrator?
Providing support to users
Creating new user accounts
Installing new file server hardware and software
Which of the following is an example of a relational database?
A database containing student records with fields such as Student ID, First Name, Last Name, Major, GPA that links to other databases in the University's system.
Which of the following describes the duties of a web administrator?
Duties include maintaining and securing the web server. Also responsible for troubleshooting the web server.
Which of the following statements accurately describe IT certifications?
Earning an IT certificate indicates an IT professional has a thorough background in a specific IT area.
What are important characteristic of an IT professional? Ability to troubleshoot
Desire to continually learn.
Good communication skills - both oral and written
As a new sales manager, Sylvia is studying the historical and current sales report numbers to determine the top three salespersons of the year. At which stage of the DIKW hierarchy is Sylvia working?
Knowledge
What describes the difference between information systems and information technology?
An information system does not have to use computer hardware; whereas information technology requires the use of hardware and software.
What best represents the relevant characteristic of quality data?
The data used applies to the question being answered.
What is/are true of the IPOS cycle?
Once words, numbers or images are entered, a computer processes the data into
useable information that can then be accessed to answer questions or meet specific needs.
What is an accurate definition of a computer system?
A computer system is a collection of hardware and software components that work together to meet the needs of the user.
What is the difference between software and hardware?
Computer software is developed by writing a program using programming language whereas computer hardware is the physical components such as memory modules and disk drives.
What would require the use of a network?
Computers in an office sharing the same printer.
Schools turning in attendance files to the district office.
Gourmet chocolate being sold on the Internet.
Which type of software includes programs such as Microsoft Word and PowerPoint?
Application
What is a program that will allow a computer to easily access the hardware and software of the computer system?
Operating system
__________ software works with hardware to provide a network service Windows Server
What is another term that defines a script?
Interpreted program
In the _______ phase of the SDLC (system development life cycle), architects think about the components that they would need to solve the problem or implement the plan. Design
During _______ users test the system in an operational setting to make sure the system continues to align with business objectives and meet the goals of the stakeholders.
User Acceptance Testing
In this phase of testing the system is given to a segment of end users for testing from their perspective before the final version is released.
Beta
___________ is ephemeral, meaning data stored is lost when the computer is powered off.
RAM
In a SQL query, the __________ operation combines two tables together?
JOIN
__________ uses the concept of reflection of light through a core made up of glass or plastic.
Optical Wire
The _______ includes the protocol, domain, and all subdomains, as well as the resource path ID and name of the document.
URL
This form of cloud computing is offered as a service by some major organizations, such as Amazon and Google, and used extensively by app developers. Its intent is to be able to quickly and reliably develop and deliver applications
PaaS (Platform as a Service)
With ________ an IT department resources (i.e. servers, data storage) are located outside of the organization and are accessible by anyone, anywhere
IaaS (Infrastructure as a Service)
What is the correct order of project phase for Project Management?
Initiation, Planning, Executing, Closing
During this phase of Project Management, the projects scope and requirements are defined
Initiation phase
The role of a ______ ______ is to respond to requests most typically come from web browsers, such as HTTP
web server
This server addresses protocols such as: IMAP, POP3, SMTP, HTTP, MAPI, and MIME
(email protocols) eMail server
In this network topology ALL devices have a single point-to-point connection with a central device
STAR network
This type of software is made freely available as source code. open source software
This software protection will protect an individuals original work (tangible form)for the authors life + 70 years Copyright
This license protects the creation of inventive concepts as well as the tangible work product for 20 years at the date of filing
Patent
The _______ keyword in SQL is used to inform the DBMS what fields or attributes are of interest (and where they are located, i.e. which table/relation they can be found in).
SELECT
The ______ keyword in SQL is used to inform the DBMS what tables are to be interrogated by the query and, if more than one table contains the data of interest, how they are to be combined or joined.
FROM
The _____ keyword in SQL is used to inform the DBMS of the specific criteria the data should match to be returned as the output of the query.
WHERE clause
All of the following are compiled languages
BASIC
Java C++
Which of the following is the correct function of the compiler?
Translates the entire program, creating an executable program, which can be run at a later time.
A program written in a high-level language must be converted into __________ code to be executed by the computer.
Machine [Show Less]