adplus-dvertising
frame-decoration

Question

Which of the following architecture can be described as a shared-nothing architecture that is more concerned with disk access than memory access?

a.

Clusters

b.

SMP (Symmetric Multiprocessing)

c.

MPP (Massively Parallel Processing)

d.

NUMA (Cache-Coherent Nonuniform Memory Architecture)

Answer: (c).MPP (Massively Parallel Processing) Explanation:The described architecture is MPP (Massively Parallel Processing).

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which of the following architecture can be described as a shared-nothing architecture that is more concerned with disk access than memory access?

Similar Questions

Discover Related MCQs

Q. Which benefit is associated with the MPP (Massively Parallel Processing) architecture?

Q. Which architecture is the newest and developed in the 1990s, breaking a big SMP into smaller SMPs that are easier to build?

Q. What does NUMA stand for in NUMA architecture?

Q. What benefit is associated with NUMA architecture?

Q. Which option can be described as a more aggressive approach, involving a NUMA machine consisting of one or two SMP nodes?

Q. Which type of indexing can be very effective in a data warehouse environment when indexing on fields with a smaller number of distinct values?

Q. Which database software feature has been enhanced to assist in bulk refreshes and incremental loading of the data warehouse?

Q. What two features are critical in a data warehouse, and the DBMS vendors have provided parallel processing to improve them?

Q. Which of the following operations can be parallelized by most current database software in a multi-processor environment?

Q. What is the responsibility of the query dispatcher software in a database system that uses parallel processing?

Q. In the context of database processing, what does "interquery parallelization" refer to?

Q. What is a limitation of interquery parallelization in database systems?

Q. What is the main advantage of intraquery parallelization in a database system?

Q. How does intraquery parallelization work in a database system?

Q. In the context of intraquery parallelization, what is meant by "the consolidation of intermediary results"?

Q. What is horizontal parallelism in the context of database processing?

Q. What is a limitation of horizontal parallelism in database processing?

Q. How does vertical parallelism differ from horizontal parallelism in database processing?

Q. What is the key advantage of the hybrid method in database processing?

Q. When selecting a DBMS for a data warehouse, which of the following is NOT a crucial feature to consider?