CIS Unit 3

Ace your homework & exams now with Quizwiz!

Match the reasons why business analysis is difficult using operational databases on the left with their correct explanations on the right. (EMTUM) 1. Inconsistent Data Definitions matches 2. Lack of Data Standards 3. Poor Data Quality 4. Inadequate Data Usefulness 5. Ineffective Direct Data Access

1. Inconsistent Data Definitions matches 1 A: 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. Lack of Data Standards 2 A: MANAGERS need to perform cross-functional analysis using data from all departments, which differed in granularities, formats, and levels. 3. Poor Data Quality 3 A: THE DATA, if available, were often incorrect or incomplete. Therefore, users could not rely on the data to make decisions. 4. Inadequate Data Usefulness 4 A: USERS could not get the data they needed; what was collected was not always useful for intended purposes. 5. Ineffective Direct Data Access 5 A: 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.

Which of the following database systems use SQL (select all that are true).

1. Oracle Database 2. Microsoft SQL server 3. PostgresSQL 4. MySQL

If a process changes, which of these may also need changing depending on the desired benefit? 1. Barrier 2. Tool 3. Input

All of them.

Which of the following are true about Algorithms.

- An Algorithm is a method for doing something. - An Algorithm is a list of steps to follow (a well defined procedure or formula) in order to solve a problem.

Match the benefits on the right with its correct type on the left. - Tangible benefits - Tangible benefits - Tangible benefits - Intangible benefits - Intangible benefits - Intangible benefits

- Decreased expenses - Decreased response time - Increased quality - Improved decision making - Improved morale - Improved goodwill

Which of these properly charcterize the AI landscape?

- Machine Learning is a subset of Artificial Intelligence. - Deep Learning is a subset of Machine Learning.

Which of the following are common SQL commands?

- SELECT - FROM - WHERE

Which of the following are true statements about Functions in R?

- The expressions (commands of logic) for a function are typically contained within braces {} - Functions have to be defined before they can be used.

Match the sustainable MIS infrastructure component on the left with the correct definition on the right. 1. Grid computing 2. Virtualized 3. Cloud Computing

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 testing type on the left with its correct definition on the right. 1. Alpha Testing 2. Development Testing 3. Integration Testing 4. System Testing 5. User Acceptance Testing (UAT) 6. Unit Testing

1. ASSESS if the entire system meets the design requirements of the users 2. TEST the SYSTEM to ensure it is bug-free 3. VERIFY that SEPARATE SYSTEM can work together, passing data back and forth correctly 4. VERIFY that the UNITs or PIECEs of code function correctly when integrated 5. DETERMINE if the system satisfies the user and business requirements 6. Test INDIVIDUAL units or pieces of code for a system

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

1. Amazon Web Services 2. Bank of sensitive information 3. All Colorado state government organizations 4. Cloud bursting

Which of the following are advantages of Bitcoin

1. Any well-connected node in the Bitcoin blockchain can determine, with certainty, whether a transaction does or does not exist in the data set. 2. A prohibitively high cost to attempt to rewrite or alter transaction history

Systems Thinking recognizes the role of Barriers and Tools. 1. Something that holds a process back is a ____. 2. Something that helps a process move forward is a _____.

1. Barrier 2. Tool

Select the correct definition on the right with the virtualization type on the left. 1. Storage virtualization 2. Network virtualization 3. Server 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.

Select the three components of a sustainable MIS infrastructure. Grid computing Cloud computing Carbon computing Virtualized computing Ewaste computing

1. Grid Computing 2. Cloud Computing 3. Virtualized Computing

------- is a distributed ledger that provides a way for information to be recorded and shared by a community.

Blockchain

A doctor notices that a patient is due for a certain medical procedure or test. The doctor initiates a transaction marked with the patient's unique digital identity within the individual's ______ wallet.

Blockchain

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?

Business Requirements

____________ EXPRESSES the SPECIFIC NUMBER of instances in an entity.

Cardinality

Module --------- 9a

Chp. 6 Business Intelligence

MODULE ------- 8A

Chp. 6 Structuring and Storing Data

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?

Cloud Computing

Integrity __________ are rules that help ensure the quality of information.

Constraints (Integrity Constraints)

What is the PROCESS of TRANSFERRING information from a legacy system to a new system?

Conversion

___________ is the PROCESS of TRANSFERRING information from a legacy system to a new system.

Conversion

____________ Maintenance makes system changes to repair design flaws, coding errors, or implementation issues.

Corrective (Maintenance)

What makes system changes to repair design flaws, coding errors, or implementation issues?

Corrective Maintenance

Select the four functions that a Database Management System(DBMS) can perform on data in a Database? - Duplicate data - Read data - Forecast data - Delete data - Update data - Govern data - Cluster data - Create data

Create data Read data Update data Delete data

Bitcoin uses encryption to maintain the integrity of transactions, which is why it is called a ________________.

Cryptocurrency

What is the common term for the representation of multidimensional information?

Cube

Software ____________ MODIFIES SOFTWARE to meet specific user or business requirements.

Customization (Software Customization)

A(n) (virtual) ------ center is a facility used to house management information systems and associated components, such as telecommunications and storage systems.

Data (Center)

What is the collection of data from various sources for the purpose of data processing?

Data Aggregation

Who is a business analytics specialist who uses visual tools to help people understand complex data?

Data Artist

What is a facility used to house management information systems and associated components, such as telecommunications and storage systems?

Data Center

Select the two terms representing the smallest or basic unit of information. Data dictionary Data-driven website Data element Data field

Data Element Data Field

What contains a subset of data warehouse information?

Data Mart

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

What is a Logical Collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks?

Data Warehouse

What compiles all of the metadata about the data elements in the data model?

Data dictionary

What maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)?

Database

MODULE ---------- 11a - - -

Database Basics - - -

What creates, reads, updates, and deletes data in a database while controlling access and security?

Database management system

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.

Design (Design Phase)

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?

Design Phase

The ____________ Phase takes all the detailed design documents from the design phase and transforms them into the actual system.

Development (Development Phase)

Which phase takes all the detailed design documents from the design phase and transforms them into the actual system?

Development Phase

A(n) entity-relationship __________ is a TECHNIQUE for documenting the entities and relationships in a database environment.

Diagram (Entity-Relationship Diagram)

What means the MIS infrastructure can be automatically scaled up or down based on needed requirement?

Dynamic scaling

What stores information about a person, place, thing, transaction, or event?

Entity

AI's modern usage traces back to the 1980s when AI was applied to ________ that allowed computers to reason by following a series of "if-then" rules - i.e., instructions to the computer that if this happens, then do that.

Expert System

What is a system that users computerized advisory programs to imitate the reasoning processes of experts in solving difficult problems?

Expert System

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?

Extraction, Transformation, and Loading (ETL)

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

___________ is the measure of the tangible and intangible benefits of an information system.

Feasibility

A(n) ------ is a characteristic of a table.

Field

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?

Foreign key

_________ Algorithm is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem.

Genetic (Algorithm)

What is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem?

Genetic Algorithm

What is a collection of computers, often geographically dispersed, that are coordinated to solve a common problem?

Grid Computing

Select the three benefits of Cloud Services. Greater reliability Less reliability Lower availability Higher availability Less efficient accessibility Improved accessibility

Higher availability Greater reliability Improved accessibility

------ 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 (management)

In the ____________ Phase, the organization places the system into production so users can begin to perform actual business operations with it.

Implementation (Phase)

In which phase does the organization place the system into production so users can begin to perform actual business operations with it?

Implementation Phase

MODULE ------------- 12A - - -

Implementing Digital Innovations - - -

Select two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete information. Information cleansing Information key Information scrubbing Information integrity Information cube

Information Cleansing Information Scrubbing

What is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information?

Information cleansing

What is a measure of the quality of information?

Information integrity

An open system has ___________.

Inputs Outputs

_________ benefits are difficult to quantify or measure.

Intangible

What are difficult to quantify or measure?

Intangible Benefits

A(n) ______ agent is a special-purpose knowledge-based information system that accomplishes specific tasks on behalf of its users.

Intelligent (Agent)

------ Systems are various commercial applications of artificial intelligence.

Intelligent (System)

What is a special-purpose knowledge-based information system that accomplishes specific tasks on behalf of its users?

Intelligent agent

What are various commercial applications of artificial intelligence?

Intelligent systems

Data ------ is the time it takes for data to be stored or retrieved.

Latency (Data Latency)

A(n) _________ system is an OLD SYSTEM that is fast approaching or beyond the end of its useful life within an organization.

Legacy (System)

What is an OLD SYSTEM that is fast approaching or beyond the end of its useful life within an organization?

Legacy System

The __________ view of information focuses on how individual users logically access information to meet their own particular business needs.

Logical View of information

In the _________ Phase, the organization performs changes, corrections, additions, and upgrades to ensure the system continues to meet business goals.

Maintenance (Phase)

Which phase does the organization perform changes, corrections, additions, and upgrades to ensure the system continues to meet business goals?

Maintenance Phase

What is a business function, which moves information about people, products, and processes across the company to facilitate decision making and problem solving?

Management Information Systems

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.

Manager (Project Manager)

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?

Many-to-Many Relationship

What provides details about data?

Metadata

----- -Valued Attribute means having the potential to contain more than one value for an attribute

Multi(-Valued Attribute)

What means having the potential to contain more than one value for an attribute?

Multi-Valued Attribute

What allows more than one piece of software to be used at a time?

Multitasking

___________ allows more than one piece of software to be used at a time.

Multitasking

What is a category of AI that attempts to emulate the way the human brain works?

Neural Network

_________ Network is a category of AI that attempts to emulate the way the human brain works.

Neutral (Network)

What is assigned to an attribute when no other value applies or when a value is unknown?

Null-valued attribute

------ -the-Shelf Application Software SUPPORTS GENERAL BUSINESS processes and does not require any specific software customization to meet the organization's needs.

Off (Off-the-Shelf Application Software)

What SUPPORTS GENERAL BUSINESS processes and does not require any specific software customization to meet the organization's needs?

Off-the-Shelf Application Software

A(n) ----- to ----- relationship is between two entities in which an instance of one entity can be related to MANY instances of a related entity.

One-to-Many (Relationship)

What occurs when an instance of one entity can be related to only one instance of a related entity?

One-to-One Relationship

_________ system software CONTROLS the application software and manages how the hardware devices work together.

Operating (Operating System Software)

What CONTROLS the application software and manages how the hardware devices work together?

Operating System Software

Bitcoin is ___________; every user is allowed to connect to the network, send new transactions to it, verify transactions, and create new blocks.

Peer-to-peer

What deals with the physical storage of information on a storage device?

Physical View of information

The Project __________ is a formal, approved document that manages and controls the entire project.

Plan (Project Plan)

The __________ Phase establishes a high-level plan of the intended project and determines project goals.

Planning (Phase)

Which phase establishes a high-level plan of the intended project and determines project goals?

Planning Phase

__________ Maintenance makes system changes to reduce the chance of future system failure.

Preventive (Maintenance)

What makes system changes to reduce the chance of future system failure?

Preventive Maintenance

A(n) ________ key is a field (or group of fields) that uniquely identifies a given record in a table.

Primary (key)

What is a field that UNIQUELY identifies a given RECORD in a table?

Primary Key

A(n) ___________ is a temporary activity a company undertakes to create a unique product, service, or result.

Project

What is a temporary activity a company undertakes to create a unique product, service, or result.

Project

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?

Project Manager

What is a formal, approved document that manages and controls the entire project?

Project Plan

What describes the business need (the problem the project will solve) and the justification, requirements, and current boundaries for the project?

Project Scope

Which tool helps users graphically design the answer to a question against a database?

Query-by-example (QBE)

A(n) _________ is a collection of related data elements.

Record

Information __________ is the duplication of data, or the storage of the same data in multiple places.

Redundancy (Information Redundancy)

A(n) ___________ database model stores information in the form of logically related two-dimensional tables.

Relational (Relational Database Model)

A(n) __________ database management system allows users to create, read, update, and delete data in a relational database.

Relational (Database Management System DBMS)

A(n) ----- is a central location in which data is stored.

Repository

____________ Management is the process of managing changes to the business requirements throughout the project.

Requirements

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.

Requirements (Business Requirements)

What is the process of managing changes to the business requirements throughout the project?

Requirements Management

The Project _________ describes the business need (the problem the project will solve) and the justification, requirements, and current boundaries for the project.

Scope (Project Scope)

____________-tenancy implies that each customer or tenant must purchase and maintain an individual system.

Single(-tenancy)

What means having only a single value of each attribute of an entity?

Single-Valued Attribute

------- is the set of instructions the hardware executes to carry out specific tasks.

Software

What is the set of instructions the hardware executes to carry out specific tasks?

Software

What MODIFIES SOFTWARE to meet specific user or business requirements?

Software Customization

What delivers applications over the cloud using a pay-per-use revenue model?

Software as a Service

------- Data has a defined length, type, and format and includes numbers, dates, or strings such as Consumer Addresses

Structured Data

What is a tool that asks users to write lines of code to answer questions against a database?

Structured query language

The ----- Development Life Cycle is the OVERALL PROCESS for DEVELOPING information systems, from planning and analysis through implementation and maintenance.

System (System Development Life Cycle)

------- software CONTROLS how the VARIOUS TECHNOLOGY tools work together along with the application software.

System (System Software)

What is the OVERALL PROCESS for DEVELOPING information systems, from planning and analysis through implementation and maintenance?

System Development Life Cycle

What CONTROLS how the VARIOUS TECHNOLOGY tools work together along with the application software?

System Software

What provides an end-to-end view of how operations work together to create a product or service?

System Thinking

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?

Systems Thinking

A(n) _______ is composed of rows and columns that represent an entity.

Table

________ Benefits are easy to quantify and typically measured to determine the success or failure of a project.

Tangible

What are easy to quantify and typically measured to determine the success or failure of a project?

Tangible Benefits

The __________ 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.

Testing (Phase)

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?

Testing Phase

SQL databases are often optimized to minimize redundancy. This means ________________.

The same piece of information is not repeated in in multiple places in a database.

True or False: Databases today scale to exceptional levels, allowing all types of users and programs to perform information processing and information-searching tasks.

True

True or false: Business-critical integrity constraints tend to mirror the very rules by which an organization achieves success.

True

MODULE ---------- 10a - - -

Types of Software - - -

------ data is not defined and does not allow a specific format and is typically free-form text such as emails, twitter tweets and text messages.

Unstructured Data

__________ software provides additional functionality to the operating system.

Utility (Utility Software)

What provides additional functionality to the operating system?

Utility Software

Why does a database offer increased information security?

Various security features of databases ensure that individuals have only certain types of access to certain types of information.

MODULE -------- 13A - - -

Virtual, Grid, and Cloud - - -

A data ________ is a Logical Collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Warehouse (Data Warehouse)

Select the statement below that accurately reflects a database.

While a database has only one physical view, it can easily support multiple logical views that provides for flexibility.

One primary goal of a database is to eliminate information redundancy by recording each piece of information in _______ place(s) in the database.

only one (Information Redundancy)

Place the Phases in the Systems Development Life Cycle in the correct order.

1. Planning 2. Analysis 3. Design 4. Development 5. Testing 6. Implementation 7. Maintenance

Select the THREE accurate statements reflecting the Business Advantages of a Relational Database. 1. Reduced information redundancy 2. Reduced information integrity 3. Increased information redundancy 4. Increased information security 5. Increased information integrity 6. Reduced flexibility

1. Reduced information redundancy 4. Increased information security 5. Increased information integrity

Match the form of application distributed method on the left with its definition on the right. 1. Single user license 2. Network user license 3. Site license 4. Application service provider license

1. Restricts the use of the software to one user at a time. 2. Enables anyone on the network to install and use the software. 3. 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. 4. Specialty software paid for on a license basis or per-use basis or usage-based licensing.

Which of the following statements are correct about SQL (select all that are true).

1. SQL is considered "the" language for getting data out of a database and working with it. 2. SQL is a language 3. SQL is the language of relational database management systems (RDBMS). IT IS NOT - an application - not a language for a hierarchal DBMS

Select the two types of Application Software. - Spreadsheet Software - Utility Software - Operating System Software - Word Processing Software

1. Spreadsheet Software 4. Word Processing Software

Match the system implementation method on the left with its correct definition on the right. 1. Parallel Implementation 2. Plunge Implementation 3. Pilot Implementation 4. Phased Implementation

1. USES both the legacy system and new system until all users verify that the new system functions correctly 2. DISCARDS the legacy system and immediately migrates all users to the new system 3. 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. INSTALLS the new system in phases (for example, by department) until it is verified that it works correctly

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

1. Users can increase storage and processing power as needed 2. All devices can access data and applications 3. Customers share pooled computing resources 4. Storage, network bandwidth, and computing capacity can be increased or decreased immediately, allowing for optimal scalability 5. Clients can monitor and measure transactions and use of resources

Match the key term on the left with its correct definition on the right. 1. Variety 2. Veracity 3. Volume 4. Velocity

1. Variety 1 A: Different forms of structured and unstructured data 2. Veracity 2 A: The uncertainty of data, including biases, noise, and abnormalities 3. Volume 3 A: The scale of data 4. Velocity 4 A: The analysis of streaming data as it travels around the Internet

Select the five primary reasons project fail. 1. Too much user participation 2. Changing technology 3. The cost of finding errors 4. Misunderstanding of tangible benefits 5. Balance of the triple constraints 6. Unclear or missing business requirements 7. Skipped SDLC phases

2. Changing technology 3. The cost of finding errors 5. Balance of the triple constraints 6. Unclear or missing business requirements 7. Skipped SDLC phases

Select the statement that accurately defines the relationship between Entities and Attributes in a Relational Database. 1. Each record in an entity occupies multiple rows in its respective table. 2. Each attribute of an entity occupies a separate column of a table. 3. Each record in an attribute occupies one row in its respective table. 4. Each key in an entity occupies one row in its respective table.

2. Each attribute of an entity occupies a separate column of a table.

Select the two types of System Software. - Spreadsheet Software - Utility Software - Operating System Software - Word Processing Software

2. Utility Software 3. Operating System Software

In the __________ Phase the firm analyzes its END-USER business requirements and refines project goals into defined functions and operations of the intended system.

Analysis (Analysis Phase)

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?

Analysis Phase

_________ software is used for specific information processing needs, including payroll, customer relationship management, project management, training, and many others.

Application (Application Software)

What is used for specific information processing needs, including payroll, customer relationship management, project management, training, and many others?

Application Software

MODULE ----------- 14a - - -

Approaches to Artificial Intelligence - - -

_________ intelligence simulates human thinking and behavior, such as the ability to reason and learn.

Artificial (intelligence)

What simulates human thinking and behavior, such as the ability to reason and learn?

Artificial Intelligence (AI)

A(n) ___________ is the DATA ELEMENT ASSOCIATED with an entity.

Attribute

The DISTINCT command in SQL is used to ___________.

Avoid returning Duplicate Data.


Related study sets