Online DBS-C01 Practice TestMore Amazon-Web-Services Products >

Free Amazon-Web-Services DBS-C01 Exam Dumps Questions

Amazon-Web-Services DBS-C01: AWS Certified Database - Specialty

- Get instant access to DBS-C01 practice exam questions

- Get ready to pass the AWS Certified Database - Specialty exam right now using our Amazon-Web-Services DBS-C01 exam package, which includes Amazon-Web-Services DBS-C01 practice test plus an Amazon-Web-Services DBS-C01 Exam Simulator.

- The best online DBS-C01 exam study material and preparation tool is here.

4.5

(2790 ratings)

Question 1

A company is looking to migrate a 1 TB Oracle database from on-premises to an Amazon Aurora PostgreSQL DB cluster. The company’s Database Specialist discovered that the Oracle database is storing 100 GB of large binary objects (LOBs) across multiple tables. The Oracle database has a maximum LOB size of 500 MB with an average LOB size of 350 MB. The Database Specialist has chosen AWS DMS to migrate the data with the largest replication instances.
How should the Database Specialist optimize the database migration using AWS DMS?

A. Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBstogether

B. Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2without LOBs

C. Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB andtask 2 without LOBs

D. Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data andLOBs together

Correct Answer:C

Question 2

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.
Where should the AWS DMS replication instance be placed for the MOST optimal performance?

A. In the same Region and VPC of the source DB instance

B. In the same Region and VPC as the target DB instance

C. In the same VPC and Availability Zone as the target DB instance

D. In the same VPC and Availability Zone as the source DB instance

Correct Answer:D

Question 3

A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora DB cluster is appropriate for the peak workload.
The company is now looking at cutting costs for this DB cluster, but needs to have a sufficient number of nodes in the cluster to support the workload at different times. The workload has not changed since the previous benchmarking exercise.
How can a Database Specialist address these requirements with minimal user involvement?

A. Split up the DB cluster into two different clusters: one for OLTP and the other for reportin

B. Monitor and set up replication between the two clusters to keep data consistent.

C. Review all evaluate the peak combined workloa

D. Ensure that utilization of the DB cluster node is at an acceptable leve

E. Adjust the number of instances, if necessary.

F. Use the stop cluster functionality to stop all the nodes of the DB cluster during times of minimal workloa

G. The cluster can be restarted again depending on the workload at the time.

H. Set up automatic scaling on the DB cluste

I. This will allow the number of reader nodes to adjust automatically to the reporting workload, when needed.

Correct Answer:D

Question 4

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

A. Amazon DynamoDB

B. Amazon Redshift

C. Amazon Neptune

D. Amazon Elasticsearch Service

E. Amazon ElastiCache

Correct Answer:AE

Question 5

A gaming company has implemented a leaderboard in AWS using a Sorted Set data structure within Amazon ElastiCache for Redis. The ElastiCache cluster has been deployed with cluster mode disabled and has a replication group deployed with two additional replicas. The company is planning for a worldwide gaming event and is anticipating a higher write load than what the current cluster can handle.
Which method should a Database Specialist use to scale the ElastiCache cluster ahead of the upcoming event?

A. Enable cluster mode on the existing ElastiCache cluster and configure separate shards for the Sorted Setacross all nodes in the cluster.

B. Increase the size of the ElastiCache cluster nodes to a larger instance size.

C. Create an additional ElastiCache cluster and load-balance traffic between the two clusters.

D. Use the EXPIRE command and set a higher time to live (TTL) after each call to increment a given key.

Correct Answer:B

Question 6

A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists.
Which step should be taken to troubleshoot this issue?

A. Ensure that the database option group for the RDS DB instance allows ingress from theDevelopermachine’s IP address

B. Ensure that the RDS DB instance’s subnet group includes a public subnet to allow the Developer toconnect

C. Ensure that the RDS DB instance has not reached its maximum connections limit

D. Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listeningfor encrypted connections

Correct Answer:B

START DBS-C01 EXAM