Amazon DBS-C01 Exam Dumps

Amazon DBS-C01 Sample Question Answers

Amazon DBS-C01 Sample Questions

Question # 1

In North America, a business launched a mobile game that swiftly expanded to 10 milliondaily active players. The game's backend is hosted on AWS and makes considerable useof a TTL-configured Amazon DynamoDB table.When an item is added or changed, its TTL is set to 600 seconds plus the current epochtime. The game logic is reliant on the purging of outdated data in order to compute rewardspoints properly. At times, items from the table are read that are many hours beyond theirTTL expiration.How should a database administrator resolve this issue?

A. Use a client library that supports the TTL functionality for DynamoDB. 
B. Include a query filter expression to ignore items with an expired TTL. 
C. Set the ConsistentRead parameter to true when querying the table. 
D. Create a local secondary index on the TTL attribute. 

Answer: B

Show Answer

Question # 2

A Database Specialist needs to define a database migration strategy to migrate an onpremises Oracle database to an Amazon Aurora MySQL DB cluster. The company requiresnear-zero downtime for the data migration. The solution must also be cost-effective.Which approach should the Database Specialist take?

A. Dump all the tables from the Oracle database into an Amazon S3 bucket usingdatapump (expdp). Run data transformations in AWS Glue. Load the data from the S3bucket to the Aurora DB cluster. 
B. Order an AWS Snowball appliance and copy the Oracle backup to the Snowballappliance. Once the Snowball data is delivered to Amazon S3, create a new Aurora DBcluster. Enable the S3 integration to migrate the data directly from Amazon S3 to AmazonRDS. 
C. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects toMySQL during the schema migration. Use AWS DMS to perform the full load and changedata capture (CDC) tasks. 
D. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machineimage as an Amazon EC2 instance. Use the Oracle Logical Dump utility to migrate theOracle data from Amazon EC2 to an Aurora DB cluster. 

Answer: C

Show Answer

Question # 3

A business is transferring its on-premises database workloads to the Amazon WebServices (AWS) Cloud. A database professional migrating an Oracle database with a hugetable to Amazon RDS has picked AWS DMS. The database professional observes thatAWS DMS is consuming considerable time migrating the data.Which activities would increase the pace of data migration? (Select three.)

A. Create multiple AWS DMS tasks to migrate the large table. 
B. Configure the AWS DMS replication instance with Multi-AZ. 
C. Increase the capacity of the AWS DMS replication server. 
D. Establish an AWS Direct Connect connection between the on-premises data center andAWS. 
E. Enable an Amazon RDS Multi-AZ configuration. 
F. Enable full large binary object (LOB) mode to migrate all LOB data for all large tables. 

Answer: A,C,D

Show Answer

Question # 4

A significant automotive manufacturer is switching a mission-critical finance application'sdatabase to Amazon DynamoDB. According to the company's risk and compliance policy,any update to the database must be documented as a log entry for auditing purposes.Each minute, the system anticipates about 500,000 log entries. Log entries should be keptin Apache Parquet files in batches of at least 100,000 records per file.How could a database professional approach these needs while using DynamoDB?

A. Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda functiontriggered by the stream. Write the log entries to an Amazon S3 object. 
B. Create a backup plan in AWS Backup to back up the DynamoDB table once a day.Create an AWS Lambda function that restores the backup in another table and comparesboth tables for changes. Generate the log entries and write them to an Amazon S3 object. 
C. Enable AWS CloudTrail logs on the table. Create an AWS Lambda function that readsthe log files once an hour and filters DynamoDB API actions. Write the filtered log files toAmazon S3. 
D. Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda functiontriggered by the stream. Write the log entries to an Amazon Kinesis Data Firehose deliverystream with buffering and Amazon S3 as the destination. 

Answer: D

Show Answer

Question # 5

A business need a data warehouse system that stores data consistently and in a highlyorganized fashion. The organization demands rapid response times for end-user inquiriesincluding current-year data, and users must have access to the whole 15-year datasetwhen necessary. Additionally, this solution must be able to manage a variable volume ofincoming inquiries. Costs associated with storing the 100 TB of data must be maintained toa minimum.Which solution satisfies these criteria?

A. Leverage an Amazon Redshift data warehouse solution using a dense storage instancetype while keeping all the data on local Amazon Redshift storage. Provision enoughinstances to support high demand. 
B. Leverage an Amazon Redshift data warehouse solution using a dense storage instanceto store the most recent data. Keep historical data on Amazon S3 and access it using theAmazon Redshift Spectrum layer. Provision enough instances to support high demand. 
C. Leverage an Amazon Redshift data warehouse solution using a dense storage instanceto store the most recent data. Keep historical data on Amazon S3 and access it using theAmazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling. 
D. Leverage an Amazon Redshift data warehouse solution using a dense storage instanceto store the most recent data. Keep historical data on Amazon S3 and access it using theAmazon Redshift Spectrum layer. Leverage Amazon Redshift elastic resize. 

Answer: C

Show Answer

Question # 6

A company is due for renewing its database license. The company wants to migrate its 80TB transactional database system from on-premises to the AWS Cloud. The migrationshould incur the least possible downtime on the downstream database applications. Thecompany’s network infrastructure has limited network bandwidth that is shared with otherapplications.Which solution should a database specialist use for a timely migration?

A. Perform a full backup of the source database to AWS Snowball Edge appliances andship them to be loaded to Amazon S3. Use AWS DMS to migrate change data capture(CDC) data from the source database to Amazon S3. Use a second AWS DMS task tomigrate all the S3 data to the target database. 
B. Perform a full backup of the source database to AWS Snowball Edge appliances andship them to be loaded to Amazon S3. Periodically perform incremental backups of thesource database to be shipped in another Snowball Edge appliance to handle syncingchange data capture (CDC) data from the source to the target database. 
C. Use AWS DMS to migrate the full load of the source database over a VPN tunnel usingthe internet for its primary connection. Allow AWS DMS to handle syncing change datacapture (CDC) data from the source to the target database. 
D. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the full load of thesource database over a VPN tunnel using the internet for its primary connection. AllowAWS SCT to handle syncing change data capture (CDC) data from the source to the targetdatabase. 

Answer: A

Show Answer

Question # 7

The website of a manufacturing firm makes use of an Amazon Aurora PostgreSQLdatabase cluster.Which settings will result in the LEAST amount of downtime for the application duringfailover? (Select three.)

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

Answer: A,C,E

Show Answer

Question # 8

A database specialist needs to configure an Amazon RDS for MySQL DB instance to closenon-interactive connections that are inactive after 900 seconds.What should the database specialist do to accomplish this task?

A. Create a custom DB parameter group and set the wait_timeout parameter value to 900.Associate the DB instance with the custom parameter group
B. Connect to the MySQL database and run the SET SESSION wait_timeout=900command. 
C. Edit the my.cnf file and set the wait_timeout parameter value to 900. Restart the DBinstance. 
D. Modify the default DB parameter group and set the wait_timeout parameter value to900. 

Answer: A

Show Answer

Question # 9

A database specialist is responsible for an Amazon RDS for MySQL DB instance with oneread replica. The DB instance and the read replica are assigned to the default parametergroup. The database team currently runs test queries against a read replica. The databaseteam wants to create additional tables in the read replica that will only be accessible fromthe read replica to benefit the tests.Which should the database specialist do to allow the database team to create the testtables?

A. Contact AWS Support to disable read-only mode on the read replica. Reboot the readreplica. Connect to the read replica and create the tables. 
B. Change the read_only parameter to false (read_only=0) in the default parameter groupof the read replica. Perform a reboot without failover. Connect to the read replica andcreate the tables using the local_only MySQL option. 
C. Change the read_only parameter to false (read_only=0) in the default parameter group.Reboot the read replica. Connect to the read replica and create the tables. 
D. Create a new DB parameter group. Change the read_only parameter to false(read_only=0). Associate the read replica with the new group. Reboot the read replica.Connect to the read replica and create the tables. 

Answer: D

Show Answer

Question # 10

A ride-hailing application stores bookings in a persistent Amazon RDS for MySQL DBinstance. This program is very popular, and the corporation anticipates a tenfold rise in theapplication's user base over the next several months. The application receives a highervolume of traffic in the morning and evening.This application is divided into two sections:An internal booking component that takes online reservations in response to concurrentuser queries.A component of a third-party customer relationship management (CRM) system thatcustomer service professionals utilize. Booking data is accessed using queries in the CRM.To manage this workload effectively, a database professional must create a cost-effectivedatabase system.Which solution satisfies these criteria?

A. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambdafunction to capture changes and push the booking data to the RDS for MySQL DB instanceused by the CRM. 
B. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams andassociate an AWS Lambda function to capture changes and push the booking data to anAmazon SQS queue. This triggers another Lambda function that pulls data from AmazonSQS and writes it to the RDS for MySQL DB instance used by the CRM. 
C. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambdafunction to capture changes and push the booking data to an Amazon Redshift databaseused by the CRM. 
D. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams andassociate an AWS Lambda function to capture changes and push the booking data toAmazon Athena, which is used by the CRM. 

Answer: B

Show Answer