fbpx

A Short Teradata Quiz for You

By Roland Wenzlofsky

October 26, 2015


A Short Teradata Quiz for You 1

Here is a short Teradata Quiz for you. I hope you like it.

 

 

[mlw_quizmaster quiz=1]
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"62516":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"62516":{"val":"var(--tcb-skin-color-0)"}},"gradients":[]},"original":{"colors":{"62516":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b4fbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"b4fbe":{"val":"rgb(241, 99, 52)"}},"gradients":[]},"original":{"colors":{"b4fbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Previous Article
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b4fbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"b4fbe":{"val":"rgb(241, 99, 52)"}},"gradients":[]},"original":{"colors":{"b4fbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Next Article
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"62516":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"62516":{"val":"rgb(255, 0, 0)"}},"gradients":[]}}]}__CONFIG_colors_palette__
GET OUR TERADATA BOOK

Roland Wenzlofsky

Roland Wenzlofsky is an experienced freelance Teradata Consultant & Performance Trainer. Born in Austria's capital Vienna, he is building and tuning some of the largest Teradata Data Warehouses in the European financial and telecommunication sectors for more than 20 years. He has played all the roles of developer, designer, business analyst, and project manager. Therefore, he knows like no other the problems and obstacles that make many data warehouse projects fail and all the tricks and tips that will help you succeed.

  • 1)Which of the following is not stored in a sub table?
    Answer Provided: Join Index (JI).Row Partitioned Table.
    Correct Answer: Row Partitioned Table.

    comment: I am aware only the Secondary indexes in Teradata creates sub-table, but for the above question, why the JI stored in sub table, does this question meant that JI allows creation of SI over the JI or does it meant Join Index (JI) stores its join results in perm space.

    2) Which of these technical join types are available on Teradata?
    Answer Provided: Left Outer Join.
    Correct Answer: Hash Join.Merge Join.Sliding Window Merge Join.Product Join.

    Comment: Hash Join, Merge Join, Sliding Window Merge Join and Product Join are the join strategies determined by the optimizer based on the joining tables data distribution, so I have answered Left outer join is the Join Type, a user can decide based on his business need.

    3) Are tables without Primary Index (NOPI) always distributed evenly across all AMPs?
    Answer Provided: Yes
    Correct Answer: No

    Comment: Could you explain to me why the NOPI tables not always evenly distributed across all AMPs.

    Kindly advise me on how to approach the above questions.

    Thanks,

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    You might also like

    >