What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Click on the arrows to vote for the correct answer
A. B. C. D. E. F.BDF
B: Transactional data tends to be heavy writes, moderate reads.
D: Typical traits of transactional data include: schema on write, strongly enforced. The schema is defined in a database.
F: Transactional data tends to be highly normalized.
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processingOnline Transaction Processing (OLTP) is a type of workload that involves a high volume of small, transactional data updates. Here are the three characteristics of an OLTP workload:
Heavy writes and moderate reads: OLTP workloads typically involve a large number of write operations, where new data is added, updated or deleted. These transactions are typically short-lived and involve a relatively small amount of data. OLTP systems must be able to handle a high volume of write transactions with low latency, often in real-time. Additionally, OLTP systems may involve moderate read operations to retrieve specific data points that are needed for processing or reporting.
Normalized data: OLTP systems typically use normalized data structures, which means that data is organized into tables with minimum redundancy. Normalization helps to reduce data duplication and improve data integrity, making it easier to maintain and update the database. In OLTP systems, the focus is on maintaining the consistency and accuracy of data, rather than on analyzing or reporting on large sets of data.
Schema defined in a database: OLTP systems typically use a predefined schema that defines the structure and relationships between tables in a database. The schema is designed to support the specific needs of the application and to optimize data access and retrieval. OLTP systems require a well-defined schema to ensure data consistency and integrity, and to support fast, efficient transaction processing.
Based on these characteristics, the correct answers are:
B. Heavy writes and moderate reads F. Normalized data D. Schema defined in a database