Deck 6: Data: Business Intelligence

Question 1

A foreign key provides details about data.

Answer 1

False
Explanation: This is the definition of metadata.

Question 2

The three primary data models for organizing information in a DBMS are hierarchical, network, and metadata.

Answer 2

False
Explanation: The three primary data models for organizing information in a DBMS are hierarchical, network, and relational database.

Question 3

There are three primary data models for organizing information: the hierarchical, network, and relational database models.

Answer 3

True
Explanation: A DBMS uses three primary data models for organizing information: the hierarchical, network, and relational database models.

Question 4

Today's chief information officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Question 5

If a manager identifies numerous data integrity issues, she or he should consider the reports generated from that data as invalid and not use them when making decisions.

Question 6

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.

Question 7

Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than business critical integrity constraints.

Question 8

A data warehouse is a tool that helps in many ways, including implementing customer profiles, hurting business operations, and many times alienating competitors.

Question 9

Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Question 10

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Question 11

A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Question 12

Zappos is an online shoe retailer, built its data-driven website caters to a specific niche market: consumers who were tired of finding that their most-desired items were always out of stock at traditional retailers.

Question 13

Data warehouses struggle with combining too much standardized information.

Question 14

There are two primary traits that help you determine the value of information: timeliness and quality.

Question 15

Information can tell an organization how it's currently performing and help it estimate and strategize for future plans and performance.

Question 16

The core component of any system, regardless of size, is a database and a database management system.

Question 17

MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

Question 18

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Question 19

Data-driven websites offer several advantages because it is far easier to manage content and store large amounts of data.

Question 20

Data redundancy is the duplication of data, or the storage of the same data in multiple places.

Question 21

Reports for each sales person, product, and part are examples of detail or fine information granularities.

Question 22

The data warehouse is a location for all of business information.

Question 23

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Question 24

One of the advantages found in a relational database is increased information redundancy.

Question 25

Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database.

Question 26

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Question 27

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

Question 28

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Question 29

The primary purpose of a data warehouse is to perform transactional processes.

Question 30

The financial industry uses business intelligence to predict hardware failures.

Question 31

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

Question 32

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

Question 33

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Question 34

Text mining analyzes structured data to find trends and patterns in words and sentences.

Question 35

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Question 36

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

Question 37

ETL, within a data warehouse model, stands for exit, track, and load.

Question 38

A data miner contains a subset of data warehouse information.

Question 39

Organizational information comes at different levels and in different formats and granularities.

Question 40

Timely information must be up-to-the-second to be accurate.

Question 41

What encompasses all organizational information where its primary purpose is to support the performing of managerial analysis tasks?

A)Transactional information
B)Analytical information
C)Timeliness
D)Quality

Question 42

Which of the following represents the different information granularities?

A)Detail, summary, aggregate
B)Document, presentation, spreadsheet, database
C)Individual, department, enterprise
D)None of these

Question 43

Which of the following is not one of the five characteristics common to high-quality information?

A)Accuracy
B)Completeness
C)Quantity
D)Consistency

Question 44

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

A)Information type, information timeliness, information quality, and information governance
B)Information statistics, information tracking, information quality, and information governance
C)Information type, information chance, information analytics, and information policy
D)Information timeliness, information quality, information quantity, and information governance policy

Question 45

Which of the following implies that information is current with respect to the business requirement?

A)Uniqueness
B)Accuracy
C)Consistency
D)Timeliness

Question 46

Which of the following represents the different information formats?

A)Detail, summary, aggregate
B)Document, presentation, spreadsheet, database
C)Individual, department, enterprise
D)None of these

Question 47

Which of the following encompasses all organizational information, where its primary purpose is to support the performing of managerial analysis tasks?

A)Analytical information
B)Transactional information
C)Statistical information
D)Targeted information

Question 48

Which of the following is not a primary trait of information?

A)Transactional
B)Analytical
C)Timeliness
D)Quantity

Question 49

Which of the following implies that aggregate or summary information is in agreement with detailed information?

A)Uniqueness
B)Completeness
C)Consistency
D)Accuracy

Question 50

What is immediate, up-to-date information?

A)Real-time information
B)Real-time systems
C)Information granularity
D)All of these

Question 51

Which of the following represents the different information levels?

A)Detail, summary, aggregate
B)Document, presentation, spreadsheet, database
C)Individual, department, enterprise
D)None of these

Question 52

What are the two different categories for information type?

A)Analytical and productive
B)Analytical and analysis
C)Transactional and analytical
D)Transactional and analysis

Question 53

Which of the following encompasses all of the information contained within a single business process or unit of work, where its primary purpose is to support daily operational tasks?

A)Targeted information
B)Analytical information
C)Productive information
D)Transactional information

Question 54

Which of the following refers to the extent of detail within the information?

A)Knowledge information
B)Information granularity
C)Chance information
D)Information analytics

Question 55

What is it called when each transaction, entity, and event is represented only once in the information?

A)Uniqueness
B)Accuracy
C)Consistency
D)Timeliness

Question 56

What is a real-time system?

A)It provides immediate, up-to-date information.
B)It provides real-time information in response to query requests.
C)It encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks.
D)It encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks.

Question 57

What provides real-time information in response to query requests?

A)Real-time information
B)Real-time systems
C)Information level
D)All of these

Question 58

Employees need to compare different types of information for what they commonly reveal to make strategic decisions.Which of the following represents the three common types of information found throughout an organization?

A)Levels, forms, granularities
B)Levels, forms, data
C)Levels, formats, granularities
D)Data, formats, granularities

Question 59

What is one of the biggest pitfalls associated with real-time information?

A)It is only available to high-level executives due to the expense.
B)It is only available in aggregate levels of granularity.
C)It continually changes.
D)It rarely changes.

Question 60

What encompasses all of the information contained within a single business process or unit of work where its primary purpose is to support the performing of daily operational tasks?

A)Transactional information
B)Analytical information
C)Timeliness
D)Quality

Question 61

Ben works at a top accounting firm in Salt Lake City, and his responsibilities include developing reports for each salesperson, product, and part as well as departmentwide sales reports by salesperson, product, and part.Ben's duties provide value-added to his company and would be categorized as occurring at the different _____________.

A)Information levels
B)Information formats
C)Information granularities
D)Information focus

Question 62

Which of the following provides real-time information in response to requests?

A)Sales system
B)Transactional system
C)Real-time system
D)Salary system

Question 63

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

A)Is the Zip code missing in the address?
B)Is the information current with respect to business needs?
C)Is the customer address current?
D)Is the information updated weekly or hourly?

Question 64

Which of the following does not represent a company that requires up-to-the-second information?

A)911 response units
B)Stock traders
C)Banks
D)Construction companies

Question 65

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.

A)Improvements
B)Change
C)Clustering
D)Cleansing

Question 66

Which of the following companies used analytical analysis to identify a correlation between storms and the increased sale of Pop-Tarts?

A)7-Eleven
B)Burger King
C)McDonald's
D)Walmart

Question 67

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

A)Are there any duplicate orders?
B)Are there any duplicate customers?
C)Is aggregate information in agreement with detailed information?
D)Is each transaction and event represented only once in the information?

Question 68

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

A)Daily information
B)Strategic information
C)Real-time information
D)Crisis information

Question 69

Which of the following are examples of analytical information?

A)Airline ticket, sales receipts, and packing slips
B)Hotel reservation, sales receipts, and packing slips
C)Future growth analysis, sales projections, and product statistics
D)Packing slips, grocery receipt, and competitor information

Question 70

Ben works at a top accounting firm in Salt Lake City, and his responsibilities include developing individual and departmental goals and generating financial analysis across departments and the enterprise as a whole for the executive team to review.Ben's duties provide value-added to his company and would be categorized as occurring at the different _____________.

A)Information levels
B)Information formats
C)Information granularities
D)Information focus

Question 71

Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?

A)Data inconsistency issue
B)Data integrity issue
C)Data control issue
D)Data mining issue

Question 72

Which of the following lists include all of the five characteristics common to high-quality information?

A)Accuracy, completeness, strength, support, and positive feedback
B)Accuracy, association, referral, sales, and marketing
C)Accuracy, competition, support, customer service, and visibility
D)Accuracy, completeness, consistency, timeliness, and uniqueness

Question 73

Which of the following represents a reason an organization might encounter low-quality information?

A)Online customers intentionally enter inaccurate information to protect their privacy.
B)Different systems have different information-entry standards and formats.
C)Third-party and external information contains inaccuracies and errors.
D)All of these.

Question 74

Which of the following occurs when the same data element has different values?

A)Data modeling issue
B)Data mining issue
C)Data governance issue
D)Data inconsistency issue

Question 75

Ben works at a top accounting firm in Salt Lake City, and his responsibilities include writing letters, memos, and emails along with generating reports for financial analysis and marketing materials for products.Ben's duties provide value-added to his company and would be categorized as occurring at the different _____________.

A)Information levels
B)Information formats
C)Information granularities
D)Information focus

Question 76

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

A)Is a value missing from the personal information?
B)Is each transaction represented only once in the information?
C)Is the address incomplete?
D)Is the area code missing for the phone information?

Question 77

Which of the following are examples of transactional information?

A)Airline ticket, sales receipts, and packing slips
B)Trends and sales statistics
C)Product sales results, grocery receipts, and growth projections
D)Airline tickets and sales growth spreadsheets

Question 78

Nestlé is one of the companies shown as an example of low-quality information causing problems for the company.Which of the following are some of the errors they found in the data or information?

A)They had 550,000 actual vendors, yet the information reports showed more than 9 million due to duplication and abbreviation inaccuracies.
B)Some of the vendor names were abbreviated, whereas others were not.
C)They had too many inaccuracies and duplications to be able to identify customer profitability.
D)All of these

Question 79

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

A)Do all sales columns equal the total for the revenue column?
B)Is the two-digit state code missing in the information?
C)Is all summary information in agreement with detailed information?
D)Does the order number match the item and the color options available?

Question 80

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

A)Is the name spelled correctly?
B)Is the email address invalid?
C)Do the name and the phone values have the exact same information?
D)Is aggregate information in agreement with detailed information?