@chaithanyaam
Yes you go into production with Ambari 2.7.4 and HDP 3.1.4 but you will be liable for whatever goes wrong on your production cluster as Cloudera engineers won't be there to rescue you !! Secondly you won't able to upgrade to the newer versions as access to HDP 3.1.5 or higher as these repositories require authentication synonym of buying Cloudera support please check the support options.
Even if you have strong technical Hortonworks experts ultimately you will have to move to a paid subscription. For example, HDP 3.1.5 brought in a lot of improvements especially in hive, Hbase, hdfs see fixed issues
Having said that I would encourage you also to see the Cloudera Platform pricing
Without Cloudera support if anything goes wrong in your cluster you won't get support or any patch or bug fixes from Cloudera unless you buy a subscription I don't think you would want your production cluster running in this mode. Taking into account the above situation it would be wiser to get a subscription for ONLY your production cluster.
CDP has for now been released for AWS and Azure I am not sure about the on-premise offering nor a Sandbox
Hope that helps