Welcome to TestSimulate

Pass Your Next Certification Exam Fast!

Everything you need to prepare, learn & pass your certification exam easily.

365 days free updates. First attempt guaranteed success.

  • Home
  • Blogs
  • [Dec 22, 2021] Get New DBS-C01 Practice Test Questions Answers [Q65-Q85]

[Dec 22, 2021] Get New DBS-C01 Practice Test Questions Answers [Q65-Q85]

Share

[Dec 22, 2021] Get New DBS-C01 Practice Test Questions Answers 

DBS-C01 Dumps and Exam Test Engine


The AWS Database Specialty certification validates the candidates' expertise in using AWS database services and helps them implement database technology to improve business processes.

 

NEW QUESTION 65
A company recently acquired a new business. A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account. The database specialist needs to minimize the amount of time required to migrate the database.
Which solution meets these requirements?

  • A. Use AWS Resource Access Manager to share the source DB instance with the destination account. Create a DB instance in the destination account using the shared resource.
  • B. Use mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.
  • C. Create a read replica of the DB instance. Give the destination account access to the read replica. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.
  • D. Create a snapshot of the source DB instance in the source account. Share the snapshot with the destination account. In the target account, create a DB instance from the snapshot.

Answer: D

 

NEW QUESTION 66
A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQLDB instance. Immediately after creating the read replica, users that query it report slow response times.
What could be causing these slow response times?

  • A. New volumes created from snapshots load lazily in the background
  • B. Long-running statements on the master
  • C. Insufficient resources on the master
  • D. Overload of a single replication thread by excessive writes on the master

Answer: B

 

NEW QUESTION 67
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?

  • A. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
  • B. The user name and password are correct, but the user is not authorized to use the DB instance.
  • C. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.
  • D. The user name and password the application is using are incorrect.

Answer: A

 

NEW QUESTION 68
A company's Security department established new requirements that state internal users must connect to an existing Amazon RDS for SQL Server DB instance using their corporate Active Directory (AD) credentials. A Database Specialist must make the modifications needed to fulfill this requirement.
Which combination of actions should the Database Specialist take? (Choose three.)

  • A. Modify the RDS SQL Server DB instance to use the directory for Windows authentication. Create appropriate new logins.
  • B. Use the AWS Management Console to create an AWS Managed Microsoft AD. Create a trust relationship with the corporate AD.
  • C. Use the AWS Management Console to create an AD Connector. Create a trust relationship with the corporate AD.
  • D. Configure the AWS Managed Microsoft AD domain controller Security Group.
  • E. Disable Transparent Data Encryption (TDE) on the RDS SQL Server DB instance.
  • F. Stop the RDS SQL Server DB instance, modify it to use the directory for Windows authentication, and start it again. Create appropriate new logins.

Answer: A,B,D

Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerWinAuth.html

 

NEW QUESTION 69
A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours. Which solution will meet these requirements and is the MOST operationally efficient?

  • A. Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot.
  • B. Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30 days.
  • C. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.
  • D. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot. Move the snapshot to the company's Amazon S3 bucket.

Answer: D

Explanation:
Unlike automated backups, manual snapshots aren't subject to the backup retention period. Snapshots don't expire. For very long-term backups of MariaDB, MySQL, and PostgreSQL data, we recommend exporting snapshot data to Amazon S3. If the major version of your DB engine is no longer supported, you can't restore to that version from a snapshot. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html

 

NEW QUESTION 70
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 as the target DB instance
  • B. In the same VPC and Availability Zone as the source DB instance
  • C. In the same Region and VPC of the source DB instance
  • D. In the same VPC and Availability Zone as the target DB instance

Answer: B

 

NEW QUESTION 71
An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.
Which settings will meet this requirement? (Choose three.)

  • A. Set DeletionPolicy to Delete
  • B. Set DeleteAutomatedBackups to False
  • C. Set DeletionPolicy to Retain
  • D. Set DeletionProtection to True
  • E. Set TerminationProtection to True
  • F. Set MultiAZ to True

Answer: C,D,E

 

NEW QUESTION 72
A company wants to automate the creation of secure test databases with random credentials to be stored safely for later use. The credentials should have sufficient information about each test database to initiate a connection and perform automated credential rotations. The credentials should not be logged or stored anywhere in an unencrypted form.
Which steps should a Database Specialist take to meet these requirements using an AWS CloudFormation template?

  • A. Add a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property. Then, define the database user name in the SecureStringTemplate template. Create a resource for the database and reference the secret string for the MasterUserName and MasterUserPassword properties. Then, add a resource of type AWS::SecretsManagerSecretTargetAttachment with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database.
  • B. Create the database with the MasterUserName and MasterUserPassword properties set to the default values. Then, create the secret with the user name and password set to the same default values. Add a Secret Target Attachment resource with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database. Finally, update the secret's password value with a randomly generated string set by the GenerateSecretString property.
  • C. Create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add an SecretTargetAttachment resource with the SecretId property set to the Amazon Resource Name (ARN) of the secret and the TargetId property set to a parameter value matching the desired database ARN. Then, create a database with the MasterUserName and MasterUserPassword properties set to the previously created values in the secret.
  • D. Add a Mapping property from the database Amazon Resource Name (ARN) to the secret ARN. Then, create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add the database with the MasterUserName and MasterUserPassword properties set to the user name of the secret.

Answer: A

 

NEW QUESTION 73
A company is about to launch a new product, and test databases must be re-created from production dat a. 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?

  • A. Restore a snapshot from the production cluster into test clusters
  • B. Add an additional read replica to the production cluster and use that node for testing
  • C. Use database cloning to create clones of the production cluster
  • D. Create logical dumps of the production cluster and restore them into new test clusters

Answer: B

 

NEW QUESTION 74
An online retail company is planning a multi-day flash sale that must support processing of up to 5,000 orders per second. The number of orders and exact schedule for the sale will vary each day. During the sale, approximately 10,000 concurrent users will look at the deals before buying items. Outside of the sale, the traffic volume is very low. The acceptable performance for read/write queries should be under 25 ms. Order items are about 2 KB in size and have a unique identifier. The company requires the most cost-effective solution that will automatically scale and is highly available.
Which solution meets these requirements?

  • A. Amazon Aurora with one writer node and an Aurora Replica with the parallel query feature enabled
  • B. Amazon DynamoDB with provisioned capacity mode with 5,000 write capacity units (WCUs) and 10,000 read capacity units (RCUs)
  • C. Amazon DynamoDB with on-demand capacity mode
  • D. Amazon Aurora with one writer node and two cross-Region Aurora Replicas

Answer: B

 

NEW QUESTION 75
A company has a heterogeneous six-node production Amazon Aurora DB cluster that handles online transaction processing (OLTP) for the core business and OLAP reports for the human resources department. To match compute resources to the use case, the company has decided to have the reporting workload for the human resources department be directed to two small nodes in the Aurora DB cluster, while every other workload goes to four large nodes in the same DB cluster.
Which option would ensure that the correct nodes are always available for the appropriate workload while meeting these requirements?

  • A. Use custom endpoints to satisfy the different workloads.
  • B. Use the writer endpoint for OLTP and the reader endpoint for the OLAP reporting workload.
  • C. Create additional readers to cater to the different scenarios.
  • D. Use automatic scaling for the Aurora Replica to have the appropriate number of replicas for the desired workload.

Answer: D

 

NEW QUESTION 76
A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS. A deep review is performed and the AWS Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server Standard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL. The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.
What is the MOST cost-effective and operationally efficient solution?

  • A. Run SQL Server Enterprise Edition on Amazon EC2.
  • B. Run SQL Server Standard Edition on Amazon RDS.
  • C. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.
  • D. Run SQL Server Enterprise Edition on Amazon RDS.

Answer: C

 

NEW QUESTION 77
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?

  • A. Connect to the Aurora host and create cron jobs to run the maintenance jobs following the requiredschedule.
  • B. Create the maintenance job using the Amazon CloudWatch job scheduling plugin.
  • C. Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.
  • D. Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatchEvents.

Answer: B

 

NEW QUESTION 78
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 ensure that failovers occur with the least amount of downtime for the application?

  • A. Start a database activity stream on the DB cluster
  • B. Enable Enhanced Monitoring on the DB cluster
  • C. Call the AWS CLI failover-db-cluster command
  • D. Set the TCP keepalive parameters low

Answer: C

 

NEW QUESTION 79
A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times.
What could be causing these slow response times?

  • A. Overload of a single replication thread by excessive writes on the master snapshot is lazy loaded If the volume is accessed where the data is not loaded, the application accessing the volume encounters a higher latency than normal while the data gets loaded
  • B. Insufficient resources on the master
  • C. Long-running statements on the master
  • D. New volumes created from snapshots load lazily in the background

Answer: D

 

NEW QUESTION 80
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.)

  • A. Re-create global secondary indexes in the new table
  • B. Set the provisioned read and write capacity
  • C. Define the TTL settings
  • D. Encrypt the table from the AWS Management Console or use the update-table command
  • E. Define IAM policies for access to the new table

Answer: A,B

 

NEW QUESTION 81
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 certificatebundle and configure the PostgreSQL connection string with sslmode=verify-ca.
  • B. Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificatebundle and configure the PostgreSQL connection string with sslmode=allow.
  • C. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificatebundle and configure the PostgreSQL connection string with sslmode=disable.
  • D. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificatebundle and configure the PostgreSQL connection string with sslmode=verify-full.

Answer: D

 

NEW QUESTION 82
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?

  • A. Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region
  • B. 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
  • C. Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot ofthe read replica
  • D. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication tocopy the snapshot into another Region

Answer: C

 

NEW QUESTION 83
A company runs a customer relationship management (CRM) system that is hosted on-premises with a MySQL database as the backend. A custom stored procedure is used to send email notifications to another system when data is inserted into a table. The company has noticed that the performance of the CRM system has decreased due to database reporting applications used by various teams. The company requires an AWS solution that would reduce maintenance, improve performance, and accommodate the email notification feature.
Which AWS solution meets these requirements?

  • A. Use Amazon Aurora MySQL in a multi-master cluster to accommodate the reporting applications. Configure Amazon RDS event subscriptions to publish a message to an Amazon SNS topic and subscribe the other system's email address to the topic.
  • B. Use MySQL running on an Amazon EC2 instance with Auto Scaling to accommodate the reporting applications. Configure a stored procedure and an AWS Lambda function that uses Amazon SES to send email notifications to the other system.
  • C. Use Amazon Aurora MySQL with a read replica for the reporting applications. Configure a stored procedure and an AWS Lambda function to publish a message to an Amazon SNS topic. Subscribe the other system's email address to the topic.
  • D. Use MySQL running on an Amazon EC2 instance with a read replica to accommodate the reporting applications. Configure Amazon SES integration to send email notifications to the other system.

Answer: C

 

NEW QUESTION 84
A company is using Amazon Aurora PostgreSQL for the backend of its application. The system users are complaining that the responses are slow. A database specialist has determined that the queries to Aurora take longer during peak times. With the Amazon RDS Performance Insights dashboard, the load in the chart for average active sessions is often above the line that denotes maximum CPU usage and the wait state shows that most wait events are IO:XactSync.
What should the company do to resolve these performance issues?

  • A. Modify applications to commit transactions in batches.
  • B. Modify applications to avoid conflicts by taking locks.
  • C. Scale up the DB instance class.
  • D. Add an Aurora Replica to scale the read traffic.

Answer: D

 

NEW QUESTION 85
......

2021 New TestSimulate DBS-C01 PDF Recently Updated Questions: https://www.testsimulate.com/DBS-C01-study-materials.html

Amazon DBS-C01 DUMPS WITH REAL EXAM QUESTIONS: https://drive.google.com/open?id=1d9Nt7hSmctlfTV5mJNjXAfPomViD03Ry 

Related Blogs

more
Go To DBS-C01 Questions

Copyright © 2026 TESTSIMULATE.COM. All rights reserved. All trademarks are the property of their respective owners and we don't provide actual questions from any vendor.