When scaling Cloud Tier for a DD9400 by adding a second cloud unit, the required amount of metadata storage is 240 TB. This is based on the specific hardware configurations and requirements for the DD series, which typically need 240 TB of metadata storage when adding a second cloud unit.