INFORMATION TECHNOLOGY MANAGEMENT ESSENTIALS - D075 QUESTIONS WITH CORRECT ANSWERS

Which type of computer runs a network operating system (NOS)? CORRECT ANSWER A server Which type of software is designed to easily generate Gantt charts? CORRECT ANSWER Project management software What term refers specifically to the physical aspects of a computer such as circuit boards, processor chips, memory, and keyboards? CORRECT ANSWER Hardware Which application software features tables, records, and fields that can be queried, updated, and managed by users, programmers, and business analysts? CORRECT ANSWER Database software Which term refers to any person in a business who uses a computer to complete their day to day tasks of the business? CORRECT ANSWER End-users What is the main purpose of a firewall? CORRECT ANSWER To prevent unauthorized users from accessing the network. 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? CORRECT ANSWER Computer System Administrator 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? CORRECT ANSWER Local area network (LAN) What term refers to the study, design, development, implementation, support, and management of computer-based information systems? CORRECT ANSWER Information Technology 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? CORRECT ANSWER Phishing A data analyst is working with a very large set of data and trying to calculate the amount of data processing that needs to be completed each week. Which attribute of big data is this analyst addressing? CORRECT ANSWER Velocity ** relates to how many data are presented that need to be stored or processed over a given time period. Which tool allows large data sets to be stored and processed across multiple servers? CORRECT ANSWER Hadoop **an infrastructure for storing and processing large sets of data across multiple servers. Which term is used to refer to the process of combining structured, unstructured, and semi structured data into a data warehouse structure? CORRECT ANSWER Data scrubbing **The process of combining structured, unstructured, and semi-structured data into a data warehouse structure is referred to as "scrubbing" data. Which technique is used to ensure data accuracy for a mailing campaign? CORRECT ANSWER Segmentation An analyst at a furniture company wants to use the company's relational database to find out which customers have made purchases in the past six months. What is an appropriate tool for the data analyst to use to find this information? CORRECT ANSWER SQL **is used to perform queries within a database. 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? CORRECT ANSWER Intranet 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? CORRECT ANSWER Rapid system scalability What did the Sarbanes-Oxley Act of 2002 require of IT departments in American companies? CORRECT ANSWER Record and preserve accounting records Which aspect of human resource management is the responsibility of an IT department? CORRECT ANSWER Administration of information on employees Which technology is a critical component of customer relationship management (CRM) systems? CORRECT ANSWER The database 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? CORRECT ANSWER Tactical decisions