This study investigates the impact of cementation on the mechanical behavior of sands with various cement content (CSR) in drained triaxial compression, employing both Acoustic Emission (AE) and Environmental Scanning Electron Microscopy (ESEM) measurements. The experimental findings, encompassing quantitative statistics of stress-strain relations, microstructure variations, and AE characteristics, demonstrate that: the addition of CSR from 1% to 20% leads to an exponential rise in peak strength and stiffness, marking a transition from ductile to brittle mechanical failure, which is pinpointed between CSR levels of 5% to 10%. AE characteristics unveil an upward-opening parabola of normalized AE hits with CSR, a clear transition zone identification, and three distinct types of AE rate evolutions corresponding to failure patterns of ductile bulging, shear banding, and brittle fracturing, respectively. It suggests an intimate correlation with the intrinsic differences in micro-mechanical behaviors and AE propagation properties of cemented sands with varying CSRs. Notably, the bulging and shear banding processes are divided by AE into three stages, whereas fracturing is characterized into five stages. Two precursory AE anomalies associated with incipient failure and complex failure modes are observed, emphasizing the advantage of using AE to reflect the internal micro-mechanical behavior of cemented sands over conventional stress-strain manifestations.