AWS Certified Database - Specialty

• #161Choose 2

  A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has restored the latest backup to a new table. To prepare the new table with identical settings, which steps should be performed? (Choose two.)

  • ARe-create global secondary indexes in the new table.
  • BDefine IAM policies for access to the new table.
  • CDefine the TTL settings.
  • DEncrypt the table from the AWS Management Console or use the update-table command.
  • ESet the provisioned read and write capacity.
  Show answer
  💬Discussion
• #162

  The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real-time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution. Which approach will meet these requirements?

  • AUse pg_audit to generate audit logs and send the logs to the Security team.
  • BUse AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
  • CSet up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.
  • DTurn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.
  Show answer
  💬Discussion
• #163

  A company has a 20 TB production Amazon Aurora DB cluster. The company runs a large batch job overnight to load data into the Aurora DB cluster. To ensure the company’s development team has the most up-to-date data for testing, a copy of the DB cluster must be available in the shortest possible time after the batch job completes. How should this be accomplished?

  • AUse the AWS CLI to schedule a manual snapshot of the DB cluster. Restore the snapshot to a new DB cluster using the AWS CLI.
  • BCreate a dump file from the DB cluster. Load the dump file into a new DB cluster.
  • CSchedule a job to create a clone of the DB cluster at the end of the overnight batch process.
  • DSet up a new daily AWS DMS task that will use cloning and change data capture (CDC) on the DB cluster to copy the data to a new DB cluster. Set up a time for the AWS DMS stream to stop when the new cluster is current.
  Show answer
  💬Discussion
• #164

  A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier. The database is used primarily during business hours with random activity peaks throughout the day. A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company’s migration to AWS. Which MySQL database option would meet these requirements?

  • AAmazon RDS for MySQL with Multi-AZ.
  • BAmazon Aurora Serverless MySQL cluster.
  • CAmazon Aurora MySQL cluster.
  • DAmazon RDS for MySQL with read replica.
  Show answer
  💬Discussion
• #165

  A company is looking to migrate a 1 TB Oracle database from on-premises to an Amazon Aurora PostgreSQL DB cluster. The company's Database Specialist discovered that the Oracle database is storing 100 GB of large binary objects (LOBs) across multiple tables. The Oracle database has a maximum LOB size of 500 MB with an average LOB size of 350 MB. The Database Specialist has chosen AWS DMS to migrate the data with the largest replication instances. How should the Database Specialist optimize the database migration using AWS DMS?

  • ACreate a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together.
  • BCreate two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs.
  • CCreate two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs.
  • DCreate a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together.
  Show answer
  💬Discussion
• #166Choose 3

  A company has multiple applications serving data from a secure on-premises database. The company is migrating all applications and databases to the AWS Cloud. The IT Risk and Compliance department requires that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as the migration target, and leveraging the Advanced Auditing feature in Aurora. Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements? (Choose three.)

  • ACONNECT.
  • BQUERY_DCL.
  • CQUERY_DDL.
  • DQUERY_DML.
  • ETABLE.
  • FQUERY.
  Show answer
  💬Discussion
• #167

  A database specialist deployed an Amazon RDS DB instance in Dev-VPC1 used by their development team. Dev-VPC1 has a peering connection with Dev-VPC2 that belongs to a different development team in the same department. The networking team confirmed that the routing between VPCs is correct; however, the database engineers in Dev-VPC2 are getting a timeout connections error when trying to connect to the database in Dev-VPC1. What is likely causing the timeouts?

  • AThe database is deployed in a VPC that is in a different Region.
  • BThe database is deployed in a VPC that is in a different Availability Zone.
  • CThe database is deployed with misconfigured security groups.
  • DThe database is deployed with the wrong client connect timeout configuration.
  Show answer
  💬Discussion
• #168

  A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster. The company requires a very low RTO and needs to improve the application recovery time after database failovers. Which approach meets these requirements?

  • ASet the max_connections parameter to 16,000 in the instance-level parameter group.
  • BModify the client connection timeout to 300 seconds.
  • CCreate an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.
  • DEnable the query cache at the instance level.
  Show answer
  💬Discussion
• #169

  An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application. The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts. How should a Database Specialist address these requirements?

  • AUse AWS DMS to migrate data from DynamoDB to Amazon DocumentDB.
  • BUse Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift.
  • CUse an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance.
  • DUse DynamoDB Accelerator to offload the reads.
  Show answer
  💬Discussion

Want to track your score, take timed mock exams and get AI explanations? Create a free account