nerdexam
Citrix

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.

Design Operational Management and Security

Question

Why does using SQL Reporting Services help the company comply with its security policy?

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)
  • A
    2% (1)
  • B
    5% (3)
  • C
    3% (2)
  • D
    90% (53)

Why each option

SQL Reporting Services helps comply with security policies by acting as a consolidation point for log data from various sources.

ABecause it is a centralized, industry-standard log that is easily queried

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.

BBecause it password-protects the audit logs for added security

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.

CBecause it uses a standard TCP port

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.

DBecause it collects logs from multiple devicesCorrect

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

#SQL Reporting Services#security compliance#data collection

Community Discussion

No community discussion yet for this question.

Full 1Y0-401 Practice