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.

COPY keyspace_name.tab_name FROM STDIN

Answer»

COPY keyspace_name.tab_name FROM STDIN
Choose the correct OPTION from below LIST
(1)copies DATA from i/o devices to table
(2)none
(3)copies data to an output devices
(4)Command is wrong

Answer:-(1)copies data from i/o devices to table

2.

What is the optimum number of concurrent_reads per processor core?

Answer»

What is the optimum NUMBER of concurrent_reads PER processor core?
Choose the correct OPTION from below list
(1)1
(2)5
(3)4
(4)8

Answer:-(3)4

3.

Which among the following can be used as COPY option

Answer»

Which among the following can be USED as COPY option
Choose the correct option from below list
(1)All the options
(2)QUOTE
(3)HEADER
(4)NULL
(5)DELIMITER

Answer:-(1)All the options

4.

Is there any relation between the directory that hold sstables and the name of the Choose the correct option from below list

Answer»

Is there any relation between the directory that HOLD sstables and the name of the Choose the CORRECT option from below list
(1)keyspace of the sstable
(2)There is no SPECIFIC rules
(3)none
(4)Both names can be different
(5)Both name has to be same

Answer:-(5)Both name has to be same

5.

Key Cassandra metrics that are important in Performance monitoring

Answer»

Key CASSANDRA METRICS that are IMPORTANT in Performance monitoring
Choose the correct option from below list
(1)Heap Size
(2)Garbage Collection
(3)All the options
(4)Disk Usage
(5)Latency

Answer:-(3)All the options

6.

What is the biggest perrformance gain in cassandra write operations?

Answer»

What is the biggest perrformance gain in cassandra write operations?
Choose the correct option from below list
(1)commit LOG in a same disk
(2)SHARE same drive
(3)no drive REQUIRED
(4)commit log in a separate disk

Answer:-(4)commit log in a separate disk

7.

What is the optimum number of concurrent_reads per processor core ?

Answer»

What is the optimum number of concurrent_reads PER PROCESSOR CORE ?
Choose the correct OPTION from below list
(1)8
(2)1
(3)5
(4)4

Answer:-(4)4

8.

What kind of files can be imported or exported using the COPY command

Answer»

What KIND of FILES can be imported or exported using the COPY command
Choose the correct option from below list
(1)sstables
(2)CSV
(3)json
(4)parquet

Answer:-(2)CSV

9.

What can also be attributed as wide-row in apache Cassandra

Answer»

What can also be ATTRIBUTED as wide-row in APACHE Cassandra
Choose the CORRECT option from below list
(1)Clustering Key
(2)Compound Key
(3)FOREIGN Key
(4)Primary Key

Answer:-(2)Compound Key

10.

Which among the following is a high-level goals of your Data-Model?

Answer»

Which among the FOLLOWING is a high-level goals of your Data-Model?
CHOOSE the correct option from below list
(1)None of the OPTIONS
(2)minimizing the number of writes
(3)minimizing the number of data-duplication
(4)SPREAD data evenly around the cluster

Answer:-(4)spread data evenly around the cluster

11.

Using sstableloader external data cannot be loaded into the cluster

Answer» USING sstableloader external DATA cannot be LOADED into the cluster
Choose the CORRECT option from below list
(1)False
(2)True

Answer:-(1)False
12.

Which is the least verbose logging level in cassandra

Answer»

Which is the least verbose logging level in cassandra
Choose the CORRECT option from below list
(1)DEBUG
(2)ERROR
(3)TRACE
(4)fatal

Answer:-(3)trace

13.

When do you have to avoid using secondary indexes

Answer»

When do you have to AVOID using SECONDARY indexes
Choose the correct option from below list
(1)On columns containing high COUNT of unique values
(2)Use secondary index on as many columns
(3)On columns containing less count of unique values
(4)can use it on any columns without EFFECTING performance

Answer:-(1)On columns containing high count of unique values

14.

What is the best method to store row data in a sorted order ?

Answer»

What is the best method to store row data in a sorted ORDER ?
Choose the correct option from below list
(1)USE a CLUSTERING key
(2)MINIMIZE the number of partions.
(3)PARTITION
(4)use a primary key

Answer:-(1)use a clustering key

15.

COPY command can be used to read data

Answer»

COPY command can be USED to read data
Choose the correct option from below list
(1)All the options
(2)From std i/o devices
(3)From csv to table
(4)From table back to csv

Answer:-(1)All the options

16.

What is the default Partitioner in apache Cassandra cluster

Answer»

What is the DEFAULT PARTITIONER in apache CASSANDRA cluster
Choose the correct OPTION from below list
(1)RandomPartitioner
(2)HashPartitioner
(3)ByteOrderedPartitioner
(4)Murmur3Partitioner

Answer:-(4)Murmur3Partitioner

17.

What is sstableloader

Answer»

What is sstableloader
sstableloader is a tool that streams them to a LIVE CLUSTER, given a set of SSTABLE data FILES as INPUT.

18.

Which among the following is undesirable in a relational data model, but not in Cassandra?

Answer»

Which among the FOLLOWING is UNDESIRABLE in a relational DATA model, but not in Cassandra?
Choose the correct option from below list
(1)UNDERSTANDING
(2)Rigorous
(3)Denormalization
(4)Normalization

Answer:-(3)Denormalization

19.

What is key that dictates how the rows are ordered on reads?

Answer»

What is key that dictates how the rows are ORDERED on reads?
Choose the correct OPTION from below list
(1)Comparator
(2)POSITION and size
(3)Size or length
(4)SHAPES

Answer:-(4)Shapes

20.

In cassandra consistency is achieved through consistency tuning mechanisms

Answer»

In cassandra consistency is achieved through consistency tuning mechanisms
Choose the correct OPTION from below LIST
(1)True
(2)False

Answer:-(1)True

21.

Which among the following is not a performance measurement tool

Answer»

Which AMONG the following is not a PERFORMANCE measurement tool
Choose the correct option from below list
(1)iostat
(2)NONE
(3)cmstat
(4)dstat

Answer:-(2)None

22.

What is the default log level used by Log4J in cassandra

Answer»

What is the default log level used by Log4J in cassandra
Choose the correct option from below list
(1)WARN
(2)INFO
(3)DEBUG
(4)ERROR

Answer:-(2)INFO

23.

What is the technique used to break through the 2 billion column limit?

Answer»

What is the technique used to break through the 2 billion COLUMN LIMIT?
Choose the correct option from below LIST
(1)SORTING
(2)BUCKETING
(3)Closure.
(4)Re-Ordering.

Answer:-(1)Sorting

24.

Which among the following is undesirable in a relational data model, but not in Cassandra

Answer»

Which among the following is undesirable in a RELATIONAL data model, but not in Cassandra?
CHOOSE the correct option from below list
(1)Normalization
(2)UNDERSTANDING
(3)Denormalization
(4)Rigorous

Answer:-(3)Denormalization

25.

What is Replication Factor in Cassandra?

Answer»

What is Replication FACTOR in Cassandra?
Choose the correct option from below list
(1)unique element
(2)Box plot
(3)NUMBER of data COPIES existing
(4)number of PRIMARY key

Answer:-(3)number of data copies existing

26.

In which of the following scenarios can we use 'Wide rows'?

Answer»

In which of the FOLLOWING scenarios can we use 'Wide rows'?
Choose the CORRECT option from below list
(1)Ordering
(2)Efficient filtering
(3)GROUPING
(4)All the options

Answer:-(4)All the options

27.

Tool that streams sstables to a live cluster

Answer»

Tool that streams sstables to a live cluster
Choose the CORRECT option from below list
(1)LOADER
(2)sstableloader
(3)TableLoader
(4)sstabletreamer

Answer:-(2)sstableloader

28.

It is wise to use secondary indexes on the columns you want to be querying on has few unique values

Answer»

It is wise to use secondary INDEXES on the columns you want to be querying on has few unique values
Choose the CORRECT option from below list
(1)True
(2)False

Answer:-(1)True

29.

Thrift API is used either to read or write data from Cassandra

Answer» THRIFT API is used either to READ or write data from Cassandra
Choose the correct OPTION from below two
(1)TRUE
(2)False

Answer:-(1)True
30.

What is the use of Source Command in Cassandra?

Answer»

What is the use of SOURCE Command in CASSANDRA?
CHOOSE the CORRECT option from below list
(1)debug a file
(2)compile a file
(3)execute a file
(4)run a file

Answer:-(3)execute a file

31.

Which among the following is possible in cassandra-Spark combination and not delivered as a feature of cassandra alone

Answer»

Which AMONG the following is possible in cassandra-Spark COMBINATION and not delivered as a feature of cassandra alone
Choose the CORRECT option from below list
(1)Union
(2)outside data integration
(3)All the options
(4)Joins

Answer:-(3)All the options

32.

____________ is used to connect Spark and Cassandra

Answer»

____________ is used to connect SPARK and CASSANDRA
Choose the correct option from below list
(1)cassandra combiner
(2)Cassandra CONNECTOR
(3)Spark connector
(4)Spark combiner

Answer:-(3)Spark connector

33.

Select the best advantage of Analytics with cassandra?

Answer»

Select the best advantage of Analytics with cassandra?
Choose the CORRECT option from below LIST
(1)partition key
(2)Fraud DETECTION
(3)Position and SIZE
(4)Data organisation

Answer:-(2)Fraud detection

34.

COPY FROM is used to import datasets that have less than

Answer»

COPY FROM is used to import datasets that have less than
Choose the correct OPTION from below LIST
(1)1 MILLION rows
(2)2 million rows
(3)SEVERAL thousand rows
(4)8 million rows

Answer:-(2)2 million rows

35.

Real-time data ingestion in Cassandra can be done using

Answer»

Real-time data ingestion in CASSANDRA can be DONE using
Choose the correct option from below LIST
(1)Kafka
(2)none
(3)both SPARK and Kafka
(4)Spark

Answer:-(3)both Spark and Kafka

36.

Cassandra supports which of the below API's to retrieve and manipulate data

Answer»

Cassandra supports which of the below API's to retrieve and manipulate data
Choose the correct option from below LIST
(1)Client API
(2)All the OPTIONS
(3)THRIFT API
(4)Avro

Answer:-(2)All the options