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

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: 3

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: 4

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: 5

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.

Question No: 6

MultipleChoice

A company has an existing system that uses a single-instance Amazon DocumentDB (with MongoDB compatibility) cluster. Read requests account for 75% of the system queries. Write requests are expected to increase by 50% after an upcoming global release. A database specialist needs to design a solution that improves the overall database performance without creating additional application overhead.

Which solution will meet these requirements?

Options

ARecreate the cluster with a shared cluster volume. Add two instances to serve both read requests and write requests.

BAdd one read replica instance. Activate a shared cluster volume. Route all read queries to the read replica instance.

CAdd one read replica instance. Set the read preference to secondary preferred.

DAdd one read replica instance. Update the application to route all read queries to the read replica instance.

Answer
CExplanation

By default, an application directs its read operations to the primary member in a replica set (i.e. read preference mode 'primary'). But, clients can specify a read preference to send read operations to secondaries. https://www.mongodb.com/docs/manual/core/read-preference/

A read replica instance is an Amazon DocumentDB instance that supports only read operations. An Amazon DocumentDB cluster can have up to 15 replicas in addition to the primary instance.Having multiple replicas enables you to distribute read workloads and increase the read throughput of your cluster1.

The read preference option determines how your MongoDB client or driver routes read requests to instances in your Amazon DocumentDB cluster.The secondary preferred option instructs the client to route read queries to the replicas, unless none are available, in which case the queries are routed to the primary instance2. This option can improve the overall database performance by offloading read requests from the primary instance, which handles all write requests, and balancing them across the replicas.

Using this solution, the company can:

Improve the overall database performance by adding one read replica instance and setting the read preference to secondary preferred.

Avoid creating additional application overhead by using the built-in read preference capabilities of the MongoDB client or driver, without having to update the application code or connection string.

Handle the expected increase in write requests by freeing up resources on the primary instance.

Question No: 7

MultipleChoice

A global company is creating an application. The application must be highly available. The company requires an RTO and an RPO of less than 5 minutes. The company needs a database that will provide the ability to set up an active-active configuration and near real-time synchronization of data across tables in multiple AWS Regions.

Which solution will meet these requirements?

Options

AAmazon RDS for MariaDB with cross-Region read replicas

BAmazon RDS With a Multi-AZ deployment

CAmazon DynamoDB global tables

DAmazon DynamoDB With a global secondary index (GSI)

Answer
CExplanation

Amazon DynamoDB global tables are a fully managed, serverless, multi-Region, and multi-active database option that delivers fast and localized read and write performance for massively scaled global applications.Global tables provide you 99.999% availability, increased application resiliency, and improved business continuity1.As global tables replicate your Amazon DynamoDB tables automatically across your choice of AWS Regions, you can achieve fast, local read and write performance1.In the rare event of a single Region failure, there is no need for a database failover as global tables' multi-active architecture allows customers to read and write to any replica table1.Global tables also eliminate the difficult work of replicating data between Regions and resolving update conflicts for multi-active workloads1.

Using Amazon DynamoDB global tables, the company can:

Set up an active-active configuration and near real-time synchronization of data across tables in multiple AWS Regions.

Meet the RTO and RPO of less than 5 minutes, as global tables provide automatic failover and zero data loss in case of a Region failure.

Achieve high availability, durability, and scalability for their application.

Question No: 8

MultipleChoice

For the first time, a database professional is establishing a test graph database on Amazon Neptune. The database expert must input millions of rows of test observations from an Amazon S3.csv file. The database professional uploaded the data to the Neptune DB instance through a series of API calls.

Which sequence of actions enables the database professional to upload the data most quickly? (Select three.)

Options

AEnsure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.

BEnsure the vertices and edges are specified in different .csv files with proper header column formatting.

CUse AWS DMS to move data from Amazon S3 to the Neptune Loader.

DCurl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.

EEnsure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket.

FCreate an S3 VPC endpoint and issue an HTTP POST to the databases loader endpoint.

Answer
B, E, FExplanation

https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-optimize.html

Question No: 9

MultipleChoice

A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three

Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one mediumsized primary instance, one large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.

In the event of a primary failure, what will occur?

Options

AAurora will promote an Aurora Replica that is of the same size as the primary instance

BAurora will promote an arbitrary Aurora Replica

CAurora will promote the largest-sized Aurora Replica

DAurora will not promote an Aurora Replica

Answer
AExplanation

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-ug.pdf

Question No: 10

MultipleChoice

A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too timeconsuming, so it is not an option.

How should the Database Specialist satisfy this new requirement?

Options

ACreate a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted
snapshot. Restore the encrypted snapshot copy.

BModify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.

CRestore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.

DCreate an encrypted read replica of the RDS DB instance. Promote it the master.

Answer
A

Limited Time Offer

25%

Off

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