22 September, 2020

Top Tips Of Most Up-to-date DBS-C01 Vce

Master the DBS-C01 AWS Certified Database - Specialty content and be ready for exam day success quickly with this Certleader DBS-C01 exam question. We guarantee it!We make it a reality and give you real DBS-C01 questions in our Amazon-Web-Services DBS-C01 braindumps.Latest 100% VALID Amazon-Web-Services DBS-C01 Exam Questions Dumps at below page. You can use our Amazon-Web-Services DBS-C01 braindumps and pass your exam.

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 large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.
What should the company do to achieve this in the shortest amount of time?

Use a blue-green deployment with a complete application-level failover test

Use the RDS console to reboot the DB instance by choosing the option to reboot with failover

Use RDS fault injection queries to simulate the primary node failure

Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone

Question 2

A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple times a day when Developers make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to complete.
Multiple team members are working on the project, making it difficult to find the correct restore point for each mistake.
Which approach should the Database Specialist take to reduce downtime?

Deploy multiple read replicas and have the team members make changes to separate replica instances

Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot

Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature

Enable the Amazon RDS for MySQL Backtrack feature

Question 3

A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ DB instance. When using the AWS Management Console to conduct this task, the Database Specialist discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read replica cannot be created.
What is the most likely reason for this?

The source DB instance has to be converted to Single-AZ first to create a read replica from it.

Enhanced Monitoring is not enabled on the source DB instance.

The minor MySQL version in the source DB instance does not support read replicas.

Automated backups are not enabled on the source DB instance.

Question 4

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

Question 5

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 6

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 7

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation.
How can the Database Specialists accomplish this?

Enable the option to push all database logs to Amazon CloudWatch for advanced analysis

Create appropriate Amazon CloudWatch dashboards to contain specific periods of time

Enable Amazon RDS Performance Insights and review the appropriate dashboard

Enable Enhanced Monitoring will the appropriate settings

Question 8

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?

Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and diskspace consumptio

Watch these dashboards during the next slow period.

Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring toolthat will run reports based on the output error logs.

Modify the logging database parameter to log all the queries related to locking in the database and thencheck the logs after the next slow period for this information.

Enable Amazon RDS Performance Insights on the PostgreSQL databas

Use the metrics to identify anyqueries that are related to spikes in the graph during the next slow period.

Question 9

A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server. Due to escalating support and maintenance costs, the company is exploring the option of moving the workload to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?

Perform a logical dump from the Db2 database and restore it to an Aurora DB cluste

Identify the gaps andcompatibility of the objects migrated by comparing row counts from source and target tables.

Run AWS DMS from the Db2 database to an Aurora DB cluste

Identify the gaps and compatibility of theobjects migrated by comparing the row counts from source and target tables.

Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate themigration compatibility.

Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster.Create a migration assessment report to evaluate the migration compatibility.

Question 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?

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.

Create a new attribute in each table to track the expiration time and enable DynamoDB Streams on each table.

Create a new attribute in each table to track the expiration time and enable time to live (TTL) on each table.

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.

Question 11

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 12

An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora. Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?

Turn on the serverless option in the DB cluster so it can automatically scale based on demand.

Provision a clone of the existing DB cluster for the new Application team.

Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoingreplication using AWS DMS change data capture (CDC).

Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPUconsumption.

Question 13

A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime using AWS DMS. A Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover. The migration must have minimal impact on the performance of the source database.
Which approach will MOST effectively meet these requirements?

Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluste

Verify the datatype of the columns.

Use the table metrics of the AWS DMS task created for migrating the data to verify the statistics for the tables being migrated and to verify that the data definition language (DDL) statements are completed.

Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigrationchecklist to make sure there are no issues with the conversion.

Enable AWS DMS data validation on the task so the AWS DMS task compares the source and targetrecords, and reports any mismatches.

Question 14

A gaming company has recently acquired a successful iOS game, which is particularly popular during theholiday season. The company has decided to add a leaderboard to the game that uses Amazon DynamoDB.The application load is expected to ramp up over the holiday season.
Which solution will meet these requirements at the lowest cost?

DynamoDB Streams

DynamoDB with DynamoDB Accelerator

DynamoDB with on-demand capacity mode

DynamoDB with provisioned capacity mode with Auto Scaling

Question 15

A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon RDS events and determined a failover event occurred at that time. The failover process took around 15 seconds to complete.
What is the MOST likely cause of the 5-minute connection outage?

After a database crash, Aurora needed to replay the redo log from the last database checkpoint

The client-side application is caching the DNS data and its TTL is set too high

After failover, the Aurora DB cluster needs time to warm up before accepting client connections

There were no active Aurora Replicas in the Aurora DB cluster

Question 16

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 most secure solution to store the master password?

Store the master password in a parameter file in each environmen

Reference the environment-specific parameter file in the CloudFormation template.

Encrypt the master password using an AWS KMS ke

Store the encrypted master password in theCloudFormation template.

Use the secretsmanager dynamic reference to retrieve the master password stored in AWS SecretsManager and enable automatic rotation.

Use the ssm dynamic reference to retrieve the master password stored in the AWS Systems ManagerParameter Store and enable automatic rotation.

Question 17

A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment. The cause of a recent spike in CPU utilization was not determined using the standard metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A Database Specialist needs to determine what caused the CPU spike.
Which combination of steps should be taken to provide more visibility into the processes and queries running during an increase in CPU load? (Choose two.)

Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.

Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.

Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.

Use Amazon QuickSight to view the SQL statement being run.

Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQLstatements, hosts, or users.

Question 18

A financial services company is developing a shared data service that supports different applications from throughout the company. A Database Specialist designed a solution to leverage Amazon ElastiCache for Redis with cluster mode enabled to enhance performance and scalability. The cluster is configured to listen on port 6379.
Which combination of steps should the Database Specialist take to secure the cache data and protect it from unauthorized access? (Choose three.)

Enable in-transit and at-rest encryption on the ElastiCache cluster.

Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.

Ensure the security group for the ElastiCache cluster allows all inbound traffic from itself and inbound traffic on TCP port 6379 from trusted clients only.

Create an IAM policy to allow the application service roles to access all ElastiCache API actions.

Ensure the security group for the ElastiCache clients authorize inbound TCP port 6379 and port 22 traffic from the trusted ElastiCache cluster’s security group.

Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.

Question 19

A marketing company is using Amazon DocumentDB and requires that database audit logs be enabled. A Database Specialist needs to configure monitoring so that all data definition language (DDL) statements performed are visible to the Administrator. The Database Specialist has set the audit_logs parameter to enabled in the cluster parameter group.
What should the Database Specialist do to automatically collect the database logs for the Administrator?

Enable DocumentDB to export the logs to Amazon CloudWatch Logs

Enable DocumentDB to export the logs to AWS CloudTrail

Enable DocumentDB Events to export the logs to Amazon CloudWatch Logs

Configure an AWS Lambda function to download the logs using the download-db-log-file-portion operationand store the logs in Amazon S3

Question 20

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.

Page: 1 / 7

Total 85 questions Full Exam Access