Process Monitoring

Basics of data concepts
Friday, January 20, 2017
11:32 AM
1. Traffic Control Center is used to monitor the state of the road network in Flanders. Every minute
data is entering the system from more than 570 locations on the highways. This data is
integrated and available to the traffic center to look at speed measurements on a certain point
on a road together with the weather condition in that region. This is an example of which data
integration scenario.
a. Business
b. Scientific
c. Commercial
d. Research
2. ‘ABC Ltd’ has different functioning departments such as HR, Finance and Sales. But the names of
the employees stored HR is not same as stored by Finance department. For example, Robert
Mathew is stored as Robert.M by HR while Finance stores this name as Mathew R.
Which of the following quality characteristics of data can rightly represent this scenario?
2. Completeness
3. Incompleteness
4. Consistency
5. Inconsistency
3. Which of the challenges would be caused by below mentioned issues collectively?
Structured and unstructured data
Various formats of the data
6. Economical challenges
7. Organizational challenges
8. Technological challenges
9. Developer challenges
4. Process of cleaning the data during ETL is
a. Transformation
b. Extraction
c. Loading
d. None of the above
5. What are the characteristics of a data warehouse?
e. Integratedf. Time variant
g. Subject oriented
h. Non volatile
i. A,b,c
ii.A,b,c,d
iii. B,c,d
iv. B,d
6. What are the characteristics of a data warehouse?
i. Integrated
j. Time variant
k. Subject oriented
l. Non violatile
v.A,B,C
vi. A,B,C,D
vii. B,C,D
viii. B,D
7. ABS Bank wanted a data warehouse to be created in order to have a centralized control over
data. When performing a data transfer from the source to the destination the developer noticed
that the same customer was being recognized as a different individual due to trivial differences
in the name present in files.
Which stage of data quality transaction is currently going on?
10. Extraction
11. Validation
12. Integration
13. None of the above
8. Which of the following is TRUE about OLAP? 2 appropriate choices from the following options.
a. It stores historical data
b. It consists of aggregated data
c. It should not be used in reporting as it consists of renormalized tables
d. Data retrieval requires more joins
9. Which of the modeling techniques is more useful for analytical systems?
e. E-R modeling
f. Data modeling
g. Dimensional modeling
h. Object modeling
10. ABS Bank wanted a data warehouse to be created in order to identify their weakness and to
improve on their skills. Saving accounts details of customers are present in an oracle database
while the details of mutual funds and their respective transactions are saved in IBM DB2
enterprise server edition. There is a column in both the tables namely ‘Returns’ which represent
different meanings in 2 tables. In Oracle it refers to ‘current final balance’ while in the latter it
represents the ‘total annual return’ for the respective mutual fund.
What kind of conflict would this lead to?14. Semantic
15. Schematic
16. Data standards
17. None of the above
11. Which of the following DW approaches was given by Ralph Kimball?
a. Top down
b. Bottom up
c. FCFS
d. LCLS
12. ‘ABC Ltd’ organization wants to analyze its data to improve its business. What all different types
of analysis can be performed?
e. Historical
f. Predictive
g. Performance
h. All of the above
13. With respect to data, what does ‘Single Version of Truth’ refer to?
i. Timeliness
j. Consistency
k. Accuracy
l. Completeness
14. Which of the following decisions are taken less frequently in an organization?
m. Operational
n. Strategic
o. Tactical
p. None
15. _____ is a broad category of application and technologies for gathering, storing, analyzing, and
providing access to data to help enterprise users make better business decisions.
q. Data Mart
r. Business Information Warehouse
s. Business Intelligence
t. Business Warehouse
16. INSERT, DELETE, UPDATE statements are most frequently used in ____ .
u. OLAP
v. OLTP
w. Batch Processing
x. Real Time Processing
17. Consider a situation, in an organization one strategy has been made for next 10 years in which
targets for employees have been increased to 10% and number of working hours have been
changed from 8.15 hrs to 9.15 hrs per day. Which of the following decision do you feel is this?
y. Tactical
z. Statistical
aa. Strategic
bb. Operational
18. Who are the end users of BI?cc. Corporate Executive
dd. Data Analysts
ee. Developers
ff. None of these
19. Employee left an organization, but his salary certificate got generated for next month. Which of
the following data properties does this discrepancy refer to?
gg. Timeliness
hh. Consistency
ii. Accuracy
jj. Completeness
20. A data warehouse id a time-variant collection of data. What does ‘time-variant’ in this statement
mean?
kk. Data being modified by transactions in the Data Warehouse
ll. Regular updating of Data Warehouse with the transaction data
mm. Data analysis requirements varying over time.
nn. Different tables taking different times for uploading in to the Data Warehouse
21. ‘XYZ’ organization records its employees’ data with First name, middle name and last name
where Middle Name is optional. If some of the employee provides their first Names and Middle
Names only, then this data will be termed as ____ .
oo. Complete
pp. Incomplete
qq. Redundant
rr. Accurate
22. Consider a data warehouse that captures data three times a day, i.e. every 8 hours. Users of the
data would prefer to view the report that has data which is aggregated into days, weeks,
quarters, or years. In such a case, how many minimum levels of the Time dimension are
required to carter to all the users?
ss. Five
tt. Six
uu. Four
vv. None of the above
23. Which of the following is a valid schema to represent a multi-dimensional data model?
ww. Ring
xx. Moon
yy. Star
zz. Bus
24. Which of the following is not the usage of hierarchy in dimensional modeling?
aaa. Used to slice and query within a cube
bbb. Provides data co-relation
ccc.Gives business perspective to data
ddd. Can be used for normalization
25. What is the maximum number of degenerate dimensions that is allowed in a fact table?
eee. One
fff. Twoggg. Three
hhh. Any, No restriction on the number
26. State true or false. “in a star constellation schema, the sme dimension table can be part of more
than one star schema’.
iii. True
jjj. False
27. Which of the following data models consists of one fact table and one or more normalized
dimension tables?
kkk.Star
lll. Fact constellation
mmm. Snowflake
nnn. Both snowflake and fact constellation
28. Which of the following is not a type of dimension?
ooo. Slowly changing
ppp. Degenerate
qqq. Junk
rrr. Additive
29. Which of the following is false in case of a garbage dimension?
sss. It’s also referred as junk dimension
ttt. Attributes of this dimension are not related to any hierarchy
uuu. Attributes of this dimension are related to specific hierarchy
vvv.Contains low-cardinality columns
30. What is a data model used for?
www. To define and analyze data in an organization
xxx.To perform relations among entities
yyy.To collect business requirements
zzz. None of these
31. Which of the following is/are different types of hierarchies?
aaaa. (a) Natural hierarchies
bbbb. (b) Ragged hierarchies
cccc. Only (a)
dddd. Both (a) and (b)
32. Which of the following statements are TRUE? Select the most appropriate 3 options.
eeee. Corporate dashboards improve accountability
ffff. Corporate dashboards improves transparency across the organization
gggg. Corporate dashboards work effectively with balanced scorecard
implementations
hhhh. Corporate dashboards improve productivity of employees
33. Which of the following are the different types of ‘Enterprise Dashboards’?
2. Enterprise Performance
3. Divisional
4. Process Monitoring
5. Balanced
iiii. I, IVjjjj. II, III, IV
kkkk. II, III
llll. I, II, III
34. Which of the following are the best practice of ‘Enterprise Dashboards’?
mmmm. Use of pie chats should be done only when all the components add to 100%
nnnn. Use specific colors to represent district categories
oooo. Data Overload should be avoid which may cause errors in decision making
pppp. Data overload sometimes is good as it gives more information
B,D
A,B,C,D
A,B,C
Only D
35. A hotel website displays a completely personalized report where the user can see the number of
reservations done by him in any month. What kind of report is this?
qqqq. Customer support dashboard
rrrr. Divisional dashboard
ssss. Performance dashboard
tttt.Metric Management report
36. In order to determine potential of market growth, John is trying to compare total revenues
generated in more than 15 countries, Which of the following chart form will be suitable for this
comparison?
uuuu. Pie Chart
vvvv. Bar Chart
wwww. Scattered plot
xxxx. Line chart
37. Suzane tries to perform comparative profit analysis of various product categories so that
promotion campaign can be planned for categories with relatively less profit margins. Which of
the following charts should Suzane choose for this survey?
yyyy. Pie chart
zzzz. Column chart
aaaaa. Scattered plot
bbbbb. Line chart
38. Which of the following is TRUE about ‘Division Dashboards’?
ccccc. Each division has its own set of KPI’s which can be visually displayed on the
enterprise dashboard
ddddd. They provide personal account information to the customers
eeeee. Both of them
fffff. None of them
39. ‘Wisco Systems’ is a service-oriented company in the field of BI and Analytics. The performance
of this organization is evaluated based on 4 criteria, that are:
a. What is it that you wish to achieve?
b. How do you know if you have been able to achieve the stated objectives?c. What is the level of performance expected or the level of improvement expected?
d. What is it that you would do to achieve your targets and thereby your objectives?
What kind of reports should be used to represent the data as per the above requirements?
18. Metric Management report
19. Balaced scorecard
20. Dashboard
21. All of the above choices
40. Corporate dashboards are used for ____. Select the valid option.
a. Better tracking
b. Better analysis
c. Proactive alerting
d. All of them
41. Which of the following are considered as bad practices for building ‘Enterprise Dashboards’?
Select 2 valid options.
e. Use of more than 6 visuals in a single dashboard
f. Use of specific colors to appeal distinct categories
g. Avoid data overload because it may cause in decision making
h. Provide as much as data possible because data overload always gives more informatio