Local + Upstream DNS for same domain

Hi,

I have an issue that maybe someone brighter than me can answer!

I have GoDaddy as a DNS provider. I have my site example.com registered with an A record.
I also have a CNAME pointing to my MikroTik Cloud DNS service mahjsdfjas.sn.mynetname.net to allow access to the services even if the WAN IP is changed.

I thought I would be able to just add static DNS addresses to allow internal lookup.
But it seems this is not working since the MikroTik DNS server returns also the external CNAME.

nslookup test.example.com 192.168.88.1
Server:         192.168.88.1
Address:        192.168.88.1#53

Non-authoritative answer:
Name:   test.example.com
Address: 192.168.88.225
test.example.com   canonical name = 3sdfdsf5c.sn.mynetname.net.

Anyone with a suggestion how to fix this?