35 + Interview Questions in Apache Phoenix in BigData Page 1 InterviewSolution

1.	Data lake uses flat architecture to store data.
Answer» DATA LAKE uses FLAT architecture to STORE data. Choose the correct OPTION from below list (1)False (2)True Answer:-(2)True

Discussion

2.	What algorithm does MapReduce programming use?
Answer» What ALGORITHM does MapReduce programming use? CHOOSE the correct option from below LIST (1)REDUCE (2)Map (3)All the above options Answer:-(3)All the above options

Discussion

3.	Which of the following is the HBase transaction manager?
Answer» Which of the FOLLOWING is the HBASE transaction manager? Choose the CORRECT option from below list (1)APACHE Hive (2)Apache TEPHRA (3)None of the options Answer:-(2)Apache Tephra

Discussion

4.	Big data sources produce a large volume of data.
Answer» Big DATA sources PRODUCE a large VOLUME of data. Choose the correct option from below list (1)FALSE (2)True Answer:-(2)True

Discussion

5.	___________ ensures that database modifications are not performed as an incomplete state transition in case of a failure.
Answer» ___________ ENSURES that database modifications are not performed as an incomplete STATE transition in case of a failure. Choose the CORRECT option from below list (1)Durability (2)CONSISTENCY (3)Atomicity (4)None of the options Answer:-(2)Consistency

Discussion

6.	__________ ensures that transaction modifications are stored forever to the database, and do not fade or get deleted even if the database crashes.
Answer» __________ ensures that transaction modifications are STORED forever to the DATABASE, and do not fade or get DELETED even if the database crashes. Choose the correct option from below list (1)CONSISTENCY (2)Durability (3)ISOLATION (4)Atomicity Answer:-(2)Durability

Discussion

7.	A transaction primarily refers to modifications performed in a database in a logical line.
Answer» A transaction primarily REFERS to MODIFICATIONS performed in a database in a logical line. Choose the correct option from below list (1)True (2)False Answer:-(1)True

Discussion

8.	Isolation allows multiple transactions to run independently of each another.
Answer» Isolation allows multiple transactions to run independently of each another. Choose the CORRECT OPTION from below list (1)TRUE (2)False Answer:-(1)True

Discussion

9.	Salesforce.com developed Apache Phoenix.
Answer» Salesforce.com DEVELOPED Apache Phoenix. Choose the correct OPTION from below list (1)FALSE (2)True Answer:-(2)True

Discussion

10.	In which of the following is Spark implemented?
Answer» In which of the FOLLOWING is Spark implemented? Choose the correct option from below list (1)SCALA (2)Ruby (3)JAVA (4)Python Answer:-(1)Scala

Discussion

11.	For HBase, what type of skin is Apache Phoenix?
Answer» For HBASE, what type of skin is APACHE Phoenix? Choose the correct option from below list (1)NONE of the options (2)NoSQL (3)SQL Answer:-(3)SQL

Discussion

12.	Which of the following can run on top of Hadoop?
Answer» Which of the following can RUN on TOP of Hadoop? Choose the correct option from below list (1)All the above OPTIONS (2)Hbase (3)Hive (4)Phoenix Answer:-(1)All the above options

Discussion

13.	Which of the following is an open source processing engine built for large scale processing of data?
Answer» Which of the following is an open source processing engine built for large scale processing of data? Choose the correct option from below list (1)None of the OPTIONS (2)APACHE Hbase (3)Apache Spark (4)Apache Hive Answer:-(3)Apache Spark

Discussion

14.	Transactions are an inevitable component of relational databases.
Answer» Transactions are an INEVITABLE COMPONENT of RELATIONAL databases. Choose the CORRECT option from below list (1)False (2)True Answer:-(2)True

Discussion

15.	Which of the following statements about Hadoop are false?
Answer» Which of the FOLLOWING STATEMENTS about HADOOP are FALSE? Choose the correct option from below LIST (1)Hadoop is a distributed framework (2)The main algorithm used in Hadoop is MapReduce (3)Hadoop runs with commodity hardware (4)None of the above options Answer:-(4)None of the above options

Discussion

16.	PhoenixHiveHandler is used to read data from Phoenix in Hive.
Answer» PhoenixHiveHandler is used to read data from PHOENIX in Hive. Choose the CORRECT option from below list (1)True (2)False Answer:-(1)True

Discussion

17.	HBase enables transaction support by utilizing Apache Tephra as its transaction manager.
Answer» HBase ENABLES transaction SUPPORT by utilizing Apache Tephra as its transaction manager. Choose the correct OPTION from below list (1)False (2)True Answer:-(2)True

Discussion

18.	A transaction manager is easy and swift, keeps all necessary states in memory, and endures all states to a _________.
Answer» A transaction manager is EASY and swift, KEEPS all necessary states in memory, and ENDURES all states to a _________. Choose the correct option from below LIST (1)None of the options (2)System-LOG (3)write-ahead log (4)All of the options Answer:-(3)write-ahead log

Discussion

19.	________ is a transactional engine for shared stores like HBase that enables enables multi-versioning and rollback.
Answer» ________ is a TRANSACTIONAL ENGINE for shared stores LIKE HBase that enables enables multi versioning and rollback. Choose the correct option from below LIST (1)Apache Hive (2)Apache Hbase (3)Apache Storm (4)Apache Tephra Answer:-(4)Apache Tephra

Discussion

20.	HBase is an open source implementation of Google's Bigtable.
Answer» HBASE is an open source IMPLEMENTATION of GOOGLES Bigtable. Choose the correct option from below list (1)False (2)True Answer:-(2)True

Discussion

21.	The Apache Phoenix framework provides both server and client libraries.
Answer» The APACHE Phoenix framework provides both server and CLIENT libraries. Choose the correct option from below list (1)False (2)TRUE Answer:-(2)True

Discussion

22.	A data lake stores a vast amount of data (like water in a natural lake).
Answer» A data lake STORES a VAST amount of data (like WATER in a natural lake). Choose the correct option from below list (1)False (2)TRUE Answer:-(2)True

Discussion

23.	Tephra enables ________ with the aid of conflict detection and multi-version control.
Answer» Tephra ENABLES ________ with the aid of CONFLICT DETECTION and multi-version control. Choose the correct option from below list (1)Pessimistic control (2)None of the options (3)Optimistic control Answer:-(3)Optimistic control

Discussion

24.	Big data includes both structured and unstructured data.
Answer» Big data includes both structured and unstructured data. Choose the CORRECT OPTION from below list (1)True (2)False Answer:-(1)True

Discussion

25.	The NOT NULL constraint makes a column to NOT take NULL values.
Answer» The NOT NULL constraint makes a COLUMN to NOT take NULL values. Choose the CORRECT option from below list (1)True (2)False Answer:-(1)True

Discussion

26.	Apache Phoenix is developed by __________________.
Answer» Apache PHOENIX is developed by __________________. CHOOSE the CORRECT option from below list (1)Facebook (2)ORACLE (3)Salesforce.com (4)Yahoo Answer:-(3)Salesforce.com

Discussion

27.	______ allows multiple transactions to run independently of each another.
Answer» ______ ALLOWS multiple TRANSACTIONS to RUN INDEPENDENTLY of each another. Choose the correct option from below list (1)Consistency (2)Atomicity (3)Isolation (4)Durability Answer:-(3)Isolation

Discussion

28.	Apache Phoenix supports array type only.
Answer» Apache PHOENIX SUPPORTS ARRAY type only. Choose the correct option from below LIST (1)False (2)True Answer:-(2)True

Discussion

29.	Transaction Manager manages and monitors transactions. It is also called Transaction Monitor.
Answer» TRANSACTION MANAGER manages and monitors transactions. It is ALSO called Transaction Monitor. Choose the correct option from below LIST (1)True (2)False Answer:-(1)True

Discussion

30.	Transaction Managers are also called ___________.
Answer» Transaction MANAGERS are also called ___________. Choose the correct option from below list (1)Transaction MONITOR (2)SLAVES (3)NONE of the options Answer:-(1)Transaction Monitor

Discussion

31.	____________ assures all operations as a unit of work are performed at once
Answer» ____________ assures all operations as a unit of work are performed at once Choose the CORRECT OPTION from below list (1)actors (2)Durability (3)MASTERS (4)Atomicity Answer:-(4)Atomicity

Discussion

32.	Apache Phoenix transforms standard JDBC APIs to native HBase calls to create tables, insert data, and query HBase data.
Answer» Apache Phoenix transforms standard JDBC APIS to native HBASE CALLS to create tables, INSERT data, and query HBase data. Choose the correct option from below list (1)False (2)True Answer:-(2)True

Discussion

33.	Apache Tephra is a transactional engine for shared stores like HBase that gives assistance of multi-versioning and rollback.
Answer» Apache TEPHRA is a transactional engine for SHARED stores like HBase that gives assistance of multi versioning and rollback. Choose the correct option from below LIST (1)True (2)False Answer:-(1)True

Discussion

34.	Apache Phoenix does not support array type.
Answer» APACHE PHOENIX does not support array type. Choose the CORRECT option from below list (1)False (2)True Answer:-(1)False

Discussion

35.	Which of the following command is used to invoke the Phoenix shell?
Answer» Which of the following command is used to INVOKE the Phoenix shell? Choose the correct option from below LIST (1)./sqlline.py localhost (2)./sql-line.py localhost (3)./sqlline.sh localhost (4)NONE of the options Answer:-(2)./sql-line.py localhost

Discussion

Explore topic-wise InterviewSolutions in .

Data lake uses flat architecture to store data.

What algorithm does MapReduce programming use?

Which of the following is the HBase transaction manager?

Big data sources produce a large volume of data.

___________ ensures that database modifications are not performed as an incomplete state transition in case of a failure.

__________ ensures that transaction modifications are stored forever to the database, and do not fade or get deleted even if the database crashes.

A transaction primarily refers to modifications performed in a database in a logical line.

Isolation allows multiple transactions to run independently of each another.

Salesforce.com developed Apache Phoenix.

In which of the following is Spark implemented?

For HBase, what type of skin is Apache Phoenix?

Which of the following can run on top of Hadoop?

Which of the following is an open source processing engine built for large scale processing of data?

Transactions are an inevitable component of relational databases.

Which of the following statements about Hadoop are false?

PhoenixHiveHandler is used to read data from Phoenix in Hive.

HBase enables transaction support by utilizing Apache Tephra as its transaction manager.

A transaction manager is easy and swift, keeps all necessary states in memory, and endures all states to a _________.

________ is a transactional engine for shared stores like HBase that enables enables multi-versioning and rollback.

HBase is an open source implementation of Google's Bigtable.

The Apache Phoenix framework provides both server and client libraries.

A data lake stores a vast amount of data (like water in a natural lake).

Tephra enables ________ with the aid of conflict detection and multi-version control.

Big data includes both structured and unstructured data.

The NOT NULL constraint makes a column to NOT take NULL values.

Apache Phoenix is developed by __________________.

______ allows multiple transactions to run independently of each another.

Apache Phoenix supports array type only.

Transaction Manager manages and monitors transactions. It is also called Transaction Monitor.

Transaction Managers are also called ___________.

____________ assures all operations as a unit of work are performed at once

Apache Phoenix transforms standard JDBC APIs to native HBase calls to create tables, insert data, and query HBase data.

Apache Tephra is a transactional engine for shared stores like HBase that gives assistance of multi-versioning and rollback.

Apache Phoenix does not support array type.

Which of the following command is used to invoke the Phoenix shell?