OK, I made a simple test, define a plain UCLASS UObject with a class member TArray of type int8. This array is initialized in the class constructor respectively with size 0, 500000000 and 1000000000. The memory usage of Unreal Editor is shown in the following figure:
This means that the CDO of a C++ UObject does exist in the memory, and takes as much memory as it needs.