Hadoop Questions and Answers – Drill with Hadoop

This set of tricky Hadoop Multiple Choice Questions & Answers (MCQs) focuses on “Drill with Hadoop”.

1. Drill is designed from the ground up to support high-performance analysis on the ____________ data.
a) semi-structured
b) structured
c) unstructured
d) none of the mentioned
View Answer

Answer: a
Explanation: Drill is an Apache open-source SQL query engine for Big Data exploration.

2. Point out the correct statement.
a) Drill provides plug-and-play integration with existing Apache Hive
b) Developers can use the sandbox environment to get a feel for the power and capabilities of Apache Drill by performing various types of queries
c) Drill is inspired by Google Dremel
d) None of the mentioned
View Answer

Answer: d
Explanation: Apache Drill is an open source, low latency SQL query engine for Hadoop and NoSQL.

3. ___________ includes Apache Drill as part of the Hadoop distribution.
a) Impala
b) MapR
c) Oozie
d) All of the mentioned
View Answer

Answer: b
Explanation: The MapR Sandbox with Apache Drill is a fully functional single-node cluster that can be used to get an overview on Apache Drill in a Hadoop environment.

4. MapR __________ Solution Earns Highest Score in Gigaom Research Data Warehouse Interoperability Report.
a) SQL-on-Hadoop
b) Hive-on-Hadoop
c) Pig-on-Hadoop
d) All of the mentioned
View Answer

Answer: a
Explanation: Drill is a pioneer in delivering self-service data exploration capabilities on data stored in multiple formats in files or NoSQL databases.

advertisement
advertisement

5. Point out the wrong statement.
a) Hadoop is a prerequisite for Drill
b) Drill tackles rapidly evolving application driven schemas and nested data structures
c) Drill provides a single interface for structured and semi-structured data allowing you to readily query JSON files and HBase tables as easily as a relational table
d) All of the mentioned
View Answer

Answer: a
Explanation: Hadoop is not a prerequisite for Drill and users can start ramping up with Drill by running SQL queries directly on the local file system.

6. Drill integrates with BI tools using a standard __________ connector.
a) JDBC
b) ODBC
c) ODBC-JDBC
d) All of the mentioned
View Answer

Answer: b
Explanation: Drill conforms to the stringent ANSI SQL standards ensuring compatibility with existing BI environments as well as Hive deployments.

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

7. Drill analyze semi-structured/nested data coming from _________ applications.
a) RDBMS
b) NoSQL
c) NewSQL
d) None of the mentioned
View Answer

Answer: b
Explanation: Modern big data applications such as social, mobile, web and IoT deal with a larger number of users and larger amount of data than the traditional transactional applications.

8. Apache _________ provides direct queries on self-describing and semi-structured data in files.
a) Drill
b) Mahout
c) Oozie
d) All of the mentioned
View Answer

Answer: a
Explanation: Users can explore live data on their own as it arrives versus spending weeks or months on data preparation, modeling, ETL and subsequent schema management.

advertisement

9. Drill provides a __________ like internal data model to represent and process data.
a) XML
b) JSON
c) TIFF
d) None of the mentioned
View Answer

Answer: b
Explanation: The flexibility of JSON data model allows Drill to query, without flattening, both simple and complex/nested data types as well as constantly changing application-driven schemas commonly seen with Hadoop/NoSQL applications.

10. Drill also provides intuitive extensions to SQL to work with _______ data types.
a) simple
b) nested
c) int
d) all of the mentioned
View Answer

Answer: b
Explanation: Users can also plug-and-play with Hive environments to enable ad-hoc low latency queries on existing Hive tables and reuse Hive’s metadata, hundreds of file formats and UDFs out of the box.

advertisement

Sanfoundry Global Education & Learning Series – Hadoop.

Here’s the list of Best Books in Hadoop.

To practice tricky questions on all areas of Hadoop, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.