In Azure, data at rest is encrypted by default using a service-managed key. Tenant root keys or customer-managed keys (CMKs) give you more control over this encryption, but don't add a second encryption layer. They just manage the existing service-managed key.
Double Key Encryption (DKE) does add a second encryption layer. It uses a key managed by Azure and another managed by you, outside of Azure. Both keys are needed to access the data.
So, your understanding is correct: Azure typically uses one layer of encryption, unless you use the DKE feature which applies two layers.