[Nov 18, 2021] Genuine DBS-C01 Exam Dumps New 2021 Amazon Pratice Exam
New 2021 Realistic DBS-C01 Dumps Test Engine Exam Questions in here
AWS Database Specialty Exam Syllabus Topics:
| Section | Objectives |
|---|---|
Workload-Specific Database Design - 26% | |
| Select appropriate database services for specific types of data and workloads. | - Differentiate between ACID vs. BASE workloads - Explain appropriate uses of types of databases (e.g., relational, key-value, document, in-memory, graph, time series, ledger) - Identify use cases for persisted data vs. ephemeral data |
| Determine strategies for disaster recovery and high availability. | - Select Region and Availability Zone placement to optimize database performance - Determine implications of Regions and Availability Zones on disaster recovery/high availability strategies - Differentiate use cases for read replicas and Multi-AZ deployments |
| Design database solutions for performance, compliance, and scalability. | - Recommend serverless vs. instance-based database architecture - Evaluate requirements for scaling read replicas - Define database caching solutions - Evaluate the implications of partitioning, sharding, and indexing - Determine appropriate instance types and storage options - Determine auto-scaling capabilities for relational and NoSQL databases - Determine the implications of Amazon DynamoDB adaptive capacity - Determine data locality based on compliance requirements |
| Compare the costs of database solutions. | - Determine cost implications of Amazon DynamoDB capacity units, including on-demand vs. provisioned capacity - Determine costs associated with instance types and automatic scaling - Design for costs including high availability, backups, multi-Region, Multi-AZ, and storage type options - Compare data access costs |
Deployment and Migration - 20% | |
| Automate database solution deployments. | - Evaluate application requirements to determine components to deploy - Choose appropriate deployment tools and services (e.g., AWS CloudFormation, AWS CLI) |
| Determine data preparation and migration strategies. | - Determine the data migration method (e.g., snapshots, replication, restore) - Evaluate database migration tools and services (e.g., AWS DMS, native database tools) - Prepare data sources and targets - Determine schema conversion methods (e.g., AWS Schema Conversion Tool) - Determine heterogeneous vs. homogeneous migration strategies |
| Execute and validate data migration. | - Design and script data migration - Run data extraction and migration scripts - Verify the successful load of data |
Management and Operations - 18% | |
| Determine maintenance tasks and processes. | - Account for the AWS shared responsibility model for database services - Determine appropriate maintenance window strategies - Differentiate between major and minor engine upgrades |
| Determine backup and restore strategies. | - Identify the need for automatic and manual backups/snapshots - Differentiate backup and restore strategies (e.g., full backup, point-in-time, encrypting backups cross-Region) - Define retention policies - Correlate the backup and restore to recovery point objective (RPO) and recovery time objective (RTO) requirements |
| Manage the operational environment of a database solution. | - Orchestrate the refresh of lower environments - Implement configuration changes (e.g., in Amazon RDS option/parameter groups or Amazon DynamoDB indexing changes) - Automate operational tasks - Take action based on AWS Trusted Advisor reports |
Monitoring and Troubleshooting - 18% | |
| Determine monitoring and alerting strategies. | - Evaluate monitoring tools (e.g., Amazon CloudWatch, Amazon RDS Performance Insights, database native) - Determine appropriate parameters and thresholds for alert conditions - Use tools to notify users when thresholds are breached (e.g., Amazon SNS, Amazon SQS, Amazon CloudWatch dashboards) |
| Troubleshoot and resolve common database issues. | - Identify, evaluate, and respond to categories of failures (e.g., troubleshoot connectivity; instance, storage, and partitioning issues) - Automate responses when possible |
| Optimize database performance. | - Troubleshoot database performance issues - Identify appropriate AWS tools and services for database optimization - Evaluate the configuration, schema design, queries, and infrastructure to improve performance |
Database Security - 18% | |
| Encrypt data at rest and in transit. | - Encrypt data in relational and NoSQL databases - Apply SSL connectivity to databases - Implement key management (e.g., AWS KMS, AWS CloudHSM) |
| Evaluate auditing solutions. | - Determine auditing strategies for structural/schema changes (e.g., DDL) - Determine auditing strategies for data changes (e.g., DML) - Determine auditing strategies for data access (e.g., queries) - Determine auditing strategies for infrastructure changes (e.g., AWS CloudTrail) - Enable the export of database logs to Amazon CloudWatch Logs |
| Determine access control and authentication mechanisms. | - Recommend authentication controls for users and roles (e.g., IAM, native credentials, Active Directory) - Recommend authorization controls for users (e.g., policies) |
| Recognize potential security vulnerabilities within database solutions. | - Determine security group rules and NACLs for database access - Identify relevant VPC configurations (e.g., VPC endpoints, public vs. private subnets, demilitarized zone) - Determine appropriate storage methods for sensitive data |
NEW QUESTION 68
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. 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.
- B. 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.
- 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. 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.
Answer: A
NEW QUESTION 69
A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The solution should also automate configuration changes across all Regions.
Which solution would meet these requirements and deploy the DynamoDB tables?
- A. Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
- B. Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-bystep guide for future deployments.
- C. Create an AWS CloudFormation template and deploy the template to all the Regions.
- D. Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
Answer: C
NEW QUESTION 70
An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application.
The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts.
How should a Database Specialist address these requirements?
- A. Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance
- B. Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into AmazonRedshift
- C. Use DynamoDB Accelerator to offload the reads
- D. Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
Answer: B
NEW QUESTION 71
A company has applications running on Amazon EC2 instances in a private subnet with no internet connectivity. The company deployed a new application that uses Amazon DynamoDB, but the application cannot connect to the DynamoDB tables. A developer already checked that all permissions are set correctly.
What should a database specialist do to resolve this issue while minimizing access to external resources?
- A. Assign a new security group to the EC2 instances with an outbound rule to ports 80 and 443.
- B. Create a VPC endpoint for DynamoDB and add a route to the endpoint in the subnet's route table.
- C. Add a route to a NAT gateway in the subnet's route table.
- D. Add a route to an internet gateway in the subnet's route table.
Answer: C
NEW QUESTION 72
An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
* Update scores in real time whenever a player is playing the game.
* Retrieve a player's score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?
- A. Create a global secondary index with user_id as the partition key
- B. Create a composite primary key with user_id as the partition key and game_id as the sort key
- C. Create a global secondary index with game_id as the partition key
- D. Create a composite primary key with game_id as the partition key and user_id as the sort key
Answer: A
NEW QUESTION 73
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 74
A company has two separate AWS accounts: one for the business unit and another for corporate analytics. The company wants to replicate the business unit data stored in Amazon RDS for MySQL in us-east-1 to its corporate analytics Amazon Redshift environment in us-west-1. The company wants to use AWS DMS with Amazon RDS as the source endpoint and Amazon Redshift as the target endpoint.
Which action will allow AVS DMS to perform the replication?
- A. Configure the AWS DMS replication instance in the same account and Region as Amazon RDS.
- B. Configure the AWS DMS replication instance in its own account and in the same Region as Amazon Redshift.
- C. Configure the AWS DMS replication instance in the same account and Region as Amazon Redshift.
- D. Configure the AWS DMS replication instance in the same account as Amazon Redshift and in the same Region as Amazon RDS.
Answer: B
NEW QUESTION 75
A company has migrated a single MySQL database to Amazon Auror
a. The production data is hosted in a DB cluster in VPC_PROD, and 12 testing environments are hosted in VPC_TEST using the same AWS account. Testing results in minimal changes to the test data. The Development team wants each environment refreshed nightly so each test database contains fresh production data every day.
Which migration approach will be the fastest and most cost-effective to implement?
- A. Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
- B. Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
- C. Run the master in Amazon Aurora MySQL. Create 12 Aurora Replicas in VPC_TEST, and script the replicas to be deleted and re-created nightly.
- D. Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.
Answer: B
NEW QUESTION 76
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 77
A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The company requires fast responses for end-user queries when looking at data from the current year, and users must have access to the full 15-year dataset, when needed. This solution also needs to handle a fluctuating number incoming queries. Storage costs for the 100 TB of data must be kept low.
Which solution meets these requirements?
- A. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling.
- B. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Leverage Amazon Redshift elastic resize.
https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html
"With the Concurrency Scaling feature, you can support virtually unlimited concurrent users and concurrent queries, with consistently fast query performance. When concurrency scaling is enabled, Amazon Redshift automatically adds additional cluster capacity when you need it to process an increase in concurrent read queries. Write operations continue as normal on your main cluster. Users always see the most current data, whether the queries run on the main cluster or on a concurrency scaling cluster. You're charged for concurrency scaling clusters only for the time they're in use. For more information about pricing, see Amazon Redshift pricing. You manage which queries are sent to the concurrency scaling cluster by configuring WLM queues. When you enable concurrency scaling for a queue, eligible queries are sent to the concurrency scaling cluster instead of waiting in line." - C. Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storage. Provision enough instances to support high demand.
- D. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Provision enough instances to support high demand.
Answer: A
NEW QUESTION 78
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. Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
- B. Modify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.
- C. Create an encrypted read replica of the RDS DB instance. Promote it the master.
- D. Create a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencryptedsnapshot. Restore the encrypted snapshot copy.
Answer: D
NEW QUESTION 79
A company is migrating its on-premises database workloads to the AWS Cloud. A database specialist performing the move has chosen AWS DMS to migrate an Oracle database with a large table to Amazon RDS. The database specialist notices that AWS DMS is taking significant time to migrate the data.
Which actions would improve the data migration speed? (Choose three.)
- A. Establish an AWS Direct Connect connection between the on-premises data center and AWS.
- B. Enable an Amazon RDS Multi-AZ configuration.
- C. Configure the AWS DMS replication instance with Multi-AZ.
- D. Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.
- E. Increase the capacity of the AWS DMS replication server.
- F. Create multiple AWS DMS tasks to migrate the large table.
Answer: A,B,E
NEW QUESTION 80
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 time to live (TTL) on each table.
- C. 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.
- D. Create a new attribute in each table to track the expiration time and enable DynamoDB Streams on each table.
Answer: A
NEW QUESTION 81
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. 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.
- B. Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring toolthat will run reports based on the output error logs.
- C. Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and diskspace consumption. Watch these dashboards during the next slow period.
- 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 82
A company needs to migrate Oracle Database Standard Edition running on an Amazon EC2 instance to an Amazon RDS for Oracle DB instance with Multi-AZ. The database supports an ecommerce website that runs continuously. The company can only provide a maintenance window of up to 5 minutes.
Which solution will meet these requirements?
- A. Configure AWS DataSync with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.
- B. Export the Oracle database from the EC2 instance using Oracle Data Pump and perform an import into Amazon RDS. Stop the application for the entire process. When the import is complete, change the database connection string and then restart the application.
- C. Configure AWS DMS with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.
- D. Configure Oracle Real Application Clusters (RAC) on the EC2 instance and the RDS DB instance. Update the connection string to point to the RAC cluster. Once the EC2 instance and RDS DB instance are in sync, fail over from Amazon EC2 to Amazon RDS.
Answer: B
NEW QUESTION 83
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 a database snapshot of the RDS for PostgreSQL DB instance and use this snapshot to create the Aurora PostgreSQL DB cluster.
- B. Use the pg_dump and pg_restore utilities to extract and restore the RDS for PostgreSQL DB instance to the Aurora PostgreSQL DB cluster.
- C. Create an Aurora PostgreSQL DB cluster. Set up replication from the source RDS for PostgreSQL DB instance using AWS DMS to the target DB cluster.
- D. Migrate data from the RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster using an Aurora Replica. Promote the replica during the cutover.
Answer: A
NEW QUESTION 84
A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.
What is the MOST cost-effective action that should be taken to avoid downtime?
- A. Enable a read replicas and direct read traffic to it when Amazon RDS is down
- B. Enable an Amazon RDS for MySQL Multi-AZ configuration
- C. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
- D. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
Answer: A
NEW QUESTION 85
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 86
A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL.
The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.
How should the Database Specialist edit the script to fix this issue?
- A. Use the AWS CLI to stop each read replica and source instance at the same time
- B. Stop the source instances before stopping their read replicas
- C. Stop the read replicas before stopping their source instances
- D. Delete each read replica before stopping its corresponding source instance
Answer: A
NEW QUESTION 87
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 Neptune for storage
- B. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling
- C. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
- D. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
Answer: B
NEW QUESTION 88
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. Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.
- B. Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
- C. Use Amazon QuickSight to view the SQL statement being run.
- D. Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.
- E. Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQLstatements, hosts, or users.
Answer: B,E
NEW QUESTION 89
A company is using an Amazon RDS for MySQL DB instance for its internal applications. A security audit shows that the DB instance is not encrypted at rest. The company's application team needs to encrypt the DB instance.
What should the team do to meet this requirement?
- A. Stop the DB instance and create an encrypted snapshot. Restore the encrypted snapshot to a new encrypted DB instance. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.
- B. Stop the DB instance and create a snapshot. Copy the snapshot into another encrypted snapshot. Restore the encrypted snapshot to a new encrypted DB instance. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.
- C. Stop the DB instance and modify it to enable encryption. Apply this setting immediately without waiting for the next scheduled RDS maintenance window.
- D. Create an encrypted read replica of the DB instance. Promote the read replica to master. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.
Answer: C
NEW QUESTION 90
A manufacturing company's website uses an Amazon Aurora PostgreSQL DB cluster.
Which configurations will result in the LEAST application downtime during a failover? (Choose three.)
- A. Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
- B. Edit and enable Aurora DB cluster cache management in parameter groups.
- C. Set Java DNS caching timeouts to a high value.
- D. Set JDBC connection string timeout variables to a low value.
- E. Set TCP keepalive parameters to a high value.
- F. Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
Answer: A,B,F
NEW QUESTION 91
......
Understanding functional and technical aspects of AWS Certified Database - Specialty Workload-Specific Database Design
The following will be discussed in AMAZON DBS-C01 dumps:
- Determine strategies for disaster recovery and high availability
- Select appropriate database services for specific types of data and workloads
- Design database solutions for performance, compliance, and scalability
- Compare the costs of database solutions
Exam Details and Topics
The Amazon AWS Certified Database – Specialty certification exam comes with the code DBS-C01. This test consists of 65 questions that are presented in the multiple-response and multiple-choice formats. It is expected that the students are able to complete all these items within the allocated time of 180 minutes. To pass the exam, the candidates must score at least 750 points. It also required that they pay the fee of $300. Please note that this test is available in different languages, including English, Japanese, Korean, and Simplified Chinese.
Grab latest Amazon DBS-C01 Dumps as PDF Updated: https://www.actualtests4sure.com/DBS-C01-test-questions.html
Updated Official licence for DBS-C01 Certified by DBS-C01 Dumps PDF: https://drive.google.com/open?id=1X14avvIUMwXzay9GyuudGs3-o4sYC5in
