70-466 · Question #91
You need to configure the SSRS data source. What should you do?
The correct answer is A. Use Windows credentials.. Configuring an SSRS data source with Windows credentials uses the authenticated Windows identity to connect to the data source, which is appropriate when integrated security is required.
Question
Options
- AUse Windows credentials.
- BPrompt the user for credentials.
- CIn the data source configuration window, select the Credentials are not required option.
- DStore the credentials.
How the community answered
(39 responses)- A87% (34)
- B3% (1)
- C3% (1)
- D8% (3)
Why each option
Configuring an SSRS data source with Windows credentials uses the authenticated Windows identity to connect to the data source, which is appropriate when integrated security is required.
Selecting Windows credentials in the SSRS data source configuration causes the report server to use the Windows identity of either the report viewer or a configured service account via Kerberos or NTLM, ensuring that authentication is handled through the existing Active Directory infrastructure without storing plaintext passwords.
Prompting the user for credentials requires interactive login each time a report runs, which breaks unattended or scheduled report execution scenarios.
The 'Credentials are not required' option is only valid for data sources that support anonymous access; using it against a secured data source results in connection failures.
Storing credentials embeds a specific username and password in the data source configuration, which introduces a credential management risk and does not leverage Windows-integrated authentication.
Concept tested: SSRS data source Windows integrated authentication configuration
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.