Amazon DBS-C01 Online Practice Questions and Exam Preparation

Amazon DBS-C01 Online Questions & Answers

• Question 201:

  A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The solution should also automate configuration changes across all Regions.

  Which solution would meet these requirements and deploy the DynamoDB tables?

  A. Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
  B. Create an AWS CloudFormation template and deploy the template to all the Regions.
  C. Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
  D. Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-by- step guide for future deployments.
  C. Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.

  ---

  Explanation/Reference:

  https://aws.amazon.com/blogs/aws/use-cloudformation-stacksets-to-provision-resources- across-multiple-aws-accounts-and-regions/ https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/stacksets- concepts.html

• Question 202:

  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.
  A. Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified log group in Amazon CloudWatch Logs.
  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.

  ---

  Explanation/Reference:

  AWS CloudWatch Logs are stored indefinitely and CloudWatch Log Insights is used to analyze the logs and query upon them.

  https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/AnalyzingLogData.html https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/WhatIsCloudWatchLogs.htm l "Log retention -By default, logs are kept indefinitely and never expire. You can adjust the retention policy for each log group, keeping the indefinite retention, or choosing a retention period between 10 years and one day." https://docs.aws.amazon.com/redshift/latest/mgmt/db-auditing.html

• Question 203:

  A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To meet the company's disaster recovery policies, the database backup needs to be copied into another Region. The company requires the solution to be cost-effective and operationally efficient.

  What should a Database Specialist do to copy the database backup into a different Region?

  A. Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region
  B. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross- Region replication to copy the snapshot into another Region
  C. Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region
  D. Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot of the read replica
  C. Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region

  ---

  Explanation/Reference:

  System snapshot can't fulfill 6 hours requirement. You need to control it by script https://aws.amazon.com/blogs/database/%C2%AD%C2%AD%C2%ADautomating-cross- region-cross-account-snapshot-copies-with-the-snapshot-tool-foramazon-aurora/

• Question 204:

  A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.

  Which migration method should a Database Specialist use?

  A. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
  B. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
  C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
  D. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.
  C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.

  ---

  Explanation/Reference:

  https://aws.amazon.com/blogs/database/best-practices-for-migrating-rds-for-mysql- databases-to-amazon-aurora/

  https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Mi grating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica

• Question 205:

  A manufacturing company stores its inventory details in an Amazon DynamoDB table in the us-east-2 Region. According to new compliance and regulatory policies, the company is required to back up all of its tables nightly and store these backups in the us-west-2 Region for disaster recovery for 1 year.

  Which solution MOST cost-effectively meets these requirements?

  A. Convert the existing DynamoDB table into a global table and create a global table replica in the us-west-2 Region.
  B. Use AWS Backup to create a backup plan. Configure cross-Region replication in the plan and assign the DynamoDB table to this plan
  C. Create an on-demand backup of the DynamoDB table and restore this backup in the us- west-2 Region.
  D. Enable Amazon S3 Cross-Region Replication (CRR) on the S3 bucket where DynamoDB on-demand backups are stored.
  B. Use AWS Backup to create a backup plan. Configure cross-Region replication in the plan and assign the DynamoDB table to this plan

  ---

  Explanation/Reference:

  AWS Backup is a fully managed service that simplifies data protection across AWS services, in the cloud, and on premises. You can use AWS Backup to create backup plans that define how and when your backups are created, how long they are stored, and where they are replicated1. You can also use AWS Backup to monitor and audit your backup activity. Using AWS Backup to create a backup plan and configure cross-Region replication is a cost-effective solution for the company's requirements, as it can automate the nightly backup of the DynamoDB table and store the backups in the uswest-2 Region for one year. You can specify the source and destination Regions, the backup vault, and the retention period for your cross-Region replication rule in your backup plan2. You can also assign your DynamoDB table to your backup plan by using a resource assignment3.

• Question 206:

  The Development team recently executed a database script containing several data definition language (DDL) and data manipulation language (DML) statements on an Amazon Aurora MySQL DB cluster. The release accidentally deleted thousands of rows from an important table and broke some application functionality. This was discovered 4 hours after the release. Upon investigation, a Database Specialist tracked the issue to a DELETE command in the script with an incorrect WHERE clause filtering the wrong set of rows.

  The Aurora DB cluster has Backtrack enabled with an 8-hour backtrack window. The Database Administrator also took a manual snapshot of the DB cluster before the release started. The database needs to be returned to the correct state as quickly as possible to resume full application functionality. Data loss must be minimal. How can the Database Specialist accomplish this?

  A. Quickly rewind the DB cluster to a point in time before the release using Backtrack.
  B. Perform a point-in-time recovery (PITR) of the DB cluster to a time before the release and copy the deleted rows from the restored database to the original database.
  C. Restore the DB cluster using the manual backup snapshot created before the release and change the application configuration settings to point to the new DB cluster.
  D. Create a clone of the DB cluster with Backtrack enabled. Rewind the cloned cluster to a point in time before the release. Copy deleted rows from the clone to the original database.
  A. Quickly rewind the DB cluster to a point in time before the release using Backtrack.

• Question 207:

  A company uses the Amazon DynamoDB table contractDB in us-east-1 for its contract system with the following schema:

  orderID (primary key) timestamp (sort key) contract (map) createdBy (string) customerEmail (string)

  After a problem in production, the operations team has asked a database specialist to provide an IAM policy to read items from the database to debug the application. In addition, the developer is not allowed to access the value of the customerEmail field to stay compliant.

  Which IAM policy should the database specialist use to achieve these requirements?

  

  

  

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

  ---

  Explanation/Reference:

• Question 208:

  A gaming company is designing a mobile gaming app that will be accessed by many users across the globe. The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users.

  Which solution meets these requirements?

  A. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling
  B. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
  C. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
  D. Use Amazon Neptune for storage
  A. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling

  ---

  Explanation/Reference:

  Reference: https://aws.amazon.com/blogs/database/how-to-use-amazon-dynamodb- global-tables-to-power- multiregion-architectures/

• Question 209:

  A company's database specialist is building an Amazon RDS for Microsoft SQL Server DB instance to store hundreds of records in CSV format. A customer service tool uploads the records to an Amazon S3 bucket.

  An employee who previously worked at the company already created a custom stored procedure to map the necessary CSV fields to the database tables. The database specialist needs to implement a solution that reuses this previous work

  and minimizes operational overhead.

  Which solution will meet these requirements?

  A. Create an Amazon S3 event to invoke an AWS Lambda function. Configure the Lambda function to parse the .csv file and use a SQL client library to run INSERT statements to load the data into the tables.
  B. Write a custom .NET app that is hosted on Amazon EC2. Configure the .NET app to load the .csv file and call the custom stored procedure to insert the data into the tables.
  C. Download the .csv file from Amazon S3 to the RDS D drive by using an AWS msdb stored procedure. Call the custom stored procedure to insert the data from the RDS D drive into the tables.
  D. Create an Amazon S3 event to invoke AWS Step Functions to parse the .csv file and call the custom stored procedure to insert the data into the tables.
  C. Download the .csv file from Amazon S3 to the RDS D drive by using an AWS msdb stored procedure. Call the custom stored procedure to insert the data from the RDS D drive into the tables.

  ---

  Explanation/Reference:

  Step 1: Download S3 Files

  Amazon RDS for SQL Server comes with several custom stored procedures and functions. These are located in the msdb database. The stored procedure to download files from S3 is "rds_download_from_s3". The syntax for this stored

  procedure is shown here:

  exec msdb.dbo.rds_download_from_s3

  @s3_arn_of_file='arn:aws:s3:::/', @rds_file_path='D:\S3\\', @overwrite_file=1;

• Question 210:

  A company uses a large, growing, and high performance on-premises Microsoft SQL Server instance With an Always On availability group cluster size of 120 TIE. The company uses a third-party backup product that requires system-level access to the databases. The company will continue to use this third-party backup product in the future.

  The company wants to move the DB cluster to AWS with the least possible downtime and data loss. The company needs a 2 Gbps connection to sustain Always On asynchronous data replication between the company's data center and AWS.

  Which combination of actions should a database specialist take to meet these requirements? (Select THREE.)

  A. Establish an AWS Direct Connect hosted connection between the companfs data center and AWS
  B. Create an AWS Site-to-Site VPN connection between the companVs data center and AWS over the internet
  C. Use AWS Database Migration Service (AWS DMS) to migrate the on-premises SQL Server databases to Amazon RDS for SQL Server Configure Always On availability groups for SQL Server.
  D. Deploy a new SQL Server Always On availability group DB cluster on Amazon EC2 Configure Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster_ Fail over to the AWS DB cluster when it is time to migrate.
  E. Grant system-level access to the third-party backup product to perform backups of the Amazon RDS for SQL Server DB instance.
  F. Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2.
  A. Establish an AWS Direct Connect hosted connection between the companfs data center and AWS
  D. Deploy a new SQL Server Always On availability group DB cluster on Amazon EC2 Configure Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster_ Fail over to the AWS DB cluster when it is time to migrate.
  F. Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2.

  ---

  Explanation/Reference:

  The best combination of actions to meet the company's requirements are:

  A. Establish an AWS Direct Connect hosted connection between the company's data center and AWS. This will provide a secure and high-bandwidth connection for the Always On data replication and minimize the network latency and data loss. D. Deploy a new SQL Server Always On availability group DB cluster on Amazon EC2. Configure Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster. Fail over to the AWS DB cluster when it is time to migrate. This will allow the company to use the same SQL Server version and edition as on-premises, and leverage the distributed availability group feature to span two separate availability groups across different locations. The failover process will be fast and seamless, with minimal downtime and data loss. F. Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2. This will enable the company to continue using their existing backup solution, which requires system-level access to the databases. Amazon RDS for SQL Server does not support system-level access, so it is not a suitable option for this requirement.