MIS 2101 - Temple University Exam 2

Describe the potential benefits of 5G networks to the Internet of Things (IoT). More than one answer may be correct.

5G connectivity has the potential to create truly connected cities. 5G networks may eventually allow for autonomous vehicles to safely interact with each other and their environment. 5G connectivity will greatly improve what businesses and individuals can do with connected devices. 5G connectivity will allow for faster communications, even faster than fiber optic connections.

Describe how 5G connectivity will support IoT. More than one answer may be correct.

5G connectivity will allow for faster connection speeds, greater data capacity, and lower latency. 5G connectivity will allow for greater data capacity. 5G connectivity will allow for lower latency. 5G connectivity will fully replace 4G connections.

Which of the following is true about geographic information systems (GIS)? More than one answer may be correct.

A GIS uses a global positioning system (GPS) powered by at least 24 satellites. Combined with GPS, GIS is used to guide the transport of goods to different locations. Spatial data generated from GIS is used by organizations to make better decisions. GIS data is only available to users and organizations in the form of maps.

Which of the following are true statements about cryptocurrencies? More than one answer may be selected.

A cryptocurrency only exists on a computer You can create new cryptocurrency using a process called mining. Cryptocurrencies are controlled by the World Bank rather than countries. A financial institution is needed to transfer cryptocurrencies.

One of the first computer aided design programs ever developed was also among the first to be integrated into ERP systems. This popular program is

AutoCAD.

Data analysts are likely to have achieved what education level when beginning their career?

Bachelor's degree

Which of the following is a benefit of collaboration software for business teams and organizations? More than one answer may be correct.

Better communication: team members can share content in real time, from any location. Better project management capabilities: leaders can easily share plans and schedules. Streamlined workflow: team members can easily add and update activities and duties.

Of the following software packages integrated into an enterprise resource planning system, which one is used by engineers in the design process?

CAD software

The essential RDBMS functions; create, read, update, and delete data is collectively referred to as which acronym?

CRUD

When working in Tableau, users can assume which three roles?

Creators Explorers Builders Viewers

What functionalities does Tableau provide for data analysis?

Data preparation and cleansing Real-time data entry What-if scenario analysis

________involves identifying errors in data sets and removing/correcting these errors to ensure the data is accurate.

Data scrubbing

From the following list, select all the characteristics of collaboration software that enhance the productivity of teams, groups, and organizations.

Dedicated workspaces are viewable and editable by approved users, regardless of their physical location. The software is cloud-based, removing the need for users to have specific software downloaded on a device. Remote users create individual, dedicated workspaces online for managing their own data and workflows. Changes to project documents or spreadsheets must be saved and sent to the members of a team.

Which statement describes part of the process for sending information on the Internet? More than one answer option may be correct.

Each device connecting to the Internet must have a network interface card (NIC) installed. Devices connect to the Internet using either network cables or wireless technologies. Modems and routers are connected to the Internet via an Internet Service Provider (ISP).

How do IoT data analytics benefit organizations?

Enables real-time monitoring and alerts Provides data that is only relevant to IT departments Offers insights that assist in proactive decision making Restricts data access to senior management

A cloud-based service offered by vendors and hosted on a vendor's cloud that allows users to access a software application using a web browser and Internet connection is referred to as software as a system.

False

According to the National Institute of Standards and Technology (NIST) there are four cloud computing deployment models. Community cloud is a cloud deployment model where cloud infrastructure is provided to multiple business units within an organization.

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.

False

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

False

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

False

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

False

What benefits does customer relationship management software (CRM) provide to an organization? More than one answer may be correct.

Identify and attract potential customers. Determine ways to sell additional products and services to existing customers. Identify which methods of payments customers frequently use. Monitor the amount of time it takes for a product to be delivered after an order is placed.

What is the second step in the process of sending a message via the Internet?

Identify the correct domain name.

Characteristics of spreadsheets include which two of the following?

Information is organized into cells Data is structured in rows and columns. Data is structured using rules and relationships defined by the DBMS. Data entry is often automated and constrained by defined parameters.

Which two of the following statements describe key benefits of an integrated computer-assisted design (CAD) module within an ERP system?

Managers can track processes that use computer-assisted design throughout an entire manufacturing cycle. Managers can monitor the use of materials, machines and labor, and level of completion within CAD processes. Managers can follow transaction-based business processes throughout the organization's entire network. Managers can monitor all critical relationships that have been developed with both customers and suppliers.

Which of the following is a popular Microsoft data analytics program that offers business intelligence as well as data visualization?

Power BI

When working in Microsoft Power BI, which three tiers are available?

Power BI Pro Power BI Explorer Power BI Premium Power BI Desktop

Which of the following correctly identify National Institute of Standards and Technology (NIST) cloud computing deployment models? More than one answer may be correct.

Private cloud infrastructure is extended to a single organization with multiple consumers e.g., business units. Public cloud infrastructure is for open use by the general public. It may be owned, managed, and operated by a business, academic, or government organization, or some combination of them. Community cloud infrastructure is a composition of two or more distinct cloud infrastructures that remain unique entities but are bound together by standardized or proprietary technology.

Using the correct syntax allows the user to extract data from multiple fields found in data tables. In order to extract information from multiple tables, the ______ command is used to indicate multiple fields in conjunction with FROM and WHERE to narrow the search and get specific results.

SELECT

One of the most popular query languages is ________.

SQL

Cloud-based ERP systems are a form of

Software as a Service (SaaS).

What does the abbreviation SQL stand for?

Structured Query Language

In order for a new block to be added to the blockchain, four criteria must be met. Which of the following are examples of the required criteria? More than one answer may be selected.

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. An importer wants to check on the status of items he ordered from China last month.

A data mart is a division of a data warehouse explicitly built and constructed for individual departments or business functions.

True

A data warehouse is a storehouse of data and information that organizations analyze to make informed business and operational decisions.

True

At its core, blockchain stores transaction data in blocks and then links the blocks together to form a chain.

True

The Four Vs of big data include Volume: Scale of Data, Variety: Different forms of data, Veracity: Uncertainty of data, and Velocity: Analysis of streaming data.

True

The term "Web 2.0" refers to the second-generation Internet, which is based on interactivity and dynamic content and includes content shared online via social media.

True

Which of the following statements about the Python programming language are true?

Uses a syntax that is easy to learn and read.

If a company wants to create a secure computer network that can be accessed and used solely by its employees, it should create

an intranet.

Someone who possesses the knowledge of processing software, business strategy, and analytical skill to deliver data and reports that guide management and executives as they create well-informed decision making is known as a data ____.

analyst.

Which type of chart is commonly used to create pictographs?

bar or line chart

Which of the following is a benefit to integrating CRM software into an existing ERP? More than one answer may be correct.

better visibility of customer relationship faster billing faster data access times quicker acquisition of new customers

Data analysts must blend facts and data with knowledge about the ______.

business or organization.

How can data visualizations establish trust and confidence when designed appropriately?

by telling a complex story quickly

A key component, and major advantage, of an ERP is its

centralized database.

The Foreign Key is a ________ field between tables that is not the primary key.

common

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

cost reduction

What is a potential consequence of including cherry-picked data in a visualization?

creation of misleading and false conclusions

Knowledge Discovery in Data (KDD) is also known as ________.

data mining

Data administration tasks include the development of information policies, data planning, ________, security, and how internal-users and end-users use that data.

database design

A cloud database infrastructure integrates computer hardware and operating system in an internet-based ________.

datacenter

Trying to answer questions such as "what happened?" or "what is occurring?" or "what was the ROI?" is the role of _______.

descriptive analytics

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?

employees' payroll and benefits

Search Engine Optimization (SEO) can be ________ through the information gained by web mining.

enhanced

Data scrubbing (data cleaning) involves identifying ________ in data sets then duplicating these errors to ensure the data is accurate for an organization.

errors

Describe the benefits 5G networks will provide cell phone carriers and users. More than one answer may be correct.

faster connections and data transfer speeds greater capacity lower latency

What must be integrated into an organization's enterprise resource management solution to allow it to create and maintain regulatory and compliance information from a centralized location?

financial management systems software

Describe difficulties in implementing an ERP system. More than one answer may be correct.

high costs steep learning curve maintenance costs poor access to data

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

high costs.

What is one of the advantages of data visualization?

illustrates patterns in data

Uses of data analytics include which three of the following?

improved decision making improved patient experiences and internal procedures in health care improved customer service increasing fonts

What is the overarching goal of organizations choosing to adopt an enterprise resource planning (ERP) system?

increase operational efficiency

Data centralization is critical for increasing data ________

integrity

Database forms structure data input to ensure data ________.

integrity

One of the features of using web mining is that it improves website usability. This usability refers to how easily website users can ________with the site.

interact

Users often find it difficult to implement or even comprehend a new ERP system without significant training because of ERPs' steep

learning curves

Describe the cost benefits of using a cloud-based ERP compared to an on-premise system. More than one answer may be correct.

lower IT infrastructure expenses lower maintenance costs reduced IT labor expenses reduced vendor support costs

Traditional file systems use ________, files, and documents.

paper

What type of computer users are considered miners?

people who validate cryptocurrency transactions on the digital ledger

What aspect of today's business environment is central to the need for robust transaction management processing systems?

proliferation of e-commerce-based organizations

Parameter queries ________ the user for values to execute/run a query.

prompt

In what ways do Enterprise Resource Planning (ERP) systems help organizations improve operational efficiency? More than one answer may be correct.

provide a centralized databaseprovide a centralized database provide access to dataprovide access to data demand low start-up fees

In order to be considered open data, databases must provide access rights so that they can be _____.

redistributed.

Which Web 2.0 feature utilizes application programming interfaces (APIs) to automate web content and/or processes?

software as a service (SaaS)

Which program is typically limited to one user at a time?

spreadsheet

Relational databases organize data into ________ based on structured data groupings.

tables

From the following list, select the two resources that organizations can track using accounting management software.

tangible assets intangible assets customer relationships supply chain resources

In order to make understanding and interpretation of SQL queries easier, users have the ability to add comments. The symbol(s) that will tell SQL that an entry is a comment and should not be used in the query is(are) _______

two dashes: "- -."

Collaboration software is designed to increase collaboration and productivity primarily by enabling team members to

view, edit, and add shared information in real time, from anywhere.