70-489 · Question #43
You need to configure authentication to access the SQL data source during development. Which authentication mechanism should you use?
The correct answer is B. Pass Through. This question tests which authentication mechanism is appropriate for accessing a SQL data source during development in a reporting or data connection context such as SSRS or Power BI Report Server.
Question
You need to configure authentication to access the SQL data source during development. Which authentication mechanism should you use?
Options
- AImpersonated Windows Identity
- BPass Through
- CImpersonated Custom Identity
- DForms Based Authentication
How the community answered
(28 responses)- A4% (1)
- B86% (24)
- C7% (2)
- D4% (1)
Why each option
This question tests which authentication mechanism is appropriate for accessing a SQL data source during development in a reporting or data connection context such as SSRS or Power BI Report Server.
Impersonated Windows Identity requires specifying a fixed Windows account whose credentials are stored and used to connect, which is unnecessary overhead during development and introduces credential management complexity.
Pass Through authentication forwards the currently authenticated user's credentials directly to the SQL data source without impersonation or stored credentials. During development, this is the preferred mechanism because the developer's own Windows identity is used to connect, making it easy to test with existing permissions and avoiding the need to configure stored or impersonated accounts.
Impersonated Custom Identity uses a stored username and password for a non-Windows account, which requires additional configuration and is not suited for a development scenario where the developer's own credentials are sufficient.
Forms Based Authentication is used for web application user authentication, not for backend data source connections to SQL Server, making it architecturally incorrect for this scenario.
Concept tested: SQL data source authentication in reporting services development
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/specify-credential-and-connection-information-for-report-data-sources
Topics
Community Discussion
No community discussion yet for this question.