nerdexam
Oracle

1Z0-515 · Question #8

You are looking to create a RAC cluster to deliver high performance for your client's data warehouse. Which statement is true about a configuration with a few large nodes versus a configuration with…

The correct answer is C. It depends on the workload specifics and the effect of a node failure. Few large nodes or many small nodes? Number of nodes does not matter Record Breaking TPC-H numbers with Oracle Grid 4, 8 and 12-Node Grids Performance differences between Few-LargeNode and Many-Small-Node Many-Small-Node grids might require more interconnect bandwidth for…

Data Warehouse Architecture and Design

Question

You are looking to create a RAC cluster to deliver high performance for your client's data warehouse. Which statement is true about a configuration with a few large nodes versus a configuration with many smaller nodes?

Options

  • AA few large nodes always perform better than many small nodes.
  • BA few large nodes always perform worse than many small nodes.
  • CIt depends on the workload specifics and the effect of a node failure.
  • DPerformance should be the same with either option.

How the community answered

(48 responses)
  • A
    4% (2)
  • B
    4% (2)
  • C
    77% (37)
  • D
    15% (7)

Explanation

Few large nodes or many small nodes? * Number of nodes does not matter * Record Breaking TPC-H numbers with Oracle Grid 4, 8 and 12-Node Grids * Performance differences between Few-LargeNode and Many-Small-Node * Many-Small-Node grids might require more interconnect bandwidth for parallel operations

Topics

#RAC#data warehouse performance#node configuration#workload analysis

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice