Exam Details

  • Exam Code
    :DBS-C01
  • Exam Name
    :AWS Certified Database - Specialty (DBS-C01)
  • Certification
    :Amazon Certifications
  • Vendor
    :Amazon
  • Total Questions
    :321 Q&As
  • Last Updated
    :Apr 22, 2025

Amazon Amazon Certifications DBS-C01 Questions & Answers

  • Question 21:

    A retail company is about to migrate its online and mobile store to AWS. The company's CEO has strategic plans to grow the brand globally. A Database Specialist has been challenged to provide predictable read and write database performance with minimal operational overhead.

    What should the Database Specialist do to meet these requirements?

    A. Use Amazon DynamoDB global tables to synchronize transactions

    B. Use Amazon EMR to copy the orders table data across Regions

    C. Use Amazon Aurora Global Database to synchronize all transactions

    D. Use Amazon DynamoDB Streams to replicate all DynamoDB transactions and sync them

  • Question 22:

    A business that specializes in internet advertising is developing an application that will show adverts to its customers. The program stores data in an Amazon DynamoDB database. Additionally, the application caches its reads using a

    DynamoDB Accelerator (DAX) cluster. The majority of reads come via the GetItem and BatchGetItem queries. The application does not need consistency of readings.

    The application cache does not behave as intended after deployment. Specific extremely consistent queries to the DAX cluster are responding in several milliseconds rather than microseconds.

    How can the business optimize cache behavior in order to boost application performance?

    A. Increase the size of the DAX cluster.

    B. Configure DAX to be an item cache with no query cache

    C. Use eventually consistent reads instead of strongly consistent reads.

    D. Create a new DAX cluster with a higher TTL for the item cache.

  • Question 23:

    A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table. TTL is enabled on one of the attributes. The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.

    What is the MOST likely reason that the items are not being deleted?

    A. The TTL attribute's value is set as a Number data type.

    B. The TTL attribute's value is set as a Binary data type.

    C. The TTL attribute's value is a timestamp in the Unix epoch time format in seconds.

    D. The TTL attribute's value is set with an expiration of 1 year.

  • Question 24:

    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.

  • Question 25:

    A worldwide digital advertising corporation collects browser information in order to provide targeted visitors with contextually relevant pictures, websites, and connections. A single page load may create many events, each of which must be kept separately. A single event may have a maximum size of 200 KB and an average size of 10 KB. Each page load requires a query of the user's browsing history in order to deliver suggestions for targeted advertising. The advertising corporation anticipates daily page views of more than 1 billion from people in the United States, Europe, Hong Kong, and India. The information structure differs according to the event. Additionally, browsing information must be written and read with a very low latency to guarantee that consumers have a positive viewing experience.

    Which database solution satisfies these criteria?

    A. Amazon DocumentDB

    B. Amazon RDS Multi-AZ deployment

    C. Amazon DynamoDB global table

    D. Amazon Aurora Global Database

  • Question 26:

    An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.

    Which settings will meet this requirement? (Choose three.)

    A. Set DeletionProtection to True

    B. Set MultiAZ to True

    C. Set TerminationProtection to True

    D. Set DeleteAutomatedBackups to False

    E. Set DeletionPolicy to Delete

    F. Set DeletionPolicy to Retain

  • Question 27:

    An worldwide gaming company's development team is experimenting with using Amazon DynamoDB to store in-game events for three mobile titles. Maximum concurrent users for the most popular game is 500,000, while the least popular game is 10,000. The typical event is 20 KB in size, while the average user session generates one event each second. Each event is assigned a millisecond time stamp and a globally unique identification.

    The lead developer generated a single DynamoDB database with the following structure for the events: Partition key: game name Sort key: event identifier Local secondary index: player identifier Event time

    In a small-scale development setting, the tests were successful. When the application was deployed to production, however, new events were not being added to the database, and the logs indicated DynamoDB failures with the ItemCollectionSizeLimitExceededException issue code.

    Which design modification should a database professional offer to the development team?

    A. Use the player identifier as the partition key. Use the event time as the sort key. Add a global secondary index with the game name as the partition key and the event time as the sort key.

    B. Create two tables. Use the game name as the partition key in both tables. Use the event time as the sort key for the first table. Use the player identifier as the sort key for the second table.

    C. Replace the sort key with a compound value consisting of the player identifier collated with the event time, separated by a dash. Add a local secondary index with the player identifier as the sort key.

    D. Create one table for each game. Use the player identifier as the partition key. Use the event time as the sort key.

  • Question 28:

    A company runs hundreds of Microsoft SQL Server databases on Windows servers in its on-premises data center. A database specialist needs to migrate these databases to Linux on AWS. Which combination of steps should the database specialist take to meet this requirement? (Choose three.)

    A. Install AWS Systems Manager Agent on the on-premises servers. Use Systems Manager Run Command to install the Windows to Linux replatforming assistant for Microsoft SQL Server Databases.

    B. Use AWS Systems Manager Run Command to install and configure the AWS Schema Conversion Tool on the on-premises servers.

    C. On the Amazon EC2 console, launch EC2 instances and select a Linux AMI that includes SQL Server. Install and configure AWS Systems Manager Agent on the EC2 instances.

    D. On the AWS Management Console, set up Amazon RDS for SQL Server DB instances with Linux as the operating system. Install AWS Systems Manager Agent on the DB instances by using an options group.

    E. Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration.

    F. On the AWS Management Console, set up AWS Database Migration Service (AWS DMS) by entering details of the source SQL Server database and the destination SQL Server database on AWS. Start migration.

  • Question 29:

    A global company is developing an application across multiple AWS Regions. The company needs a database solution with low latency in each Region and automatic disaster recovery. The database must be deployed in an active-active configuration with automatic data synchronization between Regions.

    Which solution will meet these requirements with the LOWEST latency?

    A. Amazon RDS with cross-Region read replicas

    B. Amazon DynamoDB global tables

    C. Amazon Aurora global database

    D. Amazon Athena and Amazon S3 with S3 Cross Region Replication

  • Question 30:

    A company has an application that uses an Amazon DynamoDB table to store user data. Every morning, a single-threaded process calls the DynamoDB API Scan operation to scan the entire table and generate a critical start-of-day report for management. A successful marketing campaign recently doubled the number of items in the table, and now the process takes too long to run and the report is not generated in time.

    A database specialist needs to improve the performance of the process. The database specialist notes that, when the process is running, 15% of the table's provisioned read capacity units (RCUs) are being used.

    What should the database specialist do?

    A. Enable auto scaling for the DynamoDB table.

    B. Use four threads and parallel DynamoDB API Scan operations.

    C. Double the table's provisioned RCUs.

    D. Set the Limit and Offset parameters before every call to the API.

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Amazon exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your DBS-C01 exam preparations and Amazon certification application, do not hesitate to visit our Vcedump.com to find your solutions here.