Question-2: Which of the following is correct with regards to data read/write in/out Cassandra?

1. You can use COPY command to read csv data to Cassandra
2. You can use COPY command to write CSV data from Cassandra to a file system.
3. You can use DUMP command to write CSV data from Cassandra to a file system.
4. You can use sstableloader to bulk upload external data to Cassandra.
5. You can use COPY command to bulk upload external data to Cassandra.
6. You can use DUMP command to bulk upload external data to Cassandra.

Ans: A, B, D

Exp: We can use COPY command to read CSV data to DSE and write CSV data from DSE to a file system. Hence, option-1 and 2 both are correct.

Similarly, sstableloader provides the ability to bulk load external data into Cassandra Cluster. Hence, option-4 is also correct.

We do not have DUMP command. Hence, option 3 and 5 are wrong.