Which of the following features can you install if you are installing SQL Server 2012 Enterprise
edition on a computer running Windows Server 2008 R2 SP1 Enterprise edition in the Server Core
configuration? (Choose all that apply.)
A.
Database Engine Services
B.
SQL Server Replication
C.
Analysis Services
D.
Reporting Services
Here’s another one. To get this right with similar questions, you ahve to memorize this:
https://msdn.microsoft.com/en-us/library/hh231669.aspx
A – B – C
Use the following table to find which features are supported in SQL Server 2012 on a Server Core installation of Windows Server 2008 R2 SP1 and Windows Server 2012.
Feature
Supported
Database Engine Services
Yes
SQL Server Replication
Yes
Full Text Search
Yes
Analysis Services
Yes
Reporting Services
No
SQL Server Data Tools (SSDT)
No
Client Tools Connectivity
Yes
Integration Services Server[1]
Yes
Client Tools Backward Compatibility
No
Client Tools SDK
No
SQL Server Books Online
No
Management Tools – Basic
Remote Only[2]
Management Tools – Complete
Remote Only[2]
Distributed Replay Controller
No
Distributed Replay Client
Remote Only[2]
SQL Client Connectivity SDK
Yes
Microsoft Sync Framework
Yes[3]
Master Data Services
No
Data Quality Services
No
Good old Microsoft; nothing to do with understanding, all about memorizing stupid lists…