Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?
Click on the arrows to vote for the correct answer
A. B. C. D.C
https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/The reporting solution described in the question uses batch processing. Batch processing is a method of processing data where a large amount of data is collected, processed, and stored at one time. This is different from stream processing, where data is processed in real-time as it is generated.
Paginated reports are reports that are designed to be printed or viewed on a screen, and they typically contain tables, charts, and other visualizations. These reports are created using SQL Server Reporting Services (SSRS), which is a tool for creating, deploying, and managing paginated reports.
The dimensional model mentioned in the question is a data modeling technique used in data warehousing. It organizes data into dimensions and measures, which are used to support analytical queries. Online Analytical Processing (OLAP) is a type of processing that is used to analyze data in a dimensional model. However, OLAP is not the processing method used by the reporting solution described in the question.
Online Transaction Processing (OLTP) is a type of processing used by systems that manage transactions, such as e-commerce sites or banking systems. OLTP systems are designed to process individual transactions quickly and efficiently. OLTP is not used by the reporting solution described in the question.
Therefore, the correct answer is B, batch processing. The reporting solution uses batch processing to collect and process the data needed for the paginated reports.