ExamGecko
Login
Home / Amazon / DBS-C01 / List of questions
Ask Question

Amazon DBS-C01 Practice Test - Questions Answers, Page 12

List of questions

Question 111

Report
Export
Collapse

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?

Use web identity federation on the mobile app and AWS STS with an attached IAM role to get temporary credentials to access DynamoDB.
Use web identity federation on the mobile app and AWS STS with an attached IAM role to get temporary credentials to access DynamoDB.
Use web identity federation on the mobile app and create individual IAM users with credentials to access DynamoDB.
Use web identity federation on the mobile app and create individual IAM users with credentials to access DynamoDB.
Use a self-developed user management system on the mobile app that lets users access the data from DynamoDB through an API.
Use a self-developed user management system on the mobile app that lets users access the data from DynamoDB through an API.
Use a single IAM user on the mobile app to access DynamoDB.
Use a single IAM user on the mobile app to access DynamoDB.
Suggested answer: A

Explanation:


Reference: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/WIF.html

asked 16/09/2024
Amarjeet Saini
34 questions

Question 112

Report
Export
Collapse

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?

Modify the application to commit transactions in batches
Modify the application to commit transactions in batches
Add a new Aurora Replica to the Aurora DB cluster.
Add a new Aurora Replica to the Aurora DB cluster.
Add an Amazon ElastiCache for Redis cluster and change the application to write through.
Add an Amazon ElastiCache for Redis cluster and change the application to write through.
Change the Aurora DB cluster storage to Provisioned IOPS (PIOPS).
Change the Aurora DB cluster storage to Provisioned IOPS (PIOPS).
Suggested answer: A

Explanation:


https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Reference.html

"This wait most often arises when there is a very high rate of commit activity on the system. You can sometimes alleviate this wait by modifying applications to commit transactions in batches. "

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/apg-waits.xactsync.html

asked 16/09/2024
Rio Ordonez
51 questions

Question 113

Report
Export
Collapse

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?

Use reserved capacity. Set it to the capacity levels required for peak daytime throughput.
Use reserved capacity. Set it to the capacity levels required for peak daytime throughput.
Use provisioned capacity. Set it to the capacity levels required for peak daytime throughput.
Use provisioned capacity. Set it to the capacity levels required for peak daytime throughput.
Use provisioned capacity. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
Use provisioned capacity. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
Use on-demand capacity.
Use on-demand capacity.
Suggested answer: C

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

asked 16/09/2024
Christian Knarvik
39 questions

Question 114

Report
Export
Collapse

A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system. New compliance requirements specify that the database must be encrypted at rest.

Which action will meet these requirements?

Create an encrypted copy of manual snapshot of the DB instance. Restore a new DB instance from the encrypted snapshot.
Create an encrypted copy of manual snapshot of the DB instance. Restore a new DB instance from the encrypted snapshot.
Modify the DB instance and enable encryption.
Modify the DB instance and enable encryption.
Restore a DB instance from the most recent automated snapshot and enable encryption.
Restore a DB instance from the most recent automated snapshot and enable encryption.
Create an encrypted read replica of the DB instance. Promote the read replica to a standalone instance.
Create an encrypted read replica of the DB instance. Promote the read replica to a standalone instance.
Suggested answer: A

Explanation:


https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/encrypt-an-existing-amazonrds-for-postgresql-db-instance.html

You can enable encryption for an Amazon RDS DB instance when you create it, but not after it's created. However, you can add encryption to an unencrypted DB instance by creating a snapshot of your DB instance, and then creating an encrypted copy of that snapshot. You can then restore a DB instance from the encrypted snapshot to get an encrypted copy of your original DB instance. The pattern uses AWS Database Migration Service (AWS DMS) to migrate data and AWS Key Management Service (AWS KMS) for encryption.

asked 16/09/2024
Friedrich Spies
29 questions

Question 115

Report
Export
Collapse

A database specialist was alerted that a production Amazon RDS MariaDB instance with 100 GB of storage was out of space. In response, the database specialist modified the DB instance and added 50 GB of storage capacity. Three hours later, a new alert is generated due to a lack of free space on the same DB instance. The database specialist decides to modify the instance immediately to increase its storage capacity by 20 GB.

What will happen when the modification is submitted?

The request will fail because this storage capacity is too large.
The request will fail because this storage capacity is too large.
The request will succeed only if the primary instance is in active status.
The request will succeed only if the primary instance is in active status.
The request will succeed only if CPU utilization is less than 10%.
The request will succeed only if CPU utilization is less than 10%.
The request will fail as the most recent modification was too soon.
The request will fail as the most recent modification was too soon.
Suggested answer: D

Explanation:


https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html

asked 16/09/2024
Martin Gucký
51 questions

Question 116

Report
Export
Collapse

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.)

Create an Aurora Replica with encryption enabled using AWS Key Management Service (AWS KMS). Then promote the replica to master.
Create an Aurora Replica with encryption enabled using AWS Key Management Service (AWS KMS). Then promote the replica to master.
Use SSL/TLS to secure the in-transit connection between the financial application and the Aurora DB cluster.
Use SSL/TLS to secure the in-transit connection between the financial application and the Aurora DB cluster.
Modify the existing Aurora DB cluster and enable encryption using an AWS Key Management Service (AWS KMS) encryption key. Apply the changes immediately.
Modify the existing Aurora DB cluster and enable encryption using an AWS Key Management Service (AWS KMS) encryption key. Apply the changes immediately.
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.
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.
Use AWS Key Management Service (AWS KMS) to secure the in-transit connection between the financial application and the Aurora DB cluster.
Use AWS Key Management Service (AWS KMS) to secure the in-transit connection between the financial application and the Aurora DB cluster.
Suggested answer: A, B

Explanation:


https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html

asked 16/09/2024
Andres Mauricio Rodriguez
35 questions

Question 117

Report
Export
Collapse

A company is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs). The site performs a high number of repetitive reads and writes each second on an Amazon RDS for MySQL Multi- AZ DB instance with General Purpose SSD (gp2) storage. After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance.

Which approach should the database specialist to take to resolve this issue without changing the application?

Implementing sharding to distribute the load to multiple RDS for MySQL databases.
Implementing sharding to distribute the load to multiple RDS for MySQL databases.
Use the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.
Use the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.
Add an RDS for MySQL read replica.
Add an RDS for MySQL read replica.
Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS).
Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS).
Suggested answer: D

Explanation:


asked 16/09/2024
José Santos
32 questions

Question 118

Report
Export
Collapse

A banking company recently launched an Amazon RDS for MySQL DB instance as part of a proof-ofconcept project. A database specialist has configured automated database snapshots. As a part of routine testing, the database specialist noticed one day that the automated database snapshot was not created.

Which of the following are possible reasons why the snapshot was not created? (Choose two.)

A copy of the RDS automated snapshot for this DB instance is in progress within the same AWS Region.
A copy of the RDS automated snapshot for this DB instance is in progress within the same AWS Region.
A copy of the RDS automated snapshot for this DB instance is in progress in a different AWS Region.
A copy of the RDS automated snapshot for this DB instance is in progress in a different AWS Region.
The RDS maintenance window is not configured.
The RDS maintenance window is not configured.
The RDS DB instance is in the STORAGE_FULL state.
The RDS DB instance is in the STORAGE_FULL state.
RDS event notifications have not been enabled.
RDS event notifications have not been enabled.
Suggested answer: A, D

Explanation:


https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html

asked 16/09/2024
haythem BRIGUI
31 questions

Question 119

Report
Export
Collapse

An online shopping company has a large inflow of shopping requests daily. As a result, there is a consistent load on the company’s Amazon RDS database. A database specialist needs to ensure the database is up and running at all times.

The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.

What should the database specialist do to achieve this? (Choose two.)

Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
Enable email notifications for AWS Trusted Advisor.
Enable email notifications for AWS Trusted Advisor.
Suggested answer: B, D

Explanation:


asked 16/09/2024
Giuseppina Mancinelli
34 questions

Question 120

Report
Export
Collapse

A large company has a variety of Amazon DB clusters. Each of these clusters has various configurations that adhere to various requirements. Depending on the team and use case, these configurations can be organized into broader categories.

A database administrator wants to make the process of storing and modifying these parameters more systematic. The database administrator also wants to ensure that changes to individual categories of configurations are automatically applied to all instances when required.

Which AWS service or feature will help automate and achieve this objective?

AWS Systems Manager Parameter Store
AWS Systems Manager Parameter Store
DB parameter group
DB parameter group
AWS Config
AWS Config
AWS Secrets Manager
AWS Secrets Manager
Suggested answer: B

Explanation:


Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_WorkingWithParamGroups.html

asked 16/09/2024
Sean Frenette
39 questions
Total 321 questions
Go to page: of 33
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora DB cluster is appropriate for the peak workload. The company is now looking at cutting costs for this DB cluster, but needs to have a sufficient number of nodes in the cluster to support the workload at different times. The workload has not changed since the previous benchmarking exercise. How can a Database Specialist address these requirements with minimal user involvement?
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup. The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company. Which solution will meet these requirements with minimal effort?
A Database Specialist is creating Amazon DynamoDB tables, Amazon CloudWatch alarms, and associated infrastructure for an Application team using a development AWS account. The team wants a deployment method that will standardize the core solution components while managing environment-specific settings separately, and wants to minimize rework due to configuration errors. Which process should the Database Specialist recommend to meet these requirements?
A large financial services company uses Amazon ElastiCache for Redis for its new application that has a global user base. A database administrator must develop a caching solution that will be available across AWS Regions and include low-latency replication and failover capabilities for disaster recovery (DR). The company's security team requires the encryption of cross-Region data transfers. Which solution meets these requirements with the LEAST amount of operational effort?
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 company needs to migrate Oracle Database Standard Edition running on an Amazon EC2 instance to an Amazon RDS for Oracle DB instance with Multi-AZ. The database supports an ecommerce website that runs continuously. The company can only provide a maintenance window of up to 5 minutes. Which solution will meet these requirements?
A 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 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 company is due for renewing its database license. The company wants to migrate its 80 TB transactional database system from on-premises to the AWS Cloud. The migration should incur the least possible downtime on the downstream database applications. The company’s network infrastructure has limited network bandwidth that is shared with other applications. Which solution should a database specialist use for a timely migration?
A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users. How should the Database Specialist apply the parameter group change for the DB instance?