WGU D075 Information Technology (Learning Checks and Quizes And Ans)2022

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