All Obstacles During AWS-Certified-Database-Specialty Exam Preparation with AWS-Certified-Database-Specialty Real Test Questions
Fully Updated Free Actual Amazon AWS-Certified-Database-Specialty Exam Questions
The Amazon AWS-Certified-Database-Specialty exam format of the Amazon DBS-C01 certification consists of multiple-choice and multiple-response questions. AWS-Certified-Database-Specialty exam is 170 minutes long, and the candidate must answer 65 questions. The questions are designed to test the candidate's knowledge of AWS database services, their application, and their deployment in a highly available and scalable environment. The candidate must score at least 750 out of 1000 to pass the exam.
NEW QUESTION # 25
A company is developing a new web application. An AWS CloudFormation template was created as a part of the build process.
Recently, a change was made to an AWS::RDS::DBInstance resource in the template. The CharacterSetName property was changed to allow the application to process international text. A change set was generated using the new template, which indicated that the existing DB instance should be replaced during an upgrade.
What should a database specialist do to prevent data loss during the stack upgrade?
- A. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack.
- B. Deactivate any applications that are using the DB instance. Create a snapshot of the DB instance.
Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack and reactivate the applications. - C. Modify the stack policy using the aws cloudformation update-stack command and the set-stack-policy command, then make the DB resource protected.
- D. Create a snapshot of the DB instance. Update the stack. Restore the database to a new instance.
Answer: B
Explanation:
Explanation
To preserve your data, perform the following procedure:
1.Deactivate any applications that are using the DB instance so that there's no activity on the DB instance.
2.Create a snapshot of the DB instance. For more information about creating DB snapshots
3.If you want to restore your instance using a DB snapshot, modify the updated template with your DB instance changes and add the DBSnapshotIdentifier property with the ID of the DB snapshot that you want to use
4.Update the stack.
NEW QUESTION # 26
A company is migrating a mission-critical 2-TB Oracle database from on premises to Amazon Auror a. The cost for the database migration must be kept to a minimum, and both the on-premises Oracle database and the Aurora DB cluster must remain open for write traffic until the company is ready to completely cut over to Aurora.
Which combination of actions should a database specialist take to accomplish this migration as quickly as possible? (Choose two.)
- A. Create an AWS Glue job and related resources to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS DMS task to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.
- B. Use Oracle's Data Pump tool to export a copy of the source database schema and manually edit the schema in a text editor to make it compatible with Aurora.
- C. Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema. Then restore the converted schema to the target Aurora DB cluster.
- D. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS Kinesis Data Firehose stream to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.
- E. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Select the migration type to replicate ongoing changes to keep the source and target databases in sync until the company is ready to move all user traffic to the Aurora DB cluster.
Answer: C,D
NEW QUESTION # 27
An advertising company is developing a backend for a bidding platform. The company needs a cost-effective datastore solution that will accommodate a sudden increase in the volume of write transactions. The database also needs to make data changes available in a near real-time data stream.
Which solution will meet these requirements?
- A. Amazon DynamoDB table with DynamoDB auto scaling
- B. Amazon DocumentDB (with MongoDB compatibility) cluster with a replica instance in a second Availability Zone
- C. Amazon Keyspaces (for Apache Cassandra)
- D. Amazon Aurora MySQL Multi-AZ DB cluster
Answer: A
NEW QUESTION # 28
A company's database specialist implements an AWS Database Migration Service (AWS DMS) task for change data capture (CDC) to replicate data from an on- premises Oracle database to Amazon S3. When usage of the company's application increases, the database specialist notices multiple hours of latency with the CDC.
Which solutions will reduce this latency? (Choose two.)
- A. Configure the DMS task to run in limited large binary object (LOB) mode.
- B. Create a Multi-AZ replication instance.
- C. Replicate tables in parallel by creating multiple DMS tasks for sets of tables that do not participate in common transactions.
- D. Configure the DMS task to run in full large binary object (LOB) mode.
- E. Load tables in parallel by creating multiple replication instances for sets of tables that participate in common transactions.
Answer: A,C
NEW QUESTION # 29
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. Create an IAM policy to allow the application service roles to access all ElastiCache API actions.
- B. Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.
- C. Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.
- D. 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.
- E. 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.
- F. Enable in-transit and at-rest encryption on the ElastiCache cluster.
Answer: C,E,F
Explanation:
https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/encryption.html
NEW QUESTION # 30
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 Amazon Redshift
- C. Use DynamoDB Accelerator to offload the reads
- D. Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
Answer: B
NEW QUESTION # 31
A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replica. The DB instance and the read replica are assigned to the default parameter group. The database team currently runs test queries against a read replica. The database team wants to create additional tables in the read replica that will only be accessible from the read replica to benefit the tests.
Which should the database specialist do to allow the database team to create the test tables?
- A. Create a new DB parameter group. Change the read_only parameter to false (read_only=0). Associate the read replica with the new group. Reboot the read replica. Connect to the read replica and create the tables.
- B. Contact AWS Support to disable read-only mode on the read replica. Reboot the read replica. Connect to the read replica and create the tables.
- C. Change the read_only parameter to false (read_only=0) in the default parameter group of the read replica. Perform a reboot without failover. Connect to the read replica and create the tables using the local_only MySQL option.
- D. Change the read_only parameter to false (read_only=0) in the default parameter group. Reboot the read replica. Connect to the read replica and create the tables.
Answer: A
Explanation:
Explanation
https://aws.amazon.com/premiumsupport/knowledge-center/rds-read-replica/
NEW QUESTION # 32
A gaming company is developing a new mobile game and decides to store the data for each user in Amazon DynamoDB. To make the registration process as easy as possible, users can log in with their existing Facebook or Amazon accounts. The company expects more than 10,000 users.
How should a database specialist implement access control with the LEAST operational effort?
- A. Use a single IAM user on the mobile app to access DynamoDB.
- B. Use web identity federation on the mobile app and AWS STS with an attached IAM role to get temporary credentials to access DynamoDB.
- C. Use a self-developed user management system on the mobile app that lets users access the data from DynamoDB through an API.
- D. Use web identity federation on the mobile app and create individual IAM users with credentials to access DynamoDB.
Answer: B
NEW QUESTION # 33
Application developers have reported that an application is running slower as more users are added. The application database is running on an Amazon Aurora DB cluster with an Aurora Replic a. The application is written to take advantage of read scaling through reader endpoints. A database specialist looks at the performance metrics of the database and determines that, as new users were added to the database, the primary instance CPU utilization steadily increased while the Aurora Replica CPU utilization remained steady.
How can the database specialist improve database performance while ensuring minimal downtime?
- A. Modify the Aurora DB cluster to add more replicas until the overall load stabilizes. Then, reduce the number of replicas once the application meets service level objectives.
- B. Restore the Aurora DB cluster to one that has an instance size with more CPU capacity. Then, swap the names of the old and new DB clusters.
- C. Modify the primary instance to a larger instance size that offers more CPU capacity.
- D. Modify a replica to a larger instance size that has more CPU capacity. Then, promote the modified replica.
Answer: D
NEW QUESTION # 34
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. Create logical dumps of the production cluster and restore them into new test clusters
- B. Add an additional read replica to the production cluster and use that node for testing
- C. Restore a snapshot from the production cluster into test clusters
- D. Use database cloning to create clones of the production cluster
Answer: B
NEW QUESTION # 35
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 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.
- B. Enable AWS DMS data validation on the task so the AWS DMS task compares the source and target records, and reports any mismatches.
- C. Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluster. Verify the datatype of the columns.
- D. Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigration checklist to make sure there are no issues with the conversion.
Answer: B
Explanation:
"To ensure that your data was migrated accurately from the source to the target, we highly recommend that you use data validation." https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html
NEW QUESTION # 36
A bank intends to utilize Amazon RDS to host a MySQL database instance. The database should be able to handle high-volume read requests with extremely few repeated queries.
Which solution satisfies these criteria?
- A. Create an Amazon ElastiCache cluster. Use a write-through strategy to populate the cache.
- B. Create an Amazon ElastiCache cluster. Use a lazy loading strategy to populate the cache.
- C. Change the DB instance to Multi-AZ with a standby instance in another AWS Region.
- D. Create a read replica of the DB instance. Use the read replica to distribute the read traffic.
Answer: D
NEW QUESTION # 37
A financial services organization employs an Amazon Aurora PostgreSQL DB cluster to host an application on AWS. No log files detailing database administrator activity were discovered during a recent examination. A database professional must suggest a solution that enables access to the database and maintains activity logs. The solution should be simple to implement and have a negligible effect on performance.
Which database specialist solution should be recommended?
- A. Create an AWS CloudTrail trail in the Region where the database runs. Associate the database activity logs with the trail.
- B. Allow connections to the DB cluster through a bastion host only. Restrict database access to the bastion host and application servers. Push the bastion host logs to Amazon CloudWatch Logs using the CloudWatch Logs agent.
- C. Enable Aurora Database Activity Streams on the database in asynchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Firehose destination to an Amazon S3 bucket.
- D. Enable Aurora Database Activity Streams on the database in synchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Kinesis Data Firehose destination to an Amazon S3 bucket.
Answer: C
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/DBActivityStreams.Overview.html
NEW QUESTION # 38
A company is planning to use Amazon RDS for SQL Server for one of its critical applications. The company's security team requires that the users of the RDS for SQL Server DB instance are authenticated with on-premises Microsoft Active Directory credentials.
Which combination of steps should a database specialist take to meet this requirement? (Choose three.)
- A. Extend the on-premises Active Directory to AWS by using AD Connector.
- B. Create an Active Directory domain controller on Amazon EC2.
- C. Create an IAM role that uses the AmazonRDSDirectoryServiceAccess managed IAM policy.
- D. Create a directory by using AWS Directory Service for Microsoft Active Directory.
- E. Create an IAM user that uses the AmazonRDSDirectoryServiceAccess managed IAM policy.
- F. Create a one-way forest trust from the AWS Directory Service for Microsoft Active Directory directory to the on-premises Active Directory.
Answer: C,D,F
NEW QUESTION # 39
A corporation is transitioning from an IBM Informix database to an Amazon RDS for SQL Server Multi-AZ implementation with Always On Availability Groups (AGs). SQL Server Agent tasks are scheduled to execute at 5-minute intervals on the Always On AG listener to synchronize data between the Informix and SQL Server databases. After a successful failover to the backup node with minimum delay, users endure hours of stale data.
How can a database professional guarantee that consumers view the most current data after a failover?
- A. Create the SQL Server Agent jobs on the secondary node from a script when the secondary node takes over after a failure.
- B. Set TTL to less than 30 seconds for cached DNS values on the Always On AG listener.
- C. Break up large transactions into multiple smaller transactions that complete in less than 5 minutes.
- D. Set the databases on the secondary node to read-only mode.
Answer: A
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html If you have SQL Server Agent jobs, recreate them on the secondary. You do so because these jobs are stored in the msdb database, and you can't replicate this database by using Database Mirroring (DBM) or Always On Availability Groups (AGs). Create the jobs first in the original primary, then fail over, and create the same jobs in the new primary.
NEW QUESTION # 40
A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy.
Which backup methodology should the database specialist use to MINIMIZE management overhead?
- A. Create an AWS Lambda function that creates a backup of the DynamoDB table. Create an Amazon CloudWatch Events rule that executes the Lambda function on a nightly basis.
- B. Install the AWS CLI on an Amazon EC2 instance. Write a CLI command that creates a backup of the DynamoDB table. Create a scheduled job or task that executes the command on a nightly basis.
- C. Configure DynamoDB backup and restore for an on-demand backup frequency of every 24 hours.
- D. Create a backup plan using AWS Backup, specify a backup frequency of every 24 hours, and give the plan a nightly backup window.
Answer: D
Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/CreateBackup.html#:~:text=If%20you%2
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/backuprestore_HowItWorks.html
NEW QUESTION # 41
A gaming company uses Amazon Aurora Serverless for one of its internal applications. The company's developers use Amazon RDS Data API to work with the Aurora Serverless DB cluster. After a recent security review, the company is mandating security enhancements. A database specialist must ensure that access to RDS Data API is private and never passes through the public internet.
What should the database specialist do to meet this requirement?
- A. Create an interface VPC endpoint that uses AWS PrivateLink for RDS Data API.
- B. Create a gateway VPC endpoint for RDS Data API.
- C. Modify the Aurora Serverless cluster by unchecking the publicly accessible option.
- D. Modify the Aurora Serverless cluster by selecting a VPC with private subnets.
Answer: A
Explanation:
https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-data-api-now-supports-aws-privatelink/
NEW QUESTION # 42
A Database Specialist is constructing a new Amazon Neptune DB cluster and tries to load data from Amazon S3 using the Neptune bulk loader API. The Database Specialist is confronted with the following error message:
Unable to establish a connection to the s3 endpoint.
The source URL is s3:/mybucket/graphdata/ and the region code is us-east-1.
Kindly confirm your Configuration S3.
Which of the following activities should the Database Specialist take to resolve the issue? (Select two.)
- A. Check that Amazon EC2 has an IAM role granting read access to Amazon S3
- B. Check that Neptune has an IAM role granting read access to Amazon S3
- C. Check that Amazon S3 has an IAM role granting read access to Neptune
- D. Check that an Amazon S3 VPC endpoint exists
- E. Check that a Neptune VPC endpoint exists
Answer: B,D
Explanation:
Explanation
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-tutorial-IAM.html
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-data.html
"An IAM role for the Neptune DB instance to assume that has an IAM policy that allows access to the data files in the S3 bucket. The policy must grant Read and List permissions." "An Amazon S3 VPC endpoint. For more information, see the Creating an Amazon S3 VPC Endpoint section."
NEW QUESTION # 43
......
The AWS Certified Database - Specialty Exam covers a broad range of topics, including database design, deployment, management, and optimization. Candidates will also be tested on their knowledge of data migration, backup and recovery, security, and performance tuning. AWS-Certified-Database-Specialty exam consists of 65 multiple-choice and multiple-response questions, and candidates have 180 minutes to complete the test. To pass the exam, candidates must achieve a score of at least 750 out of 1000. AWS Certified Database - Specialty (DBS-C01) Exam certification is valid for three years and can be renewed by taking a recertification exam or completing a certain number of continuing education credits.
Amazon DBS-C01 (AWS Certified Database - Specialty (DBS-C01)) Exam is a certification exam offered by Amazon Web Services (AWS) that aims to validate the database expertise of individuals in designing, deploying, and managing AWS databases. AWS-Certified-Database-Specialty exam is intended for database administrators, architects, and developers who work with AWS database services and are looking to demonstrate their skills and knowledge in this area.
Validate your AWS-Certified-Database-Specialty Exam Preparation with AWS-Certified-Database-Specialty Practice Test: https://passleader.testpassking.com/AWS-Certified-Database-Specialty-exam-testking-pass.html