MPP(Massive Parallel Process) — Learn free

Self-check

Questions 1–10 of 10

1. What does MPP stand for?
Question 1A. Multi-Process PipelineB. Massive Parallel ProcessingC. Managed Partition ProtocolD. Master Persistence PlatformE. Multiple Page Processing
2. How is a query executed in non-MPP mode?
Question 2A. Its different pieces of code run one by one in sequenceB. Its different pieces of code run in parallel on all processorsC. It is rejected unless it has a filterD. It is split across multiple locationsE. It is cached and never re-run
3. How much faster does MPP make query execution compared with one-by-one execution, according to *I Am Datapedia!*?
Question 3A. Twice as fastB. Ten times fasterC. A hundred times fasterD. A thousand times fasterE. It is no faster, only cheaper
4. For which operations is MPP mostly used?
Question 4A. Reading and writing, mostly inserts, in parallelB. Deleting and archiving dataC. Encrypting and decrypting dataD. Compressing backupsE. Rendering dashboards
5. Where may the multiple processors used by MPP be located?
Question 5A. Only within a single nodeB. Only in a single data centreC. In a single node or across multiple nodes, in the same location or multiple locationsD. Only in the cloudE. Only on a mainframe
6. Which older class of computer ran in MPP mode but was too expensive for the mass community?
Question 6A. Personal computersB. LaptopsC. TabletsD. Mainframe computersE. Mobile phones
7. Which organisation is said to have the biggest MPP architecture in place?
Question 7A. FacebookB. AmazonC. MicrosoftD. GoogleE. IBM
8. Why was Hadoop described as groundbreaking for MPP?
Question 8A. Because it was the first cloud serviceB. Because it produced canned reportsC. Because it replaced SQLD. Because it ran only on mainframesE. Because it was installable and usable on commodity hardware, even home laptops
9. What does elastic cloud computing allow when a user runs a query?
Question 9A. The query is queued until the next dayB. The query is limited to one processorC. The query is converted to MDXD. The query must be pre-approved by procurementE. Hundreds of nodes and processors can be spun up automatically within milliseconds if required
10. How long may a report or dashboard take before it is considered unacceptable in the current era?
Question 10A. More than 1 secondB. More than 3 to 5 secondsC. More than 30 secondsD. More than 5 minutesE. More than an hour