1Y0-401 · Question #160
Why does using SQL Reporting Services help the company comply with its security policy?
The correct answer is A. Because it enables automated report delivery. SQL Reporting Services helps comply with security policies by enabling automated delivery of security-relevant reports, ensuring timely review and oversight.
Question
Options
- ABecause it enables automated report delivery
- BBecause it enables PDF-based reports
- CBecause it uses a standard TCP port
- DBecause it provides security alerts by using SQL Mail
How the community answered
(20 responses)- A90% (18)
- B5% (1)
- D5% (1)
Why each option
SQL Reporting Services helps comply with security policies by enabling automated delivery of security-relevant reports, ensuring timely review and oversight.
Automated report delivery from SQL Reporting Services ensures that security audit reports, access logs, or compliance summaries are regularly distributed to responsible personnel, facilitating proactive monitoring and adherence to policies requiring periodic security reviews.
PDF-based reports are a presentation format and do not inherently contribute to security compliance beyond making reports readable.
Using a standard TCP port is a networking configuration detail and does not directly enhance security policy compliance.
SQL Reporting Services primarily focuses on report generation and delivery, not on providing security alerts directly via SQL Mail, which is a separate SQL Server feature.
Concept tested: SQL Reporting Services automated reporting for security compliance
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/subscriptions-reporting-services
Topics
Community Discussion
No community discussion yet for this question.