Apache Cassandra Developer Associate: Exam Practice Tests by Cristian Scutaru

Author:Cristian Scutaru [Scutaru, Cristian]
Language: eng
Format: azw3, mobi, epub
Published: 2021-01-14T00:00:00+00:00

UPDATE Countries SET city='Miami' WHERE country='USA' AND state='Florida';

A) The query fails, because the table is empty and there is no such row.

B) The query does nothing but does not complain.

C) The query returns a message that the row is not found.

D) A row is inserted anyway, with all those values.

Question 7:

Which is NOT an operation that happens during compaction ? (select one)

A) Rows from older SSTables are written in a new SSTable on disk.

B) For rows with the same primary key, only the most recent change is kept.

C) All tombstones are immediately removed.

D) Older SSTables are deleted at the end.

Question 8:

What is wrong with the SELECT query? (select one)

CREATE TABLE Countries (

country text,

state text,

city text,

area text,

population int,

PRIMARY KEY ((country, state), city, area)

);

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.