It should be made for various "basic roles" for windows, like DC and LDAP, File Server and Print Server, DHCP and DNS. It's can not run Microsoft SQL server, or Microsoft Exchange, as they are not basic roles. However it's can run IIS and Hyper-V.
Cons for Core Edition
I don't mind it can't run MMC locally, but it can't run Internet Explorer or Windows Explorer, which makes it pretty difficult to use. For command line, it doesn't support powershell, which disappointed me again, however the later version of core server, for example 2012, changed it.