AWS Certified Database Specialty-(DBS-C01)
The AWS Certified Database Specialty-(DBS-C01) were last updated on today.
- Viewing page 5 out of 68 pages.
- Viewing questions 21-25 out of 340 questions
- - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.and Azure
- - Trademarks, certification & product names are used for reference only and belong to Amazon.and Azure
Topic 1 - Exam A
A company has a 4 ׀¢׀’ on-premises Oracle Real Application Clusters (RAC) database. The company wants to migrate the database to AWS and reduce licensing costs. The company's application team wants to store JSON payloads that expire after 28 hours. The company has development capacity if code changes are required. Which solution meets these requirements?
- A Use Amazon DynamoDB and leverage the Time to Live (TTL) feature to automatically expire the data.
- B Use Amazon RDS for Oracle with Multi-AZ. Create an AWS Lambda function to purge the expired data. Schedule the Lambda function to run daily using Amazon EventBridge.
- C Use Amazon DocumentDB with a read replica in a different Availability Zone. Use DocumentDB change streams to expire the data.
- D Use Amazon Aurora PostgreSQL with Multi-AZ and leverage the Time to Live (TTL) feature to automatically expire the data.
NOTE: Amazon DynamoDB Time to Live (TTL) allows you to define a per-item timestamp to determine when an item is no longer needed. Shortly after the date and time of the specified timestamp, DynamoDB deletes the item from your table without consuming any write throughput. Reference: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TTL.html
A manufacturing company has an. inventory system that stores information in an Amazon Aurora MySQL DB cluster. The database tables are partitioned. The database size has grown to 3 TB. Users run one-time queries by using a SQL client. Queries that use an equijoin to join large tables are taking a long time to run. Which action will improve query performance with the LEAST operational effort?
- A Migrate the database to a new Amazon Redshift data warehouse.
- B Enable hash joins on the database by setting the variable optimizer_switch to hash_join=on.
- C Take a snapshot of the DB cluster. Create a new DB instance by using the snapshot, and enable parallel query mode.
- D Add an Aurora read replica.
NOTE: Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.BestPractices.html
A company runs hundreds of Microsoft SQL Server databases on Windows servers in its on-premises data center. A database specialist needs to migrate these databases to Linux on AWS. Which combination of steps should the database specialist take to meet this requirement? (Choose three.)
- A Install AWS Systems Manager Agent on the on-premises servers. Use Systems Manager Run Command to install the Windows to Linux replatforming assistant for Microsoft SQL Server Databases.
- B Use AWS Systems Manager Run Command to install and configure the AWS Schema Conversion Tool on the on-premises servers.
- C On the Amazon EC2 console, launch EC2 instances and select a Linux AMI that includes SQL Server. Install and configure AWS Systems Manager Agent on the EC2 instances.
- D On the AWS Management Console, set up Amazon RDS for SQL Server DB instances with Linux as the operating system. Install AWS Systems Manager Agent on the DB instances by using an options group.
- E Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration.
- F On the AWS Management Console, set up AWS Database Migration Service (AWS DMS) by entering details of the source SQL Server database and the destination SQL Server database on AWS. Start migration.
NOTE:
A financial services company runs an on-premises MySQL database for a critical application. The company is dissatisfied with its current database disaster recovery (DR) solution. The application experiences a significant amount of downtime whenever the database fails over to its DR facility. The application also experiences slower response times when reports are processed on the same database. To minimize the downtime in DR situations, the company has decided to migrate the database to AWS. The company requires a solution that is highly available and the most cost-effective. Which solution meets these requirements?
- A Create an Amazon RDS for MySQL Multi-AZ DB instance and configure a read replica in a different Availability Zone. Configure the application to reference the replica instance endpoint and report queries to reference the primary DB instance endpoint.
- B Create an Amazon RDS for MySQL Multi-AZ DB instance and configure a read replica in a different Availability Zone. Configure the application to reference the primary DB instance endpoint and report queries to reference the replica instance endpoint.
- C Create an Amazon Aurora DB cluster and configure an Aurora Replica in a different Availability Zone. Configure the application to reference the cluster endpoint and report queries to reference the reader endpoint.
- D Create an Amazon Aurora DB cluster and configure an Aurora Replica in a different Availability Zone. Configure the application to reference the primary DB instance endpoint and report queries to reference the replica instance endpoint.
NOTE: Reference: https://aws.amazon.com/rds/features/multi-az/
A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and a MySQL database that is hosted in Amazon RDS. After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company's database team needs to configure the database to require in-transit encryption for all connections. Which solution will meet this requirement?
- A Update the parameter group in use by the DB instance, and set the require_secure_transport parameter to ON.
- B Connect to the database, and use ALTER USER to enable the REQUIRE SSL option on the database user.
- C Update the security group in use by the DB instance, and remove port 80 to prevent unencrypted connections from being established.
- D Update the DB instance, and enable the Require Transport Layer Security option.
NOTE: You can set the require_secure_transport parameter to ON to require SSL/TLS for connections to your DB cluster. Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Security.html
