CIS Exam 3

Match the concept with applicable examples. 1. Tangible Benefit 2. Intangible Benefit

1. Decrease response time 1. Decreased cost 2. Better decisions 2. Increase goodwill 2. Improve morale 1. Increase sales

Which of the following are phases of a Systems Development Life Cycle?

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

Something that holds a process back is a ____

Barrier

Intangible Benefits

are difficult to quantify or measure - improved decision making - improved community service - improved goodwill - improved morale

Tangible Benefits

are easy to quantify and typically measured to determine the success or failure of a project - Decrease expenses - Decrease processing error - Decrease response time - Increase quantity or sales - Increase quality

Identify the learning objectives associated with this module. (select all that apply) Module 10

- Explain systems thinking and how management information systems enable business communication. - Describe and identify common data types used in software programming (including variables & vectors) - Identify the two main types of software. - Describe Systems Thinking as an approach to optimize tasks. - Describe the fundamental programming concept of conditional tests. - Describe the fundamental programming concepts of assignment and operations.

A data _______ contains a subset of data warehouse information.

(data) Mart

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.

(data) Scientist

Identify examples of Virtual Reality from the following list (select all that apply)

- A museum visitor interpretation provides an interactive 'walk-through' of a 3D reconstruction of Dudley Castle in England as it was in 1550. - In May 2016, Disney released a new digital experience free for download. The experience allows users to interact with the characters and worlds from the Disney, Marvel, and Lucasfilm universes. - The user is at the location of the experience.

Which of the following properly characterize Analytics (select all that apply)?

- Analytics has a goal to make better business decisions. - Analytics can be descriptive. - Analytics can be predictive. - Analytics is the use of math and statistics to derive meaning from data. - Analytics can be prescriptive.

Business Intelligence is commonly discussed using the shorthand label BI (pronounced Bee Eye). Which of the following properly characterize BI (select all that apply)?

- BI has a goal of achieving better business decisions. - BI is about delivering relevant and reliable information to the right people at the right time. - BI is a broad field that includes Analytics, predictive modeling, text mining and many other approaches for using data.

Which of the following describe Data Warehouses? (select all that apply)

- Has a purpose to combine strategic information into a single repository in such a way that people who need that information can make decisions and undertake business analysis. - A logical collection of information gathered from many operational databases. - Supports business analysis activities and decision making tasks.

Select two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete information.

- Information scrubbing - Information cleansing

Open system have ___________.

- Input - Output - Processes

If a process changes, which of these may also need changing depending on the desired benefit?

- Inputs - Barriers - Tools

An open system has ___________.

- Inputs - Outputs

Which of the following are types of relationships in a relational database? (select all that apply)

- One-to-One - Many-to-Many - One-to-Many

Select the two types of system software.

- Operating systems software - Utility software

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

- Oracle Database - Microsoft SQL Server - PostgreSQL - MySQL

Which of the following are common SQL commands?

- SELECT - FROM - WHERE

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

- SQL is a language - SQL is considered "the" language for getting data out of a database and working with it. -SQL is the language of relational database management systems (RDBMS).

Which of the following is not a feature supported by an Operating System? (select all that are not features of an OS)

- Software to transform a computer into a tool for creating, editing, proofreading, formatting and printing documents. - Software used to solve specific problems or perform specific tasks. - Antivirus protection

Big Data refers to the vast volumes and types of information that companies can now collect and process using increasingly high-tech systems. Where does big data come from (select all that apply)?

- Unstructured Data - Structured Data - Internal Data Sources - External Data Sources

Select the two types of application software.

- Word processing software - Spreadsheet software

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

Application (software)

Data ---- is the collection of data from various sources for the purpose of data processing.

Aggregation

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

Artificial

A(n) ___________ is the data elements associated with an entity.

Attribute

What is the data elements associated with an ENTITY?

Attributes

___________ is usually in real-time to enhance a person's perception of reality. This can help the user obtain otherwise hidden information and enhance the person's ability to interact with the real world.

Augmented Reality

The DISTINCT command in SQL is used to ___________.

Avoid returning duplicate data.

____________ expresses the specific number of instances in an entity.

Cardinality

Select the FOUR things a database management system (DBMS) can perform on data in a database while controlling ACCESS and SECURITY.

Create Read Update Delete

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

Cube

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

Data Artist

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

Data warehouse

Session 11 - Identify the learning objectives associated with this module. (select all that apply)

Describe why entities and attributes are organized into tables and fields. Describe how data redundancy is handled in the relational database model. Describe the purpose of the relational database model in a database management system. Describe the SQL Language, its purpose and basic commands List the relational database model's basic components

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

Diagram (Entity-Relationship Diagram)

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

Entity

What is a technique for documenting the entities and relationships in a database environment?

Entity-Relationship Diagram

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

--- is a characteristic of a table.

Field

Which is included in feedback for a car's system?

Gas Level

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

Genetic

Which of the following is used for both Virtual Reality and Augmented Reality.

Head Mounted Displays (HMDs)

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

Information cleansing

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

Intelligent agent

Combines networks by splitting the available bandwidth into independent channels that can be assigned in real time to a specific device.

Network virtualization

Module 12

MC

Module 13

Module 13

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

Multi-Valued attribute

Means having the potential to contain more than one value for an attribute.

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

Neural

Identify the learning objectives associated with this module. (select all that apply) Module 9

Module 9 - Identify the four common characteristics of big data - Describe the role and purpose of data warehouses and data marts in an organization - Explain the importance of data analytics and data visualization - Describe Business Intelligence and Data Analytics,and how they are used to solve real world challenges.

___________ 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

Which of the following is TRUE about a computer algorithm.

None of these statements is true (they are all FALSE).

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

Null-Valued attribute

What occurs 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

Module 10

Part A

Productivity is the ---- at which goods and services are produced based upon total output given total inputs.

Rate

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

Record

Which of these characterize System Management?

Regulating the process

Combines the physical resources (such as servers, and processors) along with an operating system.

Server virtualization

Is the most common form of virtualization.

Server virtualization

Session 11

Session 11

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

---- software 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

What is composed of rows and columns that represent an entity?

Table

According to Systems Thinking, systems have multiple layers of context. Systems exist within larger systems and are also composed of smaller systems. If you consider a laptop computer used in the CIS2010 lab as a system; what is the relationship between the power source (battery and charger) and the laptop?

The battery and charger is a subsystem of the laptop.

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.

Analytics is ______________.

The use of math and statistics to derive meaning from data.

What provides additional functionality to the operating system?

Utility software

A live direct or indirect view of a physical, real-world environment whose elements are supplemented by computer-generated sensory input such as sound, video, graphics or GPS data.

VR - Virtual Reality

A three dimensional aircraft can be designed which allows the designer to test their prototype without having to create several physical versions - which are time consuming and costly. It is cheaper and easier to make changes to the simulation rather than having to design and build a new aircraft. This is an example of :

Virtual Reality

Medicine is one of the biggest beneficiaries with the development of surgery simulation. This is often used as a training aid and enables the surgeon to perform an operation on a 'virtual patient'. This is an example of :

Virtual Reality

Repository

What is a central location in which data is stored and managed.

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

intelligence

Combines multiple network storage devices so they appear to be a single storage device.

Storage virtualization

Identify the learning objectives associated with this module. (select all that apply) Module 12

- Define Algorithm and Function - Describe Functions in R - Explain project management and identify the primary reasons projects fail - Describe the seven phases of the system development life cycle

Identify the learning objectives associated with this module. (select all that apply)

- Demonstrate the logic of a LOOP in R -Explain the three components of a sustainable MIS infrastructure along with their business benefits - Contrast and differentiate Augmented Reality from Virtual Reality

Identify the learning objectives associated with this module on Artificial Intelligence. (select all that apply)

- Describe Artificial Intelligence and identify its five main types. - Differentiate Artificial Intelligence, Machine learning and Deep Learning.

Match the term with its definition and characteristics. __3__ Include a knowledge based with accumulated experience and a set of rules for aplying the knowledge base to each particular situation. __4__ A subset of Artificial Intelligence that users algorithms to learn iteratively from data and can find insigths without explicit programming. __2__ analyze large quantitied of information to establish patterns and charceristicwd when the logic or rules are unknown. __1__ Mimic evolutionary precesses to generate increasingly better solutions to a problem. Mutation within a genetic algorithm involve randomly trying combinations and evaluating success (or failure) in order to learn to optimize outcomes. __5__ A subset of Machine Learnign that referst to artificial neural networks that are composed of many layers.

1. Genetic Algorithm 2. Neural Network 3. Expert System 4. Machine Learning 5. Deep Learning

A computer technology that replicates an environment, real or imagined, and simulates a user's physical presence and environment to allow for user interaction. This experience artificially creates sensory experience, which can include sight, touch, hearing, and smell.

AR - Augmented Reality

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

Database management 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

What is information that returns to its original transmitter (input, transform, or output) and modifies the transmitter's actions?

Feedback

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 controls the application software and manages how the hardware devices work together?

Operating System Software

Module 10b

Part B

The vision for highly effective BI will ________________?

Take messy information and turn it into a tidy and accessible grocery store.

Something that helps a process move forward is a _____

Tool

Which of the following are associated with "Narrow AI".

a) Natural Language Processing. Correct AnswerIncorrect Response b) Performing math calculations faster than a human. Correct Answer c) Technologies that can perform specific tasks as well as or better than humans.

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

intelligent

Many-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.