Skip to main content
Question

Characteristics of Vertica projections based on 9.1 and 9.2 version?

  • November 30, 2019
  • 3 replies
  • 18 views

hsaxena20
Forum|alt.badge.img+1

Select three characteristics of Vertica projections.
A
Each projection contains all rows from the anchor table.
A projection can contain a subset of columns from the anchor table.
A projection can contain data from one or more anchor tables.
B
A projection can contain a subset of rows from the anchor table.
Each projection contains all columns from the anchor table.
A projection can contain data from one or more anchor tables.
C
Each projection contains all columns from the anchor table.
A projection can contain data from one or more anchor tables.
Each projection contains all rows from the anchor table.
D
A projection can contain a subset of columns from the anchor table.
A projection can contain data from only one anchor table.
Each projection contains all rows from the anchor table.

3 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • December 5, 2019

Looks like a question off of the Vertica Certification Exam!


ersaurabhex
Forum|alt.badge.img+1
  • Participating Frequently
  • December 6, 2019

This question is available in Vertica academy > Projections course.
The answer is D in this case.. i.e.
1. A projection can contain a subset of columns from the anchor table.
2. A projection can contain data from only one anchor table.
3. Each projection contains all rows from the anchor table.
No question about first point.
From 9.2 onwards perspective pre-Join projections are not supported so good with second point as well.
The third point talks about all rows from the anchor table, but Top K projection does not contain all the rows from the table.


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • December 6, 2019

@ersaurabhex - Per you comments (in which I agree) the answer to the question is:

E. None of the above

I remember taking the exam back in 2011 and I questioned these types of questions. I found out the exam at that time was written by a non-technical person and that lead to the inconsistencies.