AWS Certified Database Specialty-(DBS-C01)
The AWS Certified Database Specialty-(DBS-C01) were last updated on today.
- Viewing page 7 out of 68 pages.
- Viewing questions 31-35 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 gaming company is evaluating Amazon ElastiCache as a solution to manage player leaderboards. Millions of players around the world will complete in annual tournaments. The company wants to implement an architecture that is highly available. The company also wants to ensure that maintenance activities have minimal impact on the availability of the gaming platform. Which combination of steps should the company take to meet these requirements? (Choose two.)
- A Deploy an ElastiCache for Redis cluster with read replicas and Multi-AZ enabled.
- B Deploy an ElastiCache for Memcached global datastore.
- C Deploy a single-node ElastiCache for Redis cluster with automatic backups enabled. In the event of a failure, create a new cluster and restore data from the most recent backup.
- D Use the default maintenance window to apply any required system changes and mandatory updates as soon as they are available.
- E Choose a preferred maintenance window at the time of lowest usage to apply any required changes and mandatory updates.
NOTE: Reference: https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/elasticache-use-cases.html
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 the CDC. Which solutions will reduce this latency? (Choose two.)
- A Configure the DMS task to run in full large binary object (LOB) mode.
- B Configure the DMS task to run in limited large binary object (LOB) mode.
- C Create a Multi-AZ replication instance.
- D Load tables in parallel by creating multiple replication instances for sets of tables that participate in common transactions.
- E Replicate tables in parallel by creating multiple DMS tasks for sets of tables that do not participate in common transactions.
NOTE:
A company's application development team wants to share an automated snapshot of its Amazon RDS database with another team. The database is encrypted with a custom AWS Key Management Service (AWS KMS) key under the "WeShare" AWS account. The application development team needs to share the DB snapshot under the "WeReceive" AWS account. Which combination of actions must the application development team take to meet these requirements? (Choose two.)
- A Add access from the "WeReceive" account to the custom AWS KMS key policy of the sharing team.
- B Make a copy of the DB snapshot, and set the encryption option to disable.
- C Share the DB snapshot by setting the DB snapshot visibility option to public.
- D Make a copy of the DB snapshot, and set the encryption option to enable.
- E Share the DB snapshot by using the default AWS KMS encryption key.
NOTE:
A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions. The company needs to generate connection logs, user logs, and user activity logs. The company also must make these logs available for future analysis. Which combination of steps should a database specialist take to meet these requirements? (Choose two.)
- A Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified log group in Amazon CloudWatch Logs.
- B Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified Amazon S3 bucket
- C Modify the cluster by enabling continuous delivery of AWS CloudTrail logs to Amazon S3.
- D Create a new parameter group with the enable_user_activity_logging parameter set to true. Configure the cluster to use the new parameter group.
- E Modify the system table to enable logging for each user.
NOTE:
A company has an application that uses an Amazon DynamoDB table as its data store. During normal business days, the throughput requirements from the application are uniform and consist of 5 standard write calls per second to the DynamoDB table. Each write call has 2 KB of data. For 1 hour each day, the company runs an additional automated job on the DynamoDB table that makes 20 write requests per second. No other application writes to the DynamoDB table. The DynamoDB table does not have to meet any additional capacity requirements. How should a database specialist configure the DynamoDB table's capacity to meet these requirements MOST cost-effectively?
- A Use DynamoDB provisioned capacity with 5 WCUs and auto scaling.
- B Use DynamoDB provisioned capacity with 5 WCUs and a write-through cache that DynamoDB Accelerator (DAX) provides.
- C Use DynamoDB provisioned capacity with 10 WCUs and auto scaling.
- D Use DynamoDB provisioned capacity with 10 WCUs and no auto scaling.
NOTE: Reference: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/AutoScaling.html
