Deck 6: Data: Business Intelligence

Question 1

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

Answer 1

True
Explanation: Information granularity refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Question 2

Information granularity means immediate,up-to-date information.

Answer 2

False
Explanation: Real-time information means immediate,up-to-date information.

Question 3

Information integrity issues occur when a system produces incorrect,inconsistent,or duplicate data.

Answer 3

True
Explanation: Information integrity issues occur when a system produces incorrect,inconsistent,or duplicate data.

Question 4

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Question 5

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

Question 6

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 7

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

Question 8

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

Question 9

Real-time systems provide real-time information in response to requests.

Question 10

A foreign key provides details about data.

Question 11

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

Question 12

Information granularity occurs when the same data element has different values.

Question 13

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

Question 14

Data governance refers to the overall management of the availability,usability,integrity,and security of company data.

Question 15

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

Question 16

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

Question 17

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

Question 18

Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Question 19

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

Question 20

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

Question 21

A content creator is the person responsible for creating the original website content.

Question 22

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

Question 23

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

Question 24

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

Question 25

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 26

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

Question 27

Information integrity is a measure of the quality of information.

Question 28

Zappos is an online shoe retailer,built its data-driven website catering 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 29

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

Question 30

The physical view of information deals with the physical storage of information on a storage device.

Question 31

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

A content creator is the person responsible for updating and maintaining website content.

Question 37

Integrity constraints are rules that help ensure the quality of information.

Question 38

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.Stating that merchandise returns are allowed within 10 days of purchase is an example of a business rule.

Question 39

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

Question 40

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

Question 41

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 42

Dynamic website information is stored in a dynamic catalog,or an area of a website that stores information about products in a database.

Question 43

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

Question 44

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 45

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

Question 46

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

Question 47

A data miner contains a subset of data warehouse information.

Question 48

Static information includes data that change based on user actions.

Question 49

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

Question 50

Static information includes fixed data incapable of change in the event of a user action.

Question 51

Association detection is a technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible.

Question 52

Data mining occurs on structured data that are already in a database or a spreadsheet.

Question 53

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

Question 54

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

Question 55

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

Question 56

Association detection reveals the relationship between variables along with the nature and frequency of the relationship.

Question 57

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 58

Data warehouses struggle with combining too much standardized information.

Question 59

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

Question 60

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

Question 61

Unstructured data analyzes data to find trends and patterns in words and sentences.

Question 62

Data visualization tools can help uncover correlations and trends in data that would otherwise go unrecognized.

Question 63

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

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

Question 64

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

Question 65

What 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?

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

Question 66

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.

Question 67

Informing dashboards track corporate metrics such as critical success factors and key performance indicators and include advanced capabilities such as interactive controls allowing users to manipulate data for analysis.

Question 68

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 69

Employees need to compare different types of information for what they commonly reveal to make strategic decisions.Which of the below 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 70

Web mining analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Question 71

Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

Question 72

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

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

Question 73

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 the above

Question 74

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 the above

Question 75

The financial industry uses business intelligence to predict hardware failures.

Question 76

Infographics can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time.

Question 77

Unstructured data do not exist in a fixed location and can include text documents,PDFs,voice messages,emails,and so on.

Question 78

Infographics (information graphics)displays information graphically so it can be easily understood.

Question 79

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 the above

Question 80

Informing is accessing large amounts of data from different management information systems.