Deck 8: Data and Business Intelligence

Question 1

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

Answer 1

False

Question 2

Many organisations today find it next to impossible to understand their own strengths and weaknesses,let alone those of their biggest competitors,because the enormous volume of organisational data is inaccessible to all but the MIS department.

Answer 2

True

Question 3

Within the data warehouse model,the external databases are competitor information,industry information,mailing lists and stock market analysis.

Answer 3

True

Question 4

A foreign key provides details about data.

Question 5

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

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

Question 6

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

Question 7

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

Question 8

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 9

The core components of any system,regardless of size,are a database and a database management system.

Question 10

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

Question 11

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

Question 12

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

Question 13

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 answers are correct

Question 14

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 answers are correct

Question 15

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 16

The financial industry uses business intelligence to predict hardware failures.

Question 17

Analytical information encompasses all of the information contained within a single business process or unit of work-its primary purpose is to support daily operational tasks.

Question 18

Redundancy is the duplication of data,or storing the same data in multiple places.

Question 19

Information can tell an organisation how it is currently performing and help it estimate and strategise for future plans and performance.

Question 20

Forward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

Question 21

What are the rules that help ensure the quality of information?

A)Information integrity
B)Integrity constraints
C)Relational integrity constraints
D)Business-critical integrity constraints

Question 22

What is a field that uniquely identifies a given record in a table?

A)Foreign key
B)Primary key
C)Data mining key
D)DBMS key

Question 23

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 24

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 25

Which of the following is true in regards to the elimination of redundant data?

A)Uses additional hard disk space
B)Makes performing information updates harder
C)Improves information quality
D)All the answers are correct

Question 26

What is a foreign key?

A)A field (or group of fields) that uniquely identifies a given entity in a table
B)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
C)Characteristics or properties of an entity
D)A field (or group of fields) that uniquely identifies a given attribute in a table

Question 27

Which of the following asks users to write lines of code to answer questions against a database?

A)Structured query language
B)Relational query language
C)Structured elements
D)Data mining tools

Question 28

Why do relational databases use primary keys and foreign keys?

A)To create an entity
B)To create physical relationships
C)To create logical relationships
D)To create an attribute

Question 29

What encompasses all organisational information and has the primary purpose of supporting the performing of managerial analysis tasks?

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

Question 30

Your textbook discussed a record store example where one user could perform a query to determine which recordings had a track length of four minutes or more,and another user could perform an analysis to determine the distribution of recordings as they relate to the different categories.What database advantage is this an example of?

A)Increased scalability and performance
B)Increased information security
C)Reduced information redundancy
D)Increased flexibility

Question 31

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)Trends, future growth analysis, sales projections and product statistics
D)Packing slips, grocery receipt and competitor information

Question 32

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 33

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

A)All the values are correct
B)The email address is invalid
C)The dollar amount is recorded properly
D)Aggregate information is in agreement with detailed information

Question 34

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

A)Entity
B)Relationships
C)Attribute
D)Foreign key

Question 35

If employees are using a supply chain management system to make decisions,they may find that their suppliers send information in different ways.One supplier may send detailed information in a spreadsheet,another supplier may send summary information in a word-processed document and still another may send aggregate information from a database.These different ways of sending informationwould be categorised as occurring in different ____________.

A)information levels
B)information formats
C)information ranks
D)information focuses

Question 36

What is a primary key?

A)A field (or group of fields) that uniquely identifies a given record in a table
B)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
C)Characteristics or properties of an entity
D)A field (or group of fields) that uniquely identifies a given attribute in a table

Question 37

Which of the following illustrates the primary concepts of the relational database model?

A)Ethics, applications, keys and relationships
B)Entities, attributes, keys and relationships
C)Endeavour, aspire, control and regulate
D)Early, after, before and future

Question 38

Which of the below is not an example of an advantage of using a relational database?

A)Increased information quality
B)Increased flexibility
C)Decreased information redundancy
D)Decreased information security

Question 39

What is the primary difference between an entity and an attribute?

A)An attribute is a table, an entity is a column from the attribute table
B)An entity is specific; whereas, an attribute is not data at all but brainstorming ideas that take place before the entity is created
C)An attribute refers to applications, and an entity refers to executives
D)An entity is a table that stores information about people, places or events; whereas, an attribute is a column or specific field of the data elements associated with an entity

Question 40

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

A)Data mining tools
B)Structured example language
C)Query-by-example tool
D)Relational query tool

Question 41

The primary purpose of a data warehouse is to ____________.

A)Information scaling
B)Streamlining data points
C)Standardising information
D)Standardising protocols

Question 42

What are the three common forms for mining structured and unstructured data?

A)Cluster analysis, association detection, statistical analysis
B)Cluster analysis, association detection, disassociation detection
C)Cluster analysis statistical detection, statistical analysis
D)Association detection, market-basket analysis, market-basket association

Question 43

Enterprise systems are often available as a generic,but highly customisable,group of programs for business functions,but which function would not usually be included?

A)Inconsistent data definitions
B)Lack of data standards
C)Increased data quality
D)Inadequate data usefulness

Question 44

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

A)Data warehouses make quick decisions, data marts make slow decisions
B)Data warehouses tackle ethical issues, data marts tackle hypothetical issues
C)Data warehouses have a more organisation-wide focus, data marts have functional focus
D)Data warehouses have a physical focus, data marts have logical focus

Question 45

Which of the following is not a benefit of BI?

A)Disables efficient collection and distribution of vital data and statistics
B)Helps align the organisation towards its key objectives
C)Enables faster and fact-based decision making
D)Combines multiple sources of data

Question 46

Which of the below defines the relationship between variables along with the nature and frequency of the relationship?

A)Association detection
B)Masking detection tool
C)Cluster grouping
D)Blocking barriers

Question 47

What is data mining?

A)The common term for the representation of multi-dimensional information
B)A particular attribute of information
C)Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behaviour and guide decision making
D)Process of analysing data to extract information not offered by the raw data alone

Question 48

Which of the following is not a typical drawback of not integrating databases?

A)Combine strategic information
B)Organise departments
C)Interface between the computer and employees
D)All the answers are correct

Question 49

Which of the following is not a common form of data mining?

A)Division organisation
B)Classification
C)Estimation
D)Clustering

Question 50

All of the following are business-critical integrity constraints,except

A)System does not allow an entry for an order for a non-existent customer
B)System does not allow returns of fresh produce after 15 days past delivery
C)System does not allow shipping a product to a customer who does not have a valid address
D)Systems does not allow shipping of a non-existent product to a customer

Question 51

Which of the following techniques performs such functions as information correlations,distributions,calculations and variance analysis?

A)Clustering objective analysis
B)Statistical analysis
C)Entity modelling
D)Market basket analysis

Question 52

Which of the following forms of data mining assigns records to one of a predefined set of classes?

A)Clustering
B)Classification
C)Estimation
D)Affinity grouping

Question 53

Standardising of data elements allows for:

A)Marketing, sales, inventory and billing
B)Data mart 1, data mart 2 and data mart 3
C)Competitor and industry information, mailing lists and stock market analysis
D)Marketing information, sales information and stock market analysis

Question 54

Gender can be referred to in many ways (male,female,M/F,1/0) in a data warehouse.What is this an example of?

A)Greater accuracy, completeness and consistency
B)Stabilised pivot tables
C)Faster processing of clients
D)Increased security features

Question 55

Enterprise application integration (EAI) connects the plans,methods and tools aimed at integrating separate enterprise systems.Why doesEAI review how legacy systems fit into the new shape of the organisation's business processes?A.To reuse what already exists while adding new systems and data

A)Systemic and analytic integration
B)Enhanced and relational integration
C)Forward and backward integration and central repositoryintegration
D)Independent repository integration and hierarchicalintegration

Question 56

Which of the following describes ETL?

A)A process that extracts information from internal and external databases
B)A process that transforms information using a common set of enterprise definitions
C)A process that loads information into a data warehouse
D)All the answers are correct

Question 57

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

A)Relational integrity constraint
B)Business-critical integrity constraint
C)Information-critical integrity constraint
D)None of the answers is correct

Question 58

What are two common methods used for integrating databases?

A) Accounting
B)Manufacturing
C)Engineering
D)Marketing

Question 59

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

A)Statistical detection
B)Cluster analysis
C)Association detection
D)None of the answers is correct

Question 60

What are rules that enforce basic and fundamental information-based constraints?

A)Information integrity
B)Integrity constraint
C)Business-critical integrity constraint
D)Relational integrity constraint

Question 61

Explain the four primary traits that determine the value of information.

Question 62

Which of the questions below can be answered using business intelligence?

A)Where has the business been?
B)Where is the business now?
C)Where is the business going?
D)All the answers are correct.

Question 63

Data mining is the process of analysing data to find hidden patterns and discover new insights not offered by the raw ___________ alone.

Question 64

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

Question 65

ETL is one of the three main BI tool categories.What does ETL do,and what is the role of a data mart in business?

Question 66

Broadly defined,a __________ maintains information about various types of objects,events,people and places.

Question 67

Describe a database,a database management system and the relational database model.

Question 68

What BI tools are required depends on how the data is currently managed and how it is to be analysed.BI software can be divided into three broad application categories;namely,data management tools,data discovery applications and reporting tools.What value can they potentially add to a business?

Question 69

Define data mining,and explain the three common forms for mining structured and unstructured data.

Question 70

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

Question 71

Extraction,transformation and ___________ is a process that extracts information from internal and external databases,transforms it using a common set of enterprise definitions and loads it into a data warehouse.

Question 72

Data __________ issues occur when a system produces incorrect,inconsistent or duplicate data.

Question 73

Identify the advantages of using business intelligence to support managerial decision making.

Question 74

An____________ allows separate systems to communicate directly with each other.

Question 75

BI,business analytics and data science appear quite similar.However,each is different and it has become increasingly necessary for organisations to become cognizant of the distinctions between these terms,as they relate to the value they can produce for the enterprise.How do BI,business analytics and data science differ?

Question 76

Business intelligence processes data from data warehouses or data marts using computing technologies for the identification,___________ and analysis of business data.

Question 77

The primary purpose of a data ___________ is to combine information (specifically,strategic information) throughout an organisation into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

Question 78

Define a data warehouse and provide a few reasons it can make a manager more effective.

Question 79

Identify The business benefits of a relational database.

Question 80

Explain enterprise application integration.