I was always confused with the different kinds of records using for the domain pointing and configuration.

Making a note so I remember them and also if it helps others :-

A record - Point a domain/subdomain to an IP Address
CNAME - create alias for domain or subdomain
TXT Records - text used for configuration or validation (Usually SPF/DKIM records)
MX - Used for mail server configuration