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

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

List of questions

Question 31

Report
Export
Collapse

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?

New volumes created from snapshots load lazily in the background
New volumes created from snapshots load lazily in the background
Long-running statements on the master
Long-running statements on the master
Insufficient resources on the master
Insufficient resources on the master
Overload of a single replication thread by excessive writes on the master
Overload of a single replication thread by excessive writes on the master
Suggested answer: A

Explanation:

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

https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-ebs-fast-snapshot-restoreeliminates-need-for-prewarming-data-into-volumes-created-snapshots/

asked 16/09/2024
brandon landaal
40 questions

Question 32

Report
Export
Collapse

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 hardcoded 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?

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.
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.
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.
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.
Add values for the rcuCount and wcuCount parameters as outputs of the template. Configure DynamoDB to provision throughput capacity using the stack outputs.
Add values for the rcuCount and wcuCount parameters as outputs of the template. Configure DynamoDB to provision throughput capacity using the stack outputs.
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.
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.
Suggested answer: B

Explanation:


Input parameter and FindInMap You can use an input parameter with the Fn::FindInMap function to refer to a specific value in a map. For example, suppose you have a list of regions and environment types that map to a specific AMI ID.

You can select the AMI ID that your stack uses by using an input parameter (EnvironmentType). To determine the region, use the AWS::Region pseudo parameter, which gets the AWS Region in which you create the stack.

https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/parameters-sectionstructure.html

asked 16/09/2024
Jaimie Korik-Read
43 questions

Question 33

Report
Export
Collapse

A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company’s main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application dat a. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.

Which solution meets these requirements?

Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the ap- northeast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cache application data from the replica to generate the dashboards.
Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the ap- northeast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cache application data from the replica to generate the dashboards.
Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the apnortheast- 1 Region. Use Amazon QuickSight for displaying dashboard results.
Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the apnortheast- 1 Region. Use Amazon QuickSight for displaying dashboard results.
Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replica in the ap-northeast-1 Region. Have the dashboard application read from the replica apnortheast- 1 Region.
Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replica in the ap-northeast-1 Region. Have the dashboard application read from the replica apnortheast- 1 Region.
Suggested answer: D

Explanation:


https://aws.amazon.com/blogs/database/aurora-postgresql-disaster-recovery-solutions-usingamazon-aurora-global-database/

asked 16/09/2024
Enayat Meer
34 questions

Question 34

Report
Export
Collapse

A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will enable connections logging.

Which combination of steps should the Database Specialist take to meet the logging and retention requirements? (Choose two.)

Update the log_connections parameter in the default parameter group
Update the log_connections parameter in the default parameter group
Create a custom parameter group, update the log_connections parameter, and associate the parameter with the DB instance
Create a custom parameter group, update the log_connections parameter, and associate the parameter with the DB instance
Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to 180 days
Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to 180 days
Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180 days
Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180 days
Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file
Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file
Suggested answer: A, E

Explanation:


Reference: https://aws.amazon.com/blogs/database/working-with-rds-and-aurora-postgresql-logspart-1/

asked 16/09/2024
Simon Tam
35 questions

Question 35

Report
Export
Collapse

A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load fata from Amazon S3 into the Neptune DB cluster using the Neptune bulk loader API. The Database Specialist receives the following error:

“Unable to connect to s3 endpoint. Provided source = s3://mybucket/graphdata/ and region = useast- 1. Please verify your S3 configuration.” Which combination of actions should the Database Specialist take to troubleshoot the problem?

(Choose two.)

Check that Amazon S3 has an IAM role granting read access to Neptune
Check that Amazon S3 has an IAM role granting read access to Neptune
Check that an Amazon S3 VPC endpoint exists
Check that an Amazon S3 VPC endpoint exists
Check that a Neptune VPC endpoint exists
Check that a Neptune VPC endpoint exists
Check that Amazon EC2 has an IAM role granting read access to Amazon S3
Check that Amazon EC2 has an IAM role granting read access to Amazon S3
Check that Neptune has an IAM role granting read access to Amazon S3
Check that Neptune has an IAM role granting read access to Amazon S3
Suggested answer: B, D

Explanation:


Reference: https://aws.amazon.com/premiumsupport/knowledge-center/s3-could-not-connectendpoint-url/

asked 16/09/2024
Fronzino Franco
35 questions

Question 36

Report
Export
Collapse

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?

Configure RDS Storage Auto Scaling.
Configure RDS Storage Auto Scaling.
Configure RDS instance Auto Scaling.
Configure RDS instance Auto Scaling.
Modify the DB instance allocated storage to meet the forecasted requirements.
Modify the DB instance allocated storage to meet the forecasted requirements.
Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
Suggested answer: A

Explanation:


If your workload is unpredictable, you can enable storage autoscaling for an Amazon RDS DB instance. With storage autoscaling enabled, when Amazon RDS detects that you are running out of free database space it automatically scales up your storage.

https://aws.amazon.com/aboutaws/ whats-new/2019/06/rds-storage-auto-scaling/

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

asked 16/09/2024
Jeff Benson
44 questions

Question 37

Report
Export
Collapse

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?

Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Use AWS DMS to migrate change data capture (CDC) data from the source database to Amazon S3. Use a second AWS DMS task to migrate all the S3 data to the target database.
Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Use AWS DMS to migrate change data capture (CDC) data from the source database to Amazon S3. Use a second AWS DMS task to migrate all the S3 data to the target database.
Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Periodically perform incremental backups of the source database to be shipped in another Snowball Edge appliance to handle syncing change data capture (CDC) data from the source to the target database.
Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Periodically perform incremental backups of the source database to be shipped in another Snowball Edge appliance to handle syncing change data capture (CDC) data from the source to the target database.
Use AWS DMS to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS DMS to handle syncing change data capture (CDC) data from the source to the target database.
Use AWS DMS to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS DMS to handle syncing change data capture (CDC) data from the source to the target database.
Use the AWS Schema Conversion Tool (AWS SCT) to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS SCT to handle syncing change data capture (CDC) data from the source to the target database.
Use the AWS Schema Conversion Tool (AWS SCT) to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS SCT to handle syncing change data capture (CDC) data from the source to the target database.
Suggested answer: A

Explanation:


https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html Using Amazon S3 as atarget for AWS Database Migration Service

asked 16/09/2024
Sivagami Narayanan
49 questions

Question 38

Report
Export
Collapse

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?

Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
Create an AWS CloudFormation template and deploy the template to all the Regions.
Create an AWS CloudFormation template and deploy the template to all the Regions.
Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
Create DynamoDB tables using the AWS Management Console in all the Regions and create a stepby- step guide for future deployments.
Create DynamoDB tables using the AWS Management Console in all the Regions and create a stepby- step guide for future deployments.
Suggested answer: C

Explanation:


https://aws.amazon.com/blogs/aws/use-cloudformation-stacksets-to-provision-resources-acrossmultiple-aws-accounts-and-regions/

https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/stacksets-concepts.html

asked 16/09/2024
Christopher Horting
41 questions

Question 39

Report
Export
Collapse

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation.

How can the Database Specialists accomplish this?

Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
Enable Amazon RDS Performance Insights and review the appropriate dashboard
Enable Amazon RDS Performance Insights and review the appropriate dashboard
Enable Enhanced Monitoring will the appropriate settings
Enable Enhanced Monitoring will the appropriate settings
Suggested answer: C

Explanation:


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

https://aws.amazon.com/rds/performance-insights/

https://aws.amazon.com/blogs/database/tuning-amazon-rds-for-mysql-with-performance-insights/

asked 16/09/2024
Rahul Manikpuri
36 questions

Question 40

Report
Export
Collapse

A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.

What should the company do to achieve this in the shortest amount of time?

Use a blue-green deployment with a complete application-level failover test
Use a blue-green deployment with a complete application-level failover test
Use the RDS console to reboot the DB instance by choosing the option to reboot with failover
Use the RDS console to reboot the DB instance by choosing the option to reboot with failover
Use RDS fault injection queries to simulate the primary node failure
Use RDS fault injection queries to simulate the primary node failure
Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone
Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone
Suggested answer: B

Explanation:


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

https://exain.wordpress.com/2017/07/12/amazon-rds-multi-az-setup-failover-simulation/

"Rebooting with failover is beneficial when you want to simulate a failure of a DB instance for testing, or restore operations to the original AZ after a failover occurs."

asked 16/09/2024
Maurizio Toniato
31 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?