IS Midterm Exam

In the statement: SELECT * FROM Customers, the asterisk (*) indicates that the user wants to extract all the columns of data FROM the _____table.

'customers' table

Managers have the greatest degree of control over a new business management system that is implemented as

??

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

Working on data analytics teams to extract data from large data sets, creating reports that outline key findings, monitoring key performance indicators (KPIs) to identify success or failure, and analyzing data to identify trends are just a few of the responsibilities of a data _____.

Analyst

What is conducted in the process modeling step of business process management?

Analysts use flowcharts and other tools to depict workflow.

The process of investigating raw data of various types to uncover trends and correlations, and to answer specifically crafted questions is the role of data ______.

Analytics

In terms of information quality, define "relevance" as a factor.

Data to be collected should be useful to the organization.

During a project, it is determined that some of the necessary equipment will arrive 1 week later than anticipated. In order to keep the project moving, the project manager decides to begin the second step of the project before the first step is completed. During what phase of the project management process would this occur in?

Execution Phase

By allowing managers to model, analyze, and improve business processes through automation, business performance management (BPM) systems streamline organizations' activities.

False

The third step in business process management provides managers with real-time (executable) decision making as well as the ability to play the "what-if" game by changing input variables (abstract) decision making. This is called the process modeling step.

False

What are two reasons firms use benefits management software?

HR managers must keep up to date with legal requirements. Today's benefits programs are complex.

Which statements about the analytical hierarchy process (AHP) model are true? Select all the correct answer options.

It is a multi-criteria programming model that uses an analytical hierarchy process for decision making. It allows for many variables or conditions to be considered and prioritized, resulting in the selection of the best alternatives or projects. It analyzes intricate situations and scenarios by deconstructing the problem into a visible hierarchy that can be analyzed through comparison.

Which three of the following statements about management filters are true?

Management filters are included in project management software applications. Management filters eliminate the need to search through large volumes of data. Management filters allow managers to select specific data for specific decisions.

The phenomenon in which computer chips double in computing power roughly every 18 months is called

Moore's Law.

Databases maintain data and information about various types of data ________.

Objects

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

Power BI Pro Power BI Premium Power BI Desktop

Information in tables is stored in ________called records and ________called fields.

Rows Columns

Trends in data analytics include which three of the following?

Scalable AI Composable data Data analytics as a core business function

A manager is trying to decide which vendor she should use to manage social media promotion. Which of the following is an example of how she would compare selection criteria? More than one answer may be correct.

She would determine which vendor has previously gotten companies a lot of buzz on social media platforms. She would determine which vendor has prices that fit with in her social media budget. She would determine which vendor is offering more content generation than the others.

The first two steps in business process management (BPM) are examining the design of the process and modeling the process. What are the third and fourth steps of the process?

Step 3: running the process; Step 4: monitoring the process

What occurs in the process execution step of business process management?

The business process execution language engine is run.

he process of converting the format of data from one form to another is called data ________.

Transformation

In the fourth step of business process management, managers measure the performance of the engine. This is called the process monitoring step.

True

Major corporations often manage their employee compensation plans through web-based services.

True

The business management system with the lowest initial or startup expenses is

a software as a service (SaaS) option.

What is a Gantt chart?

a visual timeline of project phases and tasks

From the following list, select ways in which CRM systems are used for customer acquisition.

acquiring customers using social media, search, affiliate, referral, and email marketing tracking customer acquisition using a lead generation funnel tracking prospective and current customers through all stages of the funnel

There are many RDBMS query tools we can use. Those query tools include crosstab queries, ________ queries, parameter queries, and queries specific to SQL.

action

When investigating a solution, what information is it important for you to identify?

any additional information you may need how much time or money you have available to fix the problem who you can blame for the problem how your predecessor would have solved the problem

How do CRM systems make it easier for businesses to target a market segment? More than one answer option may be correct.

by providing a variety of analytical tools, including some for identifying and understanding the target market by collecting data from customer transactions, which can be used for target market identification by helping organizations precisely identify their target markets and best utilize resources when marketing to potential and existing customers

What is the last step in the Five Whys?

consult with members of the organization

What is one of the greatest risks of an organization storing customer data?

data breaches

Reports offer a way to view, format, and summarize the information in a ________.

database

The process of data analytics includes which three of the following?

descriptive analytics predictive analytics prescriptive analytics

Customer interaction encompasses all communication between a customer and an organization. A customer relationship management system (CRM) captures interactions from which three of the following sources?

email social media traditional mail

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

errors

Apple has a very high customer equity (CE) value. Apple has gained this high CE value due to

extreme customer loyalty.

What type of decision-making software can identify issues and find and implement solutions at transactional speed?

high-velocity

The business world is overwhelmed by data. It estimated that 1.7MB of data is created every second by every person. Data volume has grown substantially in the last few years, when 90% of the world's data has been created. Of the following, what is the most useful fully computerized tool that can directly translate data into decisions and solutions?

high-velocity automated decision making

Henry Mintzberg classifies management roles into three types. Which of the following roles does this researcher identify? More than one answer may be correct.

interpersonal informational decisional

From the following list, select all the vital functions of customer relationship management (CRM) systems for businesses.

managing critical relationships helping synchronize customer interactions providing insights into customer satisfaction metrics

Of the following categories, which are identity data? More than one answer may be correct.

name and address date of birth family status

When discussing personally identifiable information (PII), which three of the following are usually anonymized?

names phone numbers Social Security numbers

Before the use of computers and database management systems (DBMS), traditional files systems used ________ files, ________, and ________. Check All That Apply

paper folders filing cabinets

Databases are designed to keep data and information about different types of data objects, including objects, events, ________, and places.

people

During the optimization process step of business process management, what are two key things manager look for in the process?

potential slowdowns and savings opportunities

The first step in business process management, in which analysts often "storyboard" the processes in an attempt to view the entire system prior to investigating each component is called

process design.

The third step in business process management provides managers the ability to play the "what-if" game by changing input variables (abstract) decision making. This step is called

process execution.

In the fourth step in business process management, managers track the individual components of the process as well as the process as a whole so engine performance can be measured. This step is called

process monitoring.

The main objectives of data governance include high-quality data and which other goals?

risk mitigation data use rules requirement compliance

In which stage of Herbert Simpson's four stage process for decision making are solutions identified?

second

For the process of monitoring customer procurement methods, which of the following types of customer data does a CRM system collect? More than one answer may be correct.

shopping methods motivation purchase frequency

SoSQL (non-relational databases) are also useful for querying the data generated by ________ sites, ________ apps, and other emerging digital content sources.

social media mobile

he main tools used by data analysts include which three of the following?

spreadsheets databases and query languages data visualization tools

Data governance involves the staff, procedures, and technologies needed to________ and protect the data and data properties of an entity.

supervise

Why is the meeting between all project stakeholders and key players scheduled as the final step in the planning phase?

the budgets and timelines need to be finalized before stakeholders and key players can understand the scope of the projects and their role within the project

Why might an HR director be reluctant to change the organization's business management system, even if a new one falls within the department budget? More than one answer may be correct.

the fear that the change will cause at least a short-term decrease in productivity the fear that the change will stress the employees required to adapt to the new system

The concept of "share of customer" focuses on getting

the most business from the fewest customers.

Share of customer, which focuses on getting as much business as possible from fewer customers, is also known as share of

wallet.