Chapter 6 quiz

Data-driven decision management is usually undertaken as a way to gain a competitive advantage. A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had ________ productivity rates and ________ profits.

4% higher, 6% higher

What is a data broker?

A business that collects personal information about consumers and sells that information to other organizations.

What is a foreign key?

A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables

What is prediction?

A statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.

A database maintains information on _____. A. Employees B. Inventory C. Transactions D. All of the above

D. All of the above

Business analysis is difficult from operational databases. Which of the following is a reason why? A. The data, if available, were often incorrect or incomplete. B. Every department has its own method for recording data. C. Lack of data standards across departments. D. All of the above.

D. All of the above

What does standardization of data elements accomplish? A. Increases the quality of information. B. Greater accuracy. C. Completeness and completeness. D. All of the above.

D. All of the above

Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence? A. Compare the demographics of patients with critical illnesses. B. Understand customer credit card usage and nonpayment rates. C. Analyze popular vacation locations with current flight listings. D. All of the above are examples of how industries use business intelligence.

D. All of the above are examples of how industries use business intelligence

What are the primary differences between a data warehouse and a data mart?

Data warehouses have a more organization-wide focus, data marts have functional focus

Which of the following represents the different information formats?

Document, presentation, spreadsheet, database

What includes data that change based on user actions?

Dynamic information

What includes data that change based on user actions?

Dynamic information.

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

Entity

What is a data scientist?

Extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information.

A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. True or False?

False Foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

A DBMS provides details about data. True or False?

False Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

A field is a collection of related data elements True or False

False. Record is a collection of related data elements

What is dynamic information?

Includes data that change based on user action.

In terms of big data what is volume?

Includes the scale of data.

Which of the following is not an advantage to a data-driven website?

Increasing update costs.

Which of the following represent the four primary traits that help determine the value of information?

Information type, information timeliness, information quality, and information governance

What are forecasts?

Predictions based on time-series information.

What is data mining?

Process of analyzing data to extract information not offered by the raw data alone

What is a real-time system?

Provides real-time information in response to query requests.

Which of the following refers to immediate, up-to-date information?

Real-time information.

Which of the following is a business-critical integrity constraint?

System will not allow returns of fresh produce after 15 days past delivery

Why do relational databases use primary keys and foreign keys?

To create logical relationships

A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer. True or False?

True

A data mart contains a subset of data warehouse information. True or False

True

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database. True or False

True

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database. True or False

True

A repository is a central location in which data is stored and managed. True or False

True

Accurate information asks if there is an incorrect value in the information. True or False?

True

Big data is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools. True or False?

True

Data visualization tools move beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more. True or False

True

Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information. True or False?

True

ETL stands for extraction, transformation, and loading. True or False?

True

Which of the following would not be considered part of the timely characteristic of high-quality information?

is the zip code missing in the address?