WGU C954 COMPREHENSIVE INFORMATION TECHNOLOGY MANAGEMENT 2025|2026 REVISION QUESTIONS AND VERIFIED ANSWERS

WGU C954 COMPREHENSIVE INFORMATION TECHNOLOGY MANAGEMENT 2025|2026 REVISION QUESTIONS AND VERIFIED ANSWERS database - Answer maintains info about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) database management system (DBMS) - Answer creates, reads, updates, and deletes data in a database while controlling access and security query by example tool (QBE) - Answer help users graphically design the answer to a question against a database structures query language - Answer users write lines of code to answer questions against a database data model - Answer logical data structures that detail the relationships among data elements using graphics or pictures metadata - Answer details about data relational database model - Answer type of database that stores info in the form of logically related two dimensional tables entity - Answer stores information about a person, place, thing, transaction, or event attribute - Answer the data elements associated with an entity record - Answer collection of related data elements primary key - Answer a field (or group of fields) that uniquely identifies a given entity in a table foreign key - Answer primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables physical view of information - Answer the physical storage of information on a storage device such as a hard disk logical view of information - Answer focuses on how users logically access info to meet their particular business needs data latency - Answer time it takes data to restored or retrieved information redundancy - Answer duplication of data, or the storage of the same data in multiple places information integrity - Answer measure of the quality of information integrity constraint - Answer rules that help ensure the quality of info relational integrity constraint - Answer rules that enforce basic and fundamental info based constraints business critical integrity constraint - Answer enforces business rules vital to an organization's success and often requires more insight and knowledge than a relational integrity constraints identity management - Answer a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity data driven website - Answer interactive website kept constantly updated and relevant to the needs of its customers through the use of a database static information - Answer data driven website dynamic information - Answer includes data that change based on user actions dynamic catalog - Answer an area of a website that stores information about products in a database forward integration - Answer takes info entered into a given system and sends it automatically to all downstream systems and processes backward integration - Answer takes information entered into a given system and sends it automatically to all upstream systems and processes data element or data field - Answer the smallest or basic unit of information data dictionary - Answer compiles all of the metadata about the data elements in the data model integration - Answer allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems A company has tasked the IT manager with installing communication e-business tools. Which unified communication component will provide real-time responses? A. Email B. Webinar C. Instant messaging D. Podcasting - Answer C. Instant messaging A company needs to manage the creation, storage, editing, and publication of its website content. It needs a tool that includes web-based publishing, search, navigation, and indexing to organize information. Which tool should the company use? A. Customer relationship management B. Enterprise resource planning C. IT incident management D. Content management system - Answer D. Content management system Which software allows a company to track its end users' shopping and buying behaviors to help increase loyalty, retention, and profits? A. Customer relationship management B. Content management system C. Enterprise resource planning D. Suite ticketing - Answer A. Customer relationship management A marketing department has a goal to increase customer satisfaction. Which two primary operational customer relationship management (CRM) technologies can help achieve this goal? Choose 2 answers. A. List generator B. Cross-selling or upselling C. Uplift modeling D. Data mining - Answer A. List generator B. Cross-selling or upselling What is used in IT to identify and analyze daily business activities such as payroll? A. Executive information systems B. Managerial support systems C. Transaction processing systems D. Decision support systems - Answer C. Transaction processing systems A company wants to bring production closer to customers, eliminating steps in the supply chain by using inexpensive types of hardware business tools. Which item best promotes mass customization, small production batches, and consumable inventory and also allows customer feedback? A. RFID tags B. Drones C. Robotics D. 3D printers - Answer D. 3D printers What are two core components of enterprise resource planning (ERP)??Choose 2 answers. A. Accounting B. Business intelligence C. Finance D. Customer relationship management - Answer A. Accounting C. Finance What are two extended enterprise resource planning (ERP) components???Choose 2 answers. A. Accounting B. Business intelligence C. Finance D. Customer relationship management - Answer B. Business intelligence D. Customer relationship management What is a function of analytical customer relationship management (CRM)? A. It supports back-office operations and strategic analysis, and it includes all systems that do not deal directly with the customers. B. It is used to create list generators, manage campaigns, and aid in cross-selling and upselling. C. It supports traditional transactional processing for day-to-day front-office operations or systems that deal directly with the customers. D. It connects disparate systems. - Answer A. It supports back-office operations and strategic analysis, and it includes all systems that do not deal directly with the customers. Organizations are discovering a wave of other key business areas where it is beneficial to take advantage of building strong relationships. Which emerging areas in customer relationship management (CRM) include other relationship management tools? A. Supplier relationship management (SRM), partner relationship management (PRM), and employee relationship management (ERM) B. Stable relationship management (SRM), permanent relationship management (PRM), and existing relationship management (ERM) C. Collaborative relationship management (CRM), data relationship management (DRM), and analysis relationship management (ARM) D. Relationship integration set (RIS), data relationship management (DRM), and relationship transaction processing (RTP) - Answer A. Supplier relationship management (SRM), partner relationship management (PRM), and employee relationship management (ERM) Why would a project require an executive sponsor according to the Project Management Institute (PMI)? A. To communicate project information to stakeholders B. To provide financial resources for a project C. To define specifications for the product or output of the project and to manage scope D. To define all project roles and responsibilities - Answer B. To provide financial resources for a project What is a program evaluation and review technique (PERT) chart? A. A graphical network model that depicts a project's tasks and the relationships between those tasks B. A simple bar chart that lists project tasks vertically against the project's time frame, listed horizontally C. A trigger that enables a project manager to close a project prior to completion D. The longest stretch of dependent activities, measuring these activities from start to finish - Answer A. A graphical network model that depicts a project's tasks and the relationships between those tasks Which factor is a primary reason for project failure? A. Lack of capital B. Faulty data C. The balance of the triple constraints D. Mishandled debt - Answer C. The balance of the triple constraints What is agile methodology? A. A sequence of phases in which the output of each phase becomes the input for the next B. A methodology that aims for customer satisfaction through early and continual delivery of useful software components developed by an iterative process with a design point that uses the bare minimum requirements C. A methodology that emphasizes extensive user involvement in the rapid and evolutionary construction of working prototypes of a system to accelerate the systems development process D. A set of policies, procedures, standards, processes, practices, tools, techniques, and tasks that people apply to technical and management challenges - Answer B. A methodology that aims for customer satisfaction through early and continual delivery of useful software components developed by an iterative process with a design point that uses the bare minimum requirements What is waterfall methodology? A. A methodology that emphasizes extensive user involvement in the rapid and evolutionary construction of working system prototypes to accelerate the systems development process B. A methodology that uses small teams to produce small pieces of deliverable software using sprints or 30-day intervals that achieve an appointed goal C. A methodology that aims for customer satisfaction through early and continual delivery of useful software components developed by an iterative process with a design point that uses the bare minimum requirements D. A sequence of phases in which the output of each phase becomes the input for the next - Answer D. A sequence of phases in which the output of each phase becomes the input for the next What is the systems development life cycle (SDLC)? A. The overall process for developing information systems, from planning and analysis through implementation and maintenance B. Software that supports general business processes and does not require any specific software customization to meet the organization's needs C. The set of detailed steps a system must perform along with the expected results of each step D. A set of best practices that helps an organization maximize the benefits of an information system while also establishing appropriate controls to ensure minimum errors - Answer A. The overall process for developing information systems, from planning and analysis through implementation and maintenance What is the definition of project scope? A. A list that prioritizes all the business requirements by order of importance to the company B. The need, justification, requirements, and current boundaries for a project C. The overall process for developing information systems, from planning and analysis through implementation and maintenance D. Information that highlights how to use a system and troubleshoot issues or problems - Answer B. The need, justification, requirements, and current boundaries for a project What is a value chain analysis? A. The process of gathering information about the competitive environment, including competitors' plans, activities, and products, to improve a company's ability to succeed B. A task at the bottom of the value chain, including business processes that acquire raw materials and then manufacture, deliver, market, sell, and provide after-sales services C. A standardized set of activities that accomplish a specific task, such as processing a customer's order D. A business tool that views a firm as a series of business processes that add value to a product or service - Answer D. A business tool that views a firm as a series of business processes that add value to a product or service What is the definition of Porter's three generic strategies? A. A business strategy involving methods that are neither organization- nor industry-specific and can be applied to any business, product, or service B. A standardized set of activities that accomplish a specific task, such as processing a customer's order C. A task at the bottom of the value chain, including business processes that acquire raw materials and manufacture, deliver, market, sell, and provide after-sales services D. The process of gathering information about the competitive environment, including competitors' plans, activities, and products, to improve a company's ability to succeed - Answer A. A business strategy involving methods that are neither organization- nor industry-specific and can be applied to any business, product, or service What is an assessment of the competitive forces within the environment in which a company operates to evaluate the potential for profitability in an industry? A. SWOT analysis B. Value chain analysis C. Porter's five forces model D. Competitive intelligence - Answer C. Porter's five forces model What is a SWOT analysis? A. A business tool that views a firm as a series of business processes that add value to a product or service B. An assessment of t