Business Analytics & Intelligence - Set 1
1] Business intelligence (BI) is a broad category of application programs which includes
a) Decision support
b) Data mining
c) OLAP
d) All of the mentioned
ANSWER : D
2] Point out the correct statement.
a) OLAP is an umbrella term that refers to an assortment of software applications for analyzing an organization’s raw data for intelligent decision making
b) Business intelligence equips enterprises to gain business advantage from data
c) BI makes an organization agile thereby giving it a lower edge in today’s evolving market condition
d) None of the mentioned
ANSWER : B
3] BI can catalyze a business’s success in terms of
a) Distinguish the products and services that drive revenues
b) Rank customers and locations based on profitability
c) Ranks customers and locations based on probability
d) All of the mentioned
ANSWER : D
4] Which of the following areas are affected by BI?
a) Revenue
b) CRM
c) Sales
d) All of the mentioned
ANSWER : B
5] Point out the wrong statement.
a) Data is factual information for analysis
b) BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data
c) Customer relationship management (CRM) entails all aspects of interaction that a company has with its customer
d) None of the mentioned
ANSWER : B
6] _________ is a performance management tool that recapitulates an organization’s performance from several standpoints on a single page.
a) Balanced Scorecard
b) Data Cube
c) Dashboard
d) All of the mentioned
ANSWER : A
7] _________ is a system where operations like data extraction, transformation and loading operations are executed.
a) Data staging
b) Data integration
c) ETL
d) None of the mentioned
ANSWER : A
8] _________ is a category of applications and technologies for presenting and analyzing corporate and external data.
a) Data warehouse
b) MIS
c) EIS
d) All of the mentioned
ANSWER : C
9] Which of the following is the process of basing an organization’s actions and decisions on
actual measured results of performance?
a) Institutional performance management
b) Gap analysis
c) Slice and Dice
d) None of the mentioned
ANSWER : A
10] Which of the following does not form part of BI Stack in SQL Server?
a) SSRS
b) SSIS
c) SSAS
d) OBIEE
ANSWER : D
11] The hardware unit which is used to monitor computer processing is
(A) ROM
(B) Mouse
(C) Dot matrix printer
(D) Console
ANSWER : D
12] In which of the following environment, data is held in a temporary computer file?
(A) Batch processing
(B) Online processing
(C) Online batch processing
(D) None of these
ANSWER : C
13] The task of proving that a given program works correctly is
(A) Check pointing
(B) Program verification
(C) Diagnosis
(D) Program tracing
ANSWER : B
14] The program that controls the execution of application programs and acts as an interface between user of a computer and computer hardware, is called
(A) Operating System
(B) Compiler
(C) Text Editor
(D) Linker
ANSWER : A
15] Computing systems can be effective in generating strategic information because
(A) They require managers to clarify their thinking about their plans and future possibilities
(B) Future can be predicted from the pattern of the past
(C) They give management access to large database
(D) All of these
ANSWER : A
16] The difference between raw data and information is
(A) Addition of intellect
(B) Addition of processing
(C) Addition of intelligence
(D) All of these
ANSWER : C
17] Batch system customarily requires
(A) Collection of transmission for single-shot processing
(B) Transferal of programs from one micro computer to another
(C) The ability to check files from the personal computer
(D) Direct on- line input of file data
ANSWER : A
18] The range concept of a spread sheet is its ability to
(A) Calculate random portions of that spread
(B) Print only selected portions of that spread sheet
(C) Identify subordinate portions of the spread sheet
(D) Merge two spread sheets in similar areas
ANSWER : C
19] A microcomputer consists of at least an input unit, an output unit, microprocessor unit, and a
(A) Stabilizer
(B) Memory unit
(C) Printer
(D) Network
ANSWER : B
20] A program to detect overall system malfunction is
(A) System diagnostics
(B) System software
(C) System analysis
(D) Utilities
ANSWER : A
