Deck 8: Databases-Business Intelligence

Question 1

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

Answer 1

False

Question 2

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 is correct

Answer 2

C

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

The financial industry uses business intelligence to predict hardware failures.

Question 7

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 is correct

Question 8

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 9

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

Question 10

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

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

Question 11

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

Question 12

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 13

Zappos is an online shoe retailer that 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 14

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

Question 15

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

Question 16

Many organisations 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 17

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

Question 18

A foreign key provides details about data.

Question 19

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

Question 20

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 21

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 22

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 23

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 24

Ben works at a top accounting firm in Sydney 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 categorised as occurring at the different ____________.

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

Question 25

What encompasses all organisational 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 26

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 27

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 28

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 29

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 30

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 31

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 32

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 33

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) Does the name and the phone values have the exact same information?
D) Is aggregate information in agreement with detailed information?

Question 34

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 35

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 36

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 37

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 38

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 39

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 40

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 41

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?

A) Data-driven website
B) Interactive website
C) Database performing website
D) Data processing website

Question 42

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

A) Development
B) Minimising human error
C) Increasing update costs
D) More efficient

Question 43

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 44

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 45

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 46

Standardising of data elements allows for:

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

Question 47

The primary purpose of a data warehouse is to ____________.

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

Question 48

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 49

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

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

Question 50

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 51

Which of the following fall in the category of external databases in the data warehouse model?

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 52

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 53

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 54

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 55

Which of the below statements means the same as easy to manage content?

A) Website owners can make changes only with the aid of MIS professionals
B) The website cannot organise customer data
C) Users can update data-driven website with little or no training
D) Users with extensive training can update data-driven websites

Question 56

Which of the following is not an example of an advantage to using the web to access organisational databases?

A) Web browsers are much easier to use than a computer-based database
B) The web interface requires few or no changes to the database model
C) It is cleaner and virus-free
D) It costs less

Question 57

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 58

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 behavioor and guide decision making
D) Process of analysing data to extract information not offered by the raw data alone

Question 59

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 60

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) Information scaling
B) Streamlining data points
C) Standardising information
D) Standardising protocols

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

Explain ETL and the role of a data mart in business.

Question 66

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

Question 67

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

Question 68

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 69

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

Question 70

Which of the below questions 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 71

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

Question 72

Explain the business benefits of a data-driven website.

Question 73

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

Question 74

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

Question 75

Data mining is the process of analysing data to extract information not offered by the raw _______ alone.

Question 76

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 77

What is it called when managers have so much data and information that they cannot make a decision?

A) Data rich,information poor
B) Data rich,content poor
C) Data rich,communication poor
D) Data rich,intelligence

Question 78

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

Question 79

Identify the business benefits of a relational database.