Infosys Certified Cassandra Administrator
Practice with real exam-pattern questions for Infosys Certified Cassandra Administrator. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Cassandra Administrator practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Cassandra Administrator certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
The obselete data which is deleted is written to
- ✓
Compression offset
Correct - B
Tombstone
- C
TTL
- D
Temporary cache
- ✓
- Question 2
Identify for which of the following tasks sstableloader is used?
(i) To Bulk load external data into a cluster
(ii) To Restore Snapshots
(iii) For Loading existing SSTables into another cluster with different properties
- ✓
Only (ii) and (iii)
Correct - B
Only (i) and (ii)
- C
Only (i) and (iii)
- D
All (i), (ii) and (iii)
- ✓
- Question 3
Below is the list of user accounts in RUBY keyspace with different set of privileges
Rachel has left the organization, and as per security policies the DBA revokes all permissions provided to RACHEL user account and drops the user.
Which of the following statement is TRUE regarding the privileges owned by ROSS and MONICA after Rachel’s account is deleted?
- ✓
ROSS will be able to create on all keyspaces and MONICA will be able to modify keyspace ruby
Correct - B
ROSS will be able to create on all keyspaces and MONICA will not be able to modify keyspace ruby
- C
ROSS will not be able to create on all keyspaces and MONICA will be able to modify keyspace ruby
- D
ROSS will not be able to create on all keyspaces and MONICA will not be able to modify keyspace ruby
- ✓
- Question 4
Which of the following consistency property is provided when the READ REPAIR option is set to BLOCKING?
(i) Monotonic Quorum Reads
(ii) Write Atomicity
- ✓
Only (i)
Correct - B
Only (ii)
- C
Both (i) and (ii)
- D
Neither (i) nor (ii)
- ✓
- Question 5
Which of the following decides the distribution of data in a cluster ?
- ✓
Snitch
Correct - B
Partitioner
- C
Replication Strategy
- D
Commit logs
- ✓
- Question 6
In which of the following conditions, incremental repair can be used?
- ✓
When there is syncing up of missed writes to a node in a cluster
Correct - B
When the disk is corrupted
- C
When there is a data loss through operator error
- D
When there are bugs in Cassandra which result in inconsistency of data in nodes
- ✓
- Question 7
In order to execute the following statement, authorizer parameter in cassandra.yaml must be set to
cqlsh> LIST ALL PERMISSIONS OF USER;
- ✓
AllowAllAuthorizer
Correct - B
NodetoolAuthorizer
- C
PasswordAuthorizer
- D
CassandraAuthorizer
- ✓
- Question 8
In order to disable automatic creation of snapshots before compaction which of the following option should be set to false ?
- ✓
auto_reflex_snapshot
Correct - B
snapshot_before_compaction
- C
auto_snapshot
- D
self_active_snapshot
- ✓
- Question 9
Consider the below table with primary key as (EMPNO, CONTACTNO) and its content,
Identify which of the following update queries will execute successfully?
(i) cqlsh > UPDATE GEC1.EMP SET CONTACTNO=7653486123 WHERE EMPNO=102985;
(ii) cqlsh > UPDATE GEC1.EMP SET NAME=’JimAntony’ WHERE EMPNO=102983;
(iii) cqlsh > UPDATE GEC1.EMP SET NAME=’TOM’ WHERE EMPNO=102986 and contactno= 7653486165;
- ✓
Both (i) and (ii)
Correct - B
Only (ii)
- C
Only (iii)
- D
Both (ii) and (iii)
- ✓
- Question 10
Consider the below table with primary key as (EMPNO, CONTACTNO) and its content,
Identify which of the following delete statements are executed successfully?
(i) cqlsh > DELETE FROM GEC1.EMP WHERE EMPNO=102985;
(ii) cqlsh > DELETE NAME, CONTACTNO FROM GEC1.EMP WHERE EMPNO=102986;
(iii) cqlsh > DELETE NAME FROM GEC1.EMP WHERE EMPNO=102984;
(iv) cqlsh > DELETE NAME FROM GEC1.EMP WHERE EMPNO=102983 and CONTACTNO=8467234836;
- ✓
All (i), (ii), (iii) and (iv)
Correct - B
Only (i), (iii), (iv)
- C
Only (i), (ii), (iii)
- D
Only (i) and (iv)
- E
Only (ii) and (iii)
- ✓
More in IMS Academy
Infosys Certified WebSphere Application Server 8.5 Administrator
Infosys Certified Windows 11 Administrator - Associate
Infosys Certified Windows Server 2022 Administrator – Associate
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.