WGU C182 practice

What is the definition of information technology?

It is the technology used to create, 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?

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

One computer will request information from another computer, which responds with requested information.

Client

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?

What type of software permits free temporary use followed by long

term activation for a fee?

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?

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

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?

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?

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?

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

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

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