D075 module quiz
Sparkit has developed a number of unique algorithms to support its specialized programming projects. What does Sparkit need to apply for in order to best protect its rights to its code? A copyright on each algorithm A trademark for each algorithm A trade secret for each algorithm A patent for each algorithm
A copyright on each algorithm
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? Browser-based web development A customer relationship management system A supply chain management system Cloud web services
A customer relationship management system
What is a peripheral device in a network? A handheld device such as a phone or tablet A computer that accesses a network remotely A device shared by multiple end users in a network A client computer that is connected to a network
A device shared by multiple end users in a network
The algorithms developed by Sparkit programmers need to be cataloged and shared among the programmers in all three locations and need to be easily accessible. Which type of software system can Sparkit use to enable this? A document management system (DMS) A productivity software suite A knowledge management system (KMS) A relational database
A knowledge management system (KMS)
Which component must each client computer in the office have in order to install the new network? A network interface controller An internal network server A network switch An internal network
A network interface controller
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? A router A laptop A printer A hub
A printer
Which type of computer runs a network operating system (NOS)? A mainframe computer A client computer on a network A router A server
A server
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? A)Baggage tags that record data about each piece of luggage B)Automatic parking payment stations that accept credit cards C)Monitors that display flight delays and gate changes in real time D)Menus at airport restaurants that allow passengers to order food using a tablet computer
A)Baggage tags that record data about each piece of luggage
Which three benefits does a customer relationship management system (CRM) provide to a business? Choose 3 answers. A)It facilitates marketing strategies to increase business. B)It provides communication tools and channels. C)It is a process to capture information about the business's customers. D)It is a process for returns and customer service. E)It is an order processing system. F)It is a primary sales channel to existing customers.
A)It facilitates marketing strategies to increase business. B)It provides communication tools and channels. C)It is a process to capture information about the business's customers.
What is the main purpose of a firewall? A)To prevent unauthorized users from accessing the network. B)To prevent employees from sharing data outside the network. C)To stop denial-of-service attacks from spreading to the network. D)To stop malware from causing damage within the network.
A)To prevent unauthorized users from accessing the network.
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? AVERAGE AVERAGEIF IF MAX
AVERAGEIF
Which aspect of human resource management is the responsibility of an IT department? Recruitment of new employees online. Administration of information on employees Analyzing which benefits to offer employees Developing online employee training resources
Administration of information on employees
A company is launching a new product that has been requested by thousands of loyal customers and prospective customers. Which form of promotion will best allow the customers and prospective customers to participate in promoting the new product? An information page on the company website An announcement using mass media An announcement on social media platforms An email blast to all customers
An announcement on social media platforms
What is a native app? An app that is preinstalled on a mobile device An app that targets a specific user group An app that will function only on a single platform An app that is updated frequently
An app that is preinstalled on a mobile device
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? Business intelligence research Basic research Development research Applied research
Applied research
In the following "IF" statement, what is "C2>B2" called? =IF(C2>B2,"Over Budget","Under Budget") Argument Absolute reference Cellular reference Comparative reference
Argument
Freedom Rock Bicycles is considering adopting a cloud-database system. What is the primary advantage of a cloud database? A)Database management is not required by the company. B)It can be accessed from anywhere there is an internet connection. C)It requires no software installed on client computers. D)It is inherently secure because it is stored offsite.
B)It can be accessed from anywhere there is an internet connection.
How will the maintenance of employee workstations be simplified by creating an office network? A)Client computers will no longer need network interface cards. B)Software updates for client computers can be done at once from the server. C)Software on client computers will have additional features. D)Client computers will no longer need application software.
B)Software updates for client computers can be done at once from the server.
Which wireless network uses a short-range network for connection between a cell phone and another device, such as a speaker? Wi-Fi Bluetooth GPS Cellular
Bluetooth
Which methodology for sharing information would be most appropriate to the business in the scenario? Browser-based Forward-facing LAN-based WAN-based
Browser-based
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? Hypertext markup language JavaScript Web development tool kits Browser-based web development
Browser-based web development
Sparkit knows that if it wants to be successful on social media, its customers must be familiar with and use mainstream social media technology to develop trust in Sparkit. How can Sparkit most effectively use social media to create trust? Advertise products using mass media. Use search engine advertising. Use bulletin boards to communicate to customers. Build an online community using social media.
Build an online community using social media.
An analyst uses software to analyze data in the company's data warehouse and produce information to guide the organization. The information is presented in clearly understandable charts and graphs on a dashboard and is used to inform decisions in the organization. Which type of software is this analyst using? Database management software Business productivity software Business intelligence software Data governance software
Business intelligence software
How can the Internet of Things (IoT) be used to improve supply chain management in the automotive industry? A)By using real-time communication technology to improve coordination with vendors B)By using blockchain technology to record all transactions on a shared ledger C)By placing internet-connected sensors on every part in order to monitor inventory D)By employing artificial intelligence to look for potential cost saving opportunities
C)By placing internet-connected sensors on every part in order to monitor inventory
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? A)Motion sensors to turn the lights on and off in restrooms B)Door sensors that beep when a door is left open C)Light dimmers and thermostats that report passenger traffic through the terminals in real time D)Thermostats that turn down the heat at 10 p.m. each night.
C)Light dimmers and thermostats that report passenger traffic through the terminals in real time
Which advantages do computer-aided design and computer-aided manufacturing (CAD and CAM) provide the manufacturing process? Choose 3 answers. A)Design errors are automatically corrected during the manufacturing process. B)Time to market is the same as with traditional manufacturing. C)Product changes can be easily made. D)Designs are easily transferred to automated manufacturing tools. E)CAD software can test the product design. F)IT resources required are less than with prototyping.
C)Product changes can be easily made. D)Designs are easily transferred to automated manufacturing tools. E)CAD software can test the product design.
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? Programmer CIO IT manager IT architect
CIO
What hardware component performs most of the calculations for a computer? Motherboard Operating system CPU Hard drive
CPU
Which IT professional runs the organization's IT engineering group and serves as the company's top technology architect? IT project manager Chief technology officer (CTO) Chief information security officer (CISO) Chief information officer (CIO)
Chief technology officer (CTO)
What is the term for using clustered servers to provide virtual resources for web pages? Infrastructure as a service Web development Data warehousing Cloud web hosting
Cloud web hosting
A large company has decided to invest in new IT systems, including a new server. Which IT professional should be tasked with setting up and maintaining the server? Computer System Administrator Computer System Analyst Computer Support Specialist Computer Programmer
Computer System Administrator
Which IT professional installs and performs minor repairs to hardware, performs software troubleshooting, and makes sure peripheral equipment works properly? Computer support specialist Computer systems administrator Information security analyst Computer programmer
Computer support specialist
Which observation about computing technology is expressed in Moore's law? Points of failure exist in every computer system. Computing processing power doubles every 18 months. Computing memory requirements double every 18 months. Cloud based infrastructure is more reliable than host
Computing processing power doubles every 18 months.
How can a business best determine the return on investment (ROI) of advertising on social media? Count clicks on advertisements. Calculate ROI based on cost per advertisement. Calculate the number of advertisements presented. Count the number of social media sign-ons.
Count clicks on advertisements.
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? A)A device that allows paramedics remote control of an AED B)A device that displays the patient's vital signs on a screen on an AED C)A device that provides video instruction to the user of an AED D)A device to notify paramedics when an AED is being used
D)A device to notify paramedics when an AED is being used
In the scenario above, how should the IT department resolve the incompatibility issue? A)Hold a training on how to use each software product to remove incompatibility. B)Implement a process that translates data from one software to another. C)Increase help desk support for various software packages. D)Standardize software throughout the organization.
D)Standardize software throughout the organization.
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? Data scrubbing Data governance Data normalization Data analytics
Data governance
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? Data mining Data mangement Data scrubbing Data normalization
Data mining
Which type of data are referred to as "decayed"? Data that have been altered Data that are not properly loaded Data that do not fit a schema Data that have become outdated
Data that have become outdated
Which application software features tables, records, and fields that can be queried, updated, and managed by users, programmers, and business analysts? Presentation software Word processor software Spreadsheet software Database software
Database software
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? Global positioning system (GPS) Supply chain management system (SCM) Decision support system (DSS) Transaction processing system (TPS)
Decision support system (DSS)
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? Excel PowerPoint DropBox Photoshop
DropBox
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? ETL SQL Tableau Hadoop
ETL
Which restriction applies to the data in the primary field of a database? The primary key must be the first attribute in the table. Each key must be numeric. The primary field must be generated by the system. Each key must be unique.
Each key must be unique.
Which term refers to any person in a business who uses a computer to complete their day to day tasks of the business? Systems analyst Operator IT professional End-users
End-users
Microsoft Project is classified as presentation software. True False
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
False
True or False: Written posts extracted from a social media feed are generally classified as structured data. True False
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 False
False
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? Additional device protocol support Faster internet speeds Additional MAC address support Additional password-level security
Faster internet speeds
What is the term used to describe a file sharing system that uses cloud-based technology? Local area network File synchronization service Peer-to-peer service Client-server system
File synchronization service
Dropbox and Google Drive are both examples of what service? Communications Software Function-Specific Software Project Management Software File synchronization services
File synchronization services
Maria has accumulated on her PC a lot of data that are pertinent to her job. She is investigating automated backup functions, rather than the manual systems she is currently using, to make sure her data are safe. What is the term for these automated systems? Peer-to-peer services Digital file sharing systems Information repositories File synchronization services
File synchronization services
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? Network interface card (NIC) Firewall MAC address Switch
Firewall
A database manager is setting up a relational database. The manager creates a field in a table that links to the primary key in a different table in the database. What is this field called? Schema Foreign key Absolute reference Function
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? Connection key Common key Linking key Foreign key
Foreign key
Delivery drones do not depend on guidance by a human but on information technology systems to run autonomously. Which key network system would a self-guided drone system rely on? Bluetooth Cellular network Wi-Fi GPS
GPS
What term refers specifically to the physical aspects of a computer such as circuit boards, processor chips, memory, and keyboards? Information Technology Software Operating System Hardware
Hardware
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 systems administrator Database administrator IT architect Computer systems analyst
IT architect
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? Chief information officer Computer systems administrator IT portfolio manager IT architect
IT portfolio manager
Most mobile applications (apps) go through a standard nine-step development process. What is usually the final step in the development process of a mobile app? Market the app to reach the appropriate demographics. Establish a payment system for the app. Improve the app based on user feedback. Launch the app in the appropriate app store.
Improve the app based on user feedback.
What term refers to the study, design, development, implementation, support, and management of computer-based information systems? Technology Studies Computer Information Systems Software Governance Information Technology
Information Technology
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? Web developer Database administrator Information security analyst Computer systems administrator
Information security analyst
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? Install a Bluetooth-enabled tracking system. Install a sensor with a unique identifier (UID). Install a global positioning system (GPS) navigation system. Install a device with a small Wi-Fi router in the vehicle.
Install a sensor with a unique identifier (UID).
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? Install an extranet to the company's suppliers. Connect suppliers with the company's accounting system. Install a database to manage parts inventory. Create an intranet connection for the company's suppliers.
Install an extranet to the company's suppliers.
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? Artificial intelligence Internet of Things Blockchain Robotics
Internet of Things
Transaction processing systems (TPSs) are used by grocery stores to gather data on which products are sold and when they are sold, and customer information. If all TPS data are related to a grocery store's finances, inventory, and customers, which type of network configuration would be most appropriate for the implementation of a TPS? Extranet Intranet Wireless Internet
Intranet
What is a private computer network for sharing corporate information, collaboration tools, and computing services? Intranet Peer-to-peer network Extranet Campus area network (CAN)
Intranet
Bullzai Meat Company has freezer warehouses across the southern United States to hold meat until it is purchased by restaurants and schools. Bullzai needs to monitor the atmosphere and temperature quality of each of its freezers but cannot afford to have personnel perform this on a continual basis. Which technology implementation will allow the company to accomplish this goal? IoT Wi-Fi Mobile app RFID
IoT
Establishing a large network of IoT devices can improve the operation of a manufacturing business by automating many aspects of the manufacturing process. What is the main vulnerability to production due to use of IoT devices? IoT devices require frequent replacement. IoT devices are highly vulnerable to hacking. IoT devices are highly vulnerable to software viruses. IoT devices require constant Wi-Fi connectivity.
IoT devices require constant Wi-Fi connectivity.
Why is a passphrase useful? It is secure and easy to memorize. It is random and automatically updated. It allows the use of spaces. It only uses alphabetical characters.
It is secure and easy to memorize.
What is the defining characteristic of function-specific software? It is tailored to a specific group or industry. It works only on specific devices. It is graphical in nature. It is designed for use by upper management.
It is tailored to a specific group or industry.
What is the defining characteristic of application software? It needs no system software running in the background. It runs in the background with no user intervention. It performs a specific task for the user.
It performs a specific task for the user.
How does a knowledge management system (KMS) help a company? It evaluates company knowledge for decision-making. It provides access to collective company knowledge. It creates rules for sharing company knowledge. It generates knowledge from outside data.
It provides access to collective company knowledge.
By segmenting data in a data management system, a business achieves a significant advantage over nonsegmentation. What is that advantage? It keeps data valid. It makes SQL easier. It targets the right customers. It increases return on investment (ROI).
It targets the right customers.
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? Knowing the sales price of each product Knowing which products sell the best in each region Knowing the manufacturing cost of each product Knowing who is the best salesperson
Knowing which products sell the best in each region
A small business has a single network that allows every employee to connect through a central server when they are in the company's main office. What type of network is the business using? Wide Area Network (WAN) Local area network (LAN) Peer-to-peer Network (P2P) Campus Area Network (CAN)
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? Campus area network (CAN) Local area network (LAN) Wide area network (WAN) Metropolitan area network (MAN)
Local area network (LAN)
A company's IT department is currently a subunit of the accounting department, reporting to the accounting manager. The reason for this is that accounting is the single largest consumer of the company's IT services. The company's president decides that due to widespread disorganization and poor communication, she wants to reorganize all business units. What is the best recommendation for placement of IT within the company? Move IT under the president's office. Leave IT as part of accounting. Move IT under human resources. Make the IT department independent.
Make the IT department independent.
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? Research and development Human resources Accounting Marketing
Marketing
Which category of computer is a business laptop? Handheld computer Microcomputer Mainframe computer Minicomputer
Microcomputer
Which software feature could help address the problem described in the scenario? Head count analysis Available memory Salary management Milestone tracking
Milestone tracking
Lucas uses project management software for managing all his projects. Which output of project management software is used to assign tasks? Milestones Gantt charts Unified Modeling Language (UML) System development life cycle (SDLC)
Milestones
A mobile app developer has developed a game that users can download and play for free. However, once users reach the one hundredth level, they must pay to unlock additional levels. What has the developer done by requiring app users to unlock additional levels? Licensed the app Monetized the app Created a network effect Used sponsored advertising
Monetized the app
A data analyst is using the ETL process to enter data into the company's relational database. The data contain many redundancies. Which process will the data analyst need to use before loading the extracted data into the database? Segmentation Normalization Data governance Topic analysis
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? Schema design Extraction Data governance Normalization
Normalization
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? Normalize the database Load the data Scrub the database Extract the data
Normalize the database
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? Business intelligence (BI) Data mining Online analytical processing (OLAP) Data analytics
Online analytical processing (OLAP)
An employee receives an email that appears to be from the IT department. The email asks the recipient to click a link to verify their username and password. Upon closer inspection, the employee realizes that the email is a fraudulent attempt to obtain their password. What type of fraud does this email represent? Keylogging Phishing Click fraud Spyware
Phishing
A company uses data on its past call volumes to determine call center staffing. Which type of reporting should the company utilize? Predictive reporting Financial reporting Executive reporting Strategic reporting
Predictive reporting
Which type of reporting will provide Jack and William with the right information for making strategic decisions? Executive reporting Predictive reporting Transaction reporting Management reporting
Predictive reporting
Which category do Google Docs and Dropbox fall within? Productivity apps Utility apps Lifestyle apps Social networking apps
Productivity apps
Which category of software is Microsoft Office? Network software Productivity software Database software System software
Productivity software
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? Placement Products Pricing Promotion
Products
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? Graphing software Project management software Database software Spreadsheet software
Project management software
Which type of software is designed to easily generate Gantt charts? Graphing software Database management software Spreadsheet software Project management software
Project management software
A hospital has installed a system that constantly provides the inventory status of emergency supplies. Tags added to each product contain the product information needed for inventory control and identification, and these tags can be read with a scanner. Which technology did the hospital implement to perform this service? Internet of Things Bluetooth RFID HTTP
RFID
What is "C2:F2" called in the formula =SUM(C2:F2)? Scope Array Range Group
Range
A company has experienced significant growth in just a few months. The company expects to continue this rate of growth in the coming year. Which cloud computing feature would most benefit this business in the short term as it manages its growth? Expanded system throughput Improved system stability Rapid system scalability Enhanced system functionality
Rapid system scalability
What did the Sarbanes-Oxley Act of 2002 require of IT departments in American companies? Record and preserve accounting records Protect students' educational data privacy Ensure medical patients have access to their health data Allow employees to miss work for medical reasons
Record and preserve accounting records
What is the process of normalization of a database? Creating the schema of the database Improving database performance Using "load" to place data in the data warehouse Removing redundancies within the database
Removing redundancies within the database
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? Server Hub Client Router
Server
What is the term used to describe technologies that enable, facilitate, and enhance people's ability to share digital content? Mobile apps Social media Mobile technology Social networking
Social media
Which function of a customer relationship management system helps a company identify opportunities to increase its business? Data collection Technology Strategy Process
Strategy
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? Data analytics Structured Query Language (SQL) Search engine optimization (SEO) Data administration
Structured Query Language (SQL)
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? Process the data with Tableau Use a relational database Switch to a data mart Configure the data warehouse with SQL
Switch to a data mart
What are the two basic categories of software? High-level and low-level languages Server and client Memory-based and cloud-based System and application
System and application
Which level of security is required to protect the hardware and communications equipment that support a database? Data-level security System-level security Data-center security User-level security
System-level security
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? Data mart Data mining Hadoop Tableau
Tableau
A transaction processing system (TPS) enables the entry and recording of sale-related data such as item purchased, price, and date and time of sale. Which kind of decisions does management use these data for? Strategic decisions Executive decisions Tactical decisions Predictive decisions
Tactical decisions
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? Predictive analytics Topic analytics Decision analytics Text analytics
Text analytics
What is the major issue that hinders the effective use of decision support systems (DSS)? Offering multiple solutions to a problem Poor data governance decisions and administration The collection of too much data Incorrectly distinguishing between viable and nonviable data
The collection of too much data
Which technology is a critical component of customer relationship management (CRM) systems? The schema Sales tracking Data analysis software The database
The database
IoT devices observe and gather data but have limited intelligence for analysis. With respect to the design of an IoT network, where are the IoT devices located? The network hub The cloud The data center The edge
The edge
What is the definition of the term "best practice"? The most effective way of arriving at a desired outcome The fastest way to complete a required task The application of information technology to improve a process The attainment of a competitive advantage
The most effective way of arriving at a desired outcome
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? The network analyst The network administrator The network programmer The network installer
The network administrator
Which ethical dilemma is created by music-sharing websites? They allow a user to bypass an artist's copyright. They monopolize the internet by transmitting so much data. They are part of the dark web. They distribute viruses.
They allow a user to bypass an artist's copyright.
Maria designs a website for her small business using a browser-based web development platform. She copies an image file of a large company's logo and places the words "Just Buy It" underneath the logo. She places the logo prominently on her website. Which intellectual property law does Maria's website violate? Patent Copyright Trade secret Trademark
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? Patent Trade secret Copyright Trademark
Trademark
An operating system is sometimes called a platform. True
True
On-demand cloud computing (ODC) platforms can be used to reduce data storage costs. True False
True
True or False: Structured Query Language (SQL) can be used to query data in nearly every type of database. True False
True
True or false: A challenge of IT systems is that they can capture too much data. False True
True
True or false: As the web has grown, the cost of writing, distributing, and selling a mobile application (app) has declined. False True
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. False True
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
True
True or false: Reporting systems facilitate daily, operational decision-making and longer-term strategic planning in business. True False
True
What is a computer network? A device that connects computers to the internet A system that allows data to be stored in a central location Two or more client computers using the same router Two or more computers connected to shared resources
Two or more computers connected to shared resources
Which IoT system process is used to reference each IoT device on a network? MAC Logon ID IP address Unique identifier
Unique identifier
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? Place marketing advertisements on web pages. Use search engine optimization. Put the web address on all documents. Email web page links to their customers.
Use search engine optimization.
Which attribute of big data relates to whether the data are structured or unstructured? Veracity Velocity Volume Variety
Variety
Lucas owns a medium-sized computer programming firm named Sparkit with 12 computer programmers and computer analysts with offices in three cities. The firm's specialty is point-of-sale systems programming. Many times, the firm's customers have unique needs during an implementation, and collaboration among the programmers and analysts is key to the firm's success. Lucas, as a manager, understands the benefits of business information technology. However, he has not adequately implemented IT solutions to benefit Sparkit. Which type of application can Lucas implement to allow for real-time business collaboration? Discussion boards File sharing Video conferencing Email
Video conferencing
How do most Internet of Things (IoT) devices connect to other devices? Wi-Fi Artificial intelligence Firewall Web browsers
Wi-Fi
Which network information is needed to connect an Internet of Things (IoT) device? MAC address Wi-Fi connection information Network packet type Cellular network information
Wi-Fi connection information
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? Bluetooth signal Wi-Fi signal Peer-to-peer network Cellular network
Wi-Fi signal