Changing Database compatibility level will be required when you upgrade your database from one version to another and you want to use the latest feature for sql version. For details on compatibility check this earlier post. For example lets say when you upgrade a database from sql server 2012 to 2014 the compatibility level