nerdexam
Microsoft

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.

Implement Microsoft SharePoint 2013 business connectivity services (BCS)

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)
  • A
    4% (1)
  • B
    86% (24)
  • C
    7% (2)
  • D
    4% (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.

AImpersonated Windows Identity

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.

BPass ThroughCorrect

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.

CImpersonated Custom Identity

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.

DForms Based Authentication

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

#BCS authentication#Pass Through#SQL data source#development environment

Community Discussion

No community discussion yet for this question.

Full 70-489 Practice