D075 Information Technology (Learning Checks and Quizes)

MODULE #5 True

MODULE #5 True or False: Structured Query Language (SQL) can be used to query data in nearly every type of database.

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?

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?

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?

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?

Each key must be unique.

Which restriction applies to the data in the primary field of a database?

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 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.

(Questions #5) Predictive reporting

Which type of reporting will provide Jack and William with the right information for making strategic decisions?

100

Which value will be returned in cell C4 if "=MAX(F3:F17)" is input in the cell?

Bluetooth

Which wireless network uses a short-range network for connection between a cell phone and another device, such as a speaker?

MODULE #8

MODULE #8 What is the term for using clustered servers to provide virtual resources for web pages?

MODULE #9 Wi-Fi

MODULE #9 How do most Internet of Things (IoT) devices connect to other devices?

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?

It is secure and easy to memorize.

Why is a passphrase useful?

Browser-based

Which methodology for sharing information would be most appropriate to the business in the scenario?

(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 #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 #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?

Predictive reporting

A company uses data on its past call volumes to determine call center staffing. Which type of reporting should the company utilize?

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?

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?

(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 #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?

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?

(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?

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?

System and application

What are the two basic categories of software?

CPU

What hardware component performs most of the calculations for a computer?

Range

What is "C2:F2" called in the formula =SUM(C2:F2)?

Two or more computers connected to shared resources

What is a computer network?

A device shared by multiple end users in a network

What is a peripheral device in a network?

Intranet

What is a private computer network for sharing corporate information, collaboration tools, and computing services?

It performs a specific task for the user.

What is the defining characteristic of application software?

Removing redundancies within the database

What is the process of normalization of a database?

Cloud web hosting

What is the term for using clustered servers to provide virtual resources for web pages?

Computer support specialist

Which IT professional installs and performs minor repairs to hardware, performs software troubleshooting, and makes sure peripheral equipment works properly?

Unique identifier

Which IoT system process is used to reference each IoT device on a network?

- 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.

Microcomputer

Which category of computer is a business laptop?

Productivity software

Which category of software is Microsoft Office?

A network interface controller

Which component must each client computer in the office have in order to install the new network?

(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?

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?

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?

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 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?

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?

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?

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?

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?

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?

(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 #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?

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?

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?

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?

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?

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?

Argument

In the following "IF" statement, what is "C2>B2" called? =IF(C2>B2,"Over Budget","Under Budget")

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?

Standardize software throughout the organization.

In the scenario above, how should the IT department resolve the incompatibility issue?

(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 #1 The most effective way of arriving at a desired outcome

MODULE #1 What is the definition of the term "best practice"?

MODULE #2 It provides access to collective company knowledge.

MODULE #2 How does a knowledge management system (KMS) help a 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?

MODULE #4 Variety

MODULE #4 Which attribute of big data relates to whether the data are structured or unstructured?

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?

=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?

(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?

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?

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?

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?

(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?

True

True or False An operating system is sometimes called a platform.

False

True or False Microsoft Project is classified as presentation software.

True

True or False On-demand cloud computing (ODC) platforms can be used to reduce data storage costs.

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.

False

True or False: Written posts extracted from a social media feed are generally classified as structured data.

True

True or false: A challenge of IT systems is that they can capture too much data.

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.

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.

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.

True

True or false: Reporting systems facilitate daily, operational decision-making and longer-term strategic planning in business.

They allow a user to bypass an artist's copyright.

Which ethical dilemma is created by music-sharing websites?

Computing processing power doubles every 18 months.

Which observation about computing technology is expressed in Moore's law?

Milestone tracking

Which software feature could help address the problem described in the scenario?

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?

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?