Can I use Managed DNS as a secondary server only?

Hosted DNS
Absolutely. In fact, by creating a zone via the DNS Manager that uses your own name server as the primary, you gain more than just one secondary server, you gain the benefit of our entire network.