Datastax Cassandra Administrator Certification Questions and Answer (Pratice Questions and Dumps)

Question-: For which of the below Cassandra stress test tool can be used?
A. Determining the schema performance.
B. Understanding the database scaling
C. For optimizing the data model settings
D. Determining the production capacity.


Answer: A,B,C,D

Explanation: Cassandra stress tool is a Java utility which can be used for benchmarking and testing the Cassandra cluster setup. Specifically, Data Modeling. And help in finding the issues with the Data modeling. We can use this tool for stress test the following
A. Determining the schema performance.
B. Understanding the database scaling
C. For optimizing the data model settings
D. Determining the production capacity.

Admin only


Question-: Please map the following nodetool subcommands and their usage

A. Nodetool compact
B. Nodetool compactionstats
C. Nodetool cleanup
D. Nodetool flush

1. It forces a major compaction on one or more nodes
2. You can get the statistics for the compaction
3. Access Mostly Uused Products by 50000+ Subscribers
4. It flushes the one or more tables from the memtable.

Answer: A-1,B-2,C-3,D-4

Explanation: Nodetool compact: It forces a major compaction on one or more nodes
Nodetool compactionstats : You can get the statistics for the compaction
Nodetool cleanup : Removes the keyspace and partition key no longer belonging to a node.
Nodetool flush: It flushes the one or more tables from the memtable.

Amin only



Question-: Which of the following are all node subcommands?
A. gcstats
B. gossipinfo
C. ring
D. tpstats
E. node

Answer: A,B,C,D

Explanation: Following are the detail for given command

gcstats : It prints the garbage collection statistics

gossipinfo : Provides the gossip information for the cluster

ring: It displays the status and information about the ring as determined by the node being queried. And using that information you can get the idea of the load balance and if any nodes are down. Wrongly configured nodes can show different rings. It tells you about he node’s address, its datacenter, its rack (or availability zone in case of EC2), Node is up or down.
This also shows the amount of data it is owning, but please note that when it says if it owns 100% of data and in your cluster you have replication factor as 3. It means 100/3% of data is owned by this node.

tpstats : It reports the each Cassandra stage by thread pool for example as below
- The number of active threads
- The number of pending requests waiting to be executed by the this thread pool.
- Number of task completed by thread pool.
- Number of Blocked requests

gossipinfo: It is for getting the details about the gossip in the cluster.

Admin only

Related Questions

---

Question-: Which of the following are correct statement for the sstableloader command?
A. This Tool help in loading the external data to an existing cluster.
B. This tool help in loading the existing SSTable to the cluster.
C. When you load the data from SSTable then previous cluster and new cluster should have the same number of nodes.
D. Loading the data using this tool required that previous cluster and new cluster have same application strategy or partitioner.


Question-: You have many csv files with almost million records across all the files , there is a one column in the csv file which has a date data in it. But before loading the csv file you want to change the format of date column. Which of the following is most suitable solution for this requirement?
A. You would be using CQL copy command
B. You would be using sstableloader
C. You would be using DSBulk tool
D. You would be using spark



Question-: Which of the following statement are correct for the DSBulk tool?
A. This can be used to export data from Casandra database.
B. This can be used how to load JSON file in database.
C. This can be used to load csv file in database
D. This can be used to rebalance Cassandra cluster.
E. This can be used to repartition Cassandra cluster.



Question-: In which of the following situation you would be using DSBulk tool?
A. If we have a lot of files which needs to be loaded in different tables then we should use DSBulk tool.
B. If you wanted to take the backup of data from the Cassandra cluster then we should use this tool.
C. If data model changes for our existing data and we wanted to move it to the new data model then you should use this tool.
D. While migrating data from one Cassandra database to another Cassandra database.
E. While converting JSON data to csv data.



Question-: To get the backup of the data you run the snapshot command; it would create a snapshot for the data which are in the as SSTable as well as in the memtable?
A. True
B. False


Question-: When you take up Snapshot for one of the SSTable on a particular node then it would not take a backup of the entire cluster?
A. True
B. False