Question 1

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

Accepted Answer

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

Question 2

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 ____________.

Accepted Answer

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

Question 3

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.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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 7

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?

Accepted Answer

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

Question 8

What is data mining?

Accepted Answer

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 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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 12

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

Accepted Answer

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 13

Which of the following represents the different information levels?

Accepted Answer

A)  Detail,summary,aggregate 
B)  Document,presentation,spreadsheet,database 
C)  Individual,department,enterprise 
D)  None of the answers is correct

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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 16

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

Accepted Answer

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

Question 17

Which of the following represents the different information granularities?

Accepted Answer

A)  Detail,summary,aggregate 
B)  Document,presentation,spreadsheet,database 
C)  Individual,department,enterprise 
D)  None of the answers is correct

Question 18

What is a foreign key?

Accepted Answer

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 19

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The answer of Describe a database,a database management system and...

Exam 8: Databases-Business Intelligence

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

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.

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

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

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

What is data mining?

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

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

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

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

Which of the following represents the different information levels?

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

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

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

Which of the following represents the different information granularities?

What is a foreign key?

The financial industry uses business intelligence to predict hardware failures.

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