The storage of carbon dioxide is now regarded as a critical industrial application aimed at mitigating its accumulation in the atmosphere. Reservoirs and aquifers have been identified as viable alternative locations. This report seeks to examine the impact of sedimentological heterogeneity on the development and migration of CO2 plumes over time. The study uses the Roda Sandstone Formation as a case study, primarily due to the presence of carbonate-cemented layers within the Gilbert-delta lobes, which contribute to reservoir heterogeneity commonly observed in subsurface formations. The utilization of a sketch-based modeling approach was employed in constructing the geo-models represented by Rapid Reservoir Modeling (RRM) software since the Roda Sandstone is an exposed section in Isabena Valley in Spain. Furthermore, various realizations are constructed using different parameters of the cemented layers to comprehensively comprehend all potential scenarios. The aforementioned observations pertain to variations in the thickness and lateral continuity of the cemented layers. Additionally, dynamic modeling is also performed by injecting CO2 into the reservoir for 50 years. The simulator utilized for dynamic modeling is the Delft Advanced Research Terra Simulator (DARTS). The findings demonstrate that reservoirs with moderate sedimentological heterogeneity are actually better sites to store CO2 due to the capacity and effectiveness of the storage.