Resolves the .active configuration by merging YAML layers.
.active
Layer merge order: base.yaml -> {DC_ENV}.yaml -> local.yaml -> secrets.yaml
@spec resolve_active(String.t(), String.t()) :: {:ok, term()} | {:error, term()}