[UPDATED] Amazon AWS-Certified-Database-Specialty Certification Exam Questions
Quickly and Easily Pass Amazon Exam with AWS-Certified-Database-Specialty real Dumps
Below is the cost of AWS Certified Database Specialty Exam
The price of AWS Certified Database - Specialtyexam is $300 USD.
NEW QUESTION # 102
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. 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.
- B. Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.
- C. Enable in-transit and at-rest encryption on the ElastiCache cluster.
- D. 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.
- E. Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.
- F. Create an IAM policy to allow the application service roles to access all ElastiCache API actions.
Answer: C,D,E
Explanation:
https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/encryption.html
NEW QUESTION # 103
A global company is developing an application across multiple AWS Regions. The company needs a database solution with low latency in each Region and automatic disaster recovery. The database must be deployed in an active-active configuration with automatic data synchronization between Regions.
Which solution will meet these requirements with the LOWEST latency?
- A. Amazon DynamoDB global tables
- B. Amazon RDS with cross-Region read replicas
- C. Amazon Aurora global database
- D. Amazon Athena and Amazon S3 with S3 Cross Region Replication
Answer: A
NEW QUESTION # 104
A Database Specialist is designing a new database infrastructure for a ride hailing application. The application data includes a ride tracking system that stores GPS coordinates for all rides. Real-time statistics and metadata lookups must be performed with high throughput and microsecond latency. The database should be fault tolerant with minimal operational overhead and development effort.
Which solution meets these requirements in the MOST efficient way?
- A. Use Amazon DynamoDB as the database and use Amazon API Gateway
- B. Use Amazon DynamoDB as the database and use DynamoDB Accelerator
- C. Use Amazon Aurora MySQL as the database and use Aurora's buffer cache
- D. Use Amazon RDS for MySQL as the database and use Amazon ElastiCache
Answer: B
Explanation:
https://aws.amazon.com/dynamodb/dax/#:~:text=Amazon%20DynamoDB%20Accelerator%20(DAX)%20is,millions%20of%20requests%20per%20second. "Amazon DynamoDB Accelerator (DAX) is a fully managed, highly available, in-memory cache for DynamoDB that delivers up to a 10x performance improvement - from milliseconds to microseconds - even at millions of requests per second. "
NEW QUESTION # 105
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 game_id as the partition key and user_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 user_id as the partition key and game_id as the sort key
Answer: A
NEW QUESTION # 106
A company is about to launch a new product, and test databases must be re-created from production data. 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. Use database cloning to create clones of the production cluster
- C. Add an additional read replica to the production cluster and use that node for testing
- D. Restore a snapshot from the production cluster into test clusters
Answer: B
Explanation:
Explanation
https://aws.amazon.com/getting-started/hands-on/aurora-cloning-backtracking/
"Cloning an Aurora cluster is extremely useful if you want to assess the impact of changes to your database, or if you need to perform workload-intensive operations-such as exporting data or running analytical queries, or simply if you want to use a copy of your production database in a development or testing environment. You can make multiple clones of your Aurora DB cluster. You can even create additional clones from other clones, with the constraint that the clone databases must be created in the same region as the source databases.
NEW QUESTION # 107
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. Create additional readers to cater to the different scenarios.
- B. Use automatic scaling for the Aurora Replica to have the appropriate number of replicas for the desired workload.
- C. Use custom endpoints to satisfy the different workloads.
- D. Use the writer endpoint for OLTP and the reader endpoint for the OLAP reporting workload.
Answer: B
NEW QUESTION # 108
An online retail company is planning a multi-day flash sale that must support processing of up to 5,000 orders per second. The number of orders and exact schedule for the sale will vary each day. During the sale, approximately 10,000 concurrent users will look at the deals before buying items. Outside of the sale, the traffic volume is very low. The acceptable performance for read/write queries should be under 25 ms. Order items are about 2 KB in size and have a unique identifier. The company requires the most cost-effective solution that will automatically scale and is highly available.
Which solution meets these requirements?
- A. Amazon Aurora with one writer node and an Aurora Replica with the parallel query feature enabled
- B. Amazon DynamoDB with provisioned capacity mode with 5,000 write capacity units (WCUs) and 10,000 read capacity units (RCUs)
- C. Amazon Aurora with one writer node and two cross-Region Aurora Replicas
- D. Amazon DynamoDB with on-demand capacity mode
Answer: B
NEW QUESTION # 109
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. Modify the Data Analysts' local client firewall to allow network traffic to AWS.
- B. Add explicit mappings between the Data Analysts' IP addresses and the instance in the security group assigned to the DB cluster.
- C. Restart the DB cluster to apply the SSL change.
- D. Instruct the Data Analysts to download the root certificate and use the SSL certificate on the connection string to connect.
Answer: D
Explanation:
Explanation
* To connect using SSL:
* Provide the SSLTrust certificate (can be downloaded from AWS)
* Provide SSL options when connecting to database
* Not using SSL on a DB that enforces SSL would result in error
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/ssl-certificate-rotation-aurora-postgresql.htm
NEW QUESTION # 110
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. The company recently conducted tests on the database after business hours, and the tests generated additional database logs. As a result, free storage of the DB instance is low and is expected to be exhausted in 2 days.
The company wants to recover the free storage that the additional logs consumed. The solution must not result in downtime for the database.
Which solution will meet these requirements?
- A. Modify the temp file_limit parameter to a smaller value to reclaim space on the DB instance.
- B. Modify the rds.log_retention_period parameter to 1440. Reboot the DB instance to save the changes.
- C. Modify the rds.log_retention_period parameter to 0. Reboot the DB instance to save the changes.
- D. Modify the rds.log_retention_period parameter to 1440. Wait up to 24 hours for database logs to be deleted.
Answer: D
Explanation:
Explanation from Amazon documents:
The rds.log_retention_period parameter specifies how long your RDS for PostgreSQL DB instance keeps its log files. The default setting is 3 days (4,320 minutes), but you can set this value to anywhere from 1 day (1,440 minutes) to 7 days (10,080 minutes)123. By reducing the log retention period, you can free up storage space on your DB instance without affecting its availability or performance.
To modify the rds.log_retention_period parameter, you need to use a custom DB parameter group for your RDS for PostgreSQL instance. You can modify the parameter value using the AWS Management Console, the AWS CLI, or the RDS API1. The parameter change is applied immediately, but it may take up to 24 hours for the database logs to be deleted2. Therefore, you do not need to reboot the DB instance to save the changes or to reclaim the storage space.
Therefore, option B is the correct solution to meet the requirements. Option A is incorrect because setting the rds.log_retention_period parameter to 0 disables log retention and prevents you from viewing or downloading any database logs1. Rebooting the DB instance is also unnecessary and may cause downtime. Option C is incorrect because the temp file_limit parameter controls the maximum size of temporary files that a session can generate, not the size of database logs. Modifying this parameter will not reclaim any storage space on the DB instance. Option D is incorrect because rebooting the DB instance is not required to save the changes or to reclaim the storage space.
NEW QUESTION # 111
A company has an application environment that deploys Amazon Aurora PostgreSQL databases as part of its CI/CD process that uses AWS CloudFormatlon. The company's database administrator has received reports of performance Issues from the resulting database but has no way to investigate the issues.
Which combination of changes must the database administrator make to the database deployment to automate the collection of performance data? (Select TWO.)
- A. Turn on Amazon DevOps Guru for the Aurora database resources in the CloudFormat10n template.
- B. Update the CloudFormatlon template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances.
- C. Turn on and contigure AWS Config tor all Aurora PostgreSQL databases.
- D. Turn on AWS CloudTraiI in each AWS account_
- E. Update the CloudFormatlon template to turn on Performance Insights for Aurora PostgreSQL.
Answer: B,E
Explanation:
Explanation
The combination of changes that the database administrator must make to the database deployment to automate the collection of performance data are:
Update the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances. This will allow the database administrator to monitor the CPU utilization, memory usage, disk I/O, network throughput, and other metrics of the DB instances. CloudWatch monitoring is enabled by default for Aurora DB instances, but it can also be specified in the CloudFormation template using the MonitoringInterval property of the AWS::RDS::DBInstance resource1.
Update the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL. This will allow the database administrator to analyze the database load and identify the most resource-intensive SQL queries, hosts, or users. Performance Insights is a feature of Amazon RDS that provides an easy-to-use dashboard to visualize and troubleshoot database performance. Performance Insights can be enabled in the CloudFormation template using the PerformanceInsightsEnabled property of the AWS::RDS::DBInstance resource2.
The other options are not relevant or sufficient for the requirement of automating the collection of performance data for the Aurora PostgreSQL databases. For example:
Turning on Amazon DevOps Guru for the Aurora database resources in the CloudFormation template is not necessary, as DevOps Guru is a service that uses machine learning to identify operational issues and risks across applications and infrastructure. DevOps Guru does not provide detailed performance data or analysis for Aurora PostgreSQL databases3.
Turning on AWS CloudTrail in each AWS account is not sufficient, as CloudTrail is a service that records API calls and events for AWS services. CloudTrail does not provide performance data or analysis for Aurora PostgreSQL databases, although it can help with auditing and compliance4.
Turning on and configuring AWS Config for all Aurora PostgreSQL databases is not relevant, as AWS Config is a service that tracks and evaluates the configuration changes of AWS resources. AWS Config does not provide performance data or analysis for Aurora PostgreSQL databases, although it can help with governance and security5.
NEW QUESTION # 112
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. Review the stack drift before modifying the template
- B. Set a stack policy for the database resources
- C. Define the database resources in a nested stack
- D. Export the database resources as stack outputs
- E. Create and review a change set before applying it
Answer: A,C
NEW QUESTION # 113
A company has an AWS CloudFormation template written in JSON that is used to launch new Amazon RDS for MySQL DB instances. The security team has asked a database specialist to ensure that the master password is automatically rotated every 30 days for all new DB instances that are launched using the template.
What is the MOST operationally efficient solution to meet these requirements?
- A. Integrate the Amazon RDS for MySQL DB instances with AWS IAM and centrally manage the master database user password.
- B. Create an AWS Lambda function to rotate the secret. Modify the CloudFormation template to add an AWS::SecretsManager::RotationSchedule resource. Configure the RotationLambdaARN value and, for the RotationRules property, set the AutomaticallyAfterDays parameter to 30.
- C. Modify the CloudFormation template to use the AWS KMS key as the database password. Configure an Amazon EventBridge rule to invoke the KMS API to rotate the key every 30 days by setting the ScheduleExpression parameter to ***/30***.
- D. Save the password in an Amazon S3 object. Encrypt the S3 object with an AWS KMS key. Set the KMS key to be rotated every 30 days by setting the EnableKeyRotation property to true. Use a CloudFormation custom resource to read the S3 object to extract the password.
Answer: C
NEW QUESTION # 114
A business uses Amazon EC2 instances in VPC A to serve an internal file-sharing application. This application is supported by an Amazon ElastiCache cluster in VPC B that is peering with VPC A.
The corporation migrates the instances of its applications from VPC A to VPC B. The file-sharing application is no longer able to connect to the ElastiCache cluster, as shown by the logs.
What is the best course of action for a database professional to take in order to remedy this issue?
- A. Modify the ElastiCache security group by adding outbound rules that allow traffic to VPC CIDR blocks from the ElastiCache cluster.
- B. Create a second security group on the EC2 instances. Add an outbound rule to allow traffic from the ElastiCache cluster security group.
- C. Modify the ElastiCache security group by adding an inbound rule that allows traffic from the EC2 instances security group to the ElastiCache cluster.
- D. Delete the ElastiCache security group. Add an interface VPC endpoint to enable the EC2 instances to connect to the ElastiCache cluster.
Answer: C
Explanation:
Explanation
https://docs.aws.amazon.com/vpc/latest/peering/vpc-peering-security-groups.html
NEW QUESTION # 115
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 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.
- C. 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.
- D. 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.
Answer: B
NEW QUESTION # 116
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 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.
- B. 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.
- C. 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
- D. 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.
Answer: D
Explanation:
to read the S3 file and restore the items to a DynamoDB table in the new account.
Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/dynamodb-cross-account-migration/
https://aws.amazon.com/premiumsupport/knowledge-center/data-pipeline-account-access-dynamodb-s3/
NEW QUESTION # 117
After restoring an Amazon RDS snapshot from 3 days ago, a company's Development team cannot connect tothe restored RDS DB instance. What is the likely cause of this problem?
- A. The production DB instance is using a custom parameter group
- B. The production DB instance is using a custom option group
- C. The restored DB instance is using the default security group
- D. The restored DB instance does not have Enhanced Monitoring enabled
Answer: A
NEW QUESTION # 118
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 S3 has an IAM role granting read access to Neptune
- B. Check that an Amazon S3 VPC endpoint exists
- C. Check that Amazon EC2 has an IAM role granting read access to Amazon S3
- D. Check that a Neptune VPC endpoint exists
- E. Check that Neptune has an IAM role granting read access to Amazon S3
Answer: B,E
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 # 119
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. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
- C. Enable an Amazon RDS for MySQL Multi-AZ configuration
- D. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
Answer: A
NEW QUESTION # 120
A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues. A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created. The database specialist must effectively apply this new partition key to all existing and new data.
How can this solution be implemented?
- A. Use the AWS CLI to back up the DynamoDB table. Then use the restore-table-from-backup command and modify the partition key.
- B. Use the AWS CLI to update the DynamoDB table and modify the partition key.
- C. Use Amazon EMR to export the data from the current DynamoDB table to Amazon S3. Then use Amazon EMR again to import the data from Amazon S3 into a new DynamoDB table with the new partition key.
- D. Use AWS DMS to copy the data from the current DynamoDB table to Amazon S3. Then import the DynamoDB table to create a new DynamoDB table with the new partition key.
Answer: A
NEW QUESTION # 121
A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ DB instance. When using the AWS Management Console to conduct this task, the Database Specialist discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read replica cannot be created.
What is the most likely reason for this?
- A. The minor MySQL version in the source DB instance does not support read replicas.
- B. Enhanced Monitoring is not enabled on the source DB instance.
- C. Automated backups are not enabled on the source DB instance.
- D. The source DB instance has to be converted to Single-AZ first to create a read replica from it.
Answer: C
Explanation:
>Your source DB instance must have backup retention enabled. https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstanceReadReplica.html
NEW QUESTION # 122
A company uses Amazon Aurora for secure financial transactions. The data must always be encrypted at rest and in transit to meet compliance requirements.
Which combination of actions should a database specialist take to meet these requirements? (Choose two.)
- A. Create an Aurora Replica with encryption enabled using AWS Key Management Service (AWS KMS). Then promote the replica to master.
- B. Take a snapshot of the Aurora DB cluster and encrypt the snapshot using an AWS Key Management Service (AWS KMS) encryption key. Restore the snapshot to a new DB cluster and update the financial application database endpoints.
- C. Use AWS Key Management Service (AWS KMS) to secure the in-transit connection between the financial application and the Aurora DB cluster.
- D. Use SSL/TLS to secure the in-transit connection between the financial application and the Aurora DB cluster.
- E. Modify the existing Aurora DB cluster and enable encryption using an AWS Key Management Service (AWS KMS) encryption key. Apply the changes immediately.
Answer: D,E
NEW QUESTION # 123
A company is using an Amazon Aurora PostgreSQL DB cluster for the backend of its mobile application. The application is running continuously and a database specialist is satisfied with high availability and fast failover, but is concerned about performance degradation after failover.
How can the database specialist minimize the performance degradation after failover?
- A. Enable Query Plan Management for the Aurora DB cluster and force the query optimizer to use the desired plan
- B. Enable Query Plan Management for the Aurora DB cluster and perform a manual plan capture
- C. Enable cluster cache management tor the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-1
- D. Enable cluster cache management for the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-0
Answer: D
Explanation:
Explanation from Amazon documents:
Amazon Aurora PostgreSQL supports cluster cache management, which is a feature that helps reduce the impact of failover on query performance by preserving the cache of the primary DB instance on one or more Aurora Replicas. Cluster cache management allows you to assign a promotion priority tier to each DB instance in your Aurora DB cluster. The promotion priority tier determines the order in which Aurora Replicas are considered for promotion to the primary instance after a failover. The lower the numerical value of the tier, the higher the priority.
By enabling cluster cache management for the Aurora DB cluster and setting the promotion priority for the writer DB instance and replica to tier-0, the database specialist can minimize the performance degradation after failover. This solution will ensure that the primary DB instance and one Aurora Replica have the same cache contents and are in the same promotion priority tier. In the event of a failover, Aurora will promote the tier-0 replica to the primary role, and the cache will be preserved. This will reduce the number of cache misses and improve query performance after failover.
Therefore, option A is the correct solution to minimize the performance degradation after failover. Option B is incorrect because setting the promotion priority for the writer DB instance and replica to tier-1 will not preserve the cache after failover. Aurora will first try to promote a tier-0 replica, which may have a different cache than the primary instance. Option C is incorrect because enabling Query Plan Management and performing a manual plan capture will not affect the cache behavior after failover. Query Plan Management is a feature that helps you control query execution plans and improve query performance by creating and enforcing custom execution plans. Option D is incorrect because enabling Query Plan Management and forcing the query optimizer to use the desired plan will not affect the cache behavior after failover. Forcing the query optimizer to use a desired plan may improve query performance by avoiding suboptimal plans, but it will not prevent cache misses after failover.
NEW QUESTION # 124
A ride-hailing application stores bookings in a persistent Amazon RDS for MySQL DB instance. This program is very popular, and the corporation anticipates a tenfold rise in the application's user base over the next several months. The application receives a higher volume of traffic in the morning and evening.
This application is divided into two sections:
An internal booking component that takes online reservations in response to concurrent user queries.
A component of a third-party customer relationship management (CRM) system that customer service professionals utilize. Booking data is accessed using queries in the CRM.
To manage this workload effectively, a database professional must create a cost-effective database system.
Which solution satisfies these criteria?
- A. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
- B. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
- C. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
- D. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.
Answer: B
Explanation:
Explanation
"AWS Lambda function to capture changes" capture changes to what? ElastiCache? The main use of ElastiCache is to cache frequently read data. Also "the company expects a tenfold increase in the user base" and "correspond to simultaneous requests from users"
NEW QUESTION # 125
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. Create a one-way forest trust from the AWS Directory Service for Microsoft Active Directory directory to the on-premises Active Directory.
- B. Create an Active Directory domain controller on Amazon EC2.
- C. Create an IAM user that uses the AmazonRDSDirectoryServiceAccess managed IAM policy.
- D. Create a directory by using AWS Directory Service for Microsoft Active Directory.
- E. Extend the on-premises Active Directory to AWS by using AD Connector.
- F. Create an IAM role that uses the AmazonRDSDirectoryServiceAccess managed IAM policy.
Answer: A,D,F
NEW QUESTION # 126
......
Start your AWS-Certified-Database-Specialty Exam Questions Preparation: https://www.freecram.com/Amazon-certification/AWS-Certified-Database-Specialty-exam-dumps.html
Realistic AWS-Certified-Database-Specialty Dumps Questions To Gain Brilliant Result: https://drive.google.com/open?id=1sAKlGaPvNIiE41Ip2bI_Yx8Ugv1vx8RA