100% Free AWS Certified Database AWS-Certified-Database-Specialty Dumps PDF Demo Cert Guide Cover
PDF Exam Material 2023 Realistic AWS-Certified-Database-Specialty Dumps Questions
Conclusion
This AWS Certified Database – Speciality exam (DBS-C01) can help you grow professionally. It leads you to a prestigious certification that proves to bring a lot of opportunities. Enroll in the above courses and buy the books from Amazon to prepare well for the test. Also, practice as much as you can because practice makes a man perfect. Although such amount of information can be confusing for some people, if you dive deep in each domain using the mentioned resources, you will be able to ace the exam in one go.
NEW QUESTION # 39
A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table. TTL is enabled on one of the attributes. The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.
What is the MOST likely reason that the items are not being deleted?
- A. The TTL attribute's value is a timestamp in the Unix epoch time format in seconds.
- B. The TTL attribute's value is set as a Number data type.
- C. The TTL attribute's value is set as a Binary data type.
- D. The TTL attribute's value is set with an expiration of 1 year.
Answer: C
Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TTL.html#time-to-live-ttl-before-you-star
NEW QUESTION # 40
An ecommerce company uses Amazon DynamoDB as the backend for its payments system. A new regulation requires the company to log all data access requests for financial audits. For this purpose, the company plans to use AWS logging and save logs to Amazon S3 How can a database specialist activate logging on the database?
- A. Create two trails in AWS CloudTrail. Use Trail1 to monitor DynamoDB control-plane operations. Use Trail2 to monitor DynamoDB data-plane operations.
- B. Use AWS CloudTrail to monitor DynamoDB data-plane and control-plane operations.
- C. Use AWS CloudTrail to monitor DynamoDB control-plane operations. Create a DynamoDB stream to monitor data-plane operations. Pass the stream to Amazon Kinesis Data Streams. Use that stream as a source for Amazon Kinesis Data Firehose to store the data in an Amazon S3 bucket.
- D. Use AWS CloudTrail to monitor DynamoDB data-plane operations. Create a DynamoDB stream to monitor control-plane operations. Pass the stream to Amazon Kinesis Data Streams. Use that stream as a source for Amazon Kinesis Data Firehose to store the data in an Amazon S3 bucket.
Answer: B
Explanation:
https://aws.amazon.com/about-aws/whats-new/2021/04/you-now-can-use-aws-cloudtrail-to-log-amazon-dynamodb-streams-da/
NEW QUESTION # 41
A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.
Which AWS services should the Database Specialist consider? (Choose two.)
- A. Amazon DynamoDB
- B. Amazon Redshift
- C. Amazon Neptune
- D. Amazon Elasticsearch Service
- E. Amazon ElastiCache
Answer: A,E
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html#Strategies.WriteThrough
https://aws.amazon.com/products/databases/real-time-apps-elasticache-for-redis/
NEW QUESTION # 42
A large retail company recently migrated its three-tier ecommerce applications to AWS. The company's backend database is hosted on Amazon Aurora PostgreSQL. During peak times, users complain about longer page load times. A database specialist reviewed Amazon RDS Performance Insights and found a spike in IO:XactSync wait events. The SQL attached to the wait events are all single INSERT statements.
How should this issue be resolved?
- A. Change the Aurora DB cluster storage to Provisioned IOPS (PIOPS).
- B. Add an Amazon ElastiCache for Redis cluster and change the application to write through.
- C. Add a new Aurora Replica to the Aurora DB cluster.
- D. Modify the application to commit transactions in batches
Answer: C
NEW QUESTION # 43
A company is releasing a new mobile game featuring a team play mode. As a group of mobile device users play together, an item containing their statuses is updated in an Amazon DynamoDB table. Periodically, the other users' devices read the latest statuses of their teammates from the table using the BatchGetltemn operation.
Prior to launch, some testers submitted bug reports claiming that the status data they were seeing in the game was not up-to-date. The developers are unable to replicate this issue and have asked a database specialist for a recommendation.
Which recommendation would resolve this issue?
- A. Ensure the DynamoDB table is configured to be always consistent.
- B. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to true.
- C. Enable a stream on the DynamoDB table and subscribe each device to the stream to ensure all devices receive up-to-date status information.
- D. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to false.
Answer: B
Explanation:
Explanation
https://docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/API_BatchGetItem_v20111205.htm
By default, BatchGetItem performs eventually consistent reads on every table in the request.
If you want strongly consistent reads instead, you can set ConsistentRead to true for any or all tables.
NEW QUESTION # 44
A database specialist is designing the database for a software-as-a-service (SaaS) version of an employee information application. In the current architecture, the change history of employee records is stored in a single table in an Amazon RDS for Oracle database. Triggers on the employee table populate the history table with historical records.
This architecture has two major challenges. First, there is no way to guarantee that the records have not been changed in the history table. Second, queries on the history table are slow because of the large size of the table and the need to run the queries against a large subset of data in the table.
The database specialist must design a solution that prevents modification of the historical records. The solution also must maximize the speed of the queries.
Which solution will meet these requirements?
- A. Use Amazon Aurora PostgreSQL to store employee record history in a single table. Use Aurora Auto Scaling to provision more capacity.
- B. Build a solution that uses an Amazon Redshift cluster for historical records. Query the Redshift cluster directly as needed.
- C. Migrate the current solution to an Amazon DynamoDB table. Use DynamoDB Streams to keep track of changes. Use DynamoDB Accelerator (DAX) to improve query performance.
- D. Write employee record history to Amazon Quantum Ledger Database (Amazon QLDB) for historical records and to an Amazon OpenSearch Service domain for queries.
Answer: D
Explanation:
Explanation from Amazon documents:
Amazon Quantum Ledger Database (Amazon QLDB) is a fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log of all your application changes.
Amazon QLDB tracks each and every application data change and maintains a complete and verifiable history of changes over time1. This makes it ideal for storing historical records that need to be tamper-proof and auditable. Amazon QLDB also supports PartiQL, a SQL-compatible query language that lets you query data using familiar SQL operators2.
Amazon OpenSearch Service (successor to Amazon Elasticsearch Service) is a fully managed service that makes it easy to deploy, operate, and scale OpenSearch, an open source search and analytics engine. Amazon OpenSearch Service lets you store, search, and analyze large volumes of data quickly and at low cost3. You can use Amazon OpenSearch Service to index and query your employee record history data stored in Amazon QLDB using the QLDB Streams feature. This way, you can leverage the powerful search and analytics capabilities of OpenSearch Service to run fast and flexible queries on your historical data.
Therefore, option B is the best solution that meets the requirements of preventing modification of the historical records and maximizing the speed of the queries. Option A is not suitable because DynamoDB is a key-value and document database that does not provide a ledger-like transaction log. Option C is not suitable because Aurora PostgreSQL is a relational database that does not guarantee immutability of the historical records.
Option D is not suitable because Redshift is a data warehouse that is optimized for analytical queries on large datasets, not for storing and querying individual records.
NEW QUESTION # 45
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 an RDS read replica in the ap-southeast-1 Region from the primary RDS DB instance in the uswest- 2 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
- B. 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.
- C. 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.
- D. 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.
Answer: D
NEW QUESTION # 46
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 RDS for MySQL as the database and use Amazon ElastiCache
- B. Use Amazon DynamoDB as the database and use Amazon API Gateway
- C. Use Amazon DynamoDB as the database and use DynamoDB Accelerator
- D. Use Amazon Aurora MySQL as the database and use Aurora's buffer cache
Answer: B
NEW QUESTION # 47
A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?
- A. Configure RDS instance Auto Scaling.
- B. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
- C. Configure RDS Storage Auto Scaling.
- D. Modify the DB instance allocated storage to meet the forecasted requirements.
Answer: A
NEW QUESTION # 48
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. Change the table to use Amazon DynamoDB Streams
- B. Purchase DynamoDB reserved capacity in the affected Region
- C. Change the table capacity mode to on-demand
- D. Increase the write capacity units for the specific table
- E. Change the table type to throughput optimized
Answer: D,E
NEW QUESTION # 49
A company is using an Amazon ElastiCache for Redis cluster to host its online shopping website. Shoppers receive the following error when the website's application queries the cluster:
Which solutions will resolve this memory issues with the LEAST amount of effort? (Choose three.)
- A. Increase the TTL value for keys on the node.
- B. Test different values in the parameter group for the maxmemory-policy parameter to find the ideal value to use.
- C. Reduce the TTL value for keys on the node.
- D. Increase the number of nodes.
- E. Choose a larger node type.
- F. Monitor the EngineCPUUtilization Amazon CloudWatch metric. Create an AWS Lambda function to delete keys on nodes when a threshold is reached.
Answer: B,C,E
Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/oom-command-not-allowed-redis/
NEW QUESTION # 50
A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds.
What should the database specialist do to accomplish this task?
- A. Connect to the MySQL database and run the SET SESSION wait_timeout=900 command.
- B. Modify the default DB parameter group and set the wait_timeout parameter value to 900.
- C. Edit the my.cnf file and set the wait_timeout parameter value to 900. Restart the DB instance.
- D. Create a custom DB parameter group and set the wait_timeout parameter value to 900. Associate the DB instance with the custom parameter group.
Answer: D
Explanation:
Explanation
https://aws.amazon.com/fr/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-p
"You can set parameters globally using a parameter group. Alternatively, you can set them for a particular session using the SET command."
https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-par
NEW QUESTION # 51
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 and contigure AWS Config tor all Aurora PostgreSQL databases.
- B. Turn on Amazon DevOps Guru for the Aurora database resources in the CloudFormat10n template.
- C. Update the CloudFormatlon template to turn on Performance Insights for Aurora PostgreSQL.
- D. Turn on AWS CloudTraiI in each AWS account_
- E. Update the CloudFormatlon template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances.
Answer: C,E
NEW QUESTION # 52
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 # 53
A company plans to use AWS Database Migration Service (AWS DMS) to migrate its database from one Amazon EC2 instance to another EC2 instance as a full load task. The company wants the database to be inactive during the migration. The company will use a dms.t3.medium instance to perform the migration and will use the default settings for the migration.
Which solution will MOST improve the performance of the data migration?
- A. Enable Multi-AZ on the target database while the full load task is in progress.
- B. Change the processing mode from the batch optimized apply option to transactional mode.
- C. Drop all indexes on the source tables.
- D. Increase the number of tables that are loaded in parallel.
Answer: C
Explanation:
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPractices.Performance For a full load task, we recommend that you drop primary key indexes, secondary indexes, referential integrity constraints, and data manipulation language (DML) triggers. Or you can delay their creation until after the full load tasks are complete. You don't need indexes during a full load task, and indexes incur maintenance overhead if they are present. Because the full load task loads groups of tables at a time, referential integrity constraints are violated. Similarly, insert, update, and delete triggers can cause errors, for example if a row insert is triggered for a previously bulk loaded table. Other types of triggers also affect performance due to added processing. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html
NEW QUESTION # 54
A database specialist is designing an enterprise application for a large company. The application uses Amazon DynamoDB with DynamoDB Accelerator (DAX).
The database specialist observes that most of the queries are not found in the DAX cache and that they still require DynamoDB table reads.
What should the database specialist review first to improve the utility of DAX?
- A. The validity of customer-specified AWS Key Management Service (AWS KMS) keys for DAX encryption at rest
- B. The DAX cluster's TTL setting
- C. The DynamoDB ConsumedReadCapacityUnits metric
- D. The trust relationship to perform the DynamoDB API calls
Answer: B
Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DAX.cluster-management.html#DAX.clu
NEW QUESTION # 55
A company uses Amazon DynamoDB as the data store for its ecommerce website. The website receives little to no traffic at night, and the majority of the traffic occurs during the day. The traffic growth during peak hours is gradual and predictable on a daily basis, but it can be orders of magnitude higher than during off-peak hours.
The company initially provisioned capacity based on its average volume during the day without accounting for the variability in traffic patterns. However, the website is experiencing a significant amount of throttling during peak hours. The company wants to reduce the amount of throttling while minimizing costs.
What should a database specialist do to meet these requirements?
- A. Use provisioned capacity. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
- B. Use reserved capacity. Set it to the capacity levels required for peak daytime throughput.
- C. Use provisioned capacity. Set it to the capacity levels required for peak daytime throughput.
- D. Use on-demand capacity.
Answer: A
Explanation:
On-demand mode is a good option if any of the following are true: You create new tables with unknown workloads. You have unpredictable application traffic. You prefer the ease of paying for only what you use. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.ReadWriteCapacityMode.html#HowItWorks.ProvisionedThroughput.Manual Amazon DynamoDB auto scaling uses the AWS Application Auto Scaling service to dynamically adjust provisioned throughput capacity on your behalf https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/AutoScaling.html
NEW QUESTION # 56
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 global secondary index with game_id as the partition key
- C. Create a composite primary key with game_id as the partition key and user_id as the sort 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 # 57
A database specialist is managing an application in the us-west-1 Region and wants to set up disaster recovery in the us-east-1 Region. The Amazon Aurora MySQL DB cluster needs an RPO of 1 minute and an RTO of 2 minutes.
Which approach meets these requirements with no negative performance impact?
- A. Enable asynchronous binlog replication.
- B. Copy Aurora incremental snapshots to the us-east-1 Region.
- C. Create an Aurora Global Database.
- D. Enable synchronous replication.
Answer: D
NEW QUESTION # 58
A company is using Amazon with Aurora Replicas for read-only workload scaling. A Database Specialist needs to split up two read-only applications so each application always connects to a dedicated replica. The Database Specialist wants to implement load balancing and high availability for the read-only applications.
Which solution meets these requirements?
- A. Use reader endpoints for both the read-only workload applications.
- B. Use a reader endpoint for one read-only application and use an instance endpoint for the other read-onlyapplication.
- C. Use a specific instance endpoint for each replica and add the instance endpoint to each read-onlyapplication connection string.
- D. Use custom endpoints for the two read-only applications.
Answer: A
NEW QUESTION # 59
An worldwide gaming company's development team is experimenting with using Amazon DynamoDB to store in-game events for three mobile titles. Maximum concurrent users for the most popular game is 500,000, while the least popular game is 10,000. The typical event is 20 KB in size, while the average user session generates one event each second. Each event is assigned a millisecond time stamp and a globally unique identification.
The lead developer generated a single DynamoDB database with the following structure for the events:
* Partition key: game name
* Sort key: event identifier
* Local secondary index: player identifier
* Event time
In a small-scale development setting, the tests were successful. When the application was deployed to production, however, new events were not being added to the database, and the logs indicated DynamoDB failures with the ItemCollectionSizeLimitExceededException issue code.
Which design modification should a database professional offer to the development team?
- A. Replace the sort key with a compound value consisting of the player identifier collated with the event time, separated by a dash. Add a local secondary index with the player identifier as the sort key.
- B. Use the player identifier as the partition key. Use the event time as the sort key. Add a global secondary index with the game name as the partition key and the event time as the sort key.
- C. Create one table for each game. Use the player identifier as the partition key. Use the event time as the sort key.
- D. Create two tables. Use the game name as the partition key in both tables. Use the event time as the sort key for the first table. Use the player identifier as the sort key for the second table.
Answer: C
NEW QUESTION # 60
......
To become an AWS Certified Database - Specialty professional, individuals are required to pass the certification exam which consists of 65 multiple-choice and multiple-response questions. The duration of the exam is 170 minutes, and candidates are required to score a minimum of 750 out of a possible 1000 to pass. AWS-Certified-Database-Specialty exam fee is $300, and it can be taken online or at a testing center. Successful candidates receive a digital badge and a certificate that validates their skills in database management using AWS services.
Becoming AWS Certified in Database - Specialty (DBS-C01) can open up numerous career opportunities for individuals. As more businesses move towards cloud computing, the demand for AWS certified professionals continues to grow. AWS Certified Database - Specialty (DBS-C01) Exam certification can help individuals stand out in a competitive job market and showcase their expertise in AWS database services.
Updated Amazon AWS-Certified-Database-Specialty Dumps – PDF & Online Engine: https://www.passreview.com/AWS-Certified-Database-Specialty_exam-braindumps.html
AWS-Certified-Database-Specialty.pdf - Questions Answers PDF Sample Questions Reliable: https://drive.google.com/open?id=1pstLRBHs_YifTc_RlQsK-Mp3TanP7edV