Business Analytics & Intelligence - Set 3
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] OLAP stands for
a) Online analytical processing
b) Online analysis processing
c) Online transaction processing
d) Online aggregate processing
ANSWER : A
3] Data that can be modeled as dimension attributes and measure attributes are called ________ data.
a) Multidimensional
b) Single dimensional
c) Measured
d) Dimensional
ANSWER : A
4] 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
ANSWER : A
5] 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
ANSWER : A
6] 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
ANSWER : A
7] In SQL the cross-tabs are created using
a) Slice
b) Dice
c) Pivot
d) All of the mentioned
ANSWER : A
8] What do data warehouses support?
a) OLAP
b) OLTP
c) OLAP and OLTP
d) Operational databases
ANSWER : A
9] Which one of the following is the right syntax for DECODE?
a) DECODE (search, expression, result [, search, result]... [, default])
b) DECODE (expression, result [, search, result]... [, default], search)
c) DECODE (search, result [, search, result]... [, default], expression)
d) DECODE (expression, search, result [, search, result]... [, default])
ANSWER : D
10] What is true about Data Visualization?
A. Data Visualization is used to communicate information clearly and efficiently to users by the usage of information graphics such as tables and charts.
B. Data Visualization helps users in analyzing a large amount of data in a simpler way.
C. Data Visualization makes complex data more accessible, understandable, and usable.
D. All of the above
ANSWER : D
11] Data can be visualized using?
A. graphs
B. charts
C. maps
D. All of the above
ANSWER : D
12] Data visualization is also an element of the broader .
A. deliver presentation architecture
B. data presentation architecture
C. dataset presentation architecture
D. data process architecture
ANSWER : B
13] Which method shows hierarchical data in a nested format?
A. Treemaps
B. Scatter plots
C. Population pyramids
D. Area charts
ANSWER : A
14] Which is used to inference for 1 proportion using normal approx?
A. fisher.test()
B. chisq.test()
C. Lm.test()
D. prop.test()
ANSWER : D
15] Which is used to find the factor congruence coefficients?
A. factor.mosaicplot
B. factor.xyplot
C. factor.congruence
D. factor.cumsum
ANSWER : C
16] Which of the following is tool for checking normality?
A. qqline()
B. qline()
C. anova()
D. lm()
ANSWER : A
17] Which of the following is false?
A. data visualization include the ability to absorb information quickly
B. Data visualization is another form of visual art
C. Data visualization decrease the insights and take slower decisions
D. None Of the above
ANSWER : C
18] Common use cases for data visualization include?
A. Politics
B. Sales and marketing
C. Healthcare
D. All of the above
ANSWER : D
19] 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
ANSWER : C
20] Which are pros of data visualization?
A. It can be accessed quickly by a wider audience.
B. It can misrepresent information
C. It can be distracting
D. None Of the above
ANSWER : A
