Microsoft Exam Questions

You need to ensure that Server1 passes the credentials …

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.