Studied by 0 people
Looks like no one added any tags here yet for you.
MODULE #1
The most effective way of arriving at a desired outcome
MODULE #1
What is the definition of the term "best practice"?
Computing processing power doubles every 18 months.
Which observation about computing technology is expressed in Moore's law?
CPU
What hardware component performs most of the calculations for a computer?
It performs a specific task for the user.
What is the defining characteristic of application software?
System and application
What are the two basic categories of software?
Microcomputer
Which category of computer is a business laptop?
True
True or False
An operating system is sometimes called a platform.
A device shared by multiple end users in a network
What is a peripheral device in a network?
It is secure and easy to memorize.
Why is a passphrase useful?
Two or more computers connected to shared resources
What is a computer network?
A printer
A technology business is growing rapidly and needs new systems to support a growing workforce. An IT manager is asked to create an IT department to support the growing business. This manager's first task is to make an inventory of essential items needed and their associated costs. The list includes office supplies such as desks, chairs, laptops, and a printer. The list also includes a server, a network operating system, cables, a hub, a router, and everything else it takes to set up a network for the business. The IT manager's boss has some concerns about the cost of a network and its impact on the company and employees.
The manager explains that a network will allow employees to use shared peripheral devices on the network.
Which example of a peripheral device can the manager provide based on the supply list?
Software updates for client computers can be done at once from the server.
How will the maintenance of employee workstations be simplified by creating an office network?
A network interface controller
Which component must each client computer in the office have in order to install the new network?
Local area network (LAN)
While the business in the scenario is growing, it is still a small business. There are just 25 employees, and they all work in the same location.
Which type of network will the business use?
Firewall
The business in the scenario frequently works with sensitive data, and it is important to ensure that the network is highly secure.
Which network component is specifically designed to prevent unauthorized users from accessing the network?
MODULE #2
It provides access to collective company knowledge.
MODULE #2
How does a knowledge management system (KMS) help a company?
False
True or False
Microsoft Project is classified as presentation software.
Productivity software
Which category of software is Microsoft Office?
True
True or False
On-demand cloud computing (ODC) platforms can be used to reduce data storage costs.
Project management software
A design business has employees based in different parts of the country, with all employees working remotely from home. This allows the business to attract the best expertise, which is a great benefit to the business. One problem, however, is that employees are often waiting for other employees to complete certain tasks before they can complete their own. This lack of coordination causes significant delays in projects.
Which type of software is designed specifically to address the coordination problem in the scenario?
Browser-based
Which methodology for sharing information would be most appropriate to the business in the scenario?
Milestone tracking
Which software feature could help address the problem described in the scenario?
Server
While the workforce is distributed, all the employees' computers will be managed from the main office.
Which term refers to the computer that manages software updates for all the employees' computers?
DropBox
The company hopes to use cloud-based storage to allow employees to share all their work-related files.
What is a common cloud-based storage solution for the company?
MODULE #3
Chief technology officer (CTO)
MODULE #3
Which IT professional runs the organization's IT engineering group and serves as the company's top technology architect?
IT architect
Which professional designs parts of computer applications (like screen interfaces, middleware, and programming infrastructure) that comply with the head application developer's design principles?
Computer support specialist
Which IT professional installs and performs minor repairs to hardware, performs software troubleshooting, and makes sure peripheral equipment works properly?
IT portfolio manager
A business consultant has been brought on board to investigate an organization's efficiency problems. After much examination, the consultant reports that departments within the business are using different software packages that are incompatible with each other. This is especially problematic when it comes to sharing data and information. The consultant recommends using the same software in all departments of the business. However, many managers are hesitant to employ this idea of using the same software across the organization. They claim it would be time-consuming to train employees on new software.
In the scenario above, who is responsible for designing a detailed plan to address the incompatibility issue?
Standardize software throughout the organization.
In the scenario above, how should the IT department resolve the incompatibility issue?
CIO
The company's board of directors has expressed concerns about the software compatibility issue.
Who is responsible for explaining and advocating for the new plan to the company's board of directors?
The network administrator
In the report, the consultant noted that the company's network is in need of maintenance.
Which IT professional is directly responsible for the smooth operation and maintenance of a business's networks and networking technology, including its hardware and software?
Information security analyst
An additional problem that the consultant identified was that unauthorized users could easily access data on the company's internal network.
Which IT professional is responsible for addressing this issue?
MODULE #4
Variety
MODULE #4
Which attribute of big data relates to whether the data are structured or unstructured?
False
True or False:
Written posts extracted from a social media feed are generally classified as structured data.
ETL
A large clothing retailer has an extremely active social media account and hundreds of thousands of followers who create millions of comments per year. Once a quarter, the marketing department offers a major discount to its followers on social media. The company wants to know the return on investment (ROI) of the discounts and store the information in its data warehouse. A data analyst in the IT department is given the task of extracting, processing, and analyzing the data. The data are currently unstructured. The data will be used to create information that will be given to the CIO to inform future decisions.
What can the data analyst use to retrieve and process the data to put into the data warehouse?
Normalization
The data are full of redundancies, which the data analyst needs to remove.
Which process can the data analyst use to remove the redundancies?
Data mining
A data analyst wants to use software to look for useful patterns and hidden relationships in this large set of social media data.
Which process can be used to look for these patterns and relationships?
Tableau
A business analyst wants to use the social media data to create and present business intelligence. She will create visualizations that will be used by the executive team.
Which tool is appropriate for creating and presenting this business intelligence?
Switch to a data mart
The data warehouse is very costly and time-consuming to manage, and the data analyst notices that the data warehouse only used 20 percent of its capacity during discovery.
How can the company reduce the cost and time associated with managing the data warehouse?
MODULE #5
True
MODULE #5
True or False:
Structured Query Language (SQL) can be used to query data in nearly every type of database.
Text analytics
A data analyst wants to search though unstructured data from social media posts to look for useful customer behavior patterns and sentiments.
Which type of analytics are appropriate for this task?
Data governance
Which term refers to managing the availability, integrity, and security of an organization's data to ensure that the data remain high quality and valid?
It targets the right customers.
By segmenting data in a data management system, a business achieves a significant advantage over nonsegmentation.
What is that advantage?
Removing redundancies within the database
What is the process of normalization of a database?
Each key must be unique.
Which restriction applies to the data in the primary field of a database?
Online analytical processing (OLAP)
Freedom Rock Bicycles has installed a new database to keep track of sales by region, salesperson, product, and sales prices, among other items, to keep information on business processes. After installation, Freedom Rock Bicycles discovered additional benefits of the information accumulated in the database and how the information can improve the business profitability and future plans.
Freedom Rock Bicycles found that daily reports could be run using SQL to indicate product and parts inventory and sales for the day.
Which approach can be used to retrieve this information efficiently?
Normalize the database
Freedom Rock Bicycles found that it has multiple records due to multiple sales to the same individual. This has caused access problems when looking for specific customers.
What can Freedom Rock Bicycles do to alleviate this problem?
Knowing which products sell the best in each region
Which valuable business intelligence (BI) can Freedom Rock Bicycles acquire from the database that directly relates to overall revenue and profitability based on this scenario?
It can be accessed from anywhere there is an internet connection.
Freedom Rock Bicycles is considering adopting a cloud-database system.
What is the primary advantage of a cloud database?
Foreign key
The data analyst at Freedom Rock Bicycles wants to link two tables in the database.
What is the name of the field in a database table that is used to connect or link two tables together?
MODULE #6
=SUM(F3:F17)
MODULE #6
What is the correct Excel function expression to calculate the total of all of the scores (column F) in cell C2?
100
Which value will be returned in cell C4 if "=MAX(F3:F17)" is input in the cell?
Argument
In the following "IF" statement, what is "C2>B2" called? =IF(C2>B2,"Over Budget","Under Budget")
Range
What is "C2:F2" called in the formula =SUM(C2:F2)?
=C3>70
Maria recently received a large set of data containing new employees' exam scores. She was asked to prepare the data for analysis. The first task is to identify whether each of the new employees received a score over 70. She is going to use Boolean logic to return "TRUE" if the new employee's score is over 70 and "FALSE" otherwise.
What should she type in cell D3 below?
AVERAGEIF
A manager has a data set that contains the profits of 556 stores in the United States. In the data set, along with each store location, there is a column that specifies the regions of the United States that each location belongs to: East, South, Midwest, Mountain, and Pacific. Which function should the manager use to find the average profits of stores in each region?
VLOOKUP
Daniel is a loan officer of a credit union and is assigning an interest rate to potential clients. Below is the table of interest rates based on FICO scores (a type of credit score) in column C and annual income in row 3.
In order to assign an interest rate to each client based on the client's FICO score range (column C), which Excel function should Daniel use?
MODULE #7
Marketing
MODULE #7
IT services that focus on customers promote core business responsibilities such as the branding of a business's products and services.
Which business department would these services be most relevant to?
True
True or false:
Business collaboration involves two or more people or departments working toward a common business goal, and it is facilitated by the exchange of data and information.
Intranet
What is a private computer network for sharing corporate information, collaboration tools, and computing services?
- It is a process to capture information about the business's customers.
- It provides communication tools and channels.
- It facilitates marketing strategies to increase business.
Which three benefits does a customer relationship management system (CRM) provide to a business?
Choose 3 answers.
True
True or false:
A challenge of IT systems is that they can capture too much data.
Predictive reporting
A company uses data on its past call volumes to determine call center staffing.
Which type of reporting should the company utilize?
True
True or false:
Reporting systems facilitate daily, operational decision-making and longer-term strategic planning in business.
(Question #1)
Applied research
(Questions 1-6 are based on the following scenario.)
William and Jack are motorcyclists. They ride to work each day and own a motorcycle repair shop. They started their business fixing friends' motorcycles, and before long they found they had more work than they could handle. Customers began to ask for services such as a website to buy parts and accessories and information on safety and maintenance. William and Jack believe they could expand their business and increase their revenue by adding these services and selling used motorcycles. To make this possible, they need to install and gain expertise in the use of IT. In addition, they have ideas about converting gas-powered motorcycles to electric motorcycles to differentiate their shop from other shops. This would necessitate the collection of new data and connection with additional suppliers and systems. IT will be key to the growth of their company.
Which type of research should William and Jack do to understand the electric motorcycles needed to meet customer and industry requirements and needs?
(Question #2)
Products
William and Jack believe that their large selection of rare parts and motorcycles should be the main focus of messaging to customers.
Which of the four Ps of marketing should they focus on when they analyze customer needs and customer support?
(Questions #3)
Use search engine optimization.
William and Jack have a web page, but it does not receive many visitors.
How can they make their web page more visible to those who may be looking for a motorcycle repair shop?
(Questions #4)
Install an extranet to the company's suppliers.
William manages the repair department of the business and is frustrated with the process of acquiring parts.
Which IT methodology can William use to help manage this process?
(Questions #5)
Predictive reporting
Which type of reporting will provide Jack and William with the right information for making strategic decisions?
(Questions #6)
Structured Query Language (SQL)
Jack and William want to hire a person to write code to access their database in order to build management reports.
Which skill should a successful applicant possess?
MODULE #8
MODULE #8
What is the term for using clustered servers to provide virtual resources for web pages?
Cloud web hosting
What is the term for using clustered servers to provide virtual resources for web pages?
- CAD software can test the product design.
- Designs are easily transferred to automated manufacturing tools.
- Product changes can be easily made.
Which advantages do computer-aided design and computer-aided manufacturing (CAD and CAM) provide the manufacturing process?
Choose 3 answers.
Bluetooth
Which wireless network uses a short-range network for connection between a cell phone and another device, such as a speaker?
True
True or false:
Browser-based web development using tools such as visual web designers and drag-and-drop technology has reduced the need for professional web developers.
They allow a user to bypass an artist's copyright.
Which ethical dilemma is created by music-sharing websites?
False
True or False:
The Family Educational Rights and Privacy Act (FERPA) requires all public schools to house student records in a single national database.
(Question #1)
Decision support system (DSS)
(Questions 1-5 are based on the following scenario.)
Eva is a realtor and owns her own real estate business. She has six employees: an administrative assistant at her small office and five real estate agents. She is successful and has 28 current listings of houses for sale. Eva does not believe that real estate agents should be in an office but should be meeting with prospective buyers and sellers since mobility and being visible to her customers is key to their success. To accomplish this, Eva has investigated mobile technology to assist her in her business.
Which system should Eva use to leverage business intelligence and analytics to gain insights into her real estate data?
(Question #2)
A customer relationship management system
Eva wants to implement a tracking system of everyone who logs in and searches her listings of homes for sale, capturing information on who logs in, when, and what information they accessed.
Which piece of IT infrastructure should she implement to help automate this process?
(Question #3)
Trademark
One of Eva's realtors, Alice, creates a web page of her own and places pictures of the houses she has for sale on the page. Alice took the pictures herself; however, she copies the logo from a local hospital and places it on her website to show how close some of the houses are to medical facilities.
Which type of law did Alice violate?
(Question #4)
Faster internet speeds
Smart homes with voice controlled light switches, app-connected video doorbells, and internet-enabled appliances are changing the nature of Eva's work selling real estate.
Which improvement in IT infrastructure has enabled these real-time devices to function properly?
(Question #5)
Browser-based web development
Eva wants to make her own website for her real estate business.
Which technology could she use to develop her own website without first acquiring programming skills?
MODULE #9
Wi-Fi
MODULE #9
How do most Internet of Things (IoT) devices connect to other devices?
Unique identifier
Which IoT system process is used to reference each IoT device on a network?
Internet of Things
A large agriculture company uses a system that uses sensors to measure the soil moisture at various locations in its fields. These data are used to automatically adjust the irrigation system, which reduces water waste.
Which type of technology is this company using to reduce water waste?
By placing internet-connected sensors on every part in order to monitor inventory
How can the Internet of Things (IoT) be used to improve supply chain management in the automotive industry?
False
True or false:
Implementation of the IoT in the healthcare industry will increase the need for hospital staff to monitor and record data to be analyzed.
(Question #1)
Baggage tags that record data about each piece of luggage
(Questions 1-5 are based on the following scenario.)
Charlotte is the operations manager at one of the nation's busiest airports. More than 600 flights depart or arrive at her airport every single day. Safety is not only critical but it is defined and monitored by government agencies. Food supply and baggage conveyor systems, maintenance and service vehicles, and, of course, airplanes must all move around the airport's runways and roads without creating hazards or delays for workers or passengers. Airport services including restaurants, shops, medical response, screening and security, and more must all work together seamlessly to ensure the airport runs smoothly and efficiently in order to get passengers to their destinations. Charlotte's job is to make sure that happens. The following questions are about how Internet of Things (IoT) could affect the various businesses and organizations working together at the airport.
What is an example of IoT technology being used to aid airport functions?
(Question #2)
Wi-Fi signal
The airport installs sensors along the runways, and the sensors provide air traffic controllers with real-time information about the location of every plane on the ground.
Which technology allows these sensors to transmit data to the air traffic controllers' server?
(Question #3)
Light dimmers and thermostats that report passenger traffic through the terminals in real time
Charlotte finds that the airport spends more than $100,000 each month on electricity for lighting and the heating and cooling system in the airport.
How could Charlotte use IoT to reduce her airport's power bill?
(Question #4)
A device to notify paramedics when an AED is being used
Charlotte considers installing automated external defibrillator (AED) machines at strategic locations in the airport for enhanced healthcare for patrons.
What is an example of an IoT device that can be used to improve the effective use of AED devices?
(Question #5)
Install a sensor with a unique identifier (UID).
There are many airport vehicles at Charlotte's airport, and time and movement of planes and baggage are of primary importance. Because of this, IoT is used to track the location of baggage vehicles at the airport.
When the airport purchases a new baggage vehicle, what must be done to connect it to the IoT system?
