1Y0-401 · Question #159
Why does using SQL Management Studio help the company comply with its security policy?
The correct answer is B. Because it enables you to create a database to store logs. SQL Management Studio assists in security policy compliance by providing the tools necessary to create and manage databases specifically for storing security-relevant logs.
Question
Options
- ABecause it enables you to execute SQL queries to extract data
- BBecause it enables you to create a database to store logs
- CBecause it uses a standard TCP port
- DBecause it provides security alerts by using SQL Mail
How the community answered
(26 responses)- A4% (1)
- B88% (23)
- C8% (2)
Why each option
SQL Management Studio assists in security policy compliance by providing the tools necessary to create and manage databases specifically for storing security-relevant logs.
While SSMS allows executing queries to extract data, simply extracting data does not, by itself, fulfill security policy compliance as much as establishing the secure infrastructure for data storage.
SQL Server Management Studio (SSMS) is the primary administrative tool for SQL Server, enabling database administrators to create, configure, and manage databases. For security compliance, SSMS facilitates the establishment of dedicated databases for securely storing audit trails, security event logs, and other compliance-related data, ensuring proper retention and availability for security analysis and policy adherence.
Using a standard TCP port is a basic connectivity configuration for SQL Server and SSMS, which does not directly contribute to complying with a security policy in a significant way.
SQL Mail (now Database Mail) is a feature of SQL Server for sending alerts, not a primary function of SSMS, and creating a database for logs is a more foundational contribution to overall security compliance than sending alerts.
Concept tested: SQL Server Management Studio database creation for logs
Source: https://learn.microsoft.com/sql/relational-databases/security/sql-server-audit/create-a-server-audit-and-server-audit-specification
Topics
Community Discussion
No community discussion yet for this question.