Pass Amazon AWS-Certified-Database-Specialty PDF Dumps | Recently Updated 200 Questions
Updated Test Engine to Practice AWS-Certified-Database-Specialty Dumps & Practice Exam
The benefit of obtaining the AWS Certified Database - Specialty Certification
The qualification as AWS Certified Database Specialist enables candidates to become experts in all facets as their expertise. Instead of waiting years and completing, AWS acredited development associate certifications provide a way to find a place in which you are involved without experience.
NEW QUESTION 67
A company wants to automate the creation of secure test databases with random credentials to be stored safely for later use. The credentials should have sufficient information about each test database to initiate a connection and perform automated credential rotations. The credentials should not be logged or stored anywhere in an unencrypted form.
Which steps should a Database Specialist take to meet these requirements using an AWS CloudFormation template?
- A. Add a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property.
Then, define the database user name in the SecureStringTemplate template. Create a resource for the database and reference the secret string for the MasterUserName and MasterUserPassword properties.
Then, add a resource of type AWS::SecretsManagerSecretTargetAttachment with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database. - B. Create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add an SecretTargetAttachment resource with the SecretId property set to the Amazon Resource Name (ARN) of the secret and the TargetId property set to a parameter value matching the desired database ARN. Then, create a database with the MasterUserName and MasterUserPassword properties set to the previously created values in the secret.
- C. Create the database with the MasterUserName and MasterUserPassword properties set to the default values. Then, create the secret with the user name and password set to the same default values. Add a Secret Target Attachment resource with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database. Finally, update the secret's password value with a randomly generated string set by the GenerateSecretString property.
- D. Add a Mapping property from the database Amazon Resource Name (ARN) to the secret ARN. Then, create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add the database with the MasterUserName and MasterUserPassword properties set to the user name of the secret.
Answer: A
NEW QUESTION 68
A company wants to migrate its on-premises MySQL databases to Amazon RDS for MySQL. To comply with the company's security policy, all databases must be encrypted at rest. RDS DB instance snapshots must also be shared across various accounts to provision testing and staging environments.
Which solution meets these requirements?
- A. Create an RDS for MySQL DB instance with an AWS managed CMK. Create a new key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
- B. Create an RDS for MySQL DB instance with an AWS Key Management Service (AWS KMS) customer managed CMK. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
- C. Create an RDS for MySQL DB instance with an AWS owned CMK. Create a new key policy to include the administrator user name of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
- D. Create an RDS for MySQL DB instance with an AWS CloudHSM key. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
Answer: B
NEW QUESTION 69
A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A Database Specialist needs to control the access privileges at the table level.
How can the Database Specialist meet these requirements?
- A. Configure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.
- B. Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
- C. Define access privileges to the tables containing sensitive data in the pg_hba.conf file.
- D. Use AWS IAM database authentication and restrict access to the tables using an IAM policy.
Answer: B
NEW QUESTION 70
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. Increase the local storage by upgrading the database engine version.
- B. Modify the Aurora DB cluster to enable automatic volume resizing.
- C. Modify the DB instance to use an instance class that provides more local SSD storage.
- D. Modify the DB instance and configure the required storage volume in the configuration section.
Answer: D
NEW QUESTION 71
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 loading. The Database Specialist needs to modify the workload to load the data slowly.
- B. The local storage used to store temporary tables is full. The Database Specialist needs to enable local storage scaling.
- C. The local storage used to store temporary tables is full. The Database Specialist needs to scale up the instance.
- D. The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to enable Aurora storage scaling.
Answer: C
Explanation:
Reference:
/how-can-i-tune-postgres-to-avoid-this-error
NEW QUESTION 72
A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times.
What could be causing these slow response times?
- A. Long-running statements on the master
- B. Insufficient resources on the master
- C. New volumes created from snapshots load lazily in the background
- D. Overload of a single replication thread by excessive writes on the master snapshot is lazy loaded If the volume is accessed where the data is not loaded, the application accessing the volume encounters a higher latency than normal while the data gets loaded
Answer: C
NEW QUESTION 73
A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS. The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity. A Database Specialist wants to ensure that the changes made by the Application team will not change the Amazon RDS database resources already deployed.
Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)
- A. Set a stack policy for the database resources
- B. Export the database resources as stack outputs
- C. Define the database resources in a nested stack
- D. Review the stack drift before modifying the template
- E. Create and review a change set before applying it
Answer: C,D
NEW QUESTION 74
Amazon DynamoDB global tables are being used by a business to power an online gaming game. The game is played by gamers from all around the globe. As the game became popularity, the amount of queries to DynamoDB substantially rose. Recently, gamers have complained about the game's condition being inconsistent between nations. A database professional notices that the ReplicationLatency metric for many replica tables is set to an abnormally high value.
Which strategy will resolve the issue?
- A. Configure the primary table to use DynamoDB auto scaling and the replica tables to use manually provisioned capacity.
- B. Configure the table-level write throughput limit service quota to a higher value.
- C. Configure all replica tables to use DynamoDB auto scaling.
- D. Configure a DynamoDB Accelerator (DAX) cluster on each of the replicas.
Answer: C
Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/V2globaltables_reqs_bestpractices.html
NEW QUESTION 75
Recently, a financial institution created a portfolio management service. The application's backend is powered by Amazon Aurora, which supports MySQL.
The firm demands a response time of five minutes and a response time of five minutes. A database professional must create a disaster recovery system that is both efficient and has a low replication latency.
How should the database professional tackle these requirements?
- A. Configure an Amazon Aurora global database and add a different AWS Region.
- B. Configure a binlog and create a replica in a different AWS Region.
- C. Configure a cross-Region read replica.
- D. Configure AWS Database Migration Service (AWS DMS) and create a replica in a different AWS Region.
Answer: A
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-disaster-recovery.htm
https://aws.amazon.com/blogs/database/how-to-choose-the-best-disaster-recovery-option-for-your-amazon-auror
https://aws.amazon.com/about-aws/whats-new/2019/11/aurora-supports-in-place-conversion-to-global-database/
NEW QUESTION 76
A company with branch offices in Portland, New York, and Singapore has a three-tier web application that leverages a shared database. The database runs on Amazon RDS for MySQL and is hosted in the us-west-2 Region. The application has a distributed front end deployed in the us-west-2, ap-southheast-1, and us-east-2 Regions.
This front end is used as a dashboard for Sales Managers in each branch office to see current sales statistics. There are complaints that the dashboard performs more slowly in the Singapore location than it does in Portland or New York. A solution is needed to provide consistent performance for all users in each location.
Which set of actions will meet these requirements?
- A. Create a new RDS instance in the ap-southeast-1 Region. Use AWS DMS and change data capture (CDC) to update the new instance in the ap-southeast-1 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
- B. Take a snapshot of the instance in the us-west-2 Region. Create a new instance from the snapshot in the ap-southeast-1 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
- C. Create an RDS read replica in the ap-southeast-1 Region from the primary RDS DB instance in the us- west-2 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
- D. Create an RDS read replica in the us-west-2 Region where the primary instance resides. Create a read replica in the ap-southeast-1 Region from the read replica located on the us-west-2 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
Answer: B
NEW QUESTION 77
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. Purchase DynamoDB reserved capacity in the affected Region
- B. Change the table capacity mode to on-demand
- C. Change the table to use Amazon DynamoDB Streams
- D. Increase the write capacity units for the specific table
- E. Change the table type to throughput optimized
Answer: B,D
Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/switching.capacitymode.html
NEW QUESTION 78
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. Instruct the Data Analysts to download the root certificate and use the SSL certificate on the connection string to connect.
- B. Restart the DB cluster to apply the SSL change.
- C. Modify the Data Analysts' local client firewall to allow network traffic to AWS.
- D. Add explicit mappings between the Data Analysts' IP addresses and the instance in the security group assigned to the DB cluster.
Answer: C
NEW QUESTION 79
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. Add a route to a NAT gateway in the subnet's route table.
- 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 an internet gateway in the subnet's route table.
- D. Assign a new security group to the EC2 instances with an outbound rule to ports 80 and 443.
Answer: A
NEW QUESTION 80
A company has a production environment running on Amazon RDS for SQL Server with an in-house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries.
How should the company identify the source of the problem?
- A. Create a support request and work with AWS Support to identify the source of the issue.
- B. Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.
- C. Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
- D. Use AWS X-Ray deployed with Amazon RDS to track query system traces.
Answer: C
NEW QUESTION 81
A company developed an AWS CloudFormation template used to create all new Amazon DynamoDB tables in its AWS account. The template configures provisioned throughput capacity using hard-coded values. The company wants to change the template so that the tables it creates in the future have independently configurable read and write capacity units assigned.
Which solution will enable this change?
- A. Add values for the rcuCount and wcuCount parameters as outputs of the template. Configure DynamoDB to provision throughput capacity using the stack outputs.
- B. Add values for two Number parameters, rcuCount and wcuCount, to the template. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.
- C. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.
- D. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template. Configure DynamoDB to provision throughput capacity using the stack's mappings.
Answer: B
NEW QUESTION 82
A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster. The company requires a very low RTO and needs to improve the application recovery time after database failovers.
Which approach meets these requirements?
- A. Enable the query cache at the instance level.
- B. Create an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.
- C. Set the max_connections parameter to 16,000 in the instance-level parameter group.
- D. Modify the client connection timeout to 300 seconds.
Answer: B
Explanation:
Explanation
Amazon RDS Proxy allows applications to pool and share connections established with the database, improving database efficiency and application scalability. With RDS Proxy, failover times for Aurora and RDS databases are reduced by up to 66% and database credentials, authentication, and access can be managed through integration with AWS Secrets Manager and AWS Identity and Access Management (IAM).
https://aws.amazon.com/rds/proxy/
NEW QUESTION 83
Developers have requested a new Amazon Redshift cluster so they can load new third-party marketing dat a. The new cluster is ready and the user credentials are given to the developers. The developers indicate that their copy jobs fail with the following error message:
"Amazon Invalid operation: S3ServiceException:Access Denied,Status 403,Error AccessDenied." The developers need to load this data soon, so a database specialist must act quickly to solve this issue.
What is the MOST secure solution?
- A. Create a new IAM role with read-only access to the Amazon S3 bucket with the assume role action. Add this role to the developer IAM user ID used for the copy job that ended with an error message.
- B. Create a new IAM role with the same user name as the Amazon Redshift developer user ID. Provide the IAM role with read-only access to Amazon S3 with the assume role action.
- C. Create a new IAM role with read-only access to the Amazon S3 bucket and include the assume role action. Modify the Amazon Redshift cluster to add the IAM role.
- D. Create a new IAM user with access keys and a new role with read-only access to the Amazon S3 bucket. Add this role to the Amazon Redshift cluster. Change the copy job to use the access keys created.
Answer: D
NEW QUESTION 84
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 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 CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
- D. Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
Answer: A
NEW QUESTION 85
......
Below are the Problems in taking the AWS Certified Database Specialty Exam
certifications-questions offers you the best and most valid question and answer of exams and exam dump for preparing the AWS Certified Database Specialty certification exams. AWS Certified Database Specialty Exam dump is expected to be valid for the practice to offer you the kind of multiple questions that could be asked in your Marketing Cloud developer certification exam. The Practice test software is intuitive and simulates a real exam, familiarizing you with the real exam questions. if you are a certified professional and are excited to polish your abilities and advance your credentials to further advance your career, then you must take the certification exam for AWS Certified Database Specialty. For example, Amazon is considered the career-oriented provider in constant change that gives a boost to your profession. The AWS Certified Database Specialty tops at the list and is gaining popularity among the professionals and IT industries. But professionals are reluctant to not have enough time to devote to recommended books. But here is the good news for valuable and potential candidates, now certifications-questions offers you the best solution, which helps you to pass and solve your AWS Certified Database Specialty certification exam in a week.
Amazon AWS-Certified-Database-Specialty Dumps Cover Real Exam Questions: https://actualanswers.pass4surequiz.com/AWS-Certified-Database-Specialty-exam-quiz.html