Amazon DBS-C01 AWS Certified Database - Specialty Exam Exam Practice Test Questions

• Question 1

  An online retailer uses Amazon DynamoDB for its product catalog and order data. Some popular items have led to frequently accessed keys in the data, and the company is using DynamoDB Accelerator (DAX) as the caching solution to cater to the frequently accessed keys. As the number of popular products is growing, the company realizes that more items need to be cached. The company observes a high cache miss rate and needs a solution to address this issue. What should a database specialist do to accommodate the changing requirements for DAX?

  • Increase the number of nodes in the existing DAX cluster.
  • Create a new DAX cluster with more nodes. Change the DAX endpoint in the application to point to the new cluster.
  • Create a new DAX cluster using a larger node type. Change the DAX endpoint in the application to point to the new cluster.
  • Modify the node type in the existing DAX cluster.

  Show Answer Answer: C Next

• Question 2

  A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days. Which solution will meet these requirements in the MOST operationally efficient way?

  • Create a manual copy of the snapshot.
  • Export the contents of the snapshot to an Amazon S3 bucket.
  • Change the retention period of the snapshot to 45 days.
  • Create a native SQL Server backup. Save the backup to an Amazon S3 bucket.

  Show Answer Answer: A Next

• Question 3

  A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB instance goes live. What change should the Database Specialist make to enable the migration?

  • Configure the on-premises application database to act as a source for an AWS DMS full load with Braindumps Questions ongoing change data capture (CDC)
  • Configure the AWS DMS replication instance to allow both full load and ongoing change data capture (CDC)
  • Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)
  • Configure the AWS DMS connections to allow two-way communication to allow for ongoing change data capture (CDC)

  Show Answer Answer: A Next

• Question 4

  A social media company is using Amazon DynamoDB to store user profile data and user activity data. Developers are reading and writing the data, causing the size of the tables to grow significantly. Developers have started to face performance bottlenecks with the tables. Which solution should a database specialist recommend to read items the FASTEST without consuming all the provisioned throughput for the tables?

  • Use the Scan API operation in parallel with many workers to read all the items. Use the Query API operation to read multiple items that have a specific partition key and sort key. Use the GetItem API operation to read a single item.
  • Use the Scan API operation with a filter expression that allows multiple items to be read. Use the Query API operation to read multiple items that have a specific partition key and sort key. Use the GetItem API operation to read a single item.
  • Use the Scan API operation with a filter expression that allows multiple items to be read. Use the Query API operation to read a single item that has a specific primary key. Use the BatchGetItem API operation to read multiple items.
  • Use the Scan API operation in parallel with many workers to read all the items. Use the Query API operation to read a single item that has a specific primary key Use the BatchGetItem API operation to read multiple items.

  Show Answer Answer: B Next

• Question 5

  A manufacturing company’s website uses an Amazon Aurora PostgreSQL DB cluster. Which configurations will result in the LEAST application downtime during a failover? (Choose three.)

  • Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
  • Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
  • Edit and enable Aurora DB cluster cache management in parameter groups.
  • Set TCP keepalive parameters to a high value.
  • Set JDBC connection string timeout variables to a low value.
  • Set Java DNS caching timeouts to a high value.

  Show Answer Answer: A,B,C Next