Information Technology - Final Test (SOPHIA PATHWAY)

Jeffrey consults with company leaders to identify ways in which IT can help the organization to reach its goals. Jeffrey is working in a/an __________ role for his company. • infrastructure and equipment management • network development and maintenance • planning • information technology support RATIONALE Jeffrey's role is planning, which involves consulting with an organization's leaders to identify ways in which IT can help that organization to achieve its goals. Jeffery is also responsible for monitoring the implementation of planned activities, and exercising control of his organization's IT resources, to ensure improvement and success. CONCEPT Information Technology in the Workplace 2 Alexis received an email message from an unknown sender that included an attachment. If she opens the attachment, what kind of malicious software might be activated, and what are the consequences? • Opening the attachment would release a worm, which would infect her system with a virus. • Opening the attachment would release a passive worm, which would infect her system with adware. • Opening the attachment would release a worm, which would infect her system with spyware. • Opening the attachment would release an active worm, which would infect her system with adware. RATIONALE Senders can transmit files to recipients by attaching them to email messages. Like "junk mail" delivered by the postal service, email users regularly receive unsolicited messages from unknown senders. These messages sometimes contain links to malicious websites or include attachments that contain malicious software (e.g., a worm). CONCEPT Network Security 3 Which of the following does NOT include both input and output components? • Video card • Touchscreen monitor • A portable SSD drive • A printer with a scanner RATIONALE The video card, also known as the graphics processing unit (GPU), generates images on a monitor and is an internal data processing component. A printer with a scanner, a touchscreen monitor, and a portable SSD drive are examples of input AND output devices because they enable users to receive information from a computing system, and send information into a computing system. CONCEPT Computer Components and Roles 4 Which of the following is NOT an example of computer software? • OS X • Firefox • Windows Media Player • ROM RATIONALE Read-only memory (ROM) is a type of nonvolatile memory used in computers and other electronic devices. ROM is not software. CONCEPT Computer Software 5 Select the true statement about the motherboard. • It provides much of the electrical connection between different computer parts. • It executes the commands sent to it by the application software. • It acts as the working memory of the computer by transferring data from the hard disk for processing. • It acts as a storage point for read-only memory (ROM). RATIONALE A motherboard is a printed circuit board that contains the principal components of a computer or other device. It includes connectors into which other circuit boards can be slotted. A motherboard provides much of the bus of the computer, and is the main circuit board where the memory, storage, and CPU connect. CONCEPT Internal Computer Hardware 6 Kirby visited a sweepstakes website and agreed to download a new program. Later, when he tried to use a word processing program, his document files became corrupted. How can Kirby try to remove the offending program and prevent future attacks? • Kirby should change the password on his computer. • Kirby should use WPA network encryption. • Kirby should install a biometric reader. • Kirby should run an antivirus program. RATIONALE Kirby should try to remove the offending program by running an antivirus program. To solve problems resulting from Kirby's risky online behavior, his computer should be scanned to locate and eliminate viruses, malware, and spyware. CONCEPT Network Security 7 __________ is a social media and microblogging site that enables users to post multimedia content to a short-form blog. • QQ • • Tumblr • Instagram RATIONALE Tumblr is a popular microblogging platform for creative self-expression. Users post blog entries on a myriad of topics. It is considered to be a alternative to Facebook and other social media websites. Instagram, QQ, and are not blog-based platforms. CONCEPT Benefits and Risks of Social Media 8 __________, developed by OpenOffice, is an example of word processing software. • Numbers • Writer • Keynote • Impress RATIONALE Writer is OpenOffice's word processing application. Numbers is an example of spreadsheet software developed by Apple. Keynote (developed by Apple) and Impress (developed by OpenOffice) are presentation applications. CONCEPT Selecting Software 9 Ashlee recently traveled with friends during spring break. She used her cellular Android device to change the settings on her home security system. When she finished, she began to play a game, using an e-reader equipped with a touch screen. Which device did Ashlee NOT use in this scenario? • A smartphone • A laptop • A tablet • An integrated computer system RATIONALE Ashley used a cellular Android device (smartphone), an easy chair to play a game (integrated computer systems) and an e-reader with a touch screen (tablet). Ashley did not use a laptop. CONCEPT Types of Computers 10 Clay works for a company that has offices in major cities across the United States. His department regularly holds videoconferences with teams in the other branches. Which type of network does Clay's business most likely use for videoconferencing? • WAN • LAN • PAN • MAN RATIONALE Clay's business uses a wide area network (WAN) — a type of computer network that covers a large geographical area, such as an area that includes cities across the United States. The other network types listed are not suitable because their range is not large enough to connect locations across the country. CONCEPT Computer Network Types 11 Josephine recently bought an item online. The next time she visited the seller's website, a list of items related to her recent purchase were conspicuously displayed. Josephine is experiencing an example of automation known as __________. • online software application • automated billing • importing/exporting data • advertising and marketing RATIONALE Josephine is experiencing advertising and marketing. Most websites use historical data about user behavior to offer products that fit the user's preferences and needs. CONCEPT Process Automation and Computers 12 Which of the following correctly describes a record? • A record is a single database with a single table of information. • A record is referred to as a tuple. • A record contains only quantitative information. • A record appears as a column in a table. RATIONALE A record is a single row on a table in a database. A record contains the information about a particular item in the table. Records are also called tuples. CONCEPT Introduction to Databases 13 Sarah is creating custom reports from her company's database. Select the set of file types that Sarah will use to create these reports. • .csv and .pptx • .txt and .dat • .sql and .xml • .tif and .db RATIONALE The set of file types that Sarah will use to create these reports is .sql and .xml. CONCEPT Application Software File Types and Formats 14 Which productivity software is used to create tables from statistical data? • Google Docs • Microsoft Excel •