nerdexam
Oracle

1Z0-515 · Question #42

You are looking to size a data warehouse configuration. If the I/O throughput for the CPUs is 25 GB/s, the I/O throughput for the HBA is 18 GB/s, and the I/O throughput for the disk subsystem is 6…

The correct answer is C. 6 GB/s. In this scenario the disk subsystem is the bottleneck. It determines the throughput. Note: Each of the components must provide sufficient I/O bandwidth to ensure a well- balanced The end-to-end I/O system consists of more components than just the CPUs and disks. A well-balanced…

Introduction to Data Warehousing Concepts

Question

You are looking to size a data warehouse configuration. If the I/O throughput for the CPUs is 25 GB/s, the I/O throughput for the HBA is 18 GB/s, and the I/O throughput for the disk subsystem is 6 GB/s, what is the overall throughput of the data warehouse?

Options

  • A25 GB/s
  • B18 GB/s
  • C6 GB/s
  • DIt depends on how many processors are in the servers.

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    81% (22)
  • D
    11% (3)

Explanation

In this scenario the disk subsystem is the bottleneck. It determines the throughput. Note: Each of the components must provide sufficient I/O bandwidth to ensure a well- balanced The end-to-end I/O system consists of more components than just the CPUs and disks. A well-balanced I/O system must provide approximately the same bandwidth across all components in the I/O system. These components include: * Host bus adapters (HBAs), the connectors between the server and the * Switches, in between the servers and a storage area network (SAN) or network attached storage (NAS). * Ethernet adapters for network connectivity (GigE NIC or Infiniband). In an Oracle Real Application Clusters (Oracle RAC) environment, you need an additional private port for the interconnect between the nodes that you should not include when sizing the system for I/O throughput. The interconnect must be sized separately, taking into account factors such as internode parallel execution. * Wires that connect the individual components.

Topics

#I/O throughput#performance sizing#bottleneck analysis#disk subsystem

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice