anjanesh I recommend an A record.
Either record will suffice to get the request routed to the site, but there is an important distinction:
- An A record simply says "route userdomain.com to 1.2.3.4" where "1.2.3.4" is sitedomain.com's IP.
- A CNAME record says "userdomain.com is an alias for sitedomain.com". This means that userdomain.com IS sitedomain.com. As a result, userdomain.com no longer has its own DNS records other than the CNAME and instead gets its records from sitedomain.com.
That means, for example, that userdomain.com will now use the MX records for sitedomain.com which will likely break email for userdomain.com.
If you're using subdomains like mysite.userdomain.com then it's less of concern, but I recommend using an A record all the same.