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.)

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.



Leave a Reply 2

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


Ralph

Ralph

A – do not use your personal accounts when defining a job.
B – is ok
C – too much permision
D – not recommended. We should use one central identity management = AD