nerdexam
AmazonAmazon

DBS-C01 · Question #168

DBS-C01 Question #168: Real Exam Question with Answer & Explanation

The correct answer is A: Create a service-linked role for Amazon RDS that grants permissions for Amazon RDS to store. To do this, you create an IAM role and delegate permissions so that the Amazon RDS service can use your Amazon S3 bucket. RDS uploads the completed audit logs to your S3 bucket, using the IAM role that you provide. If you enable retention, RDS keeps your audit logs on your DB ins

Submitted by noor.lb· Mar 6, 2026Database Security

Question

A company is setting up a new Amazon RDS for SQL Server DB instance. The company wants to enable SQL Server auditing on the database. Which combination of steps should a database specialist take to meet this requirement? (Choose two.)

Options

  • ACreate a service-linked role for Amazon RDS that grants permissions for Amazon RDS to store
  • BSet up a parameter group to configure an IAM role and an Amazon S3 bucket for audit log
  • CDisable Multi-AZ on the DB instance, and then enable auditing. Enable Multi-AZ after auditing is
  • DDisable automated backup on the DB instance, and then enable auditing. Enable automated
  • ESet up an options group to configure an IAM role and an Amazon S3 bucket for audit log storage.

Explanation

To do this, you create an IAM role and delegate permissions so that the Amazon RDS service can use your Amazon S3 bucket. RDS uploads the completed audit logs to your S3 bucket, using the IAM role that you provide. If you enable retention, RDS keeps your audit logs on your DB instance for the configured period of https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.Audit.

Topics

#RDS for SQL Server#SQL Server auditing#options groups#IAM roles

Community Discussion

No community discussion yet for this question.

Full DBS-C01 PracticeBrowse All DBS-C01 Questions