What are the actions of the mergeout task? (Select three.)
A.
Mergeout rewrites all ROS containers.
B.
Mergeout writes data to memory.
C.
Mergeout consolidates containers on disk.
D.
Mergeout places data into all defined projections on the source table.
E.
Mergeout purges deleted data already on disk.
F.
Mergeout moves data from memory to disk.
Explanation:
https://my.vertica.com/docs/6.1.x/HTML/index.htm#2624.htm#o14826
I agree with C and E. Option D looks quite not correct as for my personal taste, but the only another possible option here is A.
As far as I know, and I also mentioned it under Q19, none of Tuple Mover operations rewrites all containers.
On the other hand we have the following definition for ROS:
—————————————————————————————————————————————-
The Read Optimized Store (ROS) is a highly optimized, read-oriented, disk storage structure, organized by projection.
—————————————————————————————————————————————-
So, finally we have ะก, D, E as it is marked above.
0
0
C and E are exactly correct.
Option D is looking like “REFRESH” operation.
Another candidate is A but as you said tm operations never rewrites. IDK what the exact answer is
0
0