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

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

List of questions

Question 221

Report
Export
Collapse

An ecommerce company is running AWS Database Migration Service (AWS DMS) to replicate an onpremises Microsoft SQL Server database to Amazon RDS for SQL Server. The company has set up an AWS Direct Connect connection from its on-premises data center to AWS. During the migration, the company's security team receives an alarm that is related to the migration. The security team mandates that the DMS replication instance must not be accessible from public IP addresses.

What should a database specialist do to meet this requirement?

Set up a VPN connection to encrypt the traffic over the Direct Connect connection.
Set up a VPN connection to encrypt the traffic over the Direct Connect connection.
Modify the DMS replication instance by disabling the publicly accessible option.
Modify the DMS replication instance by disabling the publicly accessible option.
Delete the DMS replication instance. Recreate the DMS replication instance with the publicly accessible option disabled.
Delete the DMS replication instance. Recreate the DMS replication instance with the publicly accessible option disabled.
Create a new replication VPC subnet group with private subnets. Modify the DMS replication instance by selecting the newly created VPC subnet group.
Create a new replication VPC subnet group with private subnets. Modify the DMS replication instance by selecting the newly created VPC subnet group.
Suggested answer: C

Explanation:


https://aws.amazon.com/premiumsupport/knowledge-center/dms-disable-public-access/

asked 16/09/2024
Ryan Lee
27 questions

Question 222

Report
Export
Collapse

A company is using an Amazon Aurora MySQL database with Performance Insights enabled. A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase: `Performance Insights is unable to collect SQL Digest statistics on new queries`¦` Which action will resolve this alert message?

Truncate the events_statements_summary_by_digest table.
Truncate the events_statements_summary_by_digest table.
Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights.
Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights.
Set the value for the performance_schema parameter in the parameter group to 1.
Set the value for the performance_schema parameter in the parameter group to 1.
Disable and reenable Performance Insights to be effective in the next maintenance window.
Disable and reenable Performance Insights to be effective in the next maintenance window.
Suggested answer: A

Explanation:


https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.MySQL.html

asked 16/09/2024
Derrick Dave T Alvarez
40 questions

Question 223

Report
Export
Collapse

A bike rental company operates an application to track its bikes. The application receives location and condition data from bike sensors. The application also receives rental transaction data from the associated mobile app. The application uses Amazon DynamoDB as its database layer. The company has configured DynamoDB with provisioned capacity set to 20% above the expected peak load of the application. On an average day, DynamoDB used 22 billion read capacity units (RCUs) and 60 billion write capacity units (WCUs). The application is running well. Usage changes smoothly over the course of the day and is generally shaped like a bell curve. The timing and magnitude of peaks vary based on the weather and season, but the general shape is consistent.

Which solution will provide the MOST cost optimization of the DynamoDB database layer?

Change the DynamoDB tables to use on-demand capacity.
Change the DynamoDB tables to use on-demand capacity.
Use AWS Auto Scaling and configure time-based scaling.
Use AWS Auto Scaling and configure time-based scaling.
Enable DynamoDB capacity-based auto scaling.
Enable DynamoDB capacity-based auto scaling.
Enable DynamoDB Accelerator (DAX).
Enable DynamoDB Accelerator (DAX).
Suggested answer: C

Explanation:


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

asked 16/09/2024
Ben Pike
33 questions

Question 224

Report
Export
Collapse

A company has a quarterly customer survey. The survey uses an Amazon EC2 instance that is hosted in a public subnet to host a customer survey website. The company uses an Amazon RDS DB instance that is hosted in a private subnet in the same VPC to store the survey results.

The company takes a snapshot of the DB instance after a survey is complete, deletes the DB instance, and then restores the DB instance from the snapshot when the survey needs to be conducted again.

A database specialist discovers that the customer survey website times out when it attempts to establish a connection to the restored DB instance.

What is the root cause of this problem?

The VPC peering connection has not been configured properly for the EC2 instance to communicate with the DB instance.
The VPC peering connection has not been configured properly for the EC2 instance to communicate with the DB instance.
The route table of the private subnet that hosts the DB instance does not have a NAT gateway configured for communication with the EC2 instance.
The route table of the private subnet that hosts the DB instance does not have a NAT gateway configured for communication with the EC2 instance.
The public subnet that hosts the EC2 instance does not have an internet gateway configured for communication with the DB instance.
The public subnet that hosts the EC2 instance does not have an internet gateway configured for communication with the DB instance.
The wrong security group was associated with the new DB instance when it was restored from the snapshot.
The wrong security group was associated with the new DB instance when it was restored from the snapshot.
Suggested answer: D

Explanation:


asked 16/09/2024
Anthony Agbale
46 questions

Question 225

Report
Export
Collapse

A company wants to improve its ecommerce website on AWS. A database specialist decides to add Amazon ElastiCache for Redis in the implementation stack to ease the workload off the database and shorten the website response times.

The database specialist must also ensure the ecommerce website is highly available within the company's AWS Region.

How should the database specialist deploy ElastiCache to meet this requirement?

Launch an ElastiCache for Redis cluster using the AWS CLI with the -cluster-enabled switch.
Launch an ElastiCache for Redis cluster using the AWS CLI with the -cluster-enabled switch.
Launch an ElastiCache for Redis cluster and select read replicas in different Availability Zones.
Launch an ElastiCache for Redis cluster and select read replicas in different Availability Zones.
Launch two ElastiCache for Redis clusters in two different Availability Zones. Configure Redis streams to replicate the cache from the primary cluster to another.
Launch two ElastiCache for Redis clusters in two different Availability Zones. Configure Redis streams to replicate the cache from the primary cluster to another.
Launch an ElastiCache cluster in the primary Availability Zone and restore the cluster's snapshot to a different Availability Zone during disaster recovery.
Launch an ElastiCache cluster in the primary Availability Zone and restore the cluster's snapshot to a different Availability Zone during disaster recovery.
Suggested answer: B

Explanation:


https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/AutoFailover.html

You can enable Multi-AZ only on Redis (cluster mode disabled) clusters that have at least one available read replica. Clusters without read replicas do not provide high availability or fault tolerance.

asked 16/09/2024
Jennifer Lear
45 questions

Question 226

Report
Export
Collapse

A company hosts an on-premises Microsoft SQL Server Enterprise edition database with Transparent Data Encryption (TDE) enabled. The database is 20 TB in size and includes sparse tables. The company needs to migrate the database to Amazon RDS for SQL Server during a maintenance window that is scheduled for an upcoming weekend. Data-at-rest encryption must be enabled for the target DB instance.

Which combination of steps should the company take to migrate the database to AWS in the MOST operationally efficient manner? (Choose two.)

Use AWS Database Migration Service (AWS DMS) to migrate from the on-premises source database to the RDS for SQL Server target database.
Use AWS Database Migration Service (AWS DMS) to migrate from the on-premises source database to the RDS for SQL Server target database.
Disable TDE. Create a database backup without encryption. Copy the backup to Amazon S3.
Disable TDE. Create a database backup without encryption. Copy the backup to Amazon S3.
Restore the backup to the RDS for SQL Server DB instance. Enable TDE for the RDS for SQL Server DB instance.
Restore the backup to the RDS for SQL Server DB instance. Enable TDE for the RDS for SQL Server DB instance.
Set up an AWS Snowball Edge device. Copy the database backup to the device. Send the device to AWS. Restore the database from Amazon S3.
Set up an AWS Snowball Edge device. Copy the database backup to the device. Send the device to AWS. Restore the database from Amazon S3.
Encrypt the data with client-side encryption before transferring the data to Amazon RDS.
Encrypt the data with client-side encryption before transferring the data to Amazon RDS.
Suggested answer: B, C

Explanation:


https://aws.amazon.com/blogs/database/migrate-tde-enabled-sql-server-databases-to-amazon-rdsfor-sql-server/

asked 16/09/2024
Steve Daniels
39 questions

Question 227

Report
Export
Collapse

A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available. Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.

What might account for this? (Choose two.)

The new minor version has not yet been designated as preferred and requires a manual upgrade.
The new minor version has not yet been designated as preferred and requires a manual upgrade.
Configuring automatic upgrades using the AWS CLI is not supported. This must be enabled expressly using the AWS Management Console.
Configuring automatic upgrades using the AWS CLI is not supported. This must be enabled expressly using the AWS Management Console.
Applying minor version upgrades requires sufficient free space.
Applying minor version upgrades requires sufficient free space.
The AWS CLI command did not include an apply-immediately parameter.
The AWS CLI command did not include an apply-immediately parameter.
Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.
Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.
Suggested answer: A, D

Explanation:


"When Amazon RDS designates a minor engine version as the preferred minor engine version, each database that meets both of the following conditions is upgraded to the minor engine version automatically"

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

Call the modify-db-instance Amazon CLI command. Specify the name of your DB instance for the --db-instance-identifier option and true for the --auto-minor-version-upgrade option. Optionally, specify the --apply-immediately option to immediately enable this setting for your DB instance. Run aseparate modify-db-instance command for each DB instance in the cluster.

https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.Patching.html#AuroraMySQL.Updates.AMVU

asked 16/09/2024
Priti Agrawal
33 questions

Question 228

Report
Export
Collapse

A security team is conducting an audit for a financial company. The security team discovers that the database credentials of an Amazon RDS for MySQL DB instance are hardcoded in the source code.

The source code is stored in a shared location for automatic deployment and is exposed to all users who can access the location.

A database specialist must use encryption to ensure that the credentials are not visible in the source code.

Which solution will meet these requirements?

Use an AWS Key Management Service (AWS KMS) key to encrypt the most recent database backup. Restore the backup as a new database to activate encryption.
Use an AWS Key Management Service (AWS KMS) key to encrypt the most recent database backup. Restore the backup as a new database to activate encryption.
Store the source code to access the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the code with calls to Systems Manager.
Store the source code to access the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the code with calls to Systems Manager.
Store the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the credentials with calls to Systems Manager.
Store the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the credentials with calls to Systems Manager.
Use an AWS Key Management Service (AWS KMS) key to encrypt the DB instance at rest. Activate RDS encryption in transit by using SSL certificates.
Use an AWS Key Management Service (AWS KMS) key to encrypt the DB instance at rest. Activate RDS encryption in transit by using SSL certificates.
Suggested answer: C

Explanation:

only creds in system manager secure parameter.

asked 16/09/2024
Paul Beugelsdijk
40 questions

Question 229

Report
Export
Collapse

A gaming company is evaluating Amazon ElastiCache as a solution to manage player leaderboards.

Millions of players around the world will complete in annual tournaments. The company wants to implement an architecture that is highly available. The company also wants to ensure that maintenance activities have minimal impact on the availability of the gaming platform.

Which combination of steps should the company take to meet these requirements? (Choose two.)

Deploy an ElastiCache for Redis cluster with read replicas and Multi-AZ enabled.
Deploy an ElastiCache for Redis cluster with read replicas and Multi-AZ enabled.
Deploy an ElastiCache for Memcached global datastore.
Deploy an ElastiCache for Memcached global datastore.
Deploy a single-node ElastiCache for Redis cluster with automatic backups enabled. In the event of a failure, create a new cluster and restore data from the most recent backup.
Deploy a single-node ElastiCache for Redis cluster with automatic backups enabled. In the event of a failure, create a new cluster and restore data from the most recent backup.
Use the default maintenance window to apply any required system changes and mandatory updates as soon as they are available.
Use the default maintenance window to apply any required system changes and mandatory updates as soon as they are available.
Choose a preferred maintenance window at the time of lowest usage to apply any required changes and mandatory updates.
Choose a preferred maintenance window at the time of lowest usage to apply any required changes and mandatory updates.
Suggested answer: A, E

Explanation:


https://aws.amazon.com/blogs/database/configuring-amazon-elasticache-for-redis-for-higheravailability/

asked 16/09/2024
Katrina Allangba
40 questions

Question 230

Report
Export
Collapse

A company stores session history for its users in an Amazon DynamoDB table. The company has a large user base and generates large amounts of session data.

Teams analyze the session data for 1 week, and then the data is no longer needed. A database specialist needs to design an automated solution to purge session data that is more than 1 week old.

Which strategy meets these requirements with the MOST operational efficiency?

Create an AWS Step Functions state machine with a DynamoDB DeleteItem operation that uses the ConditionExpression parameter to delete items older than a week. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that runs the Step Functions state machine on a weekly basis.
Create an AWS Step Functions state machine with a DynamoDB DeleteItem operation that uses the ConditionExpression parameter to delete items older than a week. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that runs the Step Functions state machine on a weekly basis.
Create an AWS Lambda function to delete items older than a week from the DynamoDB table. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that triggers the Lambda function on a weekly basis.
Create an AWS Lambda function to delete items older than a week from the DynamoDB table. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that triggers the Lambda function on a weekly basis.
Enable Amazon DynamoDB Streams on the table. Use a stream to invoke an AWS Lambda function to delete items older than a week from the DynamoDB table
Enable Amazon DynamoDB Streams on the table. Use a stream to invoke an AWS Lambda function to delete items older than a week from the DynamoDB table
Enable TTL on the DynamoDB table and set a Number data type as the TTL attribute. DynamoDB will automatically delete items that have a TTL that is less than the current time.
Enable TTL on the DynamoDB table and set a Number data type as the TTL attribute. DynamoDB will automatically delete items that have a TTL that is less than the current time.
Suggested answer: D

Explanation:


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

asked 16/09/2024
Joe Mon
29 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?