Data Science

What is the primary purpose of OLTP systems?

• Data analysis and reporting

• Transaction processing and day-to-day operations

• • Generating complex queries for analysis

  
  

• Storing historical data

Which of the following is typically a characteristic of OLAP systems?

• • Frequent updates to data

  
  

• • High volume of small transactions

  
  

• Historical and consolidated data

• Limited data analysis capability

OLTP is most often used in which type of applications?

• 
  

• Data warehousing

• Real-time business applications like banking and retail

• Business intelligence

• Predictive analytics

In an OLAP system, data is organized in a ________ format for analysis.

• Flat

• Relational

• • Multidimensional

  
  

• Key-value

Which type of system typically supports data warehousing?

• OLAP

• OLTP

• Both OLAP and OLTP

• • Neither OLAP nor OLTP

  
  

Which of the following is a key feature of OLTP systems?

• Complex queries

• Large data storage

• High availability and quick response time

• Historical data storage

OLAP systems are primarily designed for which of the following?

• Processing transactions

• Managing daily operations

• Performing real-time data entry

• Running analytics and generating reports

What type of data is commonly used in OLTP systems?

• Summarized data

• Raw, real-time data

• Aggregated data

• Predictive data

How are OLAP queries typically structured?

• Simple, row-based queries

• Predefined to ensure transaction consistency

• Complex, multi-dimensional queries

• Optimized for write operations

Which of these is an example of OLTP usage?

• Product inventory checks during checkout

• Customer purchase pattern analysis

• Sales trend analysis over five years

• Daily revenue report generation