aws DBS-C01 practice test | Leads4pass New Exam Dumps Questions And Answers Update

Welcome to your aws DBS-C01 practice test

QUESTION 1

A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be
logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default parameter group.
A Database Specialist has identified that setting the log_connections parameter to 1 will enable connection logging.
Which combination of steps should the Database Specialist take to meet the logging and retention requirements?
(Choose two.)

A. Update the log_connections parameter in the default parameter group

B. Create a custom parameter group, update the log_connections parameter, and associate the parameter with the DB instance

C. Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to 180 days

D. Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180 days

E. Connect to the RDS PostgreSQL host and update the log_connections parameter in the PostgreSQL.conf file

QUESTION 2

A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster.
The database will be accessed by multiple applications across the company. The company has mandated that all
communications to the database be encrypted and the server identity must be validated. Any non-SSL-based
connections
should be disallowed access to the database.
Which solution addresses these requirements?

A. Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=allow.

B. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=disable.

C. Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-ca.

D. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-full.

QUESTION 3

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 data migration. The solution
must also be cost-effective.
Which approach should the Database Specialist take?

A. Dump all the tables from the Oracle database into an Amazon S3 bucket using a data pump (expdp). Run data transformations in AWS Glue. Load the data from the S3 bucket to the Aurora DB cluster.

B. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball appliance. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration to migrate the data directly from Amazon S3 to Amazon RDS.

C. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.

D. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an Amazon EC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to an Aurora DB cluster.

QUESTION 4

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 stored individually.
The maximum size of an event is 200 KB and the average size is 10 KB. Each page load must query the user\\’s
browsing
history to provide targeting recommendations. The advertising company expects over 1 billion page visits per day from
users in the United States, Europe, Hong Kong, and India. The structure of the metadata varies depending on the
event.
Additionally, the browsing metadata must be written and read with very low latency to ensure a good viewing experience
for the users.
Which database solution meets these requirements?

A. Amazon DocumentDB

B. Amazon RDS Multi-AZ deployment

C. Amazon DynamoDB global table

D. Amazon Aurora Global Database

QUESTION 5

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL MultiAZ DB
instance. Tests were run on the database after work hours, which generated additional database logs. The free storage
of the RDS DB instance is low due to these additional logs. What should the company do to address this space
constraint issue?

A. Log in to the host and run the rm $PGDATA/pg_logs/* command

B. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to be deleted

C. Create a ticket with AWS Support to have the logs deleted

D. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs

QUESTION 6

A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB cluster.
The Aurora DB cluster currently includes the primary instance and three Aurora Replicas. How can the Database Specialist ensures that failovers occur with the least amount of downtime for the application?

A. Set the TCP keepalive parameters low

B. Call the AWS CLI failover-DB-cluster command

C. Enable Enhanced Monitoring on the DB cluster

D. Start a database activity stream on the DB cluster

QUESTION 7

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

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

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

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

D. Set TCP keepalive parameters to a high value.

E. Set JDBC connection string timeout variables to a low value.

F. Set Java DNS caching timeouts to a high value.

QUESTION 8

A company is developing a multi-tier web application hosted on AWS using Amazon Aurora as the database.
The application needs to be deployed to production and other non-production environments. A Database Specialist
needs to specify different MasterUsername and MasterUserPassword properties in the AWS CloudFormation templates
used
for automated deployment. The CloudFormation templates are version controlled in the company\\’s code repository.
The company also needs to meet compliance requirement by routinely rotating its database master password for
production.
What is the most secure solution to store the master password?

A. Store the master password in a parameter file in each environment. Reference the environment-specific parameter file in the CloudFormation template.

B. Encrypt the master password using an AWS KMS key. Store the encrypted master password in the CloudFormation template.

C. Use the secrets manager dynamic reference to retrieve the master password stored in AWS Secrets Manager and enable automatic rotation.

D. Use the SSM dynamic reference to retrieve the master password stored in the AWS Systems Manager Parameter Store and enable automatic rotation.

QUESTION 9

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent
data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora. Which
migration method should a Database Specialist use?

A. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.

B. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.

C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.

D. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

QUESTION 10

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 reporting. Monitor and set up replication between the two clusters to keep data consistent.

B. Review all evaluates the peak combined workload. Ensure that utilization of the DB cluster node is at an acceptable level. Adjust the number of instances, if necessary.

C. Use the stop cluster functionality to stop all the nodes of the DB cluster during times of minimal workload. The cluster can be restarted again depending on the workload at the time.

D. Set up automatic scaling on the DB cluster. This will allow the number of reader nodes to adjust automatically to the reporting workload, when needed.

QUESTION 11

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?

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

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

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

D. Use custom endpoints for the two read-only applications.

QUESTION 12

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- east1.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?

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

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

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

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

QUESTION 13

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?

A. Ensure the table is always provisioned to meet peak needs

B. Allow burst capacity to handle the additional load

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

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