You deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has
SQL Server Analysis Services (SSAS) installed. The model uses a relational data source
named DB1.
You need to ensure that Server1 passes the credentials of the current user browsing the
model to DB1.
What should you do?
A.
Register a Service Principal Name (SPN) for Server1.
B.
From the SQL Server Data Tools, modify the impersonation settings.
C.
From the Web.config file, modify the impersonation settings.
D.
Register a Service Principal Name (SPN) for DB1.
You have to define spn for BD1 instance,
to enable user delegation from SSAS to SQL Server.
I think D is correct answer.
A is correct:
https://msdn.microsoft.com/en-us/library/ms191153(v=sql.110).aspx
You need to register SPN for this service that should take credentials of user and reuse them connecting to another system. Here Server1 is such a machine.
“A” is correct
I believe D is correct.
The SPN is the service you are going to delegate the credential to. You then configure the intermediary in AD to be able to delegate to this SPN only. There for you create the SPN for DB1 and configure the delegation by trusting a user/computer(Server 1) to pass credentials to only that Service.
http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/11/06/excel-services-2010-amp-2013-kerberos-configuration.aspx