Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.

There can be only one Flume agent.

Answer»

There can be only ONE Flume agent.
Choose the CORRECT option from below list
(1)True
(2)False

Answer:-(2)False

2.

___________ is a data-serialization framework.

Answer»

___________ is a data-serialization framework.
Choose the CORRECT option from below list
(1)Exec
(2)APACHE Avro
(3)syslog
(4)TCP

Answer:-(2)Apache Avro

3.

Oozie uses ___________ type of graph.

Answer» OOZIE USES ___________ TYPE of graph.
Choose the correct option from below LIST
(1)CYCLIC
(2)infinite
(3)acyclic
(4)None of the options

Answer:-(3)acyclic
4.

________ monitors status of coordinator jobs.

Answer»

________ monitors status of coordinator jobs.
Choose the CORRECT option from below list
(1)Oozie WORKFLOW
(2)Oozie Coordinator
(3)Oozie BUNDLES

Answer:-(3)Oozie Bundles

5.

Why is Sqoop highly dependent upon the primary keys of the RDBMS?

Answer»

Why is Sqoop highly dependent UPON the PRIMARY keys of the RDBMS?
Choose the correct option from below list
(1)There is no work
(2)The lack of primary NUMERIC key will increase the likelihood of undesired results
(3)The primary key will speed up indexing
(4)NONE of the options

Answer:-(3)The primary key will speed up indexing

6.

___________ is used to run multiple jobs in parallel.

Answer»

___________ is USED to run multiple JOBS in parallel.
Choose the correct option from below list
(1)Join
(2)Combine
(3)Distribute
(4)Fork

Answer:-(4)Fork

7.

What would be the correct step after Flume and Flume agent is installed?

Answer»

What would be the correct step after Flume and Flume agent is installed?
CHOOSE the correct option from below list
(1)Configure the working DIRECTORY
(2)Make a symlink
(3)Configure the CONFIGURATION directory
(4)None of the options

Answer:-(2)Make a symlink

8.

Which one of the following type of node shows the start and end of the workflow?

Answer»

Which one of the FOLLOWING type of node shows the start and end of the WORKFLOW?
Choose the correct option from below LIST
(1)ACTION Node
(2)Control Flow Node
(3)Workflow Node

Answer:-(2)Control Flow Node

9.

hduser sqoop import ______________.

Answer»

hduser sqoop import ______________.
CHOOSE the correct option from below list
(1) username user
(2) connect jdbc:mysql://LOCALHOST/
(3) password ROOT
(4)None of the options

Answer:-(2) connect jdbc:mysql://localhost/

10.

The Oozie workflow should have the __ node.

Answer»

The OOZIE workflow should have the __ node.
Choose the correct option from below LIST
(1)end
(2)START
(3)EXIT
(4)resume

Answer:-(2)start

11.

Each row in the table is taken as a _______ in HDFS.

Answer»

Each row in the table is taken as a _______ in HDFS.
Choose the correct OPTION from below list
(1)RECORD
(2)input
(3)row
(4)data

Answer:-(1)record

12.

Which of the following are applicable to Sqoop?

Answer»

Which of the following are applicable to Sqoop?
Choose the correct option from below list
(1)CREATED by Hortonworks
(2)Uses a GUID INTERFACE
(3)Designed to connect to MAPREDUCE and to LAUNCH MapReduce jobs
(4)None of the options

Answer:-(3)Designed to connect to MapReduce and to launch MapReduce jobs

13.

The ______ channel behaves very similarly to the file channel.

Answer»

The ______ channel BEHAVES very SIMILARLY to the file channel.
Choose the correct OPTION from below list
(1)Memory channel
(2)JDBC Channel
(3)FLUME channel

Answer:-(2)JDBC Channel

14.

The _________ node drives the actions of the workflow while the __________ node is a specific executable tied to a function.

Answer»

The _________ node DRIVES the actions of the WORKFLOW while the __________ node is a specific executable tied to a function.
Choose the correct option from below LIST
(1)control, workflow
(2)action, control
(3)control, action
(4)None of the options

Answer:-(3)control, action

15.

_______ provides logic between action nodes like start, end and kill.

Answer»

_______ provides LOGIC between action nodes LIKE start, END and kill.
Choose the CORRECT option from below list
(1)Workflow
(2)Control Nodes
(3)Both of the options
(4)NONE of the options

Answer:-(2)Control Nodes

16.

Which of the following options should be kept in mind before exporting data with reducers?

Answer»

Which of the following options should be kept in mind before exporting DATA with REDUCERS?
Choose the correct option from below list
(1)Sqoop EXPORTS from HDFS do not provide the LOCATION of source files
(2)Sqoop exports have a complete UNDERSTANDING of the data types
(3)The correct key values should be assigned to each reducer during the partitioning
(4)None of the options

Answer:-(3)The correct key values should be assigned to each reducer during the partitioning

17.

Which of the following options are the different types of sink in Apache Flume?

Answer»

Which of the FOLLOWING OPTIONS are the different types of sink in Apache Flume?
Choose the correct option from below list
(1)FILE Roll
(2)Null
(3)Logger
(4)All of the options

Answer:-(4)All of the options

18.

Which one of the following options is the default database of Sqoop?

Answer»

Which one of the following options is the default database of SQOOP?
Choose the CORRECT OPTION from below list
(1)Hbase
(2)ORACLE
(3)MYSQL
(4)None of the options

Answer:-(3)MySQL

19.

_____________ are the communication and retention mechanism that manage event delivery.

Answer»

_____________ are the COMMUNICATION and RETENTION mechanism that MANAGE event delivery.
Choose the correct option from below list
(1)Sink
(2)Channel
(3)Source
(4)NONE of the options

Answer:-(2)Channel

20.

Flume agent is a kind of JVM process.

Answer»

Flume agent is a kind of JVM process.
Choose the CORRECT OPTION from below list
(1)TRUE
(2)False

Answer:-(1)True

21.

Sqoop will use a column to split. If that column not present then it will use primary key column.

Answer» SQOOP will use a COLUMN to SPLIT. If that column not present then it will use primary key column.
Choose the correct option from below list
(1)True
(2)False

Answer:-(1)True
22.

Flume uses a cross-platform operating system.

Answer»

Flume uses a cross-platform operating system.
Choose the correct OPTION from below LIST
(1)True
(2)False

Answer:-(1)True

23.

____________ removes the events from channels and stores it into an external repository like HDFS.

Answer»

____________ removes the events from CHANNELS and STORES it into an external repository like HDFS.
Choose the correct option from below list
(1)Source
(2)SINK
(3)Both of the OPTIONS
(4)None of the options

Answer:-(2)Sink

24.

_______ tag in action node signifies that you can make the transition to the next node.

Answer»

_______ tag in ACTION NODE signifies that you can make the transition to the next node.
Choose the correct OPTION from below list
(1)ERROR
(2)ok
(3)None of the options

Answer:-(2)ok

25.

__________ is a server-based workflow scheduling system to manage Hadoop jobs.

Answer»

__________ is a server-based workflow scheduling SYSTEM to manage Hadoop jobs.
Choose the correct option from below LIST
(1)Flume
(2)Sqoop
(3)Oozie
(4)None of the options

Answer:-(3)Oozie

26.

Which of the following directory will save the configuration details of Oozie?

Answer»

Which of the following DIRECTORY will save the configuration details of Oozie?
CHOOSE the correct OPTION from below list
(1)confg
(2)Configuration
(3)conf
(4)None of the options

Answer:-(3)conf

27.

Which of the following options are characteristics of Oozie?

Answer»

Which of the following OPTIONS are characteristics of Oozie?
Choose the correct option from below list
(1)schedule jobs as well as reschedule jobs on failure
(2)It simplifies workflow and COORDINATION between jobs
(3)Allows creating DAG of workflows
(4)All of the options

Answer:-(4)All of the options

28.

Which of the following options are the necessary steps regarding the configuration file?

Answer»

Which of the following options are the necessary steps regarding the configuration FILE?
Choose the correct option from below LIST
(1)Every SOURCE must have at least ONE channel
(2)The component type should be specified
(3)Every sink should have one channel
(4)All of the options

Answer:-(4)All of the options

29.

Flume offers buffer storage for real-time spikes.

Answer» FLUME offers BUFFER storage for real-time spikes.
Choose the CORRECT option from below list
(1)True
(2)False

Answer:-(1)True
30.

Oozie is still using a parameter called _______ to identify the YARN arguments as they are yet to create a new parameter for YARN itself.

Answer»

Oozie is still using a PARAMETER called _______ to identify the YARN arguments as they are YET to create a new parameter for YARN itself.
Choose the correct option from below list
(1)NameNode
(2)SECONDARY NameNode
(3)JobTracker
(4)All of the options

Answer:-(3)JobTracker

31.

____________ can be MapReduce jobs, Java/Pig application, Hive, etc.

Answer»

____________ can be MapReduce JOBS, Java/Pig application, Hive, etc.
Choose the correct OPTION from below list
(1)Action Nodes
(2)Control Flow NODE
(3)None of the options
(4)Both of the options

Answer:-(1)Action Nodes

32.

We use the reducer to write out the SQL import files in Sqoop.

Answer»

We use the reducer to WRITE out the SQL IMPORT files in Sqoop.
Choose the correct option from below list
(1)TRUE
(2)False

Answer:-(2)False

33.

How do we import large objects like BLOB and CLOB in Apache Sqoop?

Answer»

How do we import LARGE objects like BLOB and CLOB in Apache SQOOP?
In Apache Sqoop we can not import large objects like BLOB and CLOB as it is not supported by Apache Sqoop import commands. So WHENEVER you need to import this large objects like I Sqoop, JDBC based IMPORTS have to be used without the direct argument to the import utility.