Top Tips Of Replace DBS-C01 Free Demo

NEW QUESTION 1
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 2
A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load fata from Amazon S3 into the Neptune DB cluster using the Neptune bulk loader API. The Database Specialist receives the following error:
“Unable to connect to s3 endpoint. Provided source = s3://mybucket/graphdata/ and region = us-east-1. Please verify your S3 configuration.”
Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)

• A. Check that Amazon S3 has an IAM role granting read access to Neptune
• B. Check that an Amazon S3 VPC endpoint exists
• C. Check that a Neptune VPC endpoint exists
• D. Check that Amazon EC2 has an IAM role granting read access to Amazon S3
• E. Check that Neptune has an IAM role granting read access to Amazon S3

Answer: BD

NEW QUESTION 3
A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.
Which AWS services should the Database Specialist consider? (Choose two.)

• A. Amazon DynamoDB
• B. Amazon Redshift
• C. Amazon Neptune
• D. Amazon Elasticsearch Service
• E. Amazon ElastiCache

Answer: AE

NEW QUESTION 4
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 reportin
• B. Monitor and set up replication between the two clusters to keep data consistent.
• C. Review all evaluate the peak combined workloa
• D. Ensure that utilization of the DB cluster node is at an acceptable leve
• E. Adjust the number of instances, if necessary.
• F. Use the stop cluster functionality to stop all the nodes of the DB cluster during times of minimal workloa
• G. The cluster can be restarted again depending on the workload at the time.
• H. Set up automatic scaling on the DB cluste
• I. This will allow the number of reader nodes to adjust automatically to the reporting workload, when needed.

Answer: D

NEW QUESTION 5
A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts. Post-migration, the company purged unwanted data from the instance. The company now want to downsize storage to save money. The solution must have the least impact on production and near-zero downtime.
Which solution would meet these requirements?

• A. Create a snapshot of the old databases and restore the snapshot with the required storage
• B. Create a new RDS DB instance with the required storage and move the databases from the old instancesto the new instance using AWS DMS
• C. Create a new database using native backup and restore
• D. Create a new read replica and make it the primary by terminating the existing primary

Answer: A

NEW QUESTION 6
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 7
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 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 parameterwith the DB instance
• C. Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to180 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

Answer: AE

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

• A. Modify the pg_hba.conf fil
• B. Add the required corporate network IPs and remove the unwanted IPs.
• C. Modify the associated security grou
• D. Add the required corporate network IPs and remove the unwanted IPs.
• E. Move the DB instance to a private subnet using AWS DMS.
• F. Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
• G. Disable the publicly accessible setting.
• H. Connect to the DB instance using private IPs and a VPN.

Answer: DEF

NEW QUESTION 9
A company maintains several databases using Amazon RDS for MySQL and PostgreSQL. Each RDS database generates log files with retention periods set to their default values. The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and after-the-fact analyses.
What should a Database Specialist do to meet these requirements with minimal effort?

• A. Create an AWS Lambda function to pull logs from the RDS databases and consolidate the log files in an Amazon S3 bucke
• B. Set a lifecycle policy to expire the objects after 90 days.
• C. Modify the RDS databases to publish log to Amazon CloudWatch Log
• D. Change the log retention policy for each log group to expire the events after 90 days.
• E. Write a stored procedure in each RDS database to download the logs and consolidate the log files in an Amazon S3 bucke
• F. Set a lifecycle policy to expire the objects after 90 days.
• G. Create an AWS Lambda function to download the logs from the RDS databases and publish the logs to Amazon CloudWatch Log
• H. Change the log retention policy for the log group to expire the events after 90 days.

Answer: A

NEW QUESTION 10
A retail company is about to migrate its online and mobile store to AWS. The company’s CEO has strategic plans to grow the brand globally. A Database Specialist has been challenged to provide predictable read and write database performance with minimal operational overhead.
What should the Database Specialist do to meet these requirements?

• A. Use Amazon DynamoDB global tables to synchronize transactions
• B. Use Amazon EMR to copy the orders table data across Regions
• C. Use Amazon Aurora Global Database to synchronize all transactions
• D. Use Amazon DynamoDB Streams to replicate all DynamoDB transactions and sync them

Answer: A

NEW QUESTION 11
A gaming company is designing a mobile gaming app that will be accessed by many users across the globe. The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users.
Which solution meets these requirements?

• A. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling
• B. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
• C. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
• D. Use Amazon Neptune for storage

Answer: A

NEW QUESTION 12
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. Define IAM policies for access to the new table
• C. Define the TTL settings
• D. Encrypt the table from the AWS Management Console or use the update-table command
• E. Set the provisioned read and write capacity

Answer: AE

NEW QUESTION 13
A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users.
How should the Database Specialist apply the parameter group change for the DB instance?

• A. Select the option to apply the change immediately
• B. Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
• C. Apply the change manually by rebooting the DB instance during the approved maintenance window
• D. Reboot the secondary Multi-AZ DB instance

Answer: D

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

• A. DynamoDB Streams
• B. DynamoDB with DynamoDB Accelerator
• C. DynamoDB with on-demand capacity mode
• D. DynamoDB with provisioned capacity mode with Auto Scaling

Answer: C

NEW QUESTION 15
The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real-time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.
Which approach will meet these requirements?

• A. Use pg_audit to generate audit logs and send the logs to the Security team.
• B. Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
• C. Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.
• D. Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.

Answer: B

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

• A. Enable in-transit and at-rest encryption on the ElastiCache cluster.
• B. Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.
• C. 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.
• D. Create an IAM policy to allow the application service roles to access all ElastiCache API actions.
• E. 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.
• F. Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.

Answer: ABE

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

• A. Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.
• B. Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
• C. Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.
• D. Use Amazon QuickSight to view the SQL statement being run.
• E. Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQLstatements, hosts, or users.

Answer: BE

NEW QUESTION 19
A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:
ERROR: cloud not write block 7507718 of temporary file: No space left on device
What is the cause of this error and what should the Database Specialist do to resolve this issue?

• A. The scaling of Aurora storage cannot catch up with the data loadin
• B. The Database Specialist needs tomodify the workload to load the data slowly.
• C. The scaling of Aurora storage cannot catch up with the data loadin
• D. The Database Specialist needs toenable Aurora storage scaling.
• E. The local storage used to store temporary tables is ful
• F. The Database Specialist needs to scale up theinstance.
• G. The local storage used to store temporary tables is ful
• H. The Database Specialist needs to enable localstorage scaling.

Answer: C

NEW QUESTION 20
A company is running an Amazon RDS for PostgeSQL DB instance and wants to migrate it to an Amazon Aurora PostgreSQL DB cluster. The current database is 1 TB in size. The migration needs to have minimal downtime.
What is the FASTEST way to accomplish this?

• A. Create an Aurora PostgreSQL DB cluste
• B. Set up replication from the source RDS for PostgreSQL DB instance using AWS DMS to the target DB cluster.
• C. Use the pg_dump and pg_restore utilities to extract and restore the RDS for PostgreSQL DB instance to the Aurora PostgreSQL DB cluster.
• D. Create a database snapshot of the RDS for PostgreSQL DB instance and use this snapshot to create the Aurora PostgreSQL DB cluster.
• E. Migrate data from the RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster using an Aurora Replic
• F. Promote the replica during the cutover.

Answer: C

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

• A. Perform a logical dump from the Db2 database and restore it to an Aurora DB cluste
• B. Identify the gaps andcompatibility of the objects migrated by comparing row counts from source and target tables.
• C. Run AWS DMS from the Db2 database to an Aurora DB cluste
• D. Identify the gaps and compatibility of theobjects migrated by comparing the row counts from source and target tables.
• E. Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate themigration compatibility.
• F. 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.

Answer: D

NEW QUESTION 22
A company is deploying a solution in Amazon Aurora by migrating from an on-premises system. The IT department has established an AWS Direct Connect link from the company’s data center. The company’s Database Specialist has selected the option to require SSL/TLS for connectivity to prevent plaintext data from being set over the network. The migration appears to be working successfully, and the data can be queried from a desktop machine.
Two Data Analysts have been asked to query and validate the data in the new Aurora DB cluster. Both Analysts are unable to connect to Aurora. Their user names and passwords have been verified as valid and
the Database Specialist can connect to the DB cluster using their accounts. The Database Specialist also verified that the security group configuration allows network from all corporate IP addresses.
What should the Database Specialist do to correct the Data Analysts’ inability to connect?

• A. Restart the DB cluster to apply the SSL change.
• B. Instruct the Data Analysts to download the root certificate and use the SSL certificate on the connection string to connect.
• C. Add explicit mappings between the Data Analysts’ IP addresses and the instance in the security groupassigned to the DB cluster.
• D. Modify the Data Analysts’ local client firewall to allow network traffic to AWS.

Answer: D

NEW QUESTION 23
......