BUS 391 IS - Walsh Final Exam Review 2024

How does AI differ from traditional computing technologies? *AI is incapable of learning from data. *AI only operates within pre-programmed parameters. *AI can simulate human problem-solving capabilities. *AI includes technologies like machine learning and deep learning.

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

Identify current business applications and uses of AI. *AIOps *health tracking *sales and marketing *accounting

*AIOps *sales and marketing *accounting

What features make Tableau popular with data analysts? *Ability to handle data from multiple sources *Complex data visualization capabilities *Intuitive drag-and-drop interface *Built-in advanced scientific calculations

*Ability to handle data from multiple sources *Complex data visualization capabilities *Intuitive drag-and-drop interface

Which of the following statements about re-commerce are true? More than one answer may be selected. *According to Yerdle Re-commerce, this segment is expected to grow from $21 billion to over $52 billion over the next five years. *Re-commerce is the practice of selling used, old, or obsolete products via the Internet in exchange for a new product or a cash payout *The practice of re-commerce has seen an increase in the marketplace and is offered by companies such as thredUp, Yerdle Re-commerce, and The RealReal. *1.25% of millennials and Gen Z expect to shop resale in 2020.

*According to Yerdle Re-commerce, this segment is expected to grow from $21 billion to over $52 billion over the next five years. *Re-commerce is the practice of selling used, old, or obsolete products via the Internet in exchange for a new product or a cash payout *The practice of re-commerce has seen an increase in the marketplace and is offered by companies such as thredUp, Yerdle Re-commerce, and The RealReal.

According to eMarketer, the most popular B2C sites in the United States include: (More than one answer may be selected). *Amazon *HP *Walmart *Lyft

*Amazon *Walmart

The steps in the data project life cycle, according to Harvard University's Data Science Ready project include which three of the following? *Proposal *Collection *Wrangling *Sensing

*Collection *Wrangling *Sensing

Integration of TPS with ERP has many advantages to managers including which 3 of the following? *Reduces environmental impact *Labor cost reduction *Saves time *Reduces human error

*Labor cost reduction *Saves time *Reduces human error

Which of the following Python libraries are commonly used to automate accounting tasks? *Django *NumPy *pandas *web2py

*NumPy *pandas

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 ___ . Multiple choice question. *BarCAD *AutoCAD *CAD-illac *CADdie

AutoCAD

Built on real-time geodata and information provided from wireless mobile devices including smartphones and tablets_____ are widely used in m-commerce.

Location-based services (LBS)

Integrating a business software module into an ERP has several advantages. Which business software module includes payment information from customers?

TPS software

The practice of selling used, old, or obsolete products via the Internet in exchange for a new product or a cash payout is called re-______

commerce

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

descriptive analytics

Enterprise resource management (ERP) systems can be designed to include a module provides the ability to join human _____ management and information technology to provide a single source of connectivity and data exchange for personnel-related information.

resource

The ability of an organization to create a strong presence among consumers in many places, with minimal time constraints, to sell the products and services they offer is called e-commerce _____.

ubiquity

Select the true statements about how Python is used in finance. *Banks use Python to get financial models out of Excel and into an environment that allows for more data analysis and visualization. *Analytics in finance provides high-level and granular-level views of an organization's financial data. *Python has limitations with processing large financial data sets. *Python is used in quantitative and qualitative financial processes in many financial areas including analytics, banking, and cryptocurrency.

*Banks use Python to get financial models out of Excel and into an environment that allows for more data analysis and visualization. *Analytics in finance provides high-level and granular-level views of an organization's financial data. *Python is used in quantitative and qualitative financial processes in many financial areas including analytics, banking, and cryptocurrency.

There are a number of different business software applications that can be integrated with an ERP system. Select 3 commonly included application modules. *CRM *CMOS *HR *PM

*CRM *HR *PM

ERP systems help organizations improve operational efficiency in which 3 of the following ways? *Centralized database *Customizable *Low start-up cost *Access to data

*Centralized database *Customizable *Access to data

Web scraping is the automation of the extraction of large volumes of data from websites. Using Python, which of the following web scraping activities can be conducted? *Collect data from social media sites. *Conduct research and development (R&D) *Conduct price comparisons. *Input of invoices.

*Collect data from social media sites. *Conduct research and development (R&D) *Conduct price comparisons.

Analytical skills necessary for a data analyst include the characteristics and capabilities that allow for the observation, research, and interpretation of a problem or change in a desired state. According to Google, there are five essential aspects of analytical skills including which 3 of the following? *Curiosity *Sensing *Data strategy *Understanding context

*Curiosity *Data strategy *Understanding context

According to Tableau, data-driven decision making (DDDM) uses which of the following to guide strategic business decisions that align with organizational goals, objectives, and initiatives? *Data *Artificial intelligence *Metrics *Facts

*Data *Metrics *Facts

The process of data analytics includes which of the following? *Virtual analytics *Descriptive analytics *Predictive analytics *Prescriptive analytics

*Descriptive analytics *Predictive analytics *Prescriptive analytics

Which Python web frameworks identified in the text assist in the development of scalable and secure FinTech web applications? *Django *Flask *Bottle *TurboGears

*Django *Flask

Most HRM modules provide a structured dashboard that provides information to managers including information such as which 3 of the following? *Employee environmental controls *Employee absences or leaves *Employee compensation *Employee performance review status

*Employee absences or leaves *Employee compensation *Employee performance review status

Which of the following are correct statements about why SQL is useful for data analytics? *Functions independently from other programming languages *Enables the discovery of relationships between data sets *Uses complex non-English syntax for queries *Integrates with other programming languages such as Python

*Enables the discovery of relationships between data sets *Integrates with other programming languages such as Python

The FTC acknowledged that AI has the potential to advance almost every industry, but all of this potential comes with some negative risks that must be addressed. Concerning AI, which of the following does the FTC urge organizations to provide evidence of? *Explain how algorithms make decisions. *Participate in nondisclosure. *Hold themselves accountable for compliance, ethics, fairness, and nondiscrimination. *Ensure that decisions are fair, robust, and empirically sound.

*Explain how algorithms make decisions. *Hold themselves accountable for compliance, ethics, fairness, and nondiscrimination. *Ensure that decisions are fair, robust, and empirically sound.

Data manipulation in Python using the wide variety of libraries that are available offer accountants the ability to automate which of the following tasks? *Generate reports. *Analyze financial data. *Perform calculations. *Create APIs.

*Generate reports. *Analyze financial data. *Perform calculations.

The Python programming language was developed in the 1980s by ______. *Bjarne Stroustrup *Guido van Rossum *Peter Slocumb *James Gosling

*Guido van Rossum

What are the challenges associated with using SQL databases? *High cost of some SQL database versions *Inability to handle large volumes of data *Complexity in setup and management *Requirement for skilled database administrators

*High cost of some SQL database versions *Complexity in setup and management *Requirement for skilled database administrators

A cost-benefit analysis is a useful tool used to analyze the costs associated with implementing a project or set of activities and the benefits that can be achieved as a result of the implementation. Which of the following would be considered costs when conducting a cost-benefit analysis? *Differentiated costs *Hiring costs *Capital outlays *Management costs

*Hiring costs *Capital outlays *Management costs

Select 3 critical factors to consider when determining the right data to select? *Has the data been anonymized? *How will the data be collected? *What types of data do you need to solve a specific problem? *How much data should be collected?

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

Select the true statements about information architecture. *Creating a clearly defined architecture and strategy is not the focus of IA. *IA is about helping people understand their surroundings and allowing them to find what they're looking for in the real world and online. *IA is a crucial component of the overall AI strategy of an organization. *Many experts agree that there is no AI without the analysis and implementation of IA.

*IA is about helping people understand their surroundings and allowing them to find what they're looking for in the real world and online. *IA is a crucial component of the overall AI strategy of an organization. *Many experts agree that there is no AI without the analysis and implementation of IA.

Uses of data analytics include which 3 of the following? *Improved data security *Improved patient experiences and internal procedures in healthcare *Improved decision making *Improved customer service

*Improved patient experiences and internal procedures in healthcare *Improved decision making *Improved customer service

With accounting management software, organizations can not only structure basic accounting information, but track a variety of other resources including which 2 of the following? *Intangible assets *Customer relationships *Tangible assets *Supply chain resources

*Intangible assets *Tangible assets

What distinguishes internal data from external data in AI applications? *External data cannot be used in AI. *Internal data is generated within an organization, while external data is sourced from outside entities. *Internal data is less reliable than external data. *Internal data is always structured, whereas external data is always unstructured.

*Internal data is generated within an organization, while external data is sourced from outside entities.

Key considerations of today's e-commerce landscape include which of the following? More than one answer may be selected. *M-commerce *Integrated shopping experiences *Internet of Things (IoT) *Location dependence

*M-commerce *Integrated shopping experiences *Internet of Things (IoT)

Disadvantages of implementing an ERP system include which 3 of the following? *Maintenance costs *High costs *Poor access to data *Steep learning curve

*Maintenance costs *High costs *Steep learning curve

A cost-benefit analysis is a useful tool used to analyze the costs associated with implementing a project or set of activities and the benefits that can be achieved as a result of the implementation. Which of the following would be considered benefits when conducting a cost-benefit analysis? *Market/brand exposure *Strategic gains *Sales increases *Productivity gains

*Market/brand exposure *Sales increases *Productivity gains

What features make Python popular for data analytics? *Requires extensive coding experience *Open-source nature *Supports graphics and visualization tools *Active developer community

*Open-source nature *Supports graphics and visualization tools *Active developer community

Benefits of Cloud-based ERP, over on-premises ERP solutions, include which 3 of the following? *Organizations using cloud-based ERP have reduced IT labor expenses. *Cloud-based ERP allows organizations to access reports from remote locations. *Cloud-based options provide more control over on-premises ERP solutions. *They have lower IT infrastructure expenses.

*Organizations using cloud-based ERP have reduced IT labor expenses. *Cloud-based ERP allows organizations to access reports from remote locations. *They have lower IT infrastructure expenses.

Which of the following would be classified as a Business-to-Business transaction? More than one answer may be selected. *Purchasing a new smartphone from Apple.com *Purchasing food service items for a restaurant *Buying medical equipment for a pediatrician's office *Purchasing office supplies for a university

*Purchasing food service items for a restaurant *Buying medical equipment for a pediatrician's office *Purchasing office supplies for a university

Select the true statements about the Python programming language. *Python is completely free to use. *Many people consider Python to be an ideal first programming language to learn. *Python is a specialty program that is extremely limited in its use. *Python syntax is considered by many to be relatively simple.

*Python is completely free to use. *Many people consider Python to be an ideal first programming language to learn. *Python syntax is considered by many to be relatively simple.

Python is designed to work with which of the following? *Python libraries *Advanced programmers *Custom software *Modules

*Python libraries *Modules

Select the true statements about connectivity in Python. *Python libraries such as pandas can interpret and merge data sets from different sources including Excel, CSV, and JASON. *Connections to external and internal data sources can be accomplished using Python. *Importing and exporting data is streamlined. *Python does not have the ability to work with cloud-based data sources.

*Python libraries such as pandas can interpret and merge data sets from different sources including Excel, CSV, and JASON. *Connections to external and internal data sources can be accomplished using Python. *Importing and exporting data is streamlined.

Common SQL terms include which 3 of the following? *SPLIT *SELECT *WHERE *FROM

*SELECT *WHERE *FROM

Which of the following Python libraries are commonly used for data processing and data visualization? *Pandas *Seaborn *Eli5 *Matplotlib

*Seaborn *Matplotlib

Which of the following are advantages of using SQL in relational database management systems? *Requires minimal programming knowledge *Simplifies the management of structured data *Automatically updates data across multiple platforms *Supports the extraction of complex relationships in data

*Simplifies the management of structured data *Supports the extraction of complex relationships in data

Customer acquisition costs associated with e-commerce activities include all of the sales and marketing costs associated with reaching and engaging potential customers and encouraging these customers to make an initial purchase. Which of the following are considered advertising and marketing expenses? *Recruitment of personnel *Social media advertising *Traditional media advertising (TV, radio, etc.) *Marketing analytics

*Social media advertising *Traditional media advertising (TV, radio, etc.) *Marketing analytics

ERP systems can be integrated with financial management systems to provide centralized access and management of financial data. The benefits of this type of integration include which 3 of the following? *The ability to generate financial reports *Improved visibility *Creates an environment where demand and supply collaboratively interact *Structured compliance architecture

*The ability to generate financial reports *Improved visibility *Structured compliance architecture

For data to be considered open data, it must have what 3 characteristics? *The public must have access and datasets must be available for use. *Datasets must have access rights that allow them to be reused and redistributed. *Datasets must be universally available so that anyone can use the data. *The data must be primary data.

*The public must have access and datasets must be available for use. *Datasets must have access rights that allow them to be reused and redistributed. *Datasets must be universally available so that anyone can use the data.

Which of the following are uses of IoT analytics in business? *To personalize products and services based on customer usage *To increase the complexity of data management *To reduce downtime by predicting equipment failures *To optimize business processes by identifying inefficiencies

*To personalize products and services based on customer usage *To reduce downtime by predicting equipment failures *To optimize business processes by identifying inefficiencies

Which of the following best describes the focus of predictive analytics? *Identifying the best courses of action for future scenarios. *Understanding and detailing past events to explain why they happened. *Analyzing current data to determine trends and conditions. *Understanding, predicting, and planning for future events and outcomes.

*Understanding, predicting, and planning for future events and outcomes.

Which of the following statements about the Python programming language are true? *Steep learning curve *Uses a syntax that is easy to learn and read *Requires a paid subscription to use *Only available on advanced computing platforms

*Uses a syntax that is easy to learn and read

Select the true statements about the scalability of Python. *When working in Python, users can save data in separate files, which allows for simultaneous work and coding. *The number of columns or rows used in a data set does not impact the *Python user because they are not operating in a data interface environment. *Python can handle data sets of almost any scale. *In Python, users cannot work on multiple sheets or tables.

*When working in Python, users can save data in separate files, which allows for simultaneous work and coding. *The number of columns or rows used in a data set does not impact the *Python user because they are not operating in a data interface environment. *Python can handle data sets of almost any scale.

Similar to how mining recovers small amounts of precious metals from large amounts of ore or earth, ______ is the process of extracting information from large data sets. Multiple choice question.

*data mining

A Python data science platform called ______ assists developers in finding cryptocurrency pricing data, the analysis of this information, and data visualization for use in decision making. Multiple choice question.

Anaconda

Protecting private or sensitive information by eliminating or encrypting information is the goal of data ____

Anonymization

Visual Basic for ______ (VBA) is included in Excel and offers the capability to create custom macros and functions that are designed to accomplish organizational specific tasks.

Applications

ERP software integrates several software packages into a single platform. An example of one of these software packages is ___ software, that engineers use in the design process.

CAD

Benefits of integrating ___ into an ERP include better visibility of customer relationships, faster billing, and single source reporting via user customized dashboards.

CRM software

Data visualization is a strength of using Python for data analysis. Which of the following are types of data visualization that can be created using Python?

Charts, interactive plots, and graphics

Only selecting and representing data that supports a desired conclusion or result can easily mislead and result in false conclusions. This is known as __ the data.

Cherry-picking

The type of e-commerce transaction that allows consumers to interact with government or authoritative bodies for activities such as paying taxes, securing building permits, or paying tuition at a university, is referred to as a ____-to-Administration transaction.

Consumer

The type of e-commerce transaction where consumers are able to provide a service to a business often through a bidding or auction type of system is called _____-to-Business. Examples of this type of transaction include Fiverr, Freelancer, and Shutterstock.

Consumer

Because they integrate data from various operational areas within the organization through modules, __ systems allow managers to view reports from across the organization.

ERP

ERP software integrates several software packages into a single platform. An example of one of these software packages is ___ software, that stores employee compensation and performance information.

HRM

The total amount of information as well as the quality of information available to all individuals in a market including customers and stakeholders is referred to as ___. E-commerce technologies help to reduce the costs associated with which of following?

Information Density

API stands for Application Programming ______ and allows for different software programs the ability to connect and work with each other.

Interface

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

Cloud-based ERP systems are a form of ______ as a Service (SaaS).

Software

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

Tableau

When selecting the right data, it is important to be aware of the source of the data. For example, data that is sold by an entity that didn't actually collect the data is considered ___ data.

Third-party

Shortening the y-axis on a bar, line, or scatterplot graph can make differences seem much bigger than they actually are. This misleading data visualization element is known as ___.

Truncating

ERP software provides value by integrating several software packages into a single platform. An example of one of these software packages is ___ software, that records ledger journaling and billing. drop zone empty.

accounting

Software designed to handle a variety of financial calculations that are used for reporting and monitoring of business performance including tracking accounts receivable and payable, billing, and payroll along with payment processing, ledger journaling, expenses, and purchase orders are referred to as ______ system software.

accounting

ERP software takes data from computer-_____ design (CAD) files and decodes the design and manufacture specifications into usable information for use throughout the manufacturing process.

aided

Search Engine Optimization (SEO) involves the design (and improvement) of websites to increase non-paid visibility on search engines including Google and Bing. There is a Python script called the SEO _____ that is a web crawler designed to collect data from websites.

analyzer

In the initiation process of project management the client and project manager determine if the project is feasible or SMART. The A in SMART refers to ______ , which is the first question asked in determining feasibility. Multiple choice question.

attainable

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

centralized data base

The information technology (IT) architecture and infrastructure, software applications, programming languages, and storage technologies used for the collection, storage, analysis, and interpretation of meaningful data is referred to as the _____ ecosystem.

data

rying to answer questions such as "what happened?" or "what is occurring?" or "what was the ROI?", is the role of _____.

descriptive analytics

According to eMarketer, the e-commerce company that ranks second in market share as a percentage of sales is ____ (Amazon is #1).

eBay

Entry-level data analysts frequently start with no prior ____ , but go through extensive on-the-job training that teaches them how to apply information learned in college as well as training on organizational policies and procedures.

experience

Systems that allow organizations the ability to measure cash flows, calculate tax liabilities, maintain compliance to legal and accounting regulations, and optimize profitability are _____ management systems.

financial

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

high costs

One disadvantage of ERP systems is that they often have steep _____ curves, making it difficult for users to implement or even comprehend a new system without significant training.

learning

In Python, a collection of related programming modules that include precompiled bundles of code that can be used repetitively in different programs and applications are referred to as a Python Blank______. They often contain configuration data, templates, classes, values, and documentation.

library

Project scheduling and project communications are two functions provided by project __ (PM) software.

management

M-commerce is emerging as one of the most important areas in today's e-commerce landscape. M-commerce relies heavily on progressive web applications (PWAs) and Accelerated _____ pages (AMPs). AMPs are a creation of Google and Twitter and are designed using a scaled down version Hyper-text markup language (HTML) to create fast loading web pages.

mobile

The process of collecting, cleansing, transforming, and classifying data is referred to as data processing and _____.

modeling

Data and information in an ERP can in some ways be equated to a fishing tacklebox in that different information is usually accessed through different ___. drop zone empty.

modules

Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered ___ data.

ordinal

Derived from the term "panel data" that is used in econometrics, ______ includes a variety of modules designed to work with data.

pandas

The ability of organizations to craft marketing messages directed and product/service offerings toward specific target markets is referred to as e-commerce _____. It includes creating marketing messages that contain the individual's name, interests, and purchase behavior.

personalization

The integration of transaction _____ systems (TPS) with ERP has the ability to reduce labor costs. Due to the streamlined nature of transaction reporting, the services of accounts receivable or payroll may be reduced or eliminated

processing

The integration of transaction ______ systems (TPS) with ERP has the ability to reduce labor costs. Due to the streamlined nature of transaction reporting, the services of accounts receivable or payroll may be reduced or eliminated

processing

A major trend in data analytics is the use of artificial intelligence to focus on small data which is more precise, using small datasets that are capable of impacting decisions in the present. This is known as __ AI. Multiple choice question.

scalable

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 ___ query language.

structured

Many e-commerce sites now host areas where users can post ratings, questions, or comments about a product or service. The content that is posted in these areas is referred to as _____-generated content (UGC).

user

The graphical and structured representation of data is known as data ______

visualization