Free Printable BDA- MSTAT

Worksheets

BDA- MSTAT

Total questions: 23

Worksheet time: 16mins

Name

Class

Date

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

(a)

(a) 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.

(a) 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.

10.

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

Transformation

Method

Operation

Action

11.

Resilient Distributed Dataset (RDD) 3 utilities in Spark

Fault Tolerance

In-Memory Computation

Batch Processing

Lazy Evaluation

12.

3 RDD action methods are?

map()

collect()

count(),

reduce()

saveAsTextFile()

13.

In Apache Spark, a Directed Acyclic Graph (DAG) is a sequence of (a) operations performed on the data, where each operation represents a step in the data processing pipeline.

14.

The Spark architecture depends upon two abstractions

RDD

DAG

MapReduce

Real Time abstraction

15.

HDFS cannot do _____

batch data analysis

static data storage

data visualization tasks

real-time data processing

16.

If You had to build an AI system which service of Spark would you use?

(a)

17.

________ transform in Spark is used to remove duplicate rows from a DataFrame or RDD.

Unique

Distinct

Special

Distinctive

18.

SparkContext is created in __________

Driver Program

Cluster Manager

the Spark shell

Executors

19.

Hive and other tools like Pig and Flink are part of which ecosystem?

Apache Kafka ecosystem

Apache Spark ecosystem

Apache Hadoop ecosystem

20.

Once a view is created in Hive, it cannot be updated or altered.

True

False

21.

Hive Bucketing is also known as _______

Hive Clustering

Hive Grouping

Hive Segmentation

Hive Partitioning

22.

If a dataset has 5 values and the table is bucketed into 2 buckets, the 3rd item will be stored in B (a) _(Single digit number)

23.

If a dataset has 5 values and the table is bucketed into 2 buckets, the 4th item will be stored in _____ bucket file

00003

00002

00000

00001

Reset

BDA- MSTAT

Total questions: 23

Worksheet time: 16mins

Similar Resources on Wayground