All About Actual DBS-C01 Samples

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

• A. Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluste
• B. Verify the datatype of the columns.
• C. 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.
• D. Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigrationchecklist to make sure there are no issues with the conversion.
• E. Enable AWS DMS data validation on the task so the AWS DMS task compares the source and targetrecords, and reports any mismatches.

Answer: D

NEW QUESTION 2
A gaming company has implemented a leaderboard in AWS using a Sorted Set data structure within Amazon ElastiCache for Redis. The ElastiCache cluster has been deployed with cluster mode disabled and has a replication group deployed with two additional replicas. The company is planning for a worldwide gaming event and is anticipating a higher write load than what the current cluster can handle.
Which method should a Database Specialist use to scale the ElastiCache cluster ahead of the upcoming event?

• A. Enable cluster mode on the existing ElastiCache cluster and configure separate shards for the Sorted Setacross all nodes in the cluster.
• B. Increase the size of the ElastiCache cluster nodes to a larger instance size.
• C. Create an additional ElastiCache cluster and load-balance traffic between the two clusters.
• D. Use the EXPIRE command and set a higher time to live (TTL) after each call to increment a given key.

Answer: B

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

• A. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
• B. Provision a clone of the existing DB cluster for the new Application team.
• C. 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).
• D. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPUconsumption.

Answer: A

NEW QUESTION 4
A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost-effective and able to handle unpredictable application traffic.
What should a Database Specialist recommend for this user?

• A. Create an Amazon DynamoDB table with provisioned capacity mode
• B. Create an Amazon DocumentDB cluster
• C. Create an Amazon DynamoDB table with on-demand capacity mode
• D. Create an Amazon Aurora Serverless DB cluster

Answer: C

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

• A. The source DB instance has to be converted to Single-AZ first to create a read replica from it.
• B. Enhanced Monitoring is not enabled on the source DB instance.
• C. The minor MySQL version in the source DB instance does not support read replicas.
• D. Automated backups are not enabled on the source DB instance.

Answer: D

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

• A. Enable DocumentDB to export the logs to Amazon CloudWatch Logs
• B. Enable DocumentDB to export the logs to AWS CloudTrail
• C. Enable DocumentDB Events to export the logs to Amazon CloudWatch Logs
• D. Configure an AWS Lambda function to download the logs using the download-db-log-file-portion operationand store the logs in Amazon S3

Answer: A

NEW QUESTION 7
A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB instance goes live.
What change should the Database Specialist make to enable the migration?

• A. Configure the on-premises application database to act as a source for an AWS DMS full load with ongoing change data capture (CDC)
• B. Configure the AWS DMS replication instance to allow both full load and ongoing change data capture(CDC)
• C. Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)
• D. Configure the AWS DMS connections to allow two-way communication to allow for ongoing change datacapture (CDC)

Answer: A

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

• A. Use a specific instance endpoint for each replica and add the instance endpoint to each read-onlyapplication 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-onlyapplication.
• D. Use custom endpoints for the two read-only applications.

Answer: B

NEW QUESTION 9
A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too time-consuming, so it is not an option.
How should the Database Specialist satisfy this new requirement?

• A. Create a snapshot of the unencrypted RDS DB instanc
• B. Create an encrypted copy of the unencryptedsnapsho
• C. Restore the encrypted snapshot copy.
• D. Modify the RDS DB instanc
• E. Enable the AWS KMS encryption option that leverages the AWS CLI.
• F. Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
• G. Create an encrypted read replica of the RDS DB instanc
• H. Promote it the master.

Answer: A

NEW QUESTION 10
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. Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.
• B. Connect to the Aurora host and create cron jobs to run the maintenance jobs following the requiredschedule.
• C. Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatchEvents.
• D. Create the maintenance job using the Amazon CloudWatch job scheduling plugin.

Answer: D

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

• A. Ensure that the database option group for the RDS DB instance allows ingress from theDevelopermachine’s IP address
• B. Ensure that the RDS DB instance’s subnet group includes a public subnet to allow the Developer toconnect
• C. Ensure that the RDS DB instance has not reached its maximum connections limit
• D. Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listeningfor encrypted connections

Answer: B

NEW QUESTION 12
After restoring an Amazon RDS snapshot from 3 days ago, a company’s Development team cannot connect tothe restored RDS DB instance. What is the likely cause of this problem?

• A. The restored DB instance does not have Enhanced Monitoring enabled
• B. The production DB instance is using a custom parameter group
• C. The restored DB instance is using the default security group
• D. The production DB instance is using a custom option group

Answer: B

NEW QUESTION 13
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.

Answer: A

NEW QUESTION 14
A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse solution. The company plans to use the AWS Schema Conversion Tool (AWS SCT) and AWS DMS for the migration to AWS. The site network bandwidth is 500 Mbps. A Database Specialist wants to migrate the on-premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse. This move must take place during a 2-week period when source systems are shut down for maintenance. The data should stay encrypted at rest and in transit.
Which approach has the least risk and the highest likelihood of a successful data transfer?

• A. Set up a VPN tunnel for encrypting data over the network from the data center to AW
• B. Leverage AWSSCT and apply the converted schema to Amazon Redshif
• C. Once complete, start an AWS DMS task tomove the data from the source to Amazon S3. Use AWS Glue to load the data from Amazon S3 to AmazonRedshift.
• D. Leverage AWS SCT and apply the converted schema to Amazon Redshif
• E. Start an AWS DMS task withtwo AWS Snowball Edge devices to copy data from on-premises to Amazon S3 with AWS KMS encryption.Use AWS DMS to finish copying data to Amazon Redshift.
• F. Leverage AWS SCT and apply the converted schema to Amazon Redshif
• G. Once complete, use a fleet of10 TB dedicated encrypted drives using the AWS Import/Export feature to copy data fromon-premises toAmazon S3 with AWS KMS encryptio
• H. Use AWS Glue to load the data to Amazon redshift.
• I. Set up a VPN tunnel for encrypting data over the network from the data center to AW
• J. Leverage a nativedatabase export feature to export the data and compress the file
• K. Use the aws S3 cp multi-port uploadcommand to upload these files to Amazon S3 with AWS KMS encryptio
• L. Once complete, load the data toAmazon Redshift using AWS Glue.

Answer: C

NEW QUESTION 15
A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.
Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

• A. Grant least privilege to groups, users, and roles
• B. Allow all users to restore a database from a backup that will reduce the overall downtime to restore thedatabase
• C. Enable multi-factor authentication for sensitive operations to access sensitive resources and APIoperations
• D. Use policy conditions to restrict access to selective IP addresses
• E. Use AccessList Controls policy type to restrict users for database instance deletion
• F. Enable AWS CloudTrail logging and Enhanced Monitoring

Answer: ACD

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

• A. Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
• B. Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
• C. Enable Amazon RDS Performance Insights and review the appropriate dashboard
• D. Enable Enhanced Monitoring will the appropriate settings

Answer: C

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

• A. Change the table to use Amazon DynamoDB Streams
• B. Purchase DynamoDB reserved capacity in the affected Region
• C. Increase the write capacity units for the specific table
• D. Change the table capacity mode to on-demand
• E. Change the table type to throughput optimized

Answer: CE

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

• A. Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp).Rundata transformations in AWS Glu
• B. Load the data from the S3 bucket to the Aurora DB cluster.
• C. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball applianc
• D. Once theSnowball data is delivered to Amazon S3, create a new Aurora DB cluste
• E. Enable the S3 integration tomigrate the data directly from Amazon S3 to Amazon RDS.
• F. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during theschema migratio
• G. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
• H. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an AmazonEC2 instanc
• I. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to anAurora DB cluster.

Answer: D

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

Answer: D

NEW QUESTION 20
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 DeletionProtection to True
• B. Set MultiAZ to True
• C. Set TerminationProtection to True
• D. Set DeleteAutomatedBackups to False
• E. Set DeletionPolicy to Delete
• F. Set DeletionPolicy to Retain

Answer: ACF

NEW QUESTION 21
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.

Answer: A

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

• A. Aurora will promote an Aurora Replica that is of the same size as the primary instance
• B. Aurora will promote an arbitrary Aurora Replica
• C. Aurora will promote the largest-sized Aurora Replica
• D. Aurora will not promote an Aurora Replica

Answer: A

NEW QUESTION 23
A clothing company uses a custom ecommerce application and a PostgreSQL database to sell clothes to thousands of users from multiple countries. The company is migrating its application and database from its on premises data center to the AWS Cloud. The company has selected Amazon EC2 for the application and Amazon RDS for PostgreSQL for the database. The company requires database passwords to be changed every 60 days. A Database Specialist needs to ensure that the credentials used by the web application to connect to the database are managed securely.
Which approach should the Database Specialist take to securely manage the database credentials?

• A. Store the credentials in a text file in an Amazon S3 bucke
• B. Restrict permissions on the bucket to the IAM role associated with the instance profile onl
• C. Modify the application to download the text file and retrieve the credentials on start u
• D. Update the text file every 60 days.
• E. Configure IAM database authentication for the application to connect to the databas
• F. Create an IAM user and map it to a separate database user for each ecommerce use
• G. Require users to update their passwords every 60 days.
• H. Store the credentials in AWS Secrets Manage
• I. Restrict permissions on the secret to only the IAM role associated with the instance profil
• J. Modify the application to retrieve the credentials from Secrets Manager on start u
• K. Configure the rotation interval to 60 days.
• L. Store the credentials in an encrypted text file in the application AM
• M. Use AWS KMS to store the key fordecrypting the text fil
• N. Modify the application to decrypt the text file and retrieve the credentials on start u
• O. Update the text file and publish a new AMI every 60 days.

Answer: B

NEW QUESTION 24
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

Answer: B

NEW QUESTION 25
......