CIS UNIT 3 REVIEW Chauncey
Match the feasibility study on the left with its correct definition on the right 1. Economic feasibility 2. Operational feasibility 3. Schedule feasibility 4. Technical feasibility 5. Political feasibility 6. Legal Feasibility -Measures the cost-effectiveness of a project -Measures how well a solution meets the identified system requirements to solve the problems and take advantage of opportunities -Measures how well a solution can be implemented within existing legal and contractual obligations -Measures the practicality of a technical solution and the availability of technical resources and expertise -Measures the project time frame to ensure it can be completed on time
1. Measures the cost-effectiveness of a project 2.Measures how well a solution meets the identified system requirements to solve the problems and take advantage of opportunities 3.Measures the project time frame to ensure it can be completed on time 4.Measures the practicality of a technical solution and the availability of technical resources and expertise Political feasibility 5. Measures how well the solution will be accepted in a given organization 6.Measures how well a solution can be implemented within existing legal and contractual obligations
Match the cloud service delivery model on the left with its correct definition on the right. 1. Infrastructure as a Service 2. Software as a Service 3. Platform as a service - Offers applications on a pay-per-use basis - Offers computer hardware and networking equipment on a pay-per-use basis - Offers hardware, networking, and applications on a pay-per-use basis
1. Offers hardware, networking, and applications on a pay-per-use basis 2. Offers applications on a pay-per-use basis 3. Offers hardware, networking, and applications on a pay-per-use basis
What is a category of AI that attempts to emulate the way the human brain works? A. Neural network B. Genetic algorithm C. Virtual reality D. Expert system
A
What is a central location in which data is stored? A. repository B. data aggregation C. dirty data D. data warehouse
A
What is a collection of computers, often geographically dispersed, that are coordinated to solve a common problem? A. Grid computing B. Carbon emissions C. Moore's law D. Cloud computing
A
What is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks? A. Data warehouse B. Data-driven website C. Database D. Data dictionary
A
What is a model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction? A. Cloud computing B. Grid computing C. Virtualization
A
What is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information? A.Information cleansing B. Information inconsistency C. Information cube D. Information granularity
A
What is a special-purpose knowledge-based information system that accomplishes specific tasks on behalf of its users? A. Intelligent agent B. Digital dashboard C. Mutation
A
What is a technique for documenting the entities and relationships in a database environment? A. Entity-relationship diagram B. Single-valued attribute C. Multi-valued attribute
A
What is an old system that is fast approaching or beyond the end of its useful life within an organization? A. Legacy system B. Off-the-shelf application C. Conversion D. SDLC
A
What is assigned to an attribute when no other value applies or when a value is unknown? A. Null-valued attribute B. Multi-valued attribute C. Single-valued attribute
A
What is the common term for the representation of multidimensional information? A. cube B. dictionary C. circle D. box
A
What is the data elements associated with an entity? A. Attribute B. Key C. Entity D. Database
A
What makes system changes to repair design flaws, coding errors, or implementation issues? A. Corrective maintenance B. Preventive maintenance C. Waterfall methodology D. Scrum methodology
A
What provides additional functionality to the operating system? A. Utility software B. Operating system software C. Application software
A
What provides an end-to-end view of how operations work together to create a product or service? A. Systems thinking B. Production process C. Management information systems
A
What provides details about data? A. metadata B. data steward C. analytical data D. data validation
A
What simulates human thinking and behavior, such as the ability to reason and learn? A. Artificial intelligence B. Transaction processing systems C. Decision support systems
A
What stores information about a person, place, thing, transaction, or event? A. Entity B. Model C. Value D. Attribut
A
What supports general business processes and does not require any specific software customization to meet the organization's needs? A. Off-the-shelf application software B. Legacy software C. Customization software D. Conversion application software
A
Which phase brings all the project pieces together into a special testing environment to eliminate errors and bugs and verify that the system meets all the business requirements defined in the analysis phase? A. Testing phase B. Implementation phase C. Design phase D. Development phase
A
Which phase does the organization perform changes, corrections, additions, and upgrades to ensure the system continues to meet business goals? A.Maintenance phase B. Design phase C. Development phase D. Analysis phase
A
Which phase establishes a high-level plan of the intended project and determines project goals? A. Planning phase B. Development phase C. Design phase D. Analysis phase
A
Which phase establishes descriptions of the desired features and operations of the system, including screen layouts, business rules, process diagrams, pseudo code, and other documentation? A. Design phase B. Development phase C. Analysis phase D. Testing phase
A
Why does a database offer increased information security? A. Various security features of databases ensure that individuals have only certain types of access to certain types of information. B. Various security features of databases allow individuals access to all information contained in the database.
A
________ network is a category of AI that attempts to emulate the way the human brain works. A. Neural B. Genetic C. Expert D. Virtual
A
__________ software provides additional functionality to the operating system. A. Utility B. Application C. Operating
A
___________ allows more than one piece of software to be used at a time. A. Multitasking B. Operating C. Utility
A
___________ as a Service delivers applications over the cloud using a pay-per-use revenue model. A. Software B. Platform C. Infrastructure
A
Select the three benefits of cloud services. A. Improved accessibility B. Greater reliability C. Higher availability D. Less reliability E. Less efficient accessibility F. Lower availability
A, B , C
Select the two types of system software. A. Operating systems software B. Word processing software C. Utility software D. Spreadsheet software
A, C
Select the two types of system software. A. Operating systems software B. Word processing software C. Spreadsheet software D. Utility software
A, D
Match the production process on the left with the examples on the right. A. Input B. Process C. Output
A. Bun, patty, lettuce, tomato B. Cook the patty, wash and chop the lettuce C. A hamburger
Select the three components of a sustainable MIS infrastructure. A. Grid computing B. Ewaste computing C. Carbon computing D. Virtualized computing E. Cloud computing
A. Grid computing D. Virtualized computing E. Cloud computing
Match the form of application distributed method on the left with its definition on the right. A. Single user license B. Network user license C. Site license D. Application service provider license
A. Restricts the use of the software to one user at a time. Network user license(SINGLE USER LICENSE) B. Enables anyone on the network to install and use the software.(NETWORK USER LICENSE) C. Enables any qualified users within the organization to install the software, regardless of whether the computer is on a network. Some employees might install the software on a home computer for working remotely.(SITE LICENSE) D. Specialty software paid for on a license basis or per-use basis or usage-based licensing.(APPLICATION SERVICE PROVIDER LICENSE)
Select the five primary reasons project fail. A. Too much user participation B. The cost of finding errors C. Changing technology D. Misunderstanding of tangible benefits E. Unclear or missing business requirements F. Skipped SDLC phases G. Balance of the triple constraints
A. Unclear or missing B. Skipped SDLC phases C. Changing technology D. The cost of finding errors E. Balance of the triple constraints
Data __________ is the collection of data from various sources for the purpose of data processing.
Aggregation
Match the sustainable MIS infrastructure component on the left with the correct definition on the right. 1. Grid computing 2. Virtualization 3. Cloud computing - Creates multiple virtual machines on a single computing device. - A collection of computers, often geographically dispersed, that are coordinated to solve a common problem. - Stores, manages, and processes data and applications over the Internet rather than on a personal computer or server.
1. A collection of computers, often geographically dispersed, that are coordinated to solve a common problem. 2. Creates multiple virtual machines on a single computing device. 3. Stores, manages, and processes data and applications over the Internet rather than on a personal computer or server.
Match the cloud computing environment on the left with its correct example on the right. 1. Public cloud 2. Private cloud 3. Community cloud 4. Hybrid cloud - Bank of sensitive information - Cloud bursting - Amazon web service - All Colorado state government organizations
1. Amazon web service 2. Bank of sensitive information 3. All Colorado state government organizations 4. Community cloud
Select the correct definition on the right with the virtualization type on the left. 1. Storage virtualization 2. Network virtualization 3. Server virtualization - Combines networks by splitting the available bandwidth into independent channels that can be assigned in real time to a specific device. - Combines the physical resources, such as servers, processors, and operating systems, from the applications. - Combines multiple network storage devices so they appear to be a single storage device. Network virtualization
1. Combines multiple network storage devices so they appear to be a single storage device. 2. Combines networks by splitting the available bandwidth into independent channels that can be assigned in real time to a specific device. 3. Combines the physical resources, such as servers, processors, and operating systems, from the applications
Match the key term on the left with its correct definition on the right. 1. Variety 2. Veracity 3. Volume 4. Velocity
1. Different forms of structured and unstructured data 2. The uncertainty of data, including biases, noise, and abnormalities 3. The scale of data 4. The analysis of streaming data as it travels around the Internet
Select the statement below that accurately reflects a database. A. While a database has only one logical view, it can easily support multiple physical views that provides for flexibility B. While a database has only one physical view, it can easily support multiple logical views that provides for flexibility. C. A database has only one physical view and one logical view.
B
Software ____________ modifies software to meet specific user or business requirements. A. conditions B. customization C. conversion D. Scripting
B
The __________ phase establishes a high-level plan of the intended project and determines project goals. A. development B. planning C. testing D. design
B
The ____________ phase establishes descriptions of the desired features and operations of the system, including screen layouts, business rules, process diagrams, pseudo code, and other documentation. A. development B. design C. testing D. analysis
B
The ____________ view of information deals with the physical storage of information on a storage device. A. primary B. physical C. foreign D. logical
B
The project __________ is a formal, approved document that manages and controls the entire project. A. phase B. plan C. manager D. scope
B
What are difficult to quantify or measure? A. Operational feasibility B. Intangible benefits C. Tangible benefits D. Technical feasibility
B
What are rules that help ensure the quality of information? A. Data-driven constraint B. Integrity constraints C. Static information D. Dynamic information
B
What are various commercial applications of artificial intelligence? A. Transaction processing systems B. Intelligent systems C. Decision support systems
B
What contains a subset of data warehouse information? A. Data website B. Data mart C. Data warehouse D. Data mining tools
B
What controls how the various technology tools work together along with the application software? A. Utility software B. System software C. Application software
B
What creates, reads, updates, and deletes data in a database while controlling access and security? A. Single-valued attribute B. Database management system C. Null-valued attribute D. Business rule
B
What is 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? A. information integrity B. identity management C. information latency D. data latency
B
What is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables? A. Data element B. Foreign key C. Primary key D. Data dictionary
B
What is a technique for documenting the entities and relationships in a database environment? A. Multi-valued attribute B. Entity-relationship diagram C. Single-valued attribute
B
What is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem? A. Virtual reality B. Genetic algorithm C. Expert system D. Neural network
B
What is composed of rows and columns that represent an entity? A. Relationship B. Table C. Field D.Key
B
What is the measure of the tangible and intangible benefits of an information system? A. Tangible benefits B. Feasibility C. Intangible benefits
B
What is the process of managing changes to the business requirements throughout the project? A. Computer-aided software engineering B. Requirements management C. User documentation D. Requirements definition document
B
What is the set of instructions the hardware executes to carry out specific tasks? A. Hardware B. Software C. Telecommunications
B
What occurs between two entities in which an instance of one entity is related to many instances of another and one instance of the other can be related to many instances of the first entity? A. One-to-many relationship B. Many-to-many relationship C. One-to-one relationship
B
What stores information in the form of logically related two-dimensional tables? A. Structured query language B. Relational database model C. Metadata D. Data dictionary
B
Which is included in feedback for a car's system? A. Seatbelt B. Gas Level C. Steering Wheel D. Door
B
Which phase takes all the detailed design documents from the design phase and transforms them into the actual system? A. Testing phase B. Development phase C. Maintenance phase D. Implementation phase
B
________ benefits are easy to quantify and typically measured to determine the success or failure of a project. A. Intangible B. Tangible C. Feasibility
B
________ computing is a collection of computers, often geographically dispersed, that are coordinated to solve a common problem. A. Cloud B. Grid C. Carbon
B
_________ benefits are difficult to quantify or measure. A. Tangible B. Intangible C. Deliverable D. Feasibility
B
_________ software is used for specific information processing needs, including payroll, customer relationship management, project management, training, and many others. A. Operating B. Application C. Utility
B
____________ expresses the specific number of instances in an entity. A. Relationship B. Cardinality C. Composite
B
____________ maintenance makes system changes to repair design flaws, coding errors, or implementation issues. A. Phased B. Corrective C. Preventive D. Pilot
B
____________ management is the process of managing changes to the business requirements throughout the project. A. Test B. Requirements C. Agent D. Software
B
____________-tenancy implies that each customer or tenant must purchase and maintain an individual system. A. Utility B. Single C. Multi
B
Select two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete information. A. Information key B. Information cleansing C. Information cube D. Information integrity E. Information scrubbing
B,E
What is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse? A. Business critical integrity constraints B. Extraction, transformation, and loading C. Relational database transformation
B.
A data _______ contains a subset of data warehouse information. A. mine B. warehouse C. mart
C
A(n) ___________ is a temporary activity a company undertakes to create a unique product, service, or result. A. methodology B. requirement C. project D. condition
C
In which phase does the firm analyzes its end-user business requirements and refines project goals into defined functions and operations of the intended system? A. Planning phase B. Design phase C. Analysis phase D. Testing phase
C
Information _________ is a measure of the quality of information. A. keys B.view C. integrity
C
Management ________ systems is a business function, like accounting and human resources, which moves information about people, products, and processes across the company to facilitate decision making and problem solving. A. intelligence B. innovation C. information
C
One primary goal of a database is to eliminate information redundancy by recording each piece of information in _______ place(s) in the database. A. several B. two C. only one
C
Question multiple choice A(n) __________ database management system allows users to create, read, update, and delete data in a relational database. A. network B. hierarchical C. relational
C
What controls how the various technology tools work together along with the application software? A.Application software B. Utility software C. System software
C
What controls the application software and manages how the hardware devices work together? A. Utility software B. Application software C. Operating system software
C
What delivers applications over the cloud using a pay-per-use revenue model? A. Infrastructure as a Service B. Platform as a Service C. Software as a Service
C
What describes the business need (the problem the project will solve) and the justification, requirements, and current boundaries for the project? A. Project manager B. Project plan C. Project scope D. Project management
C
What expresses the specific number of instances in an entity? A. Primary key B. Composite entities C. Cardinality
C
What is a business function, which moves information about people, products, and processes across the company to facilitate decision making and problem solving? A. Accounting and finance B. Human resources C. Management information systems D. Operations management
C
What is a central location in which data is stored? A. repository B. dirty data C. data warehouse D. data aggregation
C
What is a collection of related data elements? A. Field B. Table C. Record D. Key
C
What is a facility used to house management information systems and associated components, such as telecommunications and storage systems? A. Iaas B. Grid computing C. Data center D. Virtualization
C
What is a field that uniquely identifies a given record in a table? A. Structured query language B. Data dictionary C. Primary key D. Foreign key
C
What is a way of monitoring the entire system by viewing multiple inputs being processed or transformed to produce outputs while continuously gathering feedback on each part? A. Management information systems B. Production process C. Systems thinking
C
What is information that returns to its original transmitter (input, transform, or output) and modifies the transmitter's actions? A. Systems B. Productivity C. Feedback
C
What is the duplication of data, or the storage of the same data in multiple places? A. Information integrity B. Logical view of information C. Information redundancy D. Information granularity
C
What is the overall process for developing information systems, from planning and analysis through implementation and maintenance? A.Extreme programming methodology B. Off-the-shelf application software C. Systems development life cycle D. Rational unified process methodology
C
What is the process of transferring information from a legacy system to a new system? A.Brainstorming B. Off-the-shelf application C. Conversion D. Software customization
C
What is the time it takes for data to be stored or retrieved? A. information redundancy B. information integrity C. data latency D. business rule
C
What means having only a single value of each attribute of an entity? A. Relational database model B. Multi-valued attribute C. Single-valued attribute D. Composite entity
C
What occurs between two entities in which an instance of one entity can be related to many instances of a related entity? A. One-to-one relationship B. Many-to-many relationship C. One-to-many relationship
C
What occurs when an instance of one entity can be related to only one instance of a related entity? A. Many-to-many relationship B. One-to-many relationship C. One-to-one relationship
C
What provides an end-to-end view of how operations work together to create a product or service? A. Management information systems B. Production process C. Systems thinking
C
Which phase does the organization perform changes, corrections, additions, and upgrades to ensure the system continues to meet business goals? A. Maintenance phase B. Design phase C. Development phase D. Analysis phase
C
Who is an individual who is an expert in project planning and management, defines and develops the project plan, and tracks the plan to ensure the project is completed on time and on budget? A. Change agent B. Executive sponsor C. Project manager D. Business analyst
C
_________ intelligence simulates human thinking and behavior, such as the ability to reason and learn. A. Executive B. Decision C. Artificial
C
_________ scaling means the MIS infrastructure can be automatically scaled up or down based on needed requirements A. Cloud B. Grid C. Dynamic D. Utility
C
_________ system software controls the application software and manages how the hardware devices work together. A. Application B. Utility C. Operating
C
__________ -the-shelf application software supports general business processes and does not require any specific software customization to meet the organization's needs. A. Conversion B. Customization C. Off
C
___________, transformation, and loading is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse. A. Dynamic B. Existing C. Extraction
C
_____________ computing is a model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction.
Cloud
A(n) _________ (one word) is the common term for the representation of multidimensional information.
Cube
A(n) _________ system is an old system that is fast approaching or beyond the end of its useful life within an organization. A. pilot B. phased C. conversion D. legacy
D
Integrity __________ are rules that help ensure the quality of information. A. issues B. data C. classification D. constraints
D
Select the statement that accurately defines the relationship between entities and attributes in a relational database. A. Each key in an entity occupies one row in its respective table. B. Each record in an entity occupies multiple rows in its respective table. C. Each record in an attribute occupies one row in its respective table. D. Each attribute of an entity occupies a separate column of a table.
D
The project _________ describes the business need (the problem the project will solve) and the justification, requirements, and current boundaries for the project. A. phase B. plan C. manager D. scope
D
What are easy to quantify and typically measured to determine the success or failure of a project? A. Moore's law B. Feasibility C. Intangible benefits D. Tangible benefitS
D
What defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer? A. Information rule B. Business key C. Critical rule D. Business rule
D
What focuses on how individual users logically access information to meet their own particular business needs? A. Primary view of information B. Foreign view of information C. Physical view of information D. Logical view of information
D
What implies that each customer or tenant must purchase and maintain an individual system? A. PaaS B. Multi-tenancy C. Cloud fabric D. Single-tenancy
D
What is a formal, approved document that manages and controls the entire project? A. Project manager B. Project development C.Project scope D. Project plan
D
What is a measure of the quality of information? A. Relational integrity constraints B. Business rule C. Business-critical Integrity constraints D. Information integrity
D
What is a temporary activity a company undertakes to create a unique product, service, or result. A. Business requirement B. Waterfall methodology C. Fourth-generation language D. Project
D
What is the collection of data from various sources for the purpose of data processing? A. dirty data B. data repository C. data cleansing D. data aggregation
D
What is the rate at which goods and services are produced based upon total output given total inputs? A. System B. Input C. Production D. Productivity
D
What makes system changes to reduce the chance of future system failure? A. Plunge implementation B. Parallel implementation C. Corrective maintenance D. Preventive maintenance
D
What means having the potential to contain more than one value for an attribute? A. Single-valued attribute B. Composite attribute C. Null-valued attribute D. Multi-valued attribute
D
What modifies software to meet specific user or business requirements? A. Scrum methodology B. Legacy system C. Off-the-shelf application D. Software customization
D
What stores information about a person, place, thing, transaction, or event? A. Value B. Attribute C. Model D. Entity
D
Which system allows users to create, read, update, and delete data in a relational database? A. Structured query language B. Data-driven website C. Real-time systems D. Relational database management system
D
___________ is the process of transferring information from a legacy system to a new system. A. Brainstorming B. Change C. Customization D. Conversion
D
Select the four things a database management system (DBMS) can perform on data in a database while controlling access and security. A. Read B. Engineer C. Override D. Create E. Delete F. Update G. Integrate
D, A, F, E
Select the two types of application software. A. Operating system software B. Spreadsheet software C. Utility software D. Word processing software
D, B
Select the two types of application software. A. Operating system software B. Utility software C. Spreadsheet software D. Word processing software
D, C
_________ algorithm is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem. A. General B. Neural C. Fuzzy D. Genetic
D.
A (virtual) ___________ center is a facility used to house management information systems and associated components, such as telecommunications and storage systems.
Data
Who extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information?
Data Scientist
Select the three accurate statements reflecting the business advantages of a relational database. A. Reduced flexibility B. Increased information redundancy C. Increased information security D. Increased information integrity E. Reduced information redundancy F. Reduced information integrity
E C D
___________ data is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value.
Fast
What is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?
Fast Data
A(n) _________ is a characteristic of a table.
Field
___________________ management is 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.
Identity
__________ systems are various commercial applications of artificial intelligence.
Intelligent
Data ____________ is the time it takes for data to be stored or retrieved.
Latency
A(n) _______________-to-many relationship is between two entities in which an instance of one entity is related to many instances of another and one instance of the other can be related to many instances of the first entity.
Many
___________________ (one word) provides details about data.
Metadata
_____________-valued attribute means having the potential to contain more than one value for an attribute
Multi
__________ -valued attribute is assigned to an attribute when no other value applies or when a value is unknown.
Null
A(n)_____________ -to-one relationship is between two entities in which an instance of one entity can be related to only one instance of a related entity.
One
Productivity is the _____________ at which goods and services are produced based upon total output given total inputs.
Rate
Productivity is the ______________ at which goods and services are produced based upon total output given total inputs.
Rate
A(n) ____________ is a central location in which data is stored.
Repository
A data __________ extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information
Scientist
____________-valued attribute means having only a single value of each attribute of an entity.
Single
What is the set of instructions the hardware executes to carry out specific tasks?
Software
___________ is the set of instructions the hardware executes to carry out specific tasks.
Software
______________ is the set of instructions the hardware executes to carry out specific tasks.
Software
The _________________ development life cycle is the overall process for developing information systems, from planning and analysis through implementation and maintenance.
System
_____________ software controls how the various technology tools work together along with the application software.
System
________________ software controls how the various technology tools work together along with the application software.
System
Data ____________ is the collection of data from various sources for the purpose of data processing.
aggregation
What deals with the physical storage of information on a storage device? A. Physical view of information B. Structured query language C. Logical view of information
A
Match the system implementation method on the left with its correct definition on the right. -Parallel Implementation -Plunge Implementation -Pilot Implementation -Phased Implementation - Uses both the legacy system and new system until all users verify that the new system functions correctly -Discards the legacy system and immediately migrates all users to the new system -Assigns a small group of people to use the new system until it is verified that it works correctly; then the remaining users migrate to the new system -Installs the new system in phases (for example, by department) until it is verified that it works correctly
1. Parallel Implementation- Uses both the legacy system and new system until all users verify that the new system functions correctly 2. Plunge Implementation- Discards the legacy system and immediately migrates all users to the new system 3. Pilot Implementation- Assigns a small group of people to use the new system until it is verified that it works correctly; then the remaining users migrate to the new system 4. Phased Implementation- Installs the new system in phases (for example, by department) until it is verified that it works correctly
Place the phases in the systems development life cycle in the correct order. Implication/Maintenance Testing Planning Design Analysis Development
1. Planning 2. Analysis 3. Design 4. Development 5. Testing 6. Implementation/Maintenance
Match the benefits on the right with its correct type on the left 1. Tangible benefits 2. Tangible benefits 3. Tangible benefits 4. Intangible benefits 5. Intangible benefits 6. Intangible benefits -Increase Quality -Improve morale - Decrease expenses - Improve goodwill - Decrease response time -Improve decision making
1. Tangible benefits - Decrease expenses 2. Tangible benefits- Decrease response time 3. Tangible benefits- Increase quality 4. Intangible benefits- Improve decision making 5. Intangible benefits- Improve morale 6. Intangible benefits- Improve goodwill
Match the cloud computing benefit on the left with the correct reason for the benefit on the right. 1. On-demand self-service 2 Broad network access. 3. Multi-tenancy 4. Rapid elasticity 5. Measured service -Customers share pooled computing resources -All devices can access data and applications -Storage, network bandwidth, and computing capacity can be increased or decreased immediately, allowing for optimal scalability -Users can increase storage and processing power as needed -Clients can monitor and measure transactions and use of resources
1. Users can increase storage and processing power as needed 2. All devices can access data and applications 3. Customers share pooled computing resources Rapid elasticity 4. Storage, network bandwidth, and computing capacity can be increased or decreased immediately, allowing for optimal scalability Measured service 5. Clients can monitor and measure transactions and use of resources
Match the words with its definition. 1. Inconsistent Data Definitions 2. Lack of Data Standards 3. Poor Data Quality 4. Inadequate Data Usefulness 5. Ineffective Direct Data Access
1.Every department had its own method for recording data so when trying to share information, data did not match and users did not get the data they really needed. 2.Managers need to perform cross-functional analysis using data from all departments, which differed in granularities, formats, and levels. Poor Data Quality 3.The data, if available, were often incorrect or incomplete. Therefore, users could not rely on the data to make decisions 4.Users could not get the data they needed; what was collected was not always useful for intended purposes. 5. Most data stored in operational databases did not allow users direct access; users had to wait to have their queries or questions answered by MIS professionals who could code SQL
A data ________ is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks. A. warehouse B. dictionary C. website
A
A(n) ______ agent is a special-purpose knowledge-based information system that accomplishes specific tasks on behalf of its users. A. intelligent B. shopping C. virtual
A
A(n) ________ key is a field (or group of fields) that uniquely identifies a given record in a table. A. primary B. foreign C. secondary
A
A(n) _________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer. A. business B. content C. relational
A
A(n) ___________ is the data elements associated with an entity. A. attribute B. key C. entity D. database
A
A(n) ___________ stores information about a person, place, thing, transaction, or event. A. entity B. key C. relationship D. attribute
A
A(n) entity-relationship __________ is a technique for documenting the entities and relationships in a database environment. A. diagram B. key C. value D. data
A
A(n) entity-relationship __________ is a technique for documenting the entities and relationships in a database environment. A. diagram B. value C. data D. key
A
In the __________ phase the firm analyzes its end-user business requirements and refines project goals into defined functions and operations of the intended system. A. analysis B. planning C. development D. design
A
The __________ view of information focuses on how individual users logically access information to meet their own particular business needs. A. logical B.primary C. physical D. foreign
A
True or false: Business-critical integrity constraints tend to mirror the very rules by which an organization achieves success. A. True B. False
A
True or false: Databases today scale to exceptional levels, allowing all types of users and programs to perform information processing and information-searching tasks. A. True B. False
A
What allows more than one piece of software to be used at a time? A. Multitasking B. Dual boot C. Embedded operating system
A
What are the specific business requests the system must meet to be successful, so the analysis phase is critical because business requirements drive the entire systems development effort? A. Business requirements B. Project scope C. Scripting languages D. Testing conditions
A
What controls how the various technology tools work together along with the application software? A. System software B. Application software C. Utility software
A
What controls the application software and manages how the hardware devices work together? A. Operating system software B. Application software C. Utility software
A
What creates, reads, updates, and deletes data in a database while controlling access and security? A. Database management system B. Single-valued attribute C. Business rule D. Null-valued attribute
A
Match the testing type on the left with its correct definition on the right. Alpha Testing Development Testing Integration Testing System Testing User Acceptance Testing (UAT) Unit Testing -Assess if the entire system meets the design requirements of the users -Test the system to ensure it is bug-free Integration Testing -Verify that separate systems can work together, passing data back and forth correctly -Verify that the units or pieces of code function correctly when integrated -Determine if the system satisfies the user and business requirements -Test individual units or pieces of code for a system
Alpha - Assess if the entire system meets the design requirements of the users Development Testing - Test the system to ensure it is bug-free Integration Testing Integration Testing- Verify that separate systems can work together, passing data back and forth correctly System Testing- Verify that the units or pieces of code function correctly when integrated User Acceptance Testing (UAT)- Determine if the system satisfies the user and business requirements Unit Testing- Test individual units or pieces of code for a system
A data ____________ is a business analytics specialist who uses visual tools to help people understand complex data.
Artist
A data ____________ compiles all of the metadata about the data elements in the data model. A. element B. dictionary C. model D. query
B
A project ____________ is an individual who is an expert in project planning and management, defines and develops the project plan, and tracks the plan to ensure the project is completed on time and on budget. A. analyst B. manager C. agent D. executive
B
A(n) _________ is a collection of related data elements. A. field B. record C. table
B
A(n) __________ key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. A. data B. foreign C. secondary D. primary
B
Business __________ are the specific business requests the system must meet to be successful, so the analysis phase is critical because business requirements drive the entire systems development effort. A. development B. requirements C. conditions D. scripting
B
In the ____________ phase, the organization places the system into production so users can begin to perform actual business operations with it. A. maintenance B. implementation C. testing D. development
B
In which phase does the organization place the system into production so users can begin to perform actual business operations with it? A. Development phase B. Implementation phase C. Design phase D. Analysis phase
B
Information __________ is the duplication of data, or the storage of the same data in multiple places. A. granularity B. redundancy C. integrity
B
