Home
Amazon
DBS-C01: AWS Certified Database - Specialty Dumps

Free Amazon DBS-C01 Exam Dumps

Here you can find all the free questions related with Amazon AWS Certified Database - Specialty (DBS-C01) exam. You can also find on this page links to recently updated premium files with which you can practice for actual Amazon AWS Certified Database - Specialty Exam. These premium versions are provided as DBS-C01 exam practice tests, both as desktop software and browser based application, you can use whatever suits your style. Feel free to try the AWS Certified Database - Specialty Exam premium files for free, Good luck with your Amazon AWS Certified Database - Specialty Exam.

Question No: 1

MultipleChoice

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

Options

ASet the audit_logs cluster parameter to enabled

BEnable DocumentDB log export to Amazon CloudWatch Logs.

CEnable Enhanced Monitoring tor DocumentDB.

DEnable AWS CloudTrail for DocumentDB.

Euse AWS Config to monitor the state of DocumentDB.

Answer
A, BExplanation

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 No: 2

MultipleChoice

A company's application team needs to select an AWS managed database service to store application and user dat

a. The application team is familiar with MySQL but is open to new solutions. The application and user data is stored in 10 tables and is de-normalized. The application will access this data through an API layer using an unique ID in each table. The company expects the traffic to be light at first, but the traffic Will Increase to thousands of transactions each second within the first year- The database service must support active reads and writes in multiple AWS Regions at the same time_ Query response times need to be less than 100 ms Which AWS database solution will meet these requirements?

Options

ADeploy an Amazon RDS for MySQL environment in each Region and leverage AWS Database Migration Service (AWS DMS) to set up a multi-Region bidirectional replication

BDeploy an Amazon Aurora MySOL global database with write forwarding turned on

CDeploy an Amazon DynamoDB database with global tables

DDeploy an Amazon DocumentDB global cluster across multiple Regions.

Answer
C

Question No: 3

MultipleChoice

A company is running a mobile app that has a backend database in Amazon DynamoDB. The app experiences sudden increases and decreases in activity throughout the day. The companys operations team notices that DynamoDB read and write requests are being throttled at different times, resulting in a negative customer experience

Which solution will solve the throttling issue without requiring changes to the app?

Options

AAdd a DynamoD3 table in a secondary AWS Region. Populate the additional table by using DynamoDB Streams.

BDeploy an Amazon ElastiCache cluster in front of the DynamoDB table.

Cuse on-demand capacity mode tor the DynamoDB table.
D, use DynamoDB Accelerator (DAX).

Answer
CExplanation

Option C is correct because it solves the throttling issue without requiring changes to the app. On-demand capacity mode is a flexible billing option for DynamoDB that automatically accommodates your workload as it ramps up or down. With on-demand mode, you pay per request for the data reads and writes your application performs on your tables, and you don't need to specify how much read and write throughput you expect.On-demand mode can handle sudden increases and decreases in activity without throttling, as long as the request rate does not exceed the default table quotas1.To use on-demand mode, you only need to update the table settings in the AWS Management Console or by using the AWS SDK2. You don't need to modify any application logic, as on-demand mode is compatible with existing DynamoDB API calls.

Question No: 4

MultipleChoice

A social media company recently launched a new feature that gives users the ability to share live feeds of their daily activities with their followers. The company has an Amazon RDS for

MySOL DB instance that stores data about follower engagement

After the new feature launched, the company noticed high CPU utilization and high database latency during reads and writes. The company wants to implement a solution that will identify the source of the high CPU utilization.

Which solution will meet these requirements with the LEAST administrative oversight?

Options

AUse Amazon DevOps Guru insights_

BUse AWS CloudTrail

CUse Amazon CloudWatch Logs

DUse Amazon Aurora Database Activity Streams

Answer
AExplanation

Amazon DevOps Guru is a service that helps you identify and troubleshoot performance issues and operational risks in your AWS applications. DevOps Guru uses machine learning to analyze data from various sources, such as Amazon CloudWatch metrics, AWS CloudTrail events, and Amazon RDS performance events, to detect anomalous behavior and generate insights. Insights provide a summary of the issue, the affected resources, the severity, the start and end time, and recommendations for remediation. DevOps Guru can also send notifications to Amazon Simple Notification Service (SNS) topics or AWS Chatbot channels when insights are created or updated.

Using DevOps Guru insights is a suitable solution for the social media company because it can help them identify the source of the high CPU utilization and high database latency in their Amazon RDS for MySQL DB instance with minimal administrative oversight. DevOps Guru can automatically monitor their application and generate insights when it detects any operational issues or risks. The company can then use the recommendations provided by DevOps Guru to resolve the issue and improve their application performance.

Question No: 5

MultipleChoice

A financial company is hosting its web application on AWS. The application's database is hosted on Amazon RDS for MySQL with automated backups enabled.

The application has caused a logical corruption of the database, which is causing the application to become unresponsive. The specific time of the corruption has been identified, and it was within the backup retention period.

How should a database specialist recover the database to the most recent point before corruption?

Options

AUse the point-in-time restore capability to restore the DB instance to the specified time. No changes to the application connection string are required.

BUse the point-in-time restore capability to restore the DB instance to the specified time. Change the application connection string to the new, restored DB instance.

CRestore using the latest automated backup. Change the application connection string to the new, restored DB instance.

DRestore using the appropriate automated backup. No changes to the application connection string are required.

Answer
BExplanation

The point-in-time restore capability of Amazon RDS for MySQL allows you to create a new DB instance with the same configuration as the original one, but with data restored to a specific time within your backup retention period.You can specify any time within your backup retention period, up to the last five minutes of your DB instance's usage1. This feature is useful for recovering from logical corruption or user errors that affect your database.

However, when you use the point-in-time restore capability, you are creating a new DB instance with a different endpoint. Therefore, you need to change the application connection string to point to the new, restored DB instance.You can also delete or rename the original DB instance if you no longer need it1

Question No: 6

MultipleChoice

A financial services company is using AWS Database Migration Service (AWS OMS) to migrate Its databases from on-premises to AWS. A database administrator is working on replicating a database to AWS from on-premises using full load and change data capture (CDC). During the CDC replication, the database administrator observed that the target latency was high and slowly increasing-

What could be the root causes for this high target latency? (Select TWO.)

Options

AThere was ongoing maintenance on the replication instance

BThe source endpoint was changed by modifyng the task

CLoopback changes had affected the source and target instances-

DThere was no primary key or index in the target database.

EThere were resource bottlenecks in the replication instance

Answer
D, EExplanation

Target latency is the amount of time that AWS DMS takes to apply changes from the source database to the target database1. High target latency can indicate performance issues or replication errors in the AWS DMS task.

One possible cause of high target latency is the lack of a primary key or index in the target database. A primary key or index helps AWS DMS identify and apply changes to the corresponding rows in the target database.Without a primary key or index, AWS DMS has to scan the entire table to find the matching rows, which can increase the target latency and consume more CPU and memory resources2.

Another possible cause of high target latency is the resource bottlenecks in the replication instance. The replication instance is the compute resource that runs the AWS DMS task and connects to the source and target endpoints. If the replication instance is under-provisioned or overloaded, it can affect the replication performance and cause high target latency.Some factors that can contribute to resource bottlenecks are insufficient network bandwidth, low disk space, high CPU utilization, or large transaction sizes3.

Question No: 7

MultipleChoice

A marketing company is developing an application to track responses to email message campaigns. The company needs a database storage solution that is optimized to work with highly connected dat

a. The database needs to limit connections and programmatic access to the data by using IAM policies.

Which solution will meet these requirements?

Options

AAmazon ElastiCache for Redis cluster

BAmazon Aurora MySQL DB cluster

CAmazon DynamoDB table

DAmazon Neptune DB cluster

Answer
DExplanation

Amazon Neptune is a fast, reliable, fully managed graph database service that makes it easy to build and run applications that work with highly connected data sets1.Graph databases are designed to store and query data that has complex relationships and interconnections, such as social networks, recommendation engines, fraud detection, and knowledge graphs2.Amazon Neptune supports two popular graph models: Property Graph and Resource Description Framework (RDF), and their respective query languages: Apache TinkerPop Gremlin and SPARQL2.

Amazon Neptune also supports IAM policies to control access to the database resources and operations. You can use IAM database authentication to authenticate users and applications that connect to a Neptune DB cluster. IAM database authentication works with MySQL and PostgreSQL database clients.You can also use IAM roles to manage access to Neptune from other AWS services, such as Amazon EC2, AWS Lambda, and Amazon SageMaker2.

Therefore, Amazon Neptune DB cluster is a suitable solution for the marketing company's requirements, as it can provide a graph database storage solution that is optimized for highly connected data and can limit connections and programmatic access by using IAM policies.

Question No: 8

MultipleChoice

A database specialist needs to reduce the cost of an application's database. The database is running on a Multi-AZ deployment of an Amazon ROS for Microsoft SQL Server DB instance. The application requires the database to support stored procedures, SQL Server Wire Protocol (TDS), and T-SQC The database must also be highly available. The database specialist is using AWS Database Migration Service (AWS DMS) to migrate the database to a new data store.

Which solution will reduce the cost of the database with the LEAST effort?

Options

AUse AWS Database Migration Service (DMS) to migrate to an RDS for MySQL Multi-AZ database. Update the application code to use the features of MySQL that correspond to SQL Server. Update the application to use the MySQL port.

Buse AWS Database Migration Serve (OMS) to migrate to an RDS for PostgreSQL Multi-AZ database. Turn on the SQL_COMPAT optional extension within the database to allow the required features. Update the application to use the PostgreSQL port

CUse AWS Database Migration Service (OMS) to migrate to an RDS for SQL Server Single-AZ database. Update the application to use the new database endpoint

DUse AWS Database Migration Service (DMS) to migrate the database to Amazon Aurora PostgreSOL_ Turn on Babelfish for Aurora PostgreSOL_ Update the application to use the Babelfish TDS port.

Answer
DExplanation

Amazon Aurora PostgreSQL is a fully managed, compatible, and scalable relational database service that supports the PostgreSQL open source database engine1.Amazon Aurora PostgreSQL can reduce the cost of running a database compared to Amazon RDS for SQL Server, which is a commercial database engine that requires licensing fees2.

Babelfish for Aurora PostgreSQL is a new capability for Amazon Aurora PostgreSQL-Compatible Edition that enables Aurora to understand commands from applications written for Microsoft SQL Server3.Babelfish allows Aurora PostgreSQL to support the SQL Server wire-level protocol (TDS) and commonly used T-SQL language and semantics, which reduces the amount of code changes required to migrate applications from SQL Server to Aurora3.Babelfish also provides high availability by replicating data across multiple Availability Zones in a single AWS Region4.

Using AWS Database Migration Service (DMS) to migrate the database to Amazon Aurora PostgreSQL and turning on Babelfish for Aurora PostgreSQL is a suitable solution for reducing the cost of the database with the least effort, as it can preserve the compatibility and availability of the database while minimizing the code changes in the application. The only change required in the application is to update the connection string to use the Babelfish TDS port, which is 1433 by default.

Question No: 9

MultipleChoice

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

Establish an AWS Direct Connect hosted connection between the companfs data center and AWS

Create an AWS Site-to-Site VPN connection between the companVs data center and AWS over the internet

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.

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.

Grant system-level access to the third-party backup product to perform backups of the Amazon RDS for SQL Server DB instance.

Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2.

Options

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

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

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

Answer
A, D, FExplanation

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

Question No: 10

MultipleChoice

A company has more than 100 AWS accounts that need Amazon RDS instances. The company wants to build an automated solution to deploy the RDS instances with specific compliance parameters. The data does not need to be replicated. The company needs to create the databases within 1 day

Which solution will meet these requirements in the MOST operationally efficient way?

Options

ACreate RDS resources by using AWS CloudFormation. Share the CloudFormation template with each account.

BCreate an RDS snapshot. Share the snapshot With each account Deploy the snapshot into each account

Cuse AWS CloudFormation to create RDS instances in each account. Run AWS Database Migration Service (AWS DMS) replication to each ot the created instances.

DCreate a script by using the AWS CLI to copy the ROS instance into the other accounts from a template account.

Answer
AExplanation

AWS CloudFormation is a service that helps you model and set up your AWS resources so that you can spend less time managing those resources and more time focusing on your applications that run in AWS.You create a template that describes all the AWS resources that you want (like Amazon RDS instances), and CloudFormation takes care of provisioning and configuring those resources for you1.

Using AWS CloudFormation to create RDS resources and share the template with each account is a suitable solution for the company's requirements, as it can:

Automate the deployment of RDS instances with specific compliance parameters, such as security groups, encryption, backup settings, etc.

Reduce the operational overhead and human errors of manually creating RDS instances in each account.

Enable the company to create the databases within one day, as CloudFormation can provision resources in parallel and in a consistent manner.

Limited Time Offer

25%

Off

Get Premium DBS-C01 Questions as Interactive Web-Based Practice Test or PDF