Pass AWS-Certified-Database-Specialty Exam - Real Test Engine PDF with 147 Questions
Get New AWS-Certified-Database-Specialty Certification Practice Test Questions Exam Dumps
Below is a salary of AWS Certified Database Specialty Certified Professional
- England: 83,255 Pound
- United States: 108,849 USD
- Europe: 98,725 Euro
- India: 7,63,709 INR
AWS DBS-C01 Exam Certification Details:
| Schedule Exam | PEARSON VUE |
| Passing Score | 750 / 1000 |
| Exam Name | AWS Certified Database - Specialty |
| Exam Price | $300 USD |
| Recommended Training / Books | AWS Database Offerings Planning and Designing Databases on AWS Exam Readiness - AWS Certified Database - Specialty |
| Sample Questions | AWS DBS-C01 Sample Questions |
| Duration | 180 minutes |
Career Prospects
Amazon AWS Certified Database – Specialty is considered an industry recognized certificate. It validates your expertise in the larger extent of general AWS database services and fuels the overall performance of database technology to effectively drive the business transformation of an organization. After passing the Amazon DBS-C01 exam, you will be regarded as a highly qualified professional. This gives you the opportunity to be listed for interviews for various job roles, such as a Database Administrator, a Solutions Architect, an Infrastructure Cloud Engineer, a Network Engineer, a Senior Technical Trainer, a Cloud Engineer, a Senior Database Cloud Security Administrator, an IT Security Specialist, a Principal Software Engineer Developer, and a Data Architect. Besides that, the certified individuals can ask for a higher salary. With the Amazon AWS Certified Database – Specialty certification, your payment can vary from $30,000 to $150,000 per year. The number of wages will depend on several criteria, such as the organization you work for, your position, related tasks, and working experience, among others.
NEW QUESTION 19
A global digital advertising company captures browsing metadata to contextually display relevant images,pages, and links to targeted users. A single page load can generate multiple events that need to be storedindividually. The maximum size of an event is 200 KB and the average size is 10 KB. Each page load mustquery the user's browsing history to provide targeting recommendations. The advertising company expectsover 1 billion page visits per day from users in the United States, Europe, Hong Kong, and India. The structureof the metadata varies depending on the event. Additionally, the browsing metadata must be written and readwith very low latency to ensure a good viewing experience for the users.
Which database solution meets these requirements?
- A. Amazon DocumentDB
- B. Amazon Aurora Global Database
- C. Amazon DynamoDB global table
- D. Amazon RDS Multi-AZ deployment
Answer: C
NEW QUESTION 20
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 new RDS DB instance with the required storage and move the databases from the old instancesto the new instance using AWS DMS
- B. Create a new database using native backup and restore
- C. Create a new read replica and make it the primary by terminating the existing primary
- D. Create a snapshot of the old databases and restore the snapshot with the required storage
Answer: D
NEW QUESTION 21
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 a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot ofthe read replica
- C. 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
- D. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication tocopy the snapshot into another Region
Answer: B
NEW QUESTION 22
The Amazon CloudWatch metric for FreeLocalStorage on an Amazon Aurora MySQL DB instance shows that the amount of local storage is below 10 MB. A database engineer must increase the local storage available in the Aurora DB instance.
How should the database engineer meet this requirement?
- A. Modify the DB instance to use an instance class that provides more local SSD storage.
- B. Increase the local storage by upgrading the database engine version.
- C. Modify the Aurora DB cluster to enable automatic volume resizing.
- D. Modify the DB instance and configure the required storage volume in the configuration section.
Answer: D
NEW QUESTION 23
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 diskspace consumption. Watch these dashboards during the next slow period.
- B. 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.
- C. Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring toolthat will run reports based on the output error logs.
- D. Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify anyqueries that are related to spikes in the graph during the next slow period.
Answer: D
NEW QUESTION 24
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. Provision a clone of the existing DB cluster for the new Application team.
- B. 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).
- C. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPUconsumption.
- D. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
Answer: D
NEW QUESTION 25
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup.
The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company.
Which solution will meet these requirements with minimal effort?
- A. Create an Amazon Cloudwatch Events rule with the operations that need to be tracked on Amazon RDS.
Create an AWS Lambda function to act on these rules and write the output to the tracking systems. - B. Create an AWS Lambda function to trigger on AWS CloudTrail API calls. Filter on specific RDS API calls and write the output to the tracking systems.
- C. Create RDS event subscriptions. Have the tracking systems subscribe to specific RDS event system notifications.
- D. Write RDS logs to Amazon Kinesis Data Firehose. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
Answer: C
NEW QUESTION 26
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 cluster. Identify the gaps and compatibility of the objects migrated by comparing row counts from source and target tables.
- B. Run AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing the row counts from source and target tables.
- C. Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate the migration compatibility.
- D. 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 27
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 Aurora Serverless DB cluster
- C. Create an Amazon DynamoDB table with on-demand capacity mode
- D. Create an Amazon DocumentDB cluster
Answer: C
NEW QUESTION 28
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. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an Amazon EC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to an Aurora DB cluster.
- B. Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp). Run data transformations in AWS Glue. 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 appliance. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration to migrate the data directly from Amazon S3 to Amazon RDS.
- D. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
Answer: A
NEW QUESTION 29
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. Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic
- B. Preprovision additional capacity for the known peaks and then reduce the capacity after the event
- C. Ensure the table is always provisioned to meet peak needs
- D. Allow burst capacity to handle the additional load
Answer: D
NEW QUESTION 30
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 AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
- B. Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.
- C. Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.
- D. Use pg_audit to generate audit logs and send the logs to the Security team.
Answer: A
NEW QUESTION 31
A retail company manages a web application that stores data in an Amazon DynamoDB table. The company is undergoing account consolidation efforts. A database engineer needs to migrate the DynamoDB table from the current AWS account to a new AWS account.
Which strategy meets these requirements with the LEAST amount of administrative work?
- A. Create an AWS Lambda function to scan the items of the DynamoDB table in the current account and write to a file in Amazon S3. Create another Lambda function to read the S3 file and restore the items of a DynamoDB table in the new account.
- B. Use AWS Data Pipeline in the current account to export the data from the DynamoDB table to a file in Amazon S3. Use Data Pipeline to import the data from the S3 file to a DynamoDB table in the new account.
- C. Use AWS Glue to crawl the data in the DynamoDB table. Create a job using an available blueprint to export the data to Amazon S3. Import the data from the S3 file to a DynamoDB table in the new account.
- D. Configure Amazon DynamoDB Streams for the DynamoDB table in the current account. Create an AWS Lambda function to read from the stream and write to a file in Amazon S3. Create another Lambda function to read the S3 file and restore the items to a DynamoDB table in the new account.
Answer: B
NEW QUESTION 32
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 an Amazon S3 bucket and set the lifecycle policy to 180 days
- D. Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to180 days
- E. Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file
Answer: A,E
NEW QUESTION 33
A media company is using Amazon RDS for PostgreSQL to store user dat
a. 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. Disable the publicly accessible setting.
- B. Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
- C. Move the DB instance to a private subnet using AWS DMS.
- D. Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
- E. Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
- F. Connect to the DB instance using private IPs and a VPN.
Answer: A,B,F
NEW QUESTION 34
A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made.
What should the database specialist do to meet these requirements? (Choose two.)
- A. SSH to the DB instance and review the database logs.
- B. Enable auditing of CONNECT and QUERY_DML events.
- C. Enable Enhanced Monitoring on the DB instance.
- D. Create an RDS event subscription to the audit event type.
- E. Publish the database logs to Amazon CloudWatch Logs.
Answer: D,E
NEW QUESTION 35
......
AWS-Certified-Database-Specialty Exam Dumps - PDF Questions and Testing Engine: https://actualtests.test4engine.com/AWS-Certified-Database-Specialty-real-exam-questions.html