Free Amazon DBS-C01 Exam Dumps and DBS-C01 Exam Questions

Question No: 11

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.

Question No: 12

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)

Question No: 13

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.

Question No: 14

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

Question No: 15

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.

Question No: 16

MultipleChoice

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.

What should a Database Specialist do in this situation to increase performance and return latency to subsecond levels?

Options

AIncrease the size of the DB instance storage

BChange the underlying EBS storage type to General Purpose SSD (gp2)

CDisable EBS optimization on the DB instance

DChange the DB instance to an instance class with a higher maximum bandwidth

Question No: 17

MultipleChoice

A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse

solution. The company plans to use the AWS Schema Conversion Tool (AWS SCT) and AWS DMS for the

migration to AWS. The site network bandwidth is 500 Mbps. A Database Specialist wants to migrate the onpremises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse. This move must take place during a 2-week period when source systems are shut down for maintenance. The data should stay encrypted at rest and in transit.

Which approach has the least risk and the highest likelihood of a successful data transfer?

Options

ASet up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage AWS SCT and apply the converted schema to Amazon Redshift. Once complete, start an AWS DMS task to move the data from the source to Amazon S3. Use AWS Glue to load the data from Amazon S3 to Amazon Redshift.

BLeverage AWS SCT and apply the converted schema to Amazon Redshift. Start an AWS DMS task with
two AWS Snowball Edge devices to copy data from on-premises to Amazon S3 with AWS KMS encryption.
Use AWS DMS to finish copying data to Amazon Redshift.

CLeverage AWS SCT and apply the converted schema to Amazon Redshift. Once complete, use a fleet of 10 TB dedicated encrypted drives using the AWS Import/Export feature to copy data from on-premises to Amazon S3 with AWS KMS encryption. Use AWS Glue to load the data to Amazon redshift.

DSet up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage a native database export feature to export the data and compress the files. Use the aws S3 cp multi-port upload command to upload these files to Amazon S3 with AWS KMS encryption. Once complete, load the data to
Amazon Redshift using AWS Glue.

Question No: 18

MultipleChoice

A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will

offload the administrative burdens of operating and scaling distributed databases. The solution must be costeffective and able to handle unpredictable application traffic.

What should a Database Specialist recommend for this user?

Options

ACreate an Amazon DynamoDB table with provisioned capacity mode

BCreate an Amazon DocumentDB cluster

CCreate an Amazon DynamoDB table with on-demand capacity mode

DCreate an Amazon Aurora Serverless DB cluster

Question No: 19

MultipleChoice

A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice Question:s of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.

Which AWS services should the Database Specialist consider? (Choose two.)

Options

AAmazon DynamoDB

BAmazon Redshift

CAmazon Neptune

DAmazon Elasticsearch Service

EAmazon ElastiCache