DBS-C01 (Page 7)

A company is loading sensitive data into an Amazon Aurora MySQL database.To meet compliance requirements, the company needs to enable audit logging on the Aurora MySQL DB cluster to audit database activity.This logging will include events such as connections, disconnections, queries, and tables queried.The company also needs to publish the DB logs to Amazon CloudWatch to perform real-time data analysis.Which solution meets these requirements?Read More →

An ecommerce company uses Amazon DynamoDB as the backend for its payments system.A new regulation requires the company to log all data access requests for financial audits.For this purpose, the company plans to use AWS logging and save logs to Amazon S3How can a database specialist activate logging on the database?Read More →

A company stores session history for its users in an Amazon DynamoDB table.The company has a large user base and generates large amounts of session data.Teams analyze the session data for 1 week, and then the data is no longer needed.A database specialist needs to design an automated solution to purge session data that is more than 1 week old.Which strategy meets these requirements with the MOST operational efficiency?Read More →

A company is running a business-critical application on premises by using Microsoft SQL Server.A database specialist is planning to migrate the instance with several databases to the AWS Cloud.The database specialist will use SQL Server Standard edition hosted on Amazon EC2 Windows instances.The solution must provide high availability and must avoid a single point of failure in the SQL Server deployment architecture.Which solution will meet these requirements?Read More →

A company uses Amazon Aurora MySQL as the primary database engine for many of its applications.A database specialist must create a dashboard to provide the company with information about user connections to databases.According to compliance requirements, the company must retain all connection logs for at least 7 years.Which solution will meet these requirements MOST cost-effectively?Read More →

A company’s database specialist implements an AWS Database Migration Service (AWS DMS) task for change data capture (CDC) to replicate data from an on- premises Oracle database to Amazon S3.When usage of the company’s application increases, the database specialist notices multiple hours of latency with theCDC.Which solutions will reduce this latency? (Choose two.)Read More →

A retail company manages a web application that stores data in an Amazon DynamoDB table.The company is undergoing account consolidation efforts.A database engineer needs to migrate the DynamoDB table from the current AWS account to a new AWS account.Which strategy meets these requirements with the LEAST amount of administrative work?Read More →

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.)Read More →

A company uses an on-premises Microsoft SQL Server database to host relational and JSON data and to run daily ETL and advanced analytics.The company wants to migrate the database to the AWS Cloud.Database specialist must choose one or more AWS services to run the company’s workloads.Which solution will meet these requirements in the MOST operationally efficient manner?Read More →

After restoring an Amazon RDS snapshot from 3 days ago, a company’s Development team cannot connect to the restored RDS DB instance.What is the likely cause of this problem?Read More →