Split DNS is an enhancement that allows you to configure a set of servers and associate them to a given domain name (which can be a wildcard). When SonicOS/X DNS Proxy receives a query that matches the domain name, the name is transmitted to the designated DNS server.
This can be achieved over Site to Site VPN policy for remote users where DNS server is on the main site.
Network Topology
Site A
Site B
NOTE: This is only going to work for Tunnel interface VPN since we get to select the VPN interface in the Split DNS |Local interface.
This release includes significant user interface changes and many new features that are different from the SonicOS 6.5 and earlier firmware. The below resolution is for customers using SonicOS 7.X firmware.

Navigate DNS|DNS Proxy| Enable “Enforce DNS Proxy”



HOW TO TEST:
We can test this by pinging any subdomain, like abc.acme.local from TZ 670 side.
Below is the packet capture for successful response and that the query is forwarded to TZ 570.