Microsoft
70-466 · Question #14
70-466 Question #14: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #14. The question stem and answer options stay visible for context.
Configure and maintain an analysis services database
Question
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?
Options
- ARegister a Service Principal Name (SPN) for Server1.
- BFrom the SQL Server Data Tools, modify the impersonation settings.
- CFrom the Web.config file, modify the impersonation settings.
- DRegister a Service Principal Name (SPN) for DB1.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#DirectQuery mode#SPN Kerberos delegation#impersonation#credential passthrough