30 October, 2023

A Review Of 100% Correct DBS-C01 Exam Prep

Our pass rate is high to 98.9% and the similarity percentage between our DBS-C01 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Amazon-Web-Services DBS-C01 exam in just one try? I am currently studying for the Amazon-Web-Services DBS-C01 exam. Latest Amazon-Web-Services DBS-C01 Test exam practice questions and answers, Try Amazon-Web-Services DBS-C01 Brain Dumps First.

Amazon-Web-Services DBS-C01 Free Dumps Questions Online, Read and Test Now.

Page: 1 / 7

Total 85 questions Full Exam Access

Question 1

A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company’s main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.
Which solution meets these requirements?

Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the apnortheast-1 Regio

Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cacheapplication data from the replica to generate the dashboards.

Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1Regio

Use Amazon QuickSight for displaying dashboard results.

Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replicainstance in the ap-northeast-1 Regio

Have the dashboard application read from the read replica.

Use an Amazon Aurora global databas

Deploy the writer instance in the us-east-1 Region and the replicain the ap-northeast-1 Regio

Have the dashboard application read from the replica ap-northeast-1 Region.

Question 2

A global digital advertising company captures browsing metadata to contextually display relevant images,pages, and links to targeted users. A single page load can generate multiple events that need to be storedindividually. The maximum size of an event is 200 KB and the average size is 10 KB. Each page load mustquery the user’s browsing history to provide targeting recommendations. The advertising company expectsover 1 billion page visits per day from users in the United States, Europe, Hong Kong, and India. The structureof the metadata varies depending on the event. Additionally, the browsing metadata must be written and readwith very low latency to ensure a good viewing experience for the users.
Which database solution meets these requirements?

Amazon DocumentDB

Amazon RDS Multi-AZ deployment

Amazon DynamoDB global table

Amazon Aurora Global Database

Question 3

A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a
database-1.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com endpoint listening on port 3306. The company’s Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logging a “could not connect to server: Connection times out” error message to Amazon CloudWatch Logs.
What is the cause of this error?

The user name and password the application is using are incorrect.

The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.

The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.

The user name and password are correct, but the user is not authorized to use the DB instance.

Question 4

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL.
How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.

Connect to the Aurora host and create cron jobs to run the maintenance jobs following the requiredschedule.

Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatchEvents.

Create the maintenance job using the Amazon CloudWatch job scheduling plugin.

Question 5

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?

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

Aurora will promote an arbitrary Aurora Replica

Aurora will promote the largest-sized Aurora Replica

Aurora will not promote an Aurora Replica

Question 7

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?

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

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

Review all evaluate the peak combined workloa

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

Adjust the number of instances, if necessary.

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

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

Set up automatic scaling on the DB cluste

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

Question 8

A company is using Amazon with Aurora Replicas for read-only workload scaling. A Database Specialist needs to split up two read-only applications so each application always connects to a dedicated replica. The Database Specialist wants to implement load balancing and high availability for the read-only applications.
Which solution meets these requirements?

Use a specific instance endpoint for each replica and add the instance endpoint to each read-onlyapplication connection string.

Use reader endpoints for both the read-only workload applications.

Use a reader endpoint for one read-only application and use an instance endpoint for the other read-onlyapplication.

Use custom endpoints for the two read-only applications.

Question 9

A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when survey responses are being collected, a Database Specialist sees the ProvisionedThroughputExceededException error.
What can the Database Specialist do to resolve this error? (Choose two.)

Change the table to use Amazon DynamoDB Streams

Purchase DynamoDB reserved capacity in the affected Region

Increase the write capacity units for the specific table

Change the table capacity mode to on-demand

Change the table type to throughput optimized

Question 10

A media company is using Amazon RDS for PostgreSQL to store user data. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Following a recent AWS Well- Architected Framework review, a Database Specialist was given new security requirements.
Only certain on-premises corporate network IPs should connect to the DB instance.
Connectivity is allowed from the corporate network only. Which combination of steps does the Database Specialist need to take to meet these new requirements?
(Choose three.)

Modify the pg_hba.conf fil

Add the required corporate network IPs and remove the unwanted IPs.

Modify the associated security grou

Add the required corporate network IPs and remove the unwanted IPs.

Move the DB instance to a private subnet using AWS DMS.

Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.

Disable the publicly accessible setting.

Connect to the DB instance using private IPs and a VPN.

Question 12

A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective.
Which approach should the Database Specialist take?

Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp).Rundata transformations in AWS Glu

Load the data from the S3 bucket to the Aurora DB cluster.

Order an AWS Snowball appliance and copy the Oracle backup to the Snowball applianc

Once theSnowball data is delivered to Amazon S3, create a new Aurora DB cluste

Enable the S3 integration tomigrate the data directly from Amazon S3 to Amazon RDS.

Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during theschema migratio

Use AWS DMS to perform the full load and change data capture (CDC) tasks.

Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an AmazonEC2 instanc

Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to anAurora DB cluster.

Question 13

A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.
What should the Database Specialist do to meet these requirements?

Restore a snapshot from the production cluster into test clusters

Create logical dumps of the production cluster and restore them into new test clusters

Use database cloning to create clones of the production cluster

Add an additional read replica to the production cluster and use that node for testing

Question 14

A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.
Which of the following will resolve this issue?

Edit the my.cnf file for the DB cluster to increase max_connections

Increase the instance size of the DB cluster

Change the DB cluster to Multi-AZ

Increase the number of Aurora Replicas

Question 15

The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real-time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.
Which approach will meet these requirements?

Use pg_audit to generate audit logs and send the logs to the Security team.

Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.

Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.

Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.

Question 16

A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To meet the company’s disaster recovery policies, the database backup needs to be copied into another Region. The company requires the solution to be cost-effective and operationally efficient.
What should a Database Specialist do to copy the database backup into a different Region?

Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region

Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication tocopy the snapshot into another Region

Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a secondLambda function to copy the snapshot into another Region

Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot ofthe read replica

Question 17

A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has restored the latest backup to a new table.
To prepare the new table with identical settings, which steps should be performed? (Choose two.)

Re-create global secondary indexes in the new table

Define IAM policies for access to the new table

Define the TTL settings

Encrypt the table from the AWS Management Console or use the update-table command

Set the provisioned read and write capacity

Question 18

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?

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

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

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

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

Question 19

A manufacturing company’s website uses an Amazon Aurora PostgreSQL DB cluster.
Which configurations will result in the LEAST application downtime during a failover? (Choose three.)

Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.

Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.

Edit and enable Aurora DB cluster cache management in parameter groups.

Set TCP keepalive parameters to a high value.

Set JDBC connection string timeout variables to a low value.

Set Java DNS caching timeouts to a high value.

Question 20

A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users.
How should the Database Specialist apply the parameter group change for the DB instance?

Select the option to apply the change immediately

Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied

Apply the change manually by rebooting the DB instance during the approved maintenance window

Reboot the secondary Multi-AZ DB instance

Question 21

A large ecommerce company uses Amazon DynamoDB to handle the transactions on its web portal. Traffic patterns throughout the year are usually stable; however, a large event is planned. The company knows that traffic will increase by up to 10 times the normal load over the 3-day event. When sale prices are published during the event, traffic will spike rapidly.
How should a Database Specialist ensure DynamoDB can handle the increased traffic?

Ensure the table is always provisioned to meet peak needs

Allow burst capacity to handle the additional load

Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic

Preprovision additional capacity for the known peaks and then reduce the capacity after the event

Page: 1 / 7

Total 85 questions Full Exam Access