BDA- MSTAT

Which of the following statements is true about Hive indexes?

• Hive does not support indexing

• Hive indexes do not affect query performance at all.
• Indexes are automatically created for all Hive tables

• Indexes are stored as separate tables in Hive.

___________ is the primary role of the Hive Metastore

• Store metadata information about Hive tables

• Manage the distributed storage for Hive queries

• Optimize data storage
• To store the actual data of Hive tables

Three user interfaces in Hive are?

• Hive CLI

• Hive HD insight

• Hive Web Interface

• Hive API, Hive Command Line, Hive Desktop Client

Apache Hive is an open-source ___ and data warehousing infrastructure that processes ________ed data in Hadoop

______ is the language used by Hive

One primary difference between Hadoop and Spark

• Hadoop is in-memory processing; Spark is batch processing.
• Hadoop uses SQL for querying; Spark uses MapReduce.
• Hadoop is batch processing; Spark is in-memory processing.
• Hadoop is designed for real-time analytics; Spark is for data storage.

______ optimizes the way in which we can represent vertex and edges in Spark

______ is an execution model that is responsible for job scheduling in Spark

• Spark Streaming

• Apache Spark Core

• Spark SQL

• SQL

in Spark worker Node is used for?

• Storing data in a centralized database.
• Executing tasks and processing data in parallel.
• Managing user permissions and access control.
• Handling network communication between nodes.

__________ is a function that produces new RDD from the existing RDDs.

• Transformation
• Method
• Operation
• Action