Amazon DBS-C01 Online Practice Questions and Exam Preparation

Amazon DBS-C01 Online Questions & Answers

• Question 111:

  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?

  A. Use AWS Glue to crawl the data in the DynamoDB table. Create a job using an available blueprint to export the data to Amazon S3. Import the data from the S3 file to a DynamoDB table in the new account.
  B. Create an AWS Lambda function to scan the items of the DynamoDB table in the current account and write to a file in Amazon S3. Create another Lambda function to read the S3 file and restore the items of a DynamoDB table in the new account.
  C. Use AWS Data Pipeline in the current account to export the data from the DynamoDB table to a file in Amazon S3. Use Data Pipeline to import the data from the S3 file to a DynamoDB table in the new account.
  D. Configure Amazon DynamoDB Streams for the DynamoDB table in the current account. Create an AWS Lambda function to read from the stream and write to a file in Amazon S3. Create another Lambda function to read the S3 file and restore the items to a DynamoDB table in the new account.
  C. Use AWS Data Pipeline in the current account to export the data from the DynamoDB table to a file in Amazon S3. Use Data Pipeline to import the data from the S3 file to a DynamoDB table in the new account.

  ---

  Explanation/Reference:

  https://aws.amazon.com/premiumsupport/knowledge-center/dynamodb-cross-account- migration/ https://aws.amazon.com/premiumsupport/knowledge-center/data-pipeline-account-access- dynamodb-s3/

• Question 112:

  A gaming company is developing a new mobile game and decides to store the data for each user in Amazon DynamoDB. To make the registration process as easy as possible, users can log in with their existing Facebook or Amazon accounts. The company expects more than 10,000 users.

  How should a database specialist implement access control with the LEAST operational effort?

  A. Use web identity federation on the mobile app and AWS STS with an attached IAM role to get temporary credentials to access DynamoDB.
  B. Use web identity federation on the mobile app and create individual IAM users with credentials to access DynamoDB.
  C. Use a self-developed user management system on the mobile app that lets users access the data from DynamoDB through an API.
  D. Use a single IAM user on the mobile app to access DynamoDB.
  A. Use web identity federation on the mobile app and AWS STS with an attached IAM role to get temporary credentials to access DynamoDB.

  ---

  Explanation/Reference:

  Reference: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/WIF.html

• Question 113:

  A company is developing an application that performs intensive in-memory operations on advanced data structures such as sorted sets. The application requires sub-millisecond latency for reads and writes. The application occasionally must run a group of commands as an ACID-compliant operation. A database specialist is setting up the database for this application. The database specialist needs the ability to create a new database cluster from the latest backup of the production cluster.

  Which type of cluster should the database specialist create to meet these requirements?

  A. Amazon ElastiCache for Memcached
  B. Amazon Neptune
  C. Amazon ElastiCache for Redis
  D. Amazon DynamoDB Accelerator (DAX)
  C. Amazon ElastiCache for Redis

  ---

  Explanation/Reference:

  https://aws.amazon.com/elasticache/redis-vs-memcached/ https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/elasticache-use- cases.html #elasticache-for-redis-use-cases-gaming

• Question 114:

  A gaming company has recently acquired a successful iOS game, which is particularly popular during the holiday season. The company has decided to add a leaderboard to the game that uses Amazon DynamoDB. The application load is expected to ramp up over the holiday season.

  Which solution will meet these requirements at the lowest cost?

  A. DynamoDB Streams
  B. DynamoDB with DynamoDB Accelerator
  C. DynamoDB with on-demand capacity mode
  D. DynamoDB with provisioned capacity mode with Auto Scaling
  C. DynamoDB with on-demand capacity mode

  ---

  Explanation/Reference:

  Reference: https://aws.amazon.com/blogs/database/running-spiky-workloads-and- optimizing-costs-by-more- than-90-using-amazon-dynamodb-on-demand-capacity- mode/?nc1=b_rp

• Question 115:

  A web-based application uses Amazon DocumentDB (with MongoDB compatibility) as its underlying data store. Sufficient access control IS in place, but a database specialist wants to be able to review logs if the primary DocumentDB database is deleted.

  Which combination of steps Should the database specialist take to meet this requirement? (Select TWO_)

  A. Set the audit_logs cluster parameter to enabled
  B. Enable DocumentDB log export to Amazon CloudWatch Logs.
  C. Enable Enhanced Monitoring tor DocumentDB.
  D. Enable AWS CloudTrail for DocumentDB.
  E. use AWS Config to monitor the state of DocumentDB.
  A. Set the audit_logs cluster parameter to enabled
  B. Enable DocumentDB log export to Amazon CloudWatch Logs.

  ---

  Explanation/Reference:

  Option A is correct because it sets the audit_logs cluster parameter to enabled. This enables auditing on the DocumentDB cluster, which records events that were performed in the cluster, such as successful and failed authentication

  attempts, dropping a collection in a database, or creating an index1. By enabling auditing, the database specialist can review the logs to see who and when deleted the primary DocumentDB database, and what other actions were taken on

  the cluster.

  Option B is correct because it enables DocumentDB log export to Amazon CloudWatch Logs. This allows the DocumentDB cluster to export its auditing records (JSON documents) to Amazon CloudWatch Logs, where they can be analyzed,

  monitored, and archived1. By enabling log export, the database specialist can access the logs even if the primary DocumentDB database is deleted, as they are stored in a separate service.

• Question 116:

  A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL.

  The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.

  How should the Database Specialist edit the script to fix this issue?

  A. Stop the source instances before stopping their read replicas
  B. Delete each read replica before stopping its corresponding source instance
  C. Stop the read replicas before stopping their source instances
  D. Use the AWS CLI to stop each read replica and source instance at the same time
  B. Delete each read replica before stopping its corresponding source instance

  ---

  Explanation/Reference:

  https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html "The following are some limitations to stopping and starting a DB instance: You can't stop a DB instance that has a read replica, or that is a read replica." So if you cant stop a db with a read replica, you have to delete the read replica first to then stop it??? https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MySQL.Replication.R eadReplicas.html#USER_MySQL.Replication.ReadReplicas.StartStop

• Question 117:

  Application developers have reported that an application is running slower as more users are added. The application database is running on an Amazon Aurora

  DB cluster with an Aurora Replica. The application is written to take advantage of read scaling through reader endpoints. A database specialist looks at the performance metrics of the database and determines that, as new users were added

  to the database, the primary instance CPU utilization steadily increased while the Aurora Replica CPU utilization remained steady.

  How can the database specialist improve database performance while ensuring minimal downtime?

  A. Modify the Aurora DB cluster to add more replicas until the overall load stabilizes. Then, reduce the number of replicas once the application meets service level objectives.
  B. Modify the primary instance to a larger instance size that offers more CPU capacity.
  C. Modify a replica to a larger instance size that has more CPU capacity. Then, promote the modified replica.
  D. Restore the Aurora DB cluster to one that has an instance size with more CPU capacity. Then, swap the names of the old and new DB clusters.
  C. Modify a replica to a larger instance size that has more CPU capacity. Then, promote the modified replica.

  ---

  Explanation/Reference:

• Question 118:

  A company's database specialist disabled TLS on an Amazon DocumentDB cluster to perform benchmarking tests. A few days after this change was implemented, a database specialist trainee accidentally deleted multiple tables. The database specialist restored the database from available snapshots. An hour after restoring the cluster, the database specialist is still unable to connect to the new cluster endpoint.

  What should the database specialist do to connect to the new, restored Amazon DocumentDB cluster?

  A. Change the restored cluster's parameter group to the original cluster's custom parameter group.
  B. Change the restored cluster's parameter group to the Amazon DocumentDB default parameter group.
  C. Configure the interface VPC endpoint and associate the new Amazon DocumentDB cluster.
  D. Run the syncInstances command in AWS DataSync.
  A. Change the restored cluster's parameter group to the original cluster's custom parameter group.

  ---

  Explanation/Reference:

  You can't modify the parameter settings of the default parameter groups. You can use a DB parameter group to act as a container for engine configuration values that are applied to one or more DB instances. If you create a DB instance without specifying a DB parameter group, the DB instance uses a default DB parameter group. Each default DB parameter group contains database engine defaults and Amazon RDS system defaults. You can't modify the parameter settings of a default parameter group. Instead, you create your own parameter group where you choose your own parameter settings. Not all DB engine parameters can be changed in a parameter group that you create.

• Question 119:

  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.)

  A. Re-create global secondary indexes in the new table
  B. Define IAM policies for access to the new table
  C. Define the TTL settings
  D. Encrypt the table from the AWS Management Console or use the update-table command
  E. Set the provisioned read and write capacity
  B. Define IAM policies for access to the new table
  C. Define the TTL settings

  ---

  Explanation/Reference:

  The following items need to be reconfigured after restoring the DynamoDB table. --AutoScaling policy --IAM policy --CloudWatch settings --Tags --Stream settings --TTL https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/backuprestore_Ho wItWorks.html

• Question 120:

  A company is using AWS CloudFormation to provision and manage infrastructure resources, including a production database. During a recent CloudFormation stack update, a database specialist observed that changes were made to a database resource that is named ProductionDatabase. The company wants to prevent changes to only ProductionDatabase during future stack updates.

  Which stack policy will meet this requirement?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

  ---

  Explanation/Reference: