Hadoop BI Questions and Answers

Trend Nxt Hadoop BI | Question and Answers

In this Hadoop BI Quiz we wil cover these topics such as what is hadoop, apache hadoop, hadoop database, hadoop big data, hadoop db, hadoop ecosystem, hadoop is open source, is hadoop open source, cluster hadoop, hadoop cluster, hadoop programming and so on.

1

What are the limitations of traditional dashboards?
static nature
limited data visualization
customizable / Personlizable
All of the above

Answer : D

2
The _____ dashboard technology make the use of dashboards ______ throughout the organization, catering to grassroots-level operational workers
Next Gen, Pervasive
Next Gen,exclusive
Traditional, pervasive
dynamic, necessary
Answer : A

3
Next Generation Dashboards provide personalized views based on role, group, and selections of the user
role, group, selection
role, access, type
authentication, type, level
role, group, selection
Answer : A

4
Next Generation Dashboards  provides
Predictive analytics and forecasting,
data from multiple data sources
Rich visualization
All of the above
Answer : D

5
which is true in case of Next Generation Dashboards ?
combines summary and detail data analysis
Parameterization enables a single dynamic dashboard to replace hundreds of static designs
requires no prior BI literacy
All of the above
Answer : D

6
Dashboards have become dynamic in that they now have ____ directly on the dashboards that let the users ____ through many different views of data all on the same dashboard
Controls, Flip
maps, navigate
charts, pivot
speedometer, update
Answer : A

7
A traditional dashboard can be customized and is normally used by — .
CEO
Senior & Middle Level Managers
Junior Managers
None
Answer : D

8
_____ is a SQL engine that compiles queries in a familiar language and constructs into MapReduce programs
______ was developed at Yahoo! as a new way to address complex data transformations procedurally without having to write java MapReduce code.
Pig Latin, HIVE
HIVE, Pig Latin
Pig Latin, HIVE QL
HIVE QL, Pig Latin
Answer : B

9
Next Generation Dashboards provides
Animated visual effects illustrating trends over time
Personalized views based on role, group
selections and
Data interactivity
All of the above
Answer : D

10
____ has difficulty coupling data from multiple sources into one application
____ has alerts that help fast tackling of deviations
____ has a disconnect between IT and business
Traditional,Next Gen, Traditional
Next Gen, Traditional, Next Gen
Traditional,Traditional, Traditional
Traditional,Next Gen, Next Gen
Answer : A

11
In addition to robust ___, next generation dashboards provide methods to ____ a user when performance indicators are out of tolerance, then enable the exploration of details with point and click simplicity.
data architecture,visually alert
data visualization,visually alert
data security,visually alert
data mapping,visually alert
Answer : B

12
Next Gen Dashboard contains
Let’s users work proactively,analyze and drill to detail
Tailored to each user
Alerts users to exception conditions
All of the above
Answer : D

13
_____ was designed for batch processing of complex data types at scale.
In-memory BI
Real time BI
Open source BI
Hadoop
Answer : D

14
The ____ Foundation (an open source consortium created by IBM in 2001 and later joined by fifty additional software vendors)
OLAP
BI
Eclipse
Open source
Answer : C

15
___ systems are generally recognized as those that provide massive scale out capabilities, frequently with terabytes or petabytes of data, and are too expensive and unwieldy to manage with traditional systems.
Open source
Big Data
Tera Data
Real time
Answer : B

16
What are the Benefits of ____ BI?
On-Demand: Immediately available with no infrastructure to deploy
Elastic: Can scale up or down quickly with changing requirements
Affordable: No large upfront costs, pay as you go
Virtual Appliance
PaaS
Cloud
Open source
Answer : C

17
Many organizations, both private and public, are currently evaluating or deploying Open Source BI tools (OS BI) like _______
qlikview, spotfire,
JasperSoft, Pentaho, or SpagoBI or Actuate.
SAP HANA, Panorama
Netezza
Answer : B

18
While ___ business intelligence presents historical data for manual analysis, ____ business intelligence compares current business events with historical patterns to detect problems or opportunities automatically.
traditional, open source
desktop, pervasive
pervasive, in-memory
traditional, real-time
Answer : D

19
All real-time business intelligence systems have some _____ .
data quality issue
Latency
precision issue
historical data
Answer : B

20
Cloud platform services, also known as PaaS
deliver computer software – as a service
deliver computer infrastructure – typically a platform virtualisation environment – as a service, along with raw (block) storage and networking.
a computing platform and/or solution stack as a service, often consuming cloud infrastructure and sustaining cloud applications.
None of the Above
Answer : C

21
Multitenancy is
refers to a principle in software architecture where a single instance of the software runs on a server, serving multiple client organizations (tenants).
refers to a multi-instance architecture where separate software instances (or hardware systems) are set up for different client organizations.
refers to a single-instance architecture where software instance (or hardware systems) are set up for different client organizations.
refers to a multi-instance architecture where separate software instances (or hardware systems) are set up for one client.
Answer : A

23
Software as a service (SaaS), sometimes referred to
as “on-demand software,” is a software delivery model in
software and its associated data are hosted centrally (typically in the (Internet) cloud)
which and are typically accessed by users using a thin client, normally using a web browser over the Internet.
All Of the above
Answer : D

24
An increasingly viable alternative route to multitenancy that eliminates the need for significant architectural change is to use _____ technology to host multiple isolated instances of an application on one or more servers.
Mobile technology
Cloud technology
In-memory technology
Virtualization
Answer : D

25
______ deliver software as a service over the Internet, eliminating the need to install and run the application on the customer’s own computers and simplifying maintenance and support.
Appliance as a service
Cloud application services or Software as a Service (SaaS)
Software service
mobile software
Answer : B

26
Key issue currently with cloud –
privacy
Security
Performance / Data Encryption
ALL
Answer : D

27
These appliances are a subset of the broader class of software appliances. Installation of a software appliance on a virtual machine creates a — appliance.
Software
Hardware
Virtual
Hardware-Software
Answer : C

28
What is self service BI ?
designing the information delivery layer, which will make data analysis capabilities on the fly
self-serve reporting is based on designing the intuitive information delivery layer, which will provide data analysis capabilities directly to users.
designing the BI delivery layer allowing users to request BI as a service
on-demand BI service to the ender user
Answer : B

29
The approach should have an end-state vision where business users can view the key performance indicators at strategic or tactical levels, and can drill down to the operational level to understand process performance also. This is
Cloud BI
Mobile BI
In-memory BI
Self service BI
Answer : D

30
For enabling self service BI, in the back end side, the data warehouse schema and online analytical processing (OLAP) models should be redesigned to
create more database objects
expose the database schema
hide the database complexity
minimize the database objects
Answer : C

31
Most visible change that organizations have seen by implementing self-service BI
more agility in their business
take advantage of market situations more quickly with self-service BI because they have faster access to BI.
Business can react to market changes
ALL
Answer : D

32
This is now is being used increasingly as a massively parallel data processing engine for Big Data / Hadoop.
Pentaho
Qlikview
MapReduce
virtual appliance
Answer : C

33
When a business user sees a problem that requires data to analyze the problem and strategize for a solution, that business user no longer has to first approach the IT department to access the data and build the necessary report.
In-memory BI
Real-Time BI
Self-Service BI
Cloud BI
Answer : C

34
____ Business Intelligence is a suite of analytics that provides ____ feedback and actionable insights into the employees, topics, and information-sharing occurring in your community.
Open source, accurate
Social, Real Time
Real-time, Real- time
pervasive, real-time
Answer : B

35
While a traditional Enterprise BI solution has the capability to extract internal organizational data and transform it into useful information, it however, ignores the importance of data available in ______.
Cloud
Social Media
Memory
Real time
Answer : B

36
Social Intelligence comes from
bringing reliable data into the decision making process.
bringing structured data into the decision making process.
bringing unstructured data into the decision making process.
bringing raw data into the decision making process.
Answer : C

37
Unstructured data can be bucketed into these categories:
Data resides in Secured-access applications websites like Facebook,LinkedIn,Twitter
User-generated content – Published blogs, reviews, market research
Audio/Video files from YouTube and Audio forums
All of the above
Answer : D

38
Understanding public perception about a brand is a key enabler for any business.A corporation must build solutions based on Brand Intelligence which would enhance their understanding of how their brand is perceived in the marketplace – and make
better decisions as a result.
software
Image
Brand
Hardware
Answer : C

39
Taking a proactive approach and using available tools to extract social intelligence can
save time and money (and in some cases avoid a crisis),
improve a business strategy or campaign,
highlight product preference feedback,
provide insight into industry trends, reveal what competitors are doing,
All of the Above
Answer : D

40
HIVE, a data warehouse infrastructure built on top of Hadoop, which provides the relational structure necessary for schedule reporting of large datasets data stored in Hadoop files.
Hive QL
X-Query
Pig Latin
HIVE
Answer :  

41
It’s one of the biggest user of Hadoop
Oracle
Microsoft
hotmail
Yahoo
Answer : D

42
HIVE also provides a simple query language called ____
Hi-Q
Hive QL
Hi-SQL
H-SQL
Answer : B

43
Microsoft Mobile Native Application is best designed for _______________________
iPad
Blackberry
Android
None of the above
Answer : D

44
Mobile BI Development Approaches to Dashboards/Scorecards does not  include following
Native Application
Data Sync through Cable
Hybrid Web approach
HTML5
Answer : B

45
The special security measures which need to be implemented for Mobile BI applications are at
Organization Server end
Mobile Device end
Mobile Device and Server end
Only at data Transmission end
Answer : C

46
The ultimate aim / aims of mobile bi solution for an organization is /are
better decision making
improved productivity
employee satisfaction
A & B
Answer : D

47
For execution purposes, the requirements-gathering for mobile BI should be focused on identifying which reports, dashboards and alerts will be beneficial on handsets
Not all reports can be delivered to Mobile handset.
True Mobile BI Application delivers all the reports on mobile handsets. Thus replicating organizations existing BI environment.
Alerts are the only application which can be implemented in Mobile BI application. Dashboard and reports cannot be displayed on small screen of a smartphone.
Only operational reports need to be delivered.
Answer : A

48
Mobile BI involved development of applications for mobile devices excluding
Blackberry
Laptop
iOS
Android
Answer : B

49
Mobile BI delivery includes Bi data delivery to
Email to Mobile Device
Mobile Web Browser
Mobile Native Apps
A&B&C
Answer : D

50
For Mobile Bi, _____________ is a good candidate but for analytics and what-if analysis, __________ is a better option.
Tablet, Smartphone
Smartphone, iPhone
Smartphone, Tablet
iPhone, Android
Answer : C

51
Mobile BI applications can be defined/segregated as follows:
Mobile Browser Rendered App
Server Apps
Mobile Client App
A&C
Answer : D

52
Which of these is not a major Mobile BI product vendor
Microstrategy
RoamBi
Apple
IBM Cognos
Answer : C

53
IBM Cognos offers mobile BI solutions for the following mobile OS
IOS, Android
IOS, Android, BB excluding Playbook
IOS, Android, Windows and BB excluding Playbook
IOS, Android, Windows and BB including Playbook
Answer : D

54
AES or Triple DES with an encrypted SSL tunnel are forms of
Mobile Data Storage Protocols (MDSP)
Mobile Transmission Security measures.
Mobile BI Apps
Mobile Data Storage and Data Transfer measures.
Answer : B

55
With the mobile LOB deployment, data can be sent electronically to the__________________. This means the company is saving dollars that would have
been absorbed by data administration costs
Customers
Vendors
Both
None of the above. Data can only be shared with company employees due to Mobile BI restrictions.
Answer : A

56
Which of these is not a major challenge to adoption of Mobile BI in an organization
Lack of understanding of Business Benefits
Usability
Cost
Extending real time information to employees
Answer : D

57
Which of these is not  a security considerations to Mobile BI solution implementation
Device Security
Transmission security
BI Platform
Network security
Answer : C

58
Which of these are top reasons for spread of Mobile BI implementation
Real time connection
Improved screen resolution on tablets and smartphones.
Network Security
Improved broadband possibilities
Answer : C

59
Which of these is not a best practice to mobile bi implementation
Rolling out mobile BI for all users
Building mobile security architecture
Identifying the right reports to be delivered
Identifying the devices and iOS before building reports.
Answer : A

60
Offline data availability and analytics is a feature of
Thin client approach
Web browser based approach
Native Application
Email and data sync through cable
Answer : C

61
Which of these need not be classified as a security risk for an organization data
USB Thumb drives
Recordable CDs and DVDs
Laptops
HTML5
Answer : D

62
BI and device-level , Single authoring environment, Single administration environment
and Flexible support for the leading mobile devices – Android, Blackberry, iPad and iPhone, Windows is offered by
IBM Cognos
Microstrategy
This is standard offering by all BI Product vendor
Answer : A

63
The topmost limiting factor for implementing Cloud BI
Performance
Security
Cost
Scalability
Answer : B

64
Which of the following is not a service model for Cloud
PaaS
IaaS
SaaS
ZaaS
Answer : D

65
The service model that provides least control to consumer of cloud service
SaaS
PaaS
IaaS
All of the above
Answer : A

66
If the cloud infrastructure is owned by company selling cloud services, it is an example of
Private Cloud
Community Cloud
Public Cloud
Hybrid Cloud
Answer : C

67
Which of the following is the main driver for companies to adopt SaaS?
Cost
Speed of implementation
Zero Maintenance
Security
Answer : B

68
To minimize the on-going costs associated with an implementation, which option is the recommended one?
Private Cloud
Public Cloud
Hybrid Cloud
On Premise
Answer : A

69
Which of the properties aptly describe a cloud implementation
Virtualized
Multi-tenant
Utilization based
All of the above
Answer : D

70
Name the Cloud BI vendor from the list below
BadData
GoodData
BigData
AnyData
Answer : B

71
Integration of cloud with on-premise data
It cannot be done
Can be done with approval from company’s security officer
Can be done by cloud vendor through APIs only
Requires access to data behind firewall
Answer : D

72
Cloud BI is same as SaaS BI?
Yes
Both names can be used interchangeably
SaaS BI resides in the cloud
Both A and B
Answer : C

73
Which of the companies are most likely to implement a Cloud BI Solution?
Small companies
Large companies
Mid-Size companies
Does not matter
Answer : A

74
What is the most compelling reason for small size companies to adopt Cloud BI solution?
Cost of implementation
Time to implement
Do not have secure systems
Both a and b
Answer : D

75
What is multi-cloud clustering?
Multiple clouds that are on the same network
Seamless load balancing and failover between cloud nodes
Multiple clouds that are maintained by same organization
Seamless load balancing between cloud nodes
Answer : B

76
A company wishes to go for a cloud based BI solution for reporting on its marketing and financial data. Which model do you recommend?
Private Cloud
Community Cloud
Public Cloud
Hybrid Cloud
Answer : D

77
The advantage of SaaS cloud based BI is low initial investment and less reliance on internal IT resources
Yes, This is correct
No, Low initial investment but high reliance on IT resources
No, High initial investment but less reliance on IT resources
No, High initial investment and high reliance on IT resources
Answer : A

78
What is a multi-tenant cloud architecture?
Sharing of infrastructure in public cloud
Using PaaS, SaaS and IaaS in the same implementation
Different instance of software shared by multiple tenants
Same instance of software shared by multiple tenants
Answer : D

79
What is meant by metering
Pay as per usage
Ability to show metrics
Fixed On-going cost
Fixed One-time cost
Answer : A

80
What are some of the consideration to move BI to the cloud?
Type of cloud
Deployment model
Security compliance
All of the above
Answer : D

81
Which one is recommended if there is no dependency on on-premise infrastructure
Private Cloud
Community Cloud
Public Cloud
Hybrid Cloud
Answer : C

82
Which of the following tools provides a Cloud BI platform
Good Data
JasperSoft
Microstrategy
All of the above
Answer : D

83
What is the approximate usage of Cloud BI by small companies
20-30%
40-50%
50-60%
70-80%
Answer : B

84
What is vertical scaling?
Process of beefing up a server by adding more CPUs, more memory or faster disks
Process of Load balancing the servers
Clustering of servers
Increasing the number of users
Answer : A

85
What is horizontal scaling?
Addition of more RAM to existing machine
Addition of more disk space
Addition of more machines or devices to the computing
platform
Increasing the number of users
Answer : C

86
Gartner predicts that by 2012, __% of the global 1,000 companies will host BI in the cloud.
5
70%
9
1
Answer : B

87
Analytical processing is
the act of using software to analyse highly consolidated data, often to view the changes over time.
the act of using a relational database to produce reports giving data summaries on a regular basis (e.g. monthly)
the act of exporting data into a spreadsheet for analysis
the act of sumarising data on a regular basis (e.g. month end summaries)
Answer : A

88
Which type of OLAP is invalid
ROLAP
QOLAP
MOLAP
HOLAP
Answer : B

89
Which of the following is/are emerging BI trends
Mobile BI
Cloud BI
BigData
All of the above
Answer : D

90
Unstructured data refers to
Denormalized data
Normalized data provided in flat file format
Free form data from internet sites like Twitter, Facebook
Data taken from mainframes
Answer : C

91
The method in which data is transferred from diverse OLTP systems into a centralized place and then used for analysis follows the
Bottom-up approach
Hybrid approach
Top down approach
Neutral approach
Answer : C

92
Bottom-up approach refers to
Getting concurrence from end users as a starting point for use of BI tools
Designing data marts first and then connecting them through common data structures
Desiging a BI solution starting from data layer to presentation layer
Designing data warehouse and then defining views for data marts
Answer : B

93