M55353A - Administering a SQL Database Infrastructure Quiz Questions and Answers
Answer :
Weekly full backups with daily incremental backups
Explanation :
Incremental backups require less storage space than differential backups because they only include changes since the last incremental backup. Combining weekly full backups with daily incremental backups provides a balance between storage efficiency and the ability to restore to any point in time within the desired window.---
Database Audit Specifications allow you to specify particular database-level actions, such as SELECT statements on sensitive tables, for auditing. This ensures that you have a detailed audit log of data access activities relevant to compliance and security requirements.
Insufficient permissions due to wrong credentials; reassign correct permissions
Explanation :
A job failure due to credential issues usually implies insufficient permissions for the task. Correcting this involves updating job step security configurations with appropriate credentials that have the required privileges.
The public role grants default access to SQL Server for all users. It does not provide any permissions beyond the ability to connect, making it suitable for new developers who do not require schema modification capabilities.
By segregating duties and minimizing privilege exposure
Explanation :
Credentials allow SQL Server Agent to run job steps under specific user contexts, restricting access level and exposure, thus adhering to the principle of least privilege and enhancing security over external system access.
SQL Server Authentication is riskier because it can involve storing user credentials, specifically passwords, in plaintext or using weak encryption unless properly managed, increasing the potential for unauthorized access.
The importance of user permissions, encryption, and scheduling conflicts
Explanation :
When automating SQL Server tasks, it's vital to ensure the job runs with appropriate permissions, safeguards sensitive data with encryption, and avoids scheduling conflicts that could disrupt other critical operations.
User-defined database roles control permissions at the database level
Explanation :
User-defined database roles are designed to manage permissions within a database and allow customized control over access to database objects, unlike server roles that operate at the server level.
Implement a tiered alert system based on error severity
Explanation :
A tiered alert system minimizes alert fatigue by prioritizing errors based on severity, ensuring only significant issues are reported immediately, while others can be logged for later review.---
10MB equals 10485760 bytes. Dividing by the average event size (512 bytes) gives approximately 20480 events. However, due to event overhead, the actual number of storable events is lesser.
