Ebusiness - chapter 10

24) In data analysis and reporting methods, the value of BI (Business Intelligence) increases as the complexity of the level of: A) performance increases. B) performance increases. C) analysis increases. D) analysis decreases. E) information increases.

Answer: C Diff: 3 Type: MC Page Ref: 223 Skill: A Objective: 3

29) The most common form of database used in BI systems is a: A) customer database. B) client database. C) open-source database. D) relational database. E) embedded database.

Answer: D Diff: 1 Type: MC Page Ref: 228 Skill: R Objective: 4

1) A critical success factor for BI is: A) ease of use B) scalability C) flexibility D) performance and security E) all of the above

Answer: E

19) What are the main functions of a data warehouse? A) analyzing data B) storing data C) mirroring data D) compressing data E) none of the above

Answer: E Diff: 1 Type: MC Page Ref: 232 Skill: A Objective: 6

17) Which one of the following is a Business Intelligence function? A) information dissemination B) collaboration C) performance analysis D) data analysis E) all of the above

Answer: E Diff: 2 Type: MC Page Ref: 220 Skill: A Objective: 3

20) What term describes the analysis of data for relationships that may not have been previously known? A) data warehouse B) metadata C) data mart D) data searching E) data mining

Answer: E Diff: 2 Type: MC Page Ref: 224 Skill: R Objective: 3

9) The balanced scorecard is a multi-dimensional measurement tool aimed to capture performance measures related to ________. A) accounting/finance B) human resources C) internal processes D) customers E) all of the above

Answer: E Diff: 2 Type: MC Page Ref: 225 Skill: A Objective: 3

13) If the data are of high quality, means that they are: A) internal, accurate, and readily shared. B) specific, measureable, and timely. C) organized, and easy to access. D) flexible, scaleable, and secure. E) complete, current, accurate, and authorized.

Answer: E Diff: 2 Type: MC Page Ref: 232 Skill: A Objective: 5

8) Which of the following will influence the architecture design decision for intelligence applications? A) hardware selection B) number of users C) existing corporate infrastructure D) software application choice E) all of the above

Answer: E Diff: 2 Type: MC Page Ref: 234 Skill: A Objective: 6

26) Several BI providers now operate as ________ providers. A) ERP B) Internet Service C) Software as a Service D) CRM E) change management

Answer: C Diff: 2 Type: MC Page Ref: 237 Skill: R Objective: 7

12) Which of the following is a business intelligence function? A) marketing analysis B) travel analysis C) information dissemination D) transactional analysis E) none of the above

Answer: C Diff: 3 Type: MC Page Ref: 220 Skill: A Objective: 3

28) The ultimate objective of BI is to: A) enhance decision making. B) analyze data. C) draw data from diverse sources. D) improve collaboration. E) organize and store data.

Answer: A Diff: 2 Type: MC Page Ref: 216 Skill: R Objective: 1

5) A data warehouse is: A) a central data repository. B) also known as a search engine. C) a network within a national company. D) a system utilized to report data for decision-making purposes. E) an offsite records management location.

Answer: A Diff: 2 Type: MC Page Ref: 220 Skill: R Objective: 3

14) Data warehouses are divided into smaller, dedicated databases also known as ________. A) data marts B) data cubes C) data clusters D) data stores E) data mines

Answer: A Diff: 2 Type: MC Page Ref: 221 Skill: R Objective: 3

18) Data mining is the analysis of: A) data for relationships that may not have previously been known. B) data for relationships that have been previously known. C) relationships between performance indicators. D) business intelligence. E) key performance indicators.

Answer: A Diff: 2 Type: MC Page Ref: 224 Skill: R Objective: 3

10) In many cases the KPI's are linked to a ________. A) balanced scorecard B) data cube C) data mart D) metadata E) data warehouse

Answer: A Diff: 2 Type: MC Page Ref: 225 Skill: R Objective: 3

21) Two critical issues in architecture design of the system for intelligence application are: A) database design and system architecture. B) database language and system architecture. C) database interfaces and system design. D) database performance and system version. E) database architecture and system design.

Answer: A Diff: 2 Type: MC Page Ref: 234 Skill: A Objective: 6

4) A data repository that is dedicated to specific user groups and is often integrated into the data warehouse is a ________. A) metadata B) data mart C) data cube D) data mine E) BI application

Answer: B Diff: 1 Type: MC Page Ref: 221 Skill: A Objective: 3

23) Business intelligence applications can be closely related to: A) sales strategies. B) customer relationship management (CRM) strategies. C) online marketing strategies. D) supply chain strategies. E) social media strategies.

Answer: B Diff: 2 Type: MC Page Ref: 216 Skill: A Objective: 1

2) Which of the following would be considered a data source for BI? A) operating system data B) call centre data C) security data D) network data E) customer testimonials

Answer: B Diff: 2 Type: MC Page Ref: 221 Skill: A Objective: 3

11) Data mining is: A) getting rid of bad data in a database. B) analysis of data for new relationships. C) relocating data into a new database. D) searching through data to create new queries. E) none of the above

Answer: B Diff: 2 Type: MC Page Ref: 224 Skill: A Objective: 3

22) Data warehouse security can be established at the application or ________ level. A) end user B) database C) superuser D) query E) report

Answer: B Diff: 2 Type: MC Page Ref: 233 Skill: A Objective: 6

27) Primary enabling technologies of BI systems are: A) data marts and data cubes. B) data warehouses and data marts. C) internet and cloud computing. D) ERP and CRM systems. E) project and change management.

Answer: B Diff: 2 Type: MC Page Ref: 237 Skill: R Objective: 4

6) Which form of OLAP makes use of data cubes? A) Relational OLAP B) Multi-dimensional OLAP C) Hybrid OLAP D) Client-side OLAP E) all of the above

Answer: B Diff: 3 Type: MC Page Ref: 224 Skill: A Objective: 4

30) The use of relational databases reduces: A) employee training requirements. B) data accuracy. C) duplication of data. D) the level of security. E) ease of use.

Answer: C

7) The "P" in the acronym KPI stands for ________. A) production B) possibility C) performance D) position E) planning

Answer: C Diff: 1 Type: MC Page Ref: 224 Skill: R Objective: 3

16) Which type of OLAP occurs if most of the data is analyzed on the system of the end user? A) relational OLAP B) multidimensional OLAP C) client-side OLAP D) hybrid OLAP E) none of the above

Answer: C Diff: 2 Type: MC Page Ref: 224 Skill: A Objective: 3

25) Examples of Hybrid OLAP are: A) IOLAP and XOLAP. B) WOLAP and BOLAP. C) ROLAP and MOLAP. D) EOLAP and IOLAP. E) ROLAP and BOLAP.

Answer: C Diff: 2 Type: MC Page Ref: 224 Skill: R Objective: 3

3) OLAP stands for: A) Online Assistance Programs B) Office Language and Procedures C) Online Analytical Processing D) Online Advertising Programs E) none of the above

Answer: C Diff: 2 Type: MC Page Ref: 224 Skill: R Objective: 3

15) The ability of a system to maintain a set rate of performance as the number of users or volume of usage increases is called ________. A) flexibility B) performance C) scalability D) transparency E) none of the above

Answer: C Diff: 2 Type: MC Page Ref: 231 Skill: R Objective: 5

A critical success factor for BI is: A) ease of use B) scalability C) flexibility D) performance and security E) all of the above

E) all of the above