Bi All Merged
Bi All Merged
Bi All Merged
a) Decision support
b) Data mining
c) OLAP
d) All of the mentioned
View Answer
Answer: d
Explanation: Business intelligence (BI) is a broad category of application programs and
technologies for gathering, storing, analyzing, and providing access to data from various
data sources.
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
View Answer
Answer: b
Explanation: Once an organization is powered with BI it can anticipate enhanced turnaround
time on data collection, come up with fresh ideas for novel business initiatives.
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
View Answer
Answer: d
Explanation: SQL Server Business Intelligence delivers a comprehensive platform
empowering organizations to build and deploy secure, scalable and manageable BI apps.
4. Which of the following areas are affected by BI?
a) Revenue
b) CRM
c) Sales
d) All of the mentioned
View Answer
Answer: b
Explanation: Customer relationship management (CRM) is a system for managing a
company’s interactions with current and future customers. It often involves using technology
to organize, automate and synchronize sales, marketing, customer service, and technical
support.
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
View Answer
Answer: b
Explanation: Online Analytical Processing 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.
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
View Answer
Answer: a
Explanation: incorporates performance measures, benchmarks, and goals to attain the best
results.
10. Which of the following does not form part of BI Stack in SQL Server?
a) SSRS
b) SSIS
c) SSAS
d) OBIEE
View Answer
Answer: d
Explanation: Oracle Business Intelligence Enterprise Edition Plus, also termed OBI EE Plus,
is Oracle Corporation’s set of business intelligence tools.
3-1. A decision for repetitive or routine problems for which the responses have
been already been decided and been known to the person who will make the
decision is called:
a. programmed.
b. non programmed.
c. strategic.
d. professional.
a. middle management.
b. lower management.
c. top management.
d. supervisory management.
a. reactive.
b. proactive.
c. intuitive.
d. systematic.
a. systematic.
b. programmed.
c. non programmed.
d. intuitive.
a. systematic.
b. programmed.
c. non programmed.
d. intuitive.
a. establish priorities.
b. establish specific goals and objectives.
c. identify and define the problem.
d. determine courses of the problem.
a. crisis problems.
b. routine problems.
c. problems of failing to take advantage of opportunities.
d. all of the above.
a. urgency.
b. impact.
c. growth tendency.
d. none of the above.
3-9. The concept that a manager's freedom to make totally rational decisions
is restricted by internal and external environmental factors and by the
manager's own characteristics and decision-making ability is called:
a. bounded rationality.
b. values.
c. objective rationality.
d. A & B.
a. personality.
b. situational.
c. interactional.
d. all of the above.
a. quality team.
b. process improvement team.
c. task team.
d. unit team.
3-12. A process in which a group of individuals generate and state ideas, but
in which the rules prohibit questioning, evaluating, or rejecting any ideas, even
if they seem ridiculous is called:
a. delphi technique.
b. brainstorming.
c. nominal group technique.
d. bounded rationality.
a. delphi technique.
b. brainstorming.
c. nominal group technique.
d. bounded rationality.
a. accessible.
b. timely.
c. relevant.
d. none of the above.
True / False
The question was not answered. The correct answer is "true".
3-2. Programmed decisions are more likely to occur at the top management
level.
True / False
True / False
True / False
True / False
3-6. The first seven steps in the decision making process are the decision
formulation stages while the last two steps are the decision implementation
process.
True / False
3-7. According to the text, the Swiss market share of watch making collapsed
because of "defining problems in terms of assumed solutions."
True / False
True / False
True / False
True / False
True / False
3-12. A major advantage of the Delphi technique over other group decision-
making techniques is that bias effects of group interactions are eliminated.
True / False
3-13. MIS is used to collect data, store and process those data, and then
present useful and timely information to managers.
True / False
3-14. In the last five years, the amount of computer power a dollar can buy
has decreased.
True / False
True / False
B. Variance
C.Co-efficient of variation
D.None of the above
Explanation :
2:
Probability sampling and random sampling are
A.Anonymous
B. Different terms
C.Synonymous
D.None of the above
Explanation :
3:
Convenience sampling is a
A.Probability Sampling
B. Non-probability Sampling
C.Random Sampling
D.None of the above
Explanation :
4:
Coefficient of correlation will be always
A.More than 0
B. More than - 1
C.Less than -1
D.Between -1 and + 1
Explanation :
5:
Which of the following is the characteristics of a data
A. Aggregate of fact
B. Numerical expressed
Explanation :
Question: 2
(B) Mouse
(D) Console
View Answer
Ans: D
Console
Question: 3
(C) Diagnosis
Program verification
Question: 4
(B) Compiler
(D) Linker
View Answer
Ans: A
Operating System
Question: 5
They require managers to clarify their thinking about their plans and future possibilities
Question: 6
The difference between raw data and information is
(A) Addition of intellect
Addition of intelligence
Question: 7
Question: 8
Question: 9
(C) Printer
(D) Network
View Answer
Ans: B
Memory unit
Question: 10
(D) Utilities
View Answer
Ans: A
System diagnostics
1. A written report is more formal than an oral report.
a) True
b) False
View Answer
Answer: a
Explanation: The statement is true. A written report is more formal in nature than an oral
report and it removes almost every flaw inherent in an oral report.
2. Which of these is usually written in a form of a memorandum?
a) Informal reports
b) Formal reports
c) Professional reports
d) Business reports
View Answer
Answer: a
Explanation: Written reports can be of two types. They are: formal reports and informal
reports. Informal reports are normally written in the form of a memorandum or a letter.
3. Which of these is not a formal report?
a) Informational
b) Informal
c) Interpretative
d) Routine
View Answer
Answer: b
Explanation: Formal reports can be classified into three different types. They are :
informational, interpretative and routine.
10. Which of these reports involves the checking of a piece of equipment to see if it’s still in
working condition?
a) Progress report
b) Laboratory report
c) Inspection report
d) Inventory report
View Answer
Answer: c
Explanation: An inspection report is made when: An equipment is inspected to establish
whether or not it is in working condition.
1. A technical report reduces to writing the facts of a particular situation.
a) True
b) False
View Answer
Answer: a
Explanation: The statement is true. A technical report reduces to writing the facts of a
particular situation, project, process or test.
2. A technical report establishes a
a) illogical conclusion
b) logical conclusion
c) personal prejudice
d) misplaced learning
View Answer
Answer: b
Explanation: A technical report establishes a logical conclusion on the basis of the facts laid
down and the purpose for which these facts are required.
3. Which of these must never be a basis for a technical report?
a) Facts
b) Tests
c) Personal prejudices
d) Experiments
View Answer
Answer: c
Explanation: A report must never be based on personal prejudices and misplaced learning.
It must be objective. It highlights the significance of the facts.
4. Which of these must be avoided in a technical report?
a) Facts
b) Logical conclusion
c) Objective evaluation
d) Subjective evaluation
View Answer
Answer: d
Explanation: A technical report must always be objective. There is very little place for
subjective evaluation in a report. A technical report establishes a logical conclusion.
1.
A. What the report is about
B. What the problems are
C. The conclusions you arrived at
D. What you recommend
E. All of the above
29. The conclusions and recommendations must follow logically from the rest
of the report. When writing the conclusions and recommendations section,
consider:
1.
A. Do the conclusions and recommendations follow logically from the rest of
the report?
B. Check the conclusions and recommendations against the original
objective of the report.
C. Make sure you have answered the reader’s key question.
D. Finish with the final impression you want to make.
E. All of the above
30. The “appendices” should include detailed information that the reader can
essentially do without in order to make sense of the main body of the
report. Appendices should be:
1.
A. Included only if absolutely necessary.
B. Non-essential for understanding the main arguments.
C. Referred to somewhere in the body of the text i.e. there must be a link.
D. Mentioned as the final item in the table of contents.
E. All of the above
31. Request for proposal (RFP) – An RFP is a formal document that describes a
project, or need for service, and invites prospective bidders to propose
solutions.
1.
A. The above statement is correct
B. The above statement is incorrect
32. A Request for proposal (RFP) should contain:
1.
1.
I. Description of the work to be performed (in sufficient detail).
II. Method of formal submission of the proposal e.g. in a prescribed
form to be delivered by hand or by registered post.
III. Milestones and deadlines of the proposal process.
IV. Terms relating to payments, such as advances, stage (interim)
payments and any other special terms and conditions.
1.
A. All of the above
B. (I) and (III) only
C. (II) and (Iv) only
D. None
33. A proposal is either written in response to a Request for proposal (RFP), or
alternatively used as to promote an idea to a relevant stakeholder.
The essential qualities and contents of a well-prepared proposal include:
1.
1.
I. purpose of the proposal is stated clearly
II. problem or need for the proposal is understood and defined clearly
III. suggested solution offered in the proposal is workable and in the
best interests of the recipient
IV. proposal is honest, factual and objective
V. benefits to be derived from the proposal outweigh the costs
VI. proposal contains a time schedule including the milestones and any
checklists of the projects
VII. contains a list of the costs and resources involved in completion of
the project.
1.
A. (I) (III) and (VI) only
B. (I) (III) (IV) and (VI) only
C. All of the above
D. None
34. Project progress report –
1.
A. Outlines the progress of the tasks in a project, including work
completed, work remaining, costs incurred, remaining cost to
complete the project and schedule of original and anticipated time
for completion of the project.
B. Documents the quality of an employee’s work performance for a particular
period with identification of the individual’s strengths and weaknesses,
training and development needs and career planning.
C. A feasibility report examines the viability of the proposed undertaking from
its technical, commercial and economic standpoints.
D. Report that provides data of actual sales of various products classified by
their quantities, territories, sales teams and distributors for a specific
period.
35. Performance appraisal report –
1.
A. Outlines the progress of the tasks in a project, including work completed,
work remaining, costs incurred, remaining cost to complete the project and
schedule of original and anticipated time for completion of the project.
B. Documents the quality of an employee’s work performance for a
particular period with identification of the individual’s strengths and
weaknesses, training and development needs and career planning.
C. A feasibility report examines the viability of the proposed undertaking from
its technical, commercial and economic standpoints.
D. Report that provides data of actual sales of various products classified by
their quantities, territories, sales teams and distributors for a specific
period.
36. Feasibility report –
1.
A. Outlines the progress of the tasks in a project, including work completed,
work remaining, costs incurred, remaining cost to complete the project and
schedule of original and anticipated time for completion of the project.
B. Documents the quality of an employee’s work performance for a particular
period with identification of the individual’s strengths and weaknesses,
training and development needs and career planning.
C. A feasibility report examines the viability of the proposed
undertaking from its technical, commercial and economic
standpoints.
D. Report that provides data of actual sales of various products classified by
their quantities, territories, sales teams and distributors for a specific
period.
37. Sales and marketing report –
1.
A. Outlines the progress of the tasks in a project, including work completed,
work remaining, costs incurred, remaining cost to complete the project and
schedule of original and anticipated time for completion of the project.
B. Documents the quality of an employee’s work performance for a particular
period with identification of the individual’s strengths and weaknesses,
training and development needs and career planning.
C. A feasibility report examines the viability of the proposed undertaking from
its technical, commercial and economic standpoints.
D. Report that provides data of actual sales of various products
classified by their quantities, territories, sales teams and distributors
for a specific period.
38. Operating report –
1.
A. Summarises the operational activity for a particular time period.
B. Might include information on sales and purchases, employee information
and inventory.
C. Both A&B
D. None
2. Data that can be modeled as dimension attributes and measure attributes are called
data.
a) Multidimensional
b) Singledimensional
c) Measured
d) Dimensional
View Answer
Answer: a
Explanation: Given a relation used for data analysis, we can identify some of its attributes
as measure attributes, since they measure some value, and can be aggregated
upon.Dimension attribute define the dimensions on which measure attributes, and
summaries of measure attributes, are viewed.
3. The generalization of cross-tab which is represented visually is which is
also called as data cube.
a) Two dimensional cube
b) Multidimensional cube
c) N-dimensional cube
d) Cuboid
View Answer
Answer: a
Explanation: Each cell in the cube is identified for the values for the three dimensional
attributes.
4. The process of viewing the cross-tab (Single dimensional) with a fixed value of one
attribute is
a) Slicing
b) Dicing
c) Pivoting
d) Both Slicing and Dicing
View Answer
Answer: a
Explanation: The slice operation selects one particular dimension from a given cube and
provides a new sub-cube. Dice selects two or more dimensions from a given cube and
provides a new sub-cube.
5. The operation of moving from finer-granularity data to a coarser granularity (by means of
aggregation) is called a
a) Rollup
b) Drill down
c) Dicing
d) Pivoting
View Answer
Answer: a
Explanation: The opposite operation—that of moving fromcoarser-granularity data to finer-
granularity data—is called a drill down.
6. In SQL the cross-tabs are created using
a) Slice
b) Dice
c) Pivot
d) All of the mentioned
View Answer
Answer: a
Explanation: Pivot (sum(quantity) for color in (’dark’,’pastel’,’white’)).
7.
{ (item name, color, clothes size), (item name, color), (item name, clothes
size), (color, clothes size), (item name), (color), (clothes size), () }
This can be achieved by using which of the following ?
a) group by rollup
b) group by cubic
c) group by
d) none of the mentioned
View Answer
Answer: d
Explanation: ‘Group by cube’ is used .
9.
Explanation: Treemaps are best used when multiple categories are present, and the goal is
to compare different parts of a whole.
Explanation: Data visualization decrease the insights andtake solwer decisions is false
statement.
Explanation: All option are Common use cases for data visualization.
10. Which of the following plots are often used for checking randomness
in time series?
A. Autocausation
B. Autorank
C. Autocorrelation
D. None of the above
View Answer
Ans : C
Explanation: If the time series is random, such autocorrelations should be near zero for any
and all time-lag separations.
13. Which of the intricate techniques is not used for data visualization?
A. Bullet Graphs
B. Bubble Clouds
C. Fever Maps
D. Heat Maps
View Answer
Ans : C
Explanation: Fever Maps is not is not used for data visualization instead of that Fever charts
is used.
14. Which one of the following is most basic and commonly used
techniques?
A. Line charts
B. Scatter plots
C. Population pyramids
D. Area charts
View Answer
Ans : A
Explanation: Line charts. This is one of the most basic and common techniques used. Line
charts display how variables can change over time.
Explanation: names function is used to associate name with the value in the vector.
8. Which of the following compute analysis of variance table for fitted model?
a) ecdf()
b) cum()
c) anova()
d) bwplot()
View Answer
Answer: c
Explanation: ecdf() builds empirical cumulative distribution function.
1 The problem of finding hidden structure is unlabeled in Supervised Learning Unsupervised Learning Reinforcement Learning None of the above B
2 Task of inferring a model from labeled traning data is Supervised Learning Unsupervised Learning Reinforcement Learning None of the above A
3 Self-organinzing maps are an example of Supervised Learning Unsupervised Learning Reinforcement Learning Missing data imputation B
Discriminating between and span and ham e-mails is task of
4 classification True False A
In example of predicting number of babies based on Stork's
5 population size, number of babies is Outcome Feature Attribute Observation A
It may be better to avoid the metrix of ROC curve as it can
6 suffer from accuracy paradox. True False B
7 Which of the following is not involved in data mining? Knowledge extraction Data archeology Data transformation Data exploration C
This takes only 2 values. In Systems that can be used
The natural environment of a
8 Black boxes are general, it is 0 and 1 which without knowledge of internal None of the above C
can be coded in one bit. certain species. operation
A definiton of a concept is if it recognizes all the instamces of
9 a concept Complete Consistent Constant None of the above A
Knowledge Discovery
10 The full form of KDD is .................. Knowledge Database Database Knowledge Data House Knowledge Data Definition B
11 The out put of KDD is ............. Data Information Query Useful information D
A definiton of a concept is if it classifies any example coming
12 under a concept Complete Consistent Constant None of the above B
A subject oriented integrated
The actual discovery phase of The stage of selecting the data time variant non volatile
13 Data mining is None of the above A
Knowledge discovery process for KDD process collection of data in support
of management
Programs are not dependent
Data is defined separately and Programs are not dependent on
14 Data independence means on the logical attributes of Both (b) and ( c) D
not included in program the physical attributes of data data
15 E-R model uses this symbol to represent it's weak entity set. Dotted Rectangle Diamond Doubly outlined rectangle None of the above C
2 16 SET concept is used in Network Model Heirarchical Model Relational Model None of the above D
17 Relational algebra is Data Definition Language Meta Language Procedural Query Language None of the above C
18 Key to represent relationships between tables is called Primary Key Secondary Key Foreign Key None of the above C
produces the relation that has attributes
19 of Ri and R2 Cartesian Product Difference Intersection Product A
20 Which of the following are the properties of entities? Group Table Attributes Switchboards C
Ordering of rows is
21 In a relation immaterial No two rows are identical Both (a) and (b) None of the above C
Operations on a DB to
Group of similar objects that
transform or simplify data in Symbolic representation of
22 Cluster is differ significantly with other None of the above A
order to prepare it for ML facts and ideas
objects algorithm
This takes only 2 values. In Systems that can be used
The natural environment of a
23 Biotope are general, it is 0 and 1 which without knowledge of internal None of the above B
can be coded in one bit. certain species. operation
What were the two main streams of research that led to the Theoretical studies of Theoretical studies of Empirical studies of graphical
1 evolution and development of the concept of Decision organizational decisionmaking organizational behavior and displays and technical work NA A
Support Systems? and technical work on technical work on relational on artificial intelligence.
interactive computer systems. data bases.
Responds quickly to the
2 What should be a major characteristic of a DSS? Automates decision making. Includes a spreadsheet model. changing needs of decision NA C
makers.
3 In which of Steven Alter's categories of DSS would you place Analysis Information Accounting and financial Data analysis systems. Suggestion models. C
data warehouses? systems. models
There is limited support for The Web is where the DSS The quality and value of DSS-
4 What would one conclude after visiting DSS-related sites on DSS researchers and
research and development related Web sites is NA B
the World-Wide Web? practitioners on the World-
action is occurring. outstanding.
Wide Web.
A database designed to
An interactive computer based
A database application that support decision making in
organizations. It is batch system which helps decision
5 What is a data warehouse? searches for hidden patterns in makers utilize data and NA B
updated and structured for
a data base. models to identify and solve
rapid on-line queries and
problems and make decisions.
managerial summaries.
What general type of DSS would iinclude file drawer
6 systems, data warehouses, on-line analytical processing Communications-Driven DSS Data-Driven DSS Document-Driven DSS Knowledge-Driven DSS B
(OLAP) systems, and Executive Information Systems?
7 What is the most important component of a Decision Support Architecture and network Mathematical models and
Database User interface. D
System? design. analytical tools
8 .Information has three dimensions. There are Time, consent, and form Time, content, and form Cost, content, and form Time, content, and Value B
9 According to your textbook, the Decision support systems use Online Transaction A decision maker’s own
all of the following EXCEPT: Analytical models, Specialized databases
processing C
represent complex data using interactive insights and judgments
10 three- dimensional graphical forms such as charts, graphs, and Data Entry Systems Data Analysis systems Database Management Data visualization systems D
maps
11 Decision support system involves all of the following types of what-if analysis
Heuristics Goal-seeking analysis optimization analysis B
analytical modeling activities except?
12 Decision at the operational level tend to be more: Programmed decision Tactical decision Unstructured decision Semi-structured desicision A
The part of a DSS that gives the DSS its analytical
3 13 System software Spread sheet Query langauage Decision models. D
capabilities
14
support the decision-making needs of strategic Knowledge management
management, tactical management and operating management. Management support systems Operation support systems all the above A
system.
15
Most DSS analyses are performed numerically with
models. mathematical mental iconic analog D
16
A user, systems software, a database, and a set of decision
models form a(n):
is ameasure of the use of inputs to achieve MIS DSS ESS TPS B
17 outputs doing the thing right.
effectiveness efficiency increased productivity All of the above B
continues to make inroads in improving
18
DSS. Artificial intelligence ERP CRM SCM A
19
The user interface sub-system is managed by software called MBMS DBMS DSS UIMS B
the .
20 may also apply when simplifying assumptions Sub-optimization optimization opyimizer none of the above B
are used in modeling a specific problem.
is probably the most common descriptive modeling
21 Simulation Scenario Problem classification Problem solving A
method.
analysis is used to determine the robustness of any
22 Sensitivity analysis Goal seeking Simulation What-if analysis A
given alternative; slight changes in the parameters should
ideally lead to slight or no changes in the alternative chosen.
23 Strategic Tactical Operational Analytical A
models are used to support top managers
strategic planning responsibilities.
24 Operational Strategic Tactical Analytical B
models are used to support the day-to-day
working activities of the organization. Model marts Model database Model repository Model warehouses A
25
are analogous to data marts
26 types of DSS agent. four three five two C
There are
27
What type of problem occurs when the problem solver Structured problem Unstructured problem Semi–Structured problem All of the above B
understands no elements or relationships between elements?
28 Physical model narrative model Mathematical Model graphical model B
The most popular type of model is :
Which term represents a selected course of action, and Problem solving Problem Decision making Decision D
29
recognizes that usually it is necessary to make multiple
decisions in the process of solving a single problem? Intelligence Choice Review Evaluation C
30
According to Simon, which problem-solving activity is
defined as assessing past choices?
1 Mean, Median and Mode are : Measures of deviation Ways of sampling Measures of control tendency None of the above D
Finding solution to any Working in a scientific way to
2 Research is Searching again and again search for truth of any None of the above C
problem
problem
3 Which of the following is the first step in starting the research Searching sources of Searching for solutions to the
Survey of related literature Identification of problem C
process? information to locate problem. problem
4 A common test in research demands much priority on Reliability Useability Objectivity All of the above D
A research initiated to solve A research with
5 Action research means A longitudinal research An applied research C
an immediate problem socioeconomic objective
6 A reasoning where we start with certain particular statements
and conclude with a universal statement is called Deductive Reasoning Inductive Reasoning Abnormal Reasoning Transcendental Reasoning B
7 Which of the following variables cannot be expressed in
quantitative terms?
Socio-economic Status Marital Status Numerical Aptitude Professional Attitude C
8 The essential qualities of a researcher are
Reliance on observation and Systematization or theorizing
Spirit of free enquiry All the above D
9 In the process of conducting research ‘Formulation of evidence of knowledge
Hypothesis” is followed by
Statement of Objectives Analysis of Data Selection of Research Tools Collection of Data C
10 A research paper is a brief report of research work based on
Both Primary and Secondary
11 One of the following is not an open source software: Primary Data only Secondary Data only None of the above C
Data
12 Classification of all types of libraries has been made by
13 Reading centre’s, story hours, exhibitions and reading to DSpace Windows Green-stone Linux B
literature are forms of … IFLA UNISIST UNESCO INSDOC C
14 Informal self education is possible in what kind of library? Extension service Service of a public library Both none of the above C
15 Is a process of information
16 Feedback mechanism is a part of which service? National Library Public Library Specific Library College Library B
17 What is the collection of terms or records in MARC called? Books Computers CD-ROM None of the above C
Reprography CAS Translation service SDI D
System Network Website Database D
Information Management
18 What is Bibliometry? Function of Library Network Information Management Tool Library Service C
Service
19 Microchip was invented by….. Microsoft IBM DELL Intel D
20 Information is….. Raw Data Processed Data Input data Organized data D
21 Conference proceedings are considered
as ................... documents. Conventional Primary Secondary Tertiary B
22 RSS feed is a tool of :
23 An appropriate source to find out descriptive information Graphic design Web 1.0 Web 2.0 Architecture C
is................ . Encyclopedia
24 One of the following search engine is exclusively meant for Bibliography Directory Dictionary C
scientific information :
Google Yahoo SCIRUS Altavista C
25 Technological Gatekeeper is :
An informal mechanism of
A formal method of giving A method of technology A process of transfer of
keeping user informed of D
26 The Farmington plan is associated with : current awareness service assessment and evaluation technology
relevant development
Library Legislation Library Cataloguing Library Cooperation Library Indexing Service C
27 UNESCO assisted Model Public Library in India is located at Kolkata
Delhi Mumbai Chennai B
:
28 Mark the ‘odd one out’ : Cow-Calf principle Principle of osmosis Wall picture principle Whole organ principle B
29 Shelf list facilitates................ . Classification Weeding out Stock verification Documentation C
30 Questionnaire is a : Research method Measurement technique Tool for data collection Data analysis technique C
A periodical evaluation of an employee is done
4 31 through........... . Job rotation Performance appraisal Refresher course Work guide B
32 “Controlled Group” is a term used in.............. . Survey research Historical research Experimental research Descriptive research C
33 Inductive logic proceeds from : General to General Particular to General General to Particular Particular to Particular B
The oldest and the largest Library Association in the world
34 is............. . ALA LA IFLA IASLIC A
Interchange of data between Interchange of data between Linkage between two
35 Protocol means............... . two devices two computers computers Linkage between two devices D
The "curse of dimensionality" relates to which problem of
36 using operational data for BI reporting? Dirty data Inconsistent data Too much data Non-integrated data C
Business Intelligence (BI) systems do not obtain their data by Read and process data from Process extracts from Process data purchased from
37 which of the following means? an operational database Process transactions operational databases data vendors B
Which of the following are not done by Business Intelligence Analyze past and current Process and record Neither of the above is
38 (BI) systems? activities only transactions only Both of the above are correct. correct. B
A report generated by a reporting system is delivered to the
39 appropriate users via a user-accessed Web site. This system Pull Push RFM OLAP A
uses which of the following report modes?
40 The "F" in RFM analysis stands for . fast food freshness frequently fantasy C
We have Market Basket data for 1,000 rental transactions at a
Video Store. There are for videos for rent -- Video A, Video
41 B, Video C and Video D. The probability that both Video C the basic probability support lift confidence B
and Video D are rented at the same time is known as
.
Data
Which of the following is not a component of a data None of the above are data
42 extraction/cleaning/preparatio Data warehouse data Data metadata C
warehouse? n programs warehouse components.
We have been given access to the company's operational data,
and have been asked to produce a report. We discover that
43 some of the data we need are in an SQL server database while dirty data a "wrong format" problem inconsistent data non-integrated data D
other needed data are in a separate Oracle database. This is
an example of .
The reports generated by a reporting system are
44 usually not delivered in which of the following media? Web portal Commercial courier service Digital dashboard E-Mail B
Data mining applications are used accomplish which of the Do both RFM and what-if
45 following tasks? Process transactions only Do RFM analysis only Do what-if analysis only analysis C
46 In OLAP, we are interested in . levels only dimensions only measures only measures and dimensions D
We have Market Basket data for 1,000 rental transactions at a
Video Store. There are four videos for rent -- Video A, Video
47 B, Video C and Video D. The probability that Video D will the basic probability support lift confidence D
be rented given that Video C has been rented is known as
.
Hasn't ordered recently,
We have done an RFM analysis on our customer data. Mary Has ordered recently, orders Hasn't ordered recently, orders Has ordered recently, orders
orders infrequently, and
48 Jones has a score of "1 1 5". This series means that Mary frequently, and places a large infrequently, but places a large frequently, but doesn't place a C
doesn't place a large order
. order when she orders. order when she orders. large order when she orders when she orders.
One popular classification technique in Business Intelligence both cluster analysis and
49 (BI) reporting is . cluster analysis only RFM analysis only regression analysis only regression analysis B
Which of the following is not a reason that operational data
50 are difficult to read? Non-duplicated data Dirty data Missing values Non-integrated data A
UNIT I: Basics of Data Mining
5. Which of the following BI technique can predict value for a specific data item attribute?
a. Predictive modeling
b. Modeling
c. Predictive value
d. Association
a. Knowledge derived from data through the use of Business Intelligence Tools and the process of
Data Warehousing
b. Knowledge derived from data through the use of Business Intelligence Tools
c. Knowledge derived from data only
d. Both a and c
a. True
b. False
9. Information is
a. Unprocessed data
b. Processed data
c. Facts
d. None of the above
a. Roll up
b. Drill down
c. Dynamic calculation
d. pivot
12. Which of the following is a logical collection of data gathered from many databases and used to create
business intelligence?
13. is a system where operations like data extraction, transformation and loading operations are
executed.
a. Data Integration
b. ETL
c. Data Staging
d. None of the above
14. What is a subset of a data-warehouse?
a. Data storeroom
b. Data mart
c. Database
d. Data set
a. Data cube
b. OLTP
c. OLAP
d. All of the Above
a. Data warehouse
b. Database
c. Artificial Intelligence
d. None of the Above
a. Continual
b. Interval-based
c. Once a Year
d. None of the above
20. Which of the following is not a User Interface component?
a. Browser
b. Portal
c. Dashboard
d. Text File
21. Which of the following users handle the data warehouse environment?
a. Technical Staff
b. Business Users
c. Managers/executives
d. None
a. Storing data
b. Visualizing critical data for executives
c. Handle queries and perform operations on data warehouses
d. None of the Above
a. Monitoring Performance
b. Analyzing Performance
c. Both a and b
d. None of the above
26. What are features of SAP NetWeaver?
a. Summarizing data
b. Checking referential Integrity
c. Building Dimensions
d. Extracting only valid data
31. Which of the metadata approaches helps in integration with multi-vendor tools along with flexibility?
33. Which of the following is not an enabling factor in business intelligence projects?
a. Technologies
b. Analytics
c. Security
d. Human Resources
35. Why all or nothing approach in enterprise software projects not needed?
a. It leads to high costs
b. the time required for such projects is long and by the completion time user requirements change
c. unwieldy user requirements
d. all of above
37. which of the following are critical success factors in ensuring BI implementation successful
a. Performance is key
b. Having functionality for every type of business
c. Using latest technology even if performance is compromised
d. both a and b
38. Which of the following are present in successful BI project under culture and politics?
a. Fragmented culture
b. Financial culture
c. Traditional IT culture
d. All of these
39. There are how many obstacles to get the business intelligence right?
a. 2
b. 3
c. 4
d. 1
40. Which of the following is not among the three problem areas that you must tackle for a successful
business intelligence implementation.
a. User resistance
b. Feeling replaced
c. User acceptance
d. Failing to deliver
41. Which obstacle correctly suits the statement “Organizations may use business intelligence for
analysis, but fail to use it for taking action.”
a. Failing to deliver
b. Feeling replaced
c. User resistance
d. None of these
“Business Intelligence projects typically go beyond the boundaries of departments, processes and even
business units; contain a mix of strategy, business operations and technology and are often highly
political.”
a. True
b. False
“Managers, who make decisions purely based on gut feeling and not based on facts, often find it difficult
to accept the new reality that Business Intelligence represents.”
a. True
b. False
47. If we have large amounts of data at our disposal but we do not know the meaning then its called:
a. Data with context
b. Data without context
c. Meaningful data
d. None of these
48. If an organization does not register the signals that are important for effective business operations,
then the senses of that organization .
a. Works correctly
b. Works systematically
c. Malfunctions
d. All of these
49. Lack of experience, selecting the wrong advisors, developing and applying an architecture that does
not fit comes under which type of risk?
a. User risks
b. Managerial risks
c. Both i and ii
d. Organizational risks
4.) Which user uses raw data for drilling down in Ad hoc queries?
A Power users
B Business users
C It users
D Casual users
6.) Which user represent more than one are of the business?
A Power users
B Business users
C IT users
D Casual users
26.)What is BI widget?
A Application that delivers information
B entity
C Comparison
D spread at a given point of time
41.)Which company has the following GIS application:” Directs drivers to destinations”?
A Pepsi
B Toyota
C Western auto
D All
44.)Which company has the following GIS application: Manages leased property in a lot of places”?
A Pepsi
B Consolidated Rail corporation
C Western auto
D All
45.)What provides the most aid in decision making
A Scores
B Charts
C GIS
D All
4 DSS brings problem-solving and Decision making strategies together to enable decision making
true
false
7 Consider you want to open Food Center in Pune what information will be relevant for you to take
decision
a time of the restaurant
b which location will attract more customers.
c food trends in market and cost of menu.
d all of the above
8 How should one take decisions from the alternatives:
a gather relevant information for decision to be made
b find various alternatives based on imagination and information
c Evaluate ,assess and weigh the alternatives
d all of the above
16 True or False . DSS are based on improvement of the effectiveness of decision rather than efficiency.
A True
B False
17 What general type of DSS would iinclude file drawer systems, data warehouses, on-line analytical
processing (OLAP) systems, and Executive Information Systems?
A). Communications-Driven DSS
B). Data-Driven DSS
C). Document-Driven DSS
D). Knowledge-Driven DSS
23 What are the questions that needs to be addressed by analysis phase in development of DSS?
A What should DSS accomplish?
B Who will be using the DSS?
C when and How DSS will be used?
D All of the above
36 Which of the following provides end users with collection of mathematical models derived from
operations research, statistics and financial analysis?
A Model management
B Data management
C Interaction
D Knowledge management
37 Which of the following enables knowledge workers to use DSS interactively in order to carry out their
analysis.
A Interactions
B Model Management
C Knowledge Management
D Data management
38 Which of the following includes a system to contain data required by the decision making process ?
A Data management
B Model Management
C Knowledge management
D Interactions
39 Why does data management module needs to be connected with company data warehouse?
A Company data warehouse represents the main repository of the data available to develop
business intelligence analysis.
B DSS systems are not dependent on company warehouse for data rather the extract data from
external sources.
C Both A & B
B After decisions are made knowledge management module of DSS interacts with company
knowledge management to add knowledge of decision.
C Both A& B
C Greater reliability of the control mechanisms due to increased intelligibility of decision process.
A Database management system which stores the data from all the resources available.
B Database designed to contain data required by decision making processes to which DSS is
addressed.
C Data management module is usually connected with company data warehouse where data is
available for business intelligence analysis
D Both B&C.
44 Consider you are developing DSS in which of the phases you will do feasibility analysis?
A Planning
B Analysis
C Requirements
45 Consider you are developing DSS in which phase will the architecture of the system will be defined?
A Design
B Analysis
C Implementation
D Planning
46 What helps to extract crucial facts from vast amount of unstructured data transforming it into
actionable information that enables companies to make informed strategic decisions.
A Business Intelligence
C Data mining
47 Which of the following is not part of Business Intelligence decision making process?
A Data extraction
C Knowledge formation
A These are primarily involved with data and processing them into information and presenting
the information to decision maker.
B Most of the OLAP and reporting analytics software fall in this category.
C Both A & B
49 Which DSS uses computer, collaboration and communication technologies primarily to support groups
in tasks that may or may not include decision making?
C Both A& B
50 DSS which rely on knowledge coding, analysis, search and retrieval for decision support falls under
what category?
D Engineering firm that has bids on several projects and wants to know if they can be competitive
with their costs.
UNIT IV: Data Pre-processing
Q1. How many phases does a data analytics life cycle contain?
i. 4 ii. 3
iii.6 iv. 5
Q2. In which phase of the data analytics life cycle, we define the business problem as an analytics
challenge?
i. Model Planning ii. Data Discovery
iii. Operationalization iv. Data Preparation
Q3. describes any type of processing performed on raw data to prepare it for
another processing procedure.
i. Data Modeling ii. Data Processing
iii. Data Transformation iv. Data Pre-Processing
Q4. Which task in Data Preparation fills in missing values, smooth’s noisy data, removes outliers, and
resolves inconsistencies.
i. Data Cleaning ii. Data Transformation
iii. Data Integration iv. Data reduction
Q9. Whose applications use visual tools such as geographical maps, pivot-tables, and heat-maps to make
the process of finding patterns:
i. Data Modeling ii. Data Discovery
iii. Data Integration iv. None of these
Q12. Let income range $12,000 to $98,000 normalized to [0.0, 1.0]. Then $73,000 is mapped to(use min-
max normalization):
i. 0.716 ii. 0.512
iii. 0.235 iv. 0.872
Q14. involves combining data residing in different sources and providing users with a unified view
of these data.
i. Data Discretization ii. Data Integration
iii. Data Reduction iv. None of these
Q16. Which of the following does not come in the three main criteria to determine whether a data
reduction technique should be used:
i. Efficiency ii. Complexity
iii. Accuracy iv. Simplicity
Q17. Discovery is
i. It is hidden within a database and can only be recovered if one is given certain clues (an example IS
encrypted information).
ii. The process of executing implicit previously unknown and potentially useful information from data.
iii. An extremely complex molecule that occurs in human chromosomes and that carries genetic
information in the form of genes.
iv. None of these
Q20. What becomes increasingly important in cases of merging systems of two companies or
consolidating applications within one company to provide a unified view of the company's data assets.
i. Data Modeling ii. Model Building
iii. Data Integration iv. All of these.
Q22. Which step of data transformation maps data elements from the source data system to the
destination data system and captures any transformation that must occur:
i. Data mapping ii. Cell mapping
iii. Code generation iv. None of these
Q23. step takes the data element mapping specification and creates an executable program that
can be run on a computer system
i. Code generation ii. Map generation
iii. Data mapping iv. None of these
Q24. What reduces the number of values for a given continuous attribute by dividing the range of the
attribute into intervals:
i. Data Reduction ii. Data Discretization
iii. Data Integration iv. None of these
Q25. A concept hierarchy for a given numeric attribute defines a of the attribute:
i. Discretization ii. Normalization
iii. Standardization iv. All of these
Q26. Concept hierarchies often can be generated automatically or dynamically refined based on which of
the data distribution.
i. Predictive analysis ii. Statistical analysis
iii. Both i and ii iv. None of these
Q27. Which data discretization technique defines “If the process starts by first finding one or a few points
(called split points or cut points) to split the entire attribute range, and then repeats this recursively on the
resulting intervals”.
i. Top-Down ii. Bottom-Up
iii. Left-Right iv. Right-Left
Q28. Which data discretization technique defines “Starts by considering all of the continuous values as
potential split- points, removes some by merging neighborhood values to form intervals, and then
recursively applies this process to the resulting intervals”
i. Top-Down ii. Bottom-Up
iii. Left-Right iv. Right-Left
Q29. The sorted values after discretization are distributed into a number of buckets, or bins, and then
replacing each bin value by either the bin .
i. Mean ii. Median
iii. Both i or ii iv. Mode
Q31. Concept hierarchies facilitate in data warehouses to view data in multiple granularity:
i. Drilling and Rolling ii. Slicing and dicing
iii. Sampling iv. All of these
Q32. The is the process of realizing a problem, establishing and evaluating planning
criteria, creating alternatives, implementing alternatives, and monitoring progress of the alternatives.
Q33. The very similar rational decision-making model, as it is called in organizational behavior, is a
process for making decisions.
Q34. Rational decision making is a process for making logically sound decisions that aims to
follow the orderly path from problem identification through solution.
i. Single Step ii. Multi Step
iii. Hybrid iv. Systematic
Q35. Building models are scale models of structures and are commonly used in
i. Model railroading ii. Wargaming
iii. Diorama making iv. All of these
Q36. In which phase the team builds and executes models based on the work done in the model planning
phase.
i. Model Planning ii. Model Building
iii. Data Preparation iv. None of these
Q37. In which phase does the team explores the data to learn about the relationships between variables
and subsequently selects key variables and the most suitable models.
Q38. In which phase does the team, in collaboration with major stakeholders, determines if the results of
the project are a success or a failure based on the criteria developed in Phase 1
To communicate the findings effectively, these need to be understandable to clients who may know little
about market research and who may even be unfamiliar with the specific market research project.
Q40. During this stage the team delivers final reports, briefings, code, and technical documents. In
addition, the team may run a pilot project to implement the models in a production environment.
Operationalization also sets up exact definitions of each variable, decreasing the quality of the results, and
improving the robustness of the design.
Q45. It is a data object that deviates significantly from the rest of the objects, as if it were generated by a
different mechanism.
i. Noisy data ii. Outlier
iv. Noise iii. None of these
Q47. Which outlier detection method assumes that an object is an outlier if the proximity of the object to
its nearest neighbors significantly deviates from the proximity of most of the other objects to their
neighbors in the same data set.
i. Proximity based analysis ii. Clustering based analysis
iii. Both i and ii iv. None of these
Q48. If an individual data instance is anomalous in a specific context (but not otherwise), then it is termed
as a
i. Global Outlier ii. Collective Outlier
iii. Point Outlier iv. Contextual Outlier
Q49. If a collection of data points is anomalous with respect to the entire data set, it is termed as a:
i. Global Outlier ii. Collective Outlier
iii. Point Outlier iv. Contextual Outlier
Q50. based outlier detection methods assume that the normal data objects belong to large
and dense clusters, whereas outliers belong to small or sparse clusters, or do not belong to any clusters.
i. Cluster ii. Proximity
iii. Point iv. None of these
1. What is not the part of BI Cycle?
a. Measurement
b. Data Collection
c. Insight
d. Analysis
5. Which of the following BI technique can predict value for a specific data item attribute?
a. Predictive modeling
b. Modeling
c. Predictive value
d. Association
a. Knowledge derived from data through the use of Business Intelligence Tools and
the process of Data Warehousing
b. Knowledge derived from data through the use of Business Intelligence Tools
c. Knowledge derived from data only
d. Both a and c
8. All business intelligence applications require a data warehouse.
a. True
b. False
9. Information is
a. Unprocessed data
b. Processed data
c. Facts
d. None of the above
a. Roll up
b. Drill down
c. Dynamic calculation
d. pivot
12. Which of the following is a logical collection of data gathered from many databases and
used to create business intelligence?
13. is a system where operations like data extraction, transformation and loading operations
are executed.
a. Data Integration
b. ETL
c. Data Staging
d. None of the above
14. What is a subset of a data-warehouse?
a. Data storeroom
b. Data mart
c. Database
d. Data set
a. Data cube
b. OLTP
c. OLAP
d. All of the Above
a. Data warehouse
b. Database
c. Artificial Intelligence
d. None of the Above
a. Continual
b. Interval-based
c. Once a Year
d. None of the above
20. Which of the following is not a User Interface component?
a. Browser
b. Portal
c. Dashboard
d. Text File
21. Which of the following users handle the data warehouse environment?
a. Technical Staff
b. Business Users
c. Managers/executives
d. None
a. Storing data
b. Visualizing critical data for executives
c. Handle queries and perform operations on data warehouses
d. None of the Above
a. Monitoring Performance
b. Analyzing Performance
c. Both a and b
d. None of the above
26. What are features of SAP NetWeaver?
a. Summarizing data
b. Checking referential Integrity
c. Building Dimensions
d. Extracting only valid data
31. Which of the metadata approaches helps in integration with multi-vendor tools along with
flexibility?
33. Which of the following is not an enabling factor in business intelligence projects?
a. Technologies
b. Analytics
c. Security
d. Human Resources
35. Why all or nothing approach in enterprise software projects not needed?
a. It leads to high costs
b. the time required for such projects is long and by the completion time user requirements
change
c. unwieldy user requirements
d. all of above
37. which of the following are critical success factors in ensuring BI implementation successful
a. Performance is key
b. Having functionality for every type of business
c. Using latest technology even if performance is compromised
d. both a and b
38. Which of the following are present in successful BI project under culture and politics?
a. Fragmented culture
b. Financial culture
c. Traditional IT culture
d. All of these
39. There are how many obstacles to get the business intelligence right?
a. 2
b. 3
c. 4
d. 1
40. Which of the following is not among the three problem areas that you must tackle for a
successful business intelligence implementation.
a. User resistance
b. Feeling replaced
c. User acceptance
d. Failing to deliver
41. Which obstacle correctly suits the statement “Organizations may use business intelligence
for analysis, but fail to use it for taking action.”
a. Failing to deliver
b. Feeling replaced
c. User resistance
d. None of these
a. True
b. False
“Managers, who make decisions purely based on gut feeling and not based on facts, often find it
difficult to accept the new reality that Business Intelligence represents.”
a. True
b. False
47. If we have large amounts of data at our disposal but we do not know the meaning then its
called:
a. Data with context
b. Data without context
c. Meaningful data
d. None of these
48. If an organization does not register the signals that are important for effective business
operations, then the senses of that organization .
a. Works correctly
b. Works systematically
c. Malfunctions
d. All of these
49. Lack of experience, selecting the wrong advisors, developing and applying an architecture
that does not fit comes under which type of risk?
a. User risks
b. Managerial risks
c. Both i and ii
d. Organizational risks
4.) Which user uses raw data for drilling down in Ad hoc queries?
A Power users
B Business users
C It users
D Casual users
6.) Which user represent more than one are of the business?
A Power users
B Business users
C IT users
D Casual users
41.) Which company has the following GIS application:” Directs drivers to
destinations”?
A Pepsi
B Toyota
C Western auto
D All
47.) What question is this “How much revenue in the last quarter?”
A1D
B2D
C3D
D All
4 DSS brings problem-solving and Decision making strategies together to enable decision
making
true
false
B Support for all managerial levels ranging from top executives to line managers.
A Requirement,analysis,planning,design,implementation,delivery
B Analysis,requirement,planning,design,implementation,delivery
C Requirement,Planning,Analysis,Design,Implementation,Delivery
D Requirement,Analysis,Design,Planning,Implementation,Delivery
A Most of the semi-structured problems are previously solved and contain information
about the problems in details.
D Both B&C
36 Which of the following provides end users with collection of mathematical models derived
from operations research, statistics and financial analysis?
A Model management
B Data management
C Interaction
D Knowledge management
37 Which of the following enables knowledge workers to use DSS interactively in order to carry
out their analysis.
A Interactions
B Model Management
C Knowledge Management
D Data management
38 Which of the following includes a system to contain data required by the decision making
process ?
A Data management
B Model Management
C Knowledge management
D Interactions
39 Why does data management module needs to be connected with company data warehouse?
A Company data warehouse represents the main repository of the data available to
develop business intelligence analysis.
B DSS systems are not dependent on company warehouse for data rather the extract data
from external sources.
C Both A & B
B After decisions are made knowledge management module of DSS interacts with
company knowledge management to add knowledge of decision.
C Both A& B
A Database management system which stores the data from all the resources
available.
D Both B&C.
C Data directory
D All of the above.
44 Consider you are developing DSS in which of the phases you will do feasibility
analysis?
A Planning
B Analysis
C Requirements
45 Consider you are developing DSS in which phase will the architecture of the system
will be defined?
A Design
B Analysis
C Implementation
D Planning
46 What helps to extract crucial facts from vast amount of unstructured data transforming
it into actionable information that enables companies to make informed strategic decisions.
A Business Intelligence
C Data mining
47 Which of the following is not part of Business Intelligence decision making process?
A Data extraction
C Knowledge formation
A These are primarily involved with data and processing them into information and
presenting the information to decision maker.
B Most of the OLAP and reporting analytics software fall in this category.
C Both A & B
C Both A& B
50 DSS which rely on knowledge coding, analysis, search and retrieval for decision support
falls under what category?
D Engineering firm that has bids on several projects and wants to know if they can be
competitive with their costs.
Business Intelligence Multiple Choice
Questions
Unit IV- Data Pre-processing
Q1. How many phases does a data analytics life cycle contain?
i. 4 ii. 3
iii.6 iv. 5
Q2. In which phase of the data analytics life cycle, we define the business
problem as an analytics challenge?
i. Model Planning ii. Data Discovery
iii. Operationalization iv. Data Preparation
Q3. describes any type of processing performed on raw data to
prepare it for another processing procedure.
i. Data Modeling ii. Data Processing
iii. Data Transformation iv. Data Pre-Processing
Q4. Which task in Data Preparation fills in missing values, smooth’s noisy
data, removes outliers, and resolves inconsistencies.
i. Data Cleaning ii. Data Transformation
iii. Data Integration iv. Data reduction
Q5. Integration of multiple databases, data cubes, or files is done in:
i. Data Transformation ii. Data discretization
iii. Data Cleaning iv. None of these
Q12. Let income range $12,000 to $98,000 normalized to [0.0, 1.0]. Then
$73,000 is mapped to(use min-max normalization):
i. 0.716 ii. 0.512
iii. 0.235 iv. 0.872
Q13. State true or false:
Data cleansing differs from data validation in that validation almost
invariably means data is rejected from the system at entry and is performed
at entry time, rather than on batches of data.
i. True ii. False
Q14. involves combining data residing in different sources and
providing users with a unified view of these data.
i. Data Discretization ii. Data Integration
iii. Data Reduction iv. None of these
Q15. Which of the following are Data Integration tools:
i. Alteryx ii. Analytics Canvas
iii. Rapid Miner Studio iv. All of these
Q16. Which of the following does not come in the three main criteria to
determine whether a data reduction technique should be used:
i. Efficiency ii. Complexity
iii. Accuracy iv. Simplicity
Q17. Discovery is
Q19. It is a process which pulls out specified data that is significant in some
particular context:
i. Sampling ii. Feature Extraction
iii. Both I and II iv. None of these
Q27. Which data discretization technique defines “If the process starts by
first finding one or a few points (called split points or cut points) to split the
entire attribute range, and then repeats this recursively on the resulting
intervals”.
i. Top-Down ii. Bottom-Up
iii. Left-Right iv. Right-Left
Q28. Which data discretization technique defines “Starts by considering all
of the continuous values as potential split- points, removes some by
merging neighborhood values to form intervals, and then recursively
applies this process to the resulting intervals”
i. Top-Down ii. Bottom-Up
iii. Left-Right iv. Right-Left
Q29. The sorted values after discretization are distributed into a number of
buckets, or bins, and then replacing each bin value by either the bin
.
i. Mean ii. Median
iii. Both i or ii iv. Mode
Q30. Which of the following is not a binning method:
i. Equal width partitioning ii. Equal depth partitioning
iii. Equal height partitioning iv. None of these
Q37. In which phase does the team explores the data to learn about the
relationships between variables and subsequently selects key variables and the
most suitable models.
Q40. During this stage the team delivers final reports, briefings, code, and
technical documents. In addition, the team may run a pilot project to
implement the models in a production environment.
Answer: C
2. Which of the following are not done by Business Intelligence (BI) systems?
Answer: B
3. Business Intelligence (BI) systems do not obtain their data by which of the following means?
Answer: B
4. The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
A. Dirty data
B. Inconsistent data
D. Non-integrated data
Answer: C
5. A report generated by a reporting system is delivered to the appropriate users via a user-accessed
Web site. This system uses which of the following report modes?
A. Push B. Pull
C. RFM D. OLAP
Answer: B
RFM analysis uses customers' purchasing patterns to .
A. record transactions
D. perform OLAP
Answer: B
A. frequently
B. freshness
C. fast food
D. fantasy
Answer: A
8. We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos
for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D
C. lift
D. confidence
Answer: B
9. Business Intelligence (BI) reporting systems cannot do which of the following operations?
A. Filter data
B. Group data
C. Modify data
Answer: C
C. Data metadata
D. None of the above are data warehouse components.
Answer: C
C. OLAP only
Answer: A
12. We have been given access to the company's operational data, and have been asked to
produce a report. We discover that some of the data we need are in an SQL server database
while other needed data are in a separate Oracle database. This is an example of .
A. dirty data
B. inconsistent data
C. non-integrated data
Answer: C
13. The reports generated by a reporting system are usually not delivered in which of the
following media?
A. Web portal
C. Digital dashboard
D. E-Mail
Answer: B
14. Data mining applications are used accomplish which of the following tasks?
Answer: C
Answer: A
A. levels only
B. dimensions only
C. measures only
Answer: D
17. Which of the following is not a reason that operational data are difficult to read?
A. Non-duplicated data
B. Dirty data
C. Missing values
D. Non-integrated data
Answer: A
18. We have Market Basket data for 1,000 rental transactions at a Video Store. There are
four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D
B. support
C. lift
D. confidence
Answer: D
Answer: C
20. We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5".
Hasn't ordered recently, orders infrequently, but places a large order when she
B.
orders.
Has ordered recently, orders frequently, but doesn't place a large order when
C.
she orders
Hasn't ordered recently, orders infrequently, and doesn't place a large order
D.
when she orders.
Answer: C
21. This is an approach to selling goods and services in which a prospect explicitly agrees
B. data mining
C. permission marketing
D. one-to-one marketing
E. batch processing
Answer C
22. In an Internet context, this is the practice of tailoring Web pages to individual users'
characteristics or preferences.
a. Web services
b. customer-facing
c. client/server
d. customer valuation
e. personalization
Answer E
23. This is the processing of data about customers and their relationship with the
enterprise in order to improve the enterprise's future sales and service and lower cost.
a. clickstream analysis
b. database marketing
d. CRM analytics
e. B2C
Answer D
24. This is a broad category of applications and technologies for gathering, storing,
analyzing, and providing access to data to help enterprise users make better business
decisions.
a. best practice
b. data mart
d. business intelligence
e. business warehouse
Answer D
consumer data (both for customers and potential customers) that is maintained in a
company's databases.
a. database marketing
b. marketing encyclopedia
c. application integration
d. service oriented integration
Answer A
26. This is an arrangement in which a company outsources some or all of its customer
a. spend management
c. hosted CRM
Answer C
Initiative (BPMI) as a means of modeling business processes, much as XML is, itself, a
a. BizTalk
b. BPML
c. e-biz
d. ebXML
e. ECB
Answer B
28. This is a central point in an enterprise from which all customer contacts are managed.
a. contact center
b. help system
c. multichannel marketing
d. call center
e. help desk
Answer A
29. This is the practice of dividing a customer base into groups of individuals that are similar
in specific ways relevant to marketing, such as age, gender, interests, spending habits, and so
on.
d. customer segmentation
e. change management
Answer D
30. In data mining, this is a technique used to predict future behavior and anticipate the
consequences of change.
a. predictive technology
b. disaster recovery
c. phase change
d. Digital Silhouettes
e. predictive modeling
Answer E