PrepAway - Latest Free Exam Questions & Answers

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

PrepAway - Latest Free Exam Questions & Answers

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.

2 Comments on “How should you define the impersonation information for the connection?


Leave a Reply