1Y0-401 · Question #156
Why does using SQL Reporting Services help the company comply with its security policy?
The correct answer is D. Because it collects logs from multiple devices. SQL Reporting Services helps comply with security policies by acting as a consolidation point for log data from various sources.
Question
Options
- ABecause it is a centralized, industry-standard log that is easily queried
- BBecause it password-protects the audit logs for added security
- CBecause it uses a standard TCP port
- DBecause it collects logs from multiple devices
How the community answered
(59 responses)- A2% (1)
- B5% (3)
- C3% (2)
- D90% (53)
Why each option
SQL Reporting Services helps comply with security policies by acting as a consolidation point for log data from various sources.
SSRS is a reporting platform, not an industry-standard log itself, and while it presents data from logs, it does not function as a log aggregator or store logs in a specific industry-standard format.
SSRS does not inherently password-protect audit logs; rather, it reports on data, and the security of the underlying log data is managed by the source systems or SQL Server itself.
Using a standard TCP port is a basic networking requirement for SSRS accessibility and does not directly contribute to security policy compliance beyond enabling connectivity.
SQL Reporting Services (SSRS) can connect to and present data from multiple disparate sources, including logs collected from various devices across an organization. This centralization within reports provides a unified view for security auditing and compliance analysis, making it easier to monitor and identify security-relevant events across the entire infrastructure.
Concept tested: SQL Reporting Services centralized log data collection
Source: https://learn.microsoft.com/sql/reporting-services/report-data/data-sources-supported-by-reporting-services-ssrs
Topics
Community Discussion
No community discussion yet for this question.