Microsoft Exam Questions

You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1

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.