Amazon exam practice test / dbs-c01 dumps / dbs-c01 exam / dbs-c01 exam dumps / dbs-c01 pdf / dbs-c01 practice exam / dbs-c01 study guide

[Split-New] Real And Effective Amazon DBS-C01 Dumps Questions By Pass4itSure

The Amazon AWS Certified Specialty certification is a very popular certification. Pass the DBS-C01 exam to earn this certification. You can do this with the help of a real Amazon AWS DBS-C01 dumps.

Pass4itSure has launched the latest version of AWS DBS-C01 dumps https://www.pass4itsure.com/aws-certified-database-specialty.html (Updated: Feb 01, 2022)

Maybe there are more other Amazon certification exams you want to pass https://www.pass4itsure.com/amazon.html Welcome to pass.

In addition, the site shares some AWS DBS-C01 exam practice questions q1-q12 from the Pass4itSure dumps.

Start testing your abilities now >>>

Latest AWS DBS-C01 exam questions and answers – Pass4itSure DBS-C01 dumps

AWS Certified Database – Specialty (DBS-C01) exam questions online test

Q 1

A company uses a single-node Amazon RDS for MySQL DB instance for its production database. The DB instance runs in an AWS Region in the United States.

A week before a big sales event, a new maintenance update is available for the DB instance. The maintenance update is marked as required. The company wants to minimize downtime for the DB instance and asks a database specialist to make the DB instance highly available until the sales event ends.

Which solution will meet these requirements?

A. Defer the maintenance update until the sales event is over.
B. Create a read replica with the latest update. Initiate a failover before the sales event.
C. Create a read replica with the latest update. Transfer all read-only traffic to the read replica during the sales event.
D. Convert the DB instance into a Multi-AZ deployment. Apply the maintenance update.

Correct Answer: D

Reference: https://aws.amazon.com/rds/features/multi-az/

Q 2

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 reading 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 sub-second levels?

A. Increase the size of the DB instance storage
B. Change the underlying EBS storage type to General Purpose SSD (gp2)
C. Disable EBS optimization on the DB instance
D. Change the DB instance to an instance class with a higher maximum bandwidth

Correct Answer: B

Q 3

A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database. After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower. The company has narrowed down the cause of this issue to the database and not the application.

Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?

A. Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumption. Watch these dashboards during the next slow period.
B. Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring tool that will run reports based on the output error logs.
C. Modify the logging database parameter to log all the queries related to locking in the database and then check the logs after the next slow period for this information.
D. Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify any queries that are related to spikes in the graph during the next slow period.

Correct Answer: D

Q 4

A company is going through a security audit. The audit team has identified cleartext master user passwords in the AWS CloudFormation templates for Amazon RDS for MySQL DB instances. The audit team has flagged this as a security risk to the database team.

What should a database specialist do to mitigate this risk?

A. Change all the databases to use AWS IAM for authentication and remove all the cleartext passwords in CloudFormation templates.
B. Use an AWS Secrets Manager resource to generate a random password and reference the secret in the CloudFormation template.
C. Remove the passwords from the CloudFormation templates so Amazon RDS prompts for the password when the database is being created.
D. Remove the passwords from the CloudFormation template and store them in a separate file. Replace the passwords by running CloudFormation using the sed command.

Correct Answer: C

Q 5

A bank plans to use an Amazon RDS for MySQL DB instance. The database should support read-intensive traffic with very few repeated queries. Which solution meets these requirements?

A. Create an Amazon ElastiCache cluster. Use a write-through strategy to populate the cache.
B. Create an Amazon ElastiCache cluster. Use a lazy loading strategy to populate the cache.
C. Change the DB instance to Multi-AZ with a standby instance in another AWS Region.
D. Create a read replica of the DB instance. Use the read replica to distribute the read traffic.

Correct Answer: D

Q 6

A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A Database Specialist needs to control the access privileges at the table level.

How can the Database Specialist meet these requirements?

A. Use AWS IAM database authentication and restrict access to the tables using an IAM policy.
B. Configure the rules in a NaCl to restrict outbound traffic from the Aurora DB cluster.
C. Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
D. Define access privileges to the tables containing sensitive data in the pg_hba.conf file.

Correct Answer: C

Reference: https://aws.amazon.com/blogs/database/managing-postgresql-users-and-roles/

Q 7

An eCommerce company is migrating its core application database to Amazon Aurora MySQL. The company is currently performing online transaction processing (OLTP) stress testing with concurrent database sessions. During the first round of tests, a database specialist noticed slow performance for some specific write operations.

Reviewing Amazon CloudWatch metrics for the Aurora DB cluster showed 90% CPU utilization.
Which steps should the database specialist take to MOST effectively identify the root cause of high CPU utilization and slow performance? (Choose two.)

A. Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.
B. Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I/O.
C. Review Amazon RDS Performance Insights to identify the top SQL statements and wait for events.
D. Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.
E. Enable Advanced Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.

Correct Answer: BC

Q 8

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 the 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 connections 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

Correct Answer: AE

Reference: https://aws.amazon.com/blogs/database/working-with-rds-and-aurora-postgresql-logs-part-1/

Q 9

A company is using a Single-AZ Amazon RDS for MySQL DB instance for development. The DB instance is experiencing slow performance when queries are executed. Amazon CloudWatch metrics indicate that the instance requires more I/ O capacity.

Which actions can a database specialist perform to resolve this issue? (Choose two.)

A. Restart the application tool used to execute queries.
B. Change to a database instance class with higher throughput.
C. Convert from Single-AZ to Multi-AZ.
D. Increase the I/O parameter in Amazon RDS Enhanced Monitoring.
E. Convert from General Purpose to Provisioned IOPS (PIOPS).

Correct Answer: BD

Q 10

A company is concerned about the cost of a large-scale, transactional application using Amazon DynamoDB that only needs to store data for 2 days before it is deleted. In looking at the tables, a Database Specialist notices that much of the data is months old, and goes back to when the application was first deployed.

What can the Database Specialist do to reduce the overall cost?

A. Create a new attribute in each table to track the expiration time and create an AWS Glue transformation to delete entries more than 2 days old.
B. Create a new attribute in each table to track the expiration time and enable DynamoDB Streams on each table.
C. Create a new attribute in each table to track the expiration time and enable time to live (TTL) on each table.
D. Create an Amazon CloudWatch Events event to export the data to Amazon S3 daily using AWS Data Pipeline and then truncate the Amazon DynamoDB table.

Correct Answer: A

Q 11

An electric utility company wants to store power plant sensor data in an Amazon DynamoDB table. The utility company has over 100 power plants and each power plant has over 200 sensors that send data every 2 seconds. The sensor data includes time with milliseconds precision, a value, and a fault attribute if the sensor is malfunctioning.

Power plants are identified by a globally unique identifier. Sensors are identified by a unique identifier within each power plant. A database specialist needs to design the table to support an efficient method of finding all faulty sensors within a given power plant.

Which schema should the database specialist use when creating the DynamoDB table to achieve the fastest query time when looking for faulty sensors?

A. Use the plant identifier as the partition key and the measurement time as the sort key. Create a global secondary index (GSI) with the plant identifier as the partition key and the fault attribute as the sort key.

B. Create a composite of the plant identifier and sensor identifier as the partition key. Use the measurement time as the sort key. Create a local secondary index (LSI) on the fault attribute.

C. Create a composite of the plant identifier and sensor identifier as the partition key. Use the measurement time as the sort key. Create a global secondary index (GSI) with the plant identifier as the partition key and the fault attribute as the sort key.

D. Use the plant identifier as the partition key and the sensor identifier as the sort key. Create a local secondary index (LSI) on the fault attribute.

Correct Answer: B

Q 12

A company uses Amazon Aurora for secure financial transactions. The data must always be encrypted at rest and in transit to meet compliance requirements.

Which combination of actions should a database specialist take to meet these requirements? (Choose two.)

A. Create an Aurora Replica with encryption enabled using AWS Key Management Service (AWS KMS). Then promote the replica to master.

B. Use SSL/TLS to secure the in-transit connection between the financial application and the Aurora DB cluster.

C. Modify the existing Aurora DB cluster and enable encryption using an AWS Key Management Service (AWS KMS) encryption key. Apply the changes immediately.

D. Take a snapshot of the Aurora DB cluster and encrypt the snapshot using an AWS Key Management Service (AWS KMS) encryption key. Restore the snapshot to a new DB cluster and update the financial application database endpoints.

E. Use AWS Key Management Service (AWS KMS) to secure the in-transit connection between the financial application and the Aurora DB cluster.

Correct Answer: BC

Get Pass4itSure 2022 Amazon DBS-C01 dumps pdf from Google Drive:

free Amazon DBS-C01 dumps pdf 2022 https://drive.google.com/file/d/1x9QqoUAMlj21qVKMRcZOCBJqnHBRGLte/view?usp=sharing

Well, I’ll share it here, and the emphasis is that the AWS DBS-C01 dump is important for passing the exam, of course, this also requires your hard work.

Get the full Pass4itSure AWS DBS-C01 dumps https://www.pass4itsure.com/aws-certified-database-specialty.html (both PDF and VCE modes) to get started.