How should you define the impersonation information for the connection?

You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use your domain credentials. Grant least privilege to your account in the source database.
B. Create and use a new Windows domain account. Grant least privilege to this account in the source database.
C. Use the credentials of the SQL Server Analysis Services (SSAS) service account. Grant least privilege to this account in the source database.
D. Use SQL Server authentication.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.