BMIS 311

Which of the following is an example of why a database should be accessible through the web?

A company has recently scaled its operations so that it competes internationally and needs business partners all over the world to have access to its database. A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work. A small distributor with limited staffing wants customers to be able to track the status of their orders without having to contact a customer service representative.

Which statement best summarizes how organizations use data warehouses?

Data warehouses are used to store data from multiple sources for collective analysis

Data mining is best described as

a research and analysis technique in which data analysts employ mathematical tools and artificial intelligence (AI) to search large volumes of data and discover less-obvious patterns and trends

n the ClassList table, the primary key is likely the __ field.

classnumber

Organizing data so that data are in simple tables without any redundancies is known as

data normalization

Organizations use data warehouses mainly to

facilitate the analysis of data from multiple sources

To create a relationship between two tables, it is necessary to create a key in one table that is the primary key of the other table.

foreign

The primary purpose of a business intelligence (BI) system is to

help a business make strategic decisions based on its own data

Businesses use business intelligence (BI) systems to

help them make decisions that are informed by business data and facts

Businesses can use in-memory computing to conduct or support almost any task that

involves the near-instantaneous processing and analysis of huge volumes of data

In contrast to computerized systems, traditional file management systems can create issues with ______.

organization, repetition, and lack of consistency

Analytic platforms are designed to

quickly gather and analyze specific organizational data to provide information that guides decision making

In the datasheet view of a relational database (such as Microsoft Access), a row of information is called a

record

The primary characteristic of a relational database is that it

stores and allows access to data objects that are related to one another

A DBMS maximizes the benefits a database can provide. DBMS stands for Database Management

system

Which of the following is an example of what an information policy could specify?

A health insurance company stores data that patients self-report as inputs on its website, but does not link that data with information about the patient's search history. A large corporation grants access to salary information to the direct supervisors of employees and to members of the Human Resources department who administer payroll. A user agreement on a website indicates that it will store the browsing history linked to the IP address for an indefinite amount of time and reserves the right to sell that information to interested parties.

Which of the following sets of characteristics specifically apply to relational databases?

A relational database organizes data in tables composed of records or objects(rows) and fields(columns) Data tables in a relational database are linked by the fields they have in common

Which of the following would be a reason why an organization would use web usage mining?

An e-commerce business looking to improve the customer experience on its website to boost sales wants to know what types of sites users go to after visiting their website and putting items in their cart, but not completing a purchase. A new social media platform wants to increase engagement and is looking to know what content its most frequent users spend the most time engaging with.

Which of the following is an example of an organization analyzing predictive behavior with the goal of creating new offerings?

An in-home healthcare provider tracks the hospital readmission rates of elderly people who live alone after they received care for falling in their homes. Netflix tracks what users who viewed all three seasons of Stranger Things also had in their queues.

Which of the following are primary goals of database normalization?

Avoid anomalies during database operations. Reduce data redundancy. Maintain data consistency.

In analyzing transactions, Walmart discovered that many people who buy Children's Tylenol in their stores also buy orange juice in the same transaction. They used this information to discount Children's Tylenol but raised the price of orange juice during flu season. What is the name of the approach Walmart used to discover this information?

Big data

Select the two statements that correctly explain the roles of data marts and data warehouses in a decision support system (DSS).

Data warehouses are used to analyze long-term, historical data for an organization's strategic purposes, because they store data from different time periods and subject areas. Data marts are used to analyze recent data that a department needs for operational troubleshooting and management, because they collect and measure data specific to that area.

Which statement best explains why traditional file systems have certain issues?

Each file is independent of another file in a traditional system.

Which of the following is not considered an entity in a university database?

Lecture Times

Which of the following are primary functions of SQL in database management?

Manipulating data Defining data Querying data

Which of the following correctly identify how SQL is used in different industries?

Marketing to analyze sales and advertising success Finance for handling and analyzing large data sets Healthcare for patient data analysis and reporting

Which of these steps in the data mining process most likely involves the actual "mining" or "Knowledge Discovery in Data"?

Model building and evaluation

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

Normalization

Why is it important for all organizations, no matter how small, to create and implement organizational information policies?

Organizational data are a critical asset; it is important to ensure its security.

Which of the following tasks can businesses perform with the help of in-memory computing?

Predicting the impact of news on stock prices and conducting immediate transactions - Alerting online customers that the desired item is out of stock, before the order is placed - Mapping alternate driving routes to help truckers avoid bad weather and traffic jams

For which task is a data mart more useful or appropriate than a data warehouse?

Resolving a current problem with a specific type of inventory, purchase transaction, or supply chain

Which statement best summarizes the primary advantages of performing a data quality audit?

The audit recommends ways the organization can improve its data quality and reduce costs through increasing data consistency.

From the following list, select all of the examples of a relationship that an entity-relationship diagram (ERD) could be used to describe.

The employees who report to a specific manager in an organizational chartThe courses a student is takingProducts a customer has ordered

Why do large, data-driven companies use analytic platforms?

They generate vast amounts of organizational data and need to be able to rapidly analyze and interpret this information to make informed business decisions.

Which of the following is an example of an advantage of being able to access a database via the web? Turnover among telephone customer service representatives at your company is high and they receive only brief training before they interact with customers. Reps need to be able to access your sales database to assist customers who call. Your product is primarily sold in developing countries where most of your suppliers are small business owners who access the Internet via a mobile device instead of a computer. Your company needs suppliers in all countries to be able to access your inventory database. A company wants to ensure that the data it keeps on its database are secure and cannot be accessed by unauthorized users.

Turnover among telephone customer service representatives at your company is high and they receive only brief training before they interact with customers. Reps need to be able to access your sales database to assist customers who call. Your product is primarily sold in developing countries where most of your suppliers are small business owners who access the Internet via a mobile device instead of a computer. Your company needs suppliers in all countries to be able to access your inventory database.

Where could you click to switch to the Design view?

View

A corporate sales organization is hosting its annual regional meeting. It needs to book a hotel within the region where attendees will stay for three days and two nights. The hotel must have: 30 standard hotel rooms for its sales reps, 5 suites for the regional managers, and 5 conference rooms to hold training sessions. There also must be two restaurants within walking distance of the hotel that can accommodate a dinner reservation for 40 people. Which web mining technique would the organization use to narrow down the choices of hotels to those that fit these parameters?

Web content mining