Exam 2 - MIS 2101

How does AI differ from traditional computing technologies?

1. AI includes technologies like machine learning and deep learning 2. AI can simulate human problem-solving capabilities

The six-step process analysts use to create data-driven decision making includes what?

1. Ask 2. Analysis 3. Prepare

Which of the following are supported by AI?

1. Automating typing corrections in texts or emails 2. Generating textual content from minimal user input 3. Learning from data to make predictions and decisions

List benefits of integrating a CRM software into an existing ERP

1. Better visibility of customer relationships 2. Faster billing 3. Faster data access times

What business software applications are commonly integrated with an enterprise resource planning (ERP) system as modules?

1. CRM 2. PM 3. BI

List three major varieties of data formatting

1. Discrete data 2. Structured data 3. Unstructured data

Most HRM modules provide a structured dashboard that managers can access for information. List some of the types of information that are included

1. Employee absences or leaves 2. Employee compensation 3. Employee performance review status

List common methods of connecting a LAN to the Internet

1. Fiber optic cables 2. Ethernet cables 3. Coaxial cables

List a few examples of how the blockchain can be used

1. For business contracts, blockchain makes it almost impossible to change any information in a contract. This is advantageous for businesses that are dealing with multiple contracts. 2. In supply chain management, blockchain can verify with almost absolute certainty where items and goods are along the supply chain, thus removing guesswork and inefficiencies for shippers and customers. 3. Blockchain can be used to assist with quality assurance by tracing mistakes and errors in manufacturing back to where they occurred.

What are the challenges associated with using SQL databases?

1. High cost of some SQL database versions 2. Complexity in setup and management 3. Requirement for skilled database administrators

What are some difficulties of implementing and ERP system

1. High costs 2. Steep learning curve 3. Maintenance costs

List three critical factors to consider when determining the right data to select?

1. How will the data be collected 2. What types of data do you need to solve a specific problem? 3. How much data should be collected?

List factors associated with maintenance costs incurred by employing an ERP system

1. Increased IT personnel 2. Software consultants 3. Time costs

List some cost benefits of using a cloud-based ERP compared to an on-premise one

1. Lower IT infrastructure expenses 2. Lower maintenance costs 3. Reduced IT labor expenses

What are some key features of Microsoft Power BI

1. Provides data transformation and modeling capabilities 2. Offers self-service access for end-users 3. Includes interactive data visualizations

Trends in data analytics includes what?

1. Scalable AI 2. Composable data 3. data analytics as a core business function

List three tools that data analysts use

1. Spreadsheets 2. Databases and query languages 3. Data visualization tools

List resources that an organization can track using accounting management software

1. Tangible assets 2. Intangible assets

List characteristics of the Internet that helps explain how it works?

1. The Internet has connections points called nodes. 2. Data is usually stored on specialized computers called servers. 3. Data is transferred between networks through hardware called routers.

In order for a new block to be added to the blockchain, four criteria must be met. List some of the criteria (Order doesn't matter)

1. The digital signature of the vendor and consumer, as well as the transaction amount and date and time of purchase are stored on a block 2. A hardware company purchases lumber. 3. An independent bookstore pays off a line of credit used to purchase a bulk order of J.K. Rowling's most recent novel.

List examples of how the project communications piece of project management software could be used when integrated with enterprise resource planning software

1. The visual project completion map is automatically updated as phases are completed. 2. The client is able to access information about all phases of the project in one place, reducing the need for individual status reports.

List examples of data transformation?

1. copying or replicating data 2. standardizing names and variables across data sets 3. the deletion of database fields or records to ensure data integrity

What best practices should be applied when designing data visualizations?

1. defining a specific purpose for the visualization 2. designing visualizations for the target audience 3. including all relevant data

What are potential disadvantages of data visualization?

1. display correlations that do not accurately reflect causation 2. convey biased or inaccurate information or inaccurate information

What is the difference between a cloud service and a web service?

A cloud service provides users with increased computing power and data management, whereas a web service provides the software tools needed for devices and systems to communicate with each other.

Which of the following is an advantage of integrating AI with database management?

AI can significantly reduce data errors and optimize resources

How does each additional block added to the blockchain strengthen the integrity of the entire chain?

Because each block contains information on recording time and sequence for both its transaction and the transaction immediately preceding it, with more blocks there is more transaction history information, making it difficult to falsify.

The key goals of data governance include rules for data use, requirement compliance, high-quality data, and what

Cost reduction

Forms are created using what type of software?

DBMS

We use database forms to control how what enters a database

Data

What is the correct term for the small computer within a smartphone that analyzes the sounds entering your phone through the analog/digital converter?

Digital Signal Processor (DSP)

A manager is using the organization's ERP software to generate a report that links its human resources data to its overall financial performance. What is one type of HR data that the ERP accounting module could factor into this report?

Employee's payroll and benefits

What can be done to search engine optimization (SEO) by utilizing the data gained by web mining

Enhanced

Which cryptocurrency offers a blockchain-based platform that can be used to develop decentralized applications?

Ethereum

A server is a group of two or more devices/computers that are connected to allow them to exchange information and share resources. (True or False)

False

Accounting management systems give organizations the ability to measure cash flows, calculate tax liabilities, maintain compliance to legal and accounting regulations, and optimize profitability. (True or False)

False

Businesses have found that though their reliance on internal IT infrastructure has increased, while their costs are reduced when using the cloud. (True or False)

False

Collaboration software leads to better collaboration by enabling people from across the organization and in the same time zone to share content in real time. (True or False)

False

ERP software allows managers to easily view computer-assisted design (CAD) files and manually decode them to feed specifications into the manufacturing process. (True or False)

False

In a table relationship, if a primary key field has associated records and you delete the primary key field, you will not end up with an orphan record. (True or False)

False

Integrating transaction processing systems (TPS) with ERP allows organizations to streamline services but does not reduce labor costs. (True or False)

False

Maintaining referential integrity maintains orphan records.

False

One noted disadvantage of cloud computing is the issue of overcollaboration between users. (True or False)

False

Systems that assist organizations in synchronizing business operating units relating to inventory management are customer relationship management systems. (True or False)

False

When data is centralized, it means data is harder to maintain. (True or False)

False

When using multiple lists and data sources, information can become consistent and lead to an increase in data integrity? (True or False)

False

One of the ways web mining improves web experiences is through site visibility. What does site visibility include to make the website appear when queries are executed into a search enginge?

How and When

The amount of time that passes between when a device is asked to perform and when it completes the task is known as

Latency

What is another term used to describe line charts?

Line plots

Which database design strategy is likely to be used where transaction integrity is critical?

Normalization

Software that businesses use to manage activities in both the internal and external operational environment is known as Enterprise Resource

Planning

In the initiation phase of project management, the client and project manager determine if the project is SMART. What does the R in SMART refer to?

Realistic

Cloud-based ERP solutions are usually offered as

Software as a Service (SaaS)

Cloud-based ERP systems are a form of

Software as a Service (SaaS)

SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for what

Structured

A database and a DBMS are different. A database is a collection of metadata, relationships, and

Tables

What is one reason to create database policies

To specify the rules used in database design

What is the second criteria necessary for adding a block to the blockchain?

Transaction Verification

A project manager needs to assess how much progress her team has made on the project, to provide executives with a weekly update. Which collaboration software program will be most useful for assessing the project's status?

Trello

A virtual private network creates a secure connection between two computers, allowing for encrypted communications that uses the Internet for data transmissions and communication. (True or False)

True

Accounting system software is designed to perform the necessary financial calculations and ledger journaling for tracking accounts receivable and payable, handling billing and payroll, processing payments, managing expenses and purchase orders, and monitoring and reporting on all of these areas. (True or False)

True

Enterprise resource planning systems allow managers to view reports that integrate data from various operational areas within the organization, thus facilitating informed business decisions. (True or False)

True

Middleware is software that provides processing capabilities outside what is offered by the user's operating system. (True or False)

True

One of the benefits of cloud computing is increased collaboration among corporate users. (True or False)

True

One of the technologies on which web services are based is XML. XML stands for Extensible Markup Language. (True or False)

True

What is the second step that occurs when placing a call on a cellular network?

Your voice is converted by your phone to an electrical signal that is transmitted via radio waves to the nearest cell tower.

Data analysts must blend facts and data with knowledge about the

business or organization.

The 3-step data visualization process consists of exploring the data sets for pattern, then planning for visuals, and finally

creating your visuals.

While ERP systems offer many competitive advantages to users, particularly those in upper management, a significant disadvantage is their

high cost

Data centralization is critical for increasing data

integrity

Data marts are used to track what, purchases, transactions, and the supply chain

inventories

The main advantage of the IPv6 format for IP addresses is that

it can accommodate many more addresses than the IPv4 format.

What is the primary effect of truncating the y-axis in data visualization?

making data differences seem smaller than they are

Database administrators do what as well as troubleshooting the database to ensure it is stable and usable when needed

monitor

Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered what type of data?

ordinal

RAM storage and what processing are two main in-memory computing components

parallel

An independent data mart is what type of system, created separate from a data warehouse and focused on specific organizational functions

stand-alone

One way to visualize a data ecosystem is to apply it to the data project life cycle. The Data Science Ready project outlines the five steps of the data project life cycle. The final stage in this life cycle is

storage

Data governance involves the staff, procedures, and technologies needed to do what and protect the data and data properties of an entity

supervise

In a bar, line, or scatterplot graph, which axis is typically used to represent the values being compared?

y-axis