ITELEC4(PREMID-MIDTERM) QUIZ_032625

What does OLAP stand for?

• Online Analytical Processing
• Online Logical Application Processing
• Offline Analytical Processing
• Online Advanced Processing

What is the primary function of OLAP?

• Data storage
• Multidimensional data analysis
• Transaction processing
• Image processing

Which of the following is NOT an OLAP operation?

• Slice
• Drill-down
• Pivot
• Indexing

OLAP is primarily used in conjunction with which type of system?

• CRM systems
• Data warehouses
• Operating systems
• Cloud storage

Which OLAP type uses precomputed cubes for faster queries?

• MOLAP
• ROLAP
• HOLAP
• OLTP

What is the key advantage of MOLAP?

• Uses less storage
• Faster query performance
• Works directly with relational databases
• No need for multidimensional analysis

Which OLAP type works directly with relational databases?

• MOLAP
• ROLAP
• HOLAP
• SQL

What is a drawback of MOLAP?

• Slower query response
• High storage requirements
• No multidimensional support
• Inability to handle large datasets

Which OLAP type combines the advantages of both MOLAP and ROLAP?

• OLTP
• HOLAP
• MOLAP
• ROLAP

A bank using OLAP for fraud detection and loan risk assessment would likely use:

• MOLAP
• ROLAP
• HOLAP
• OLTP