Amazon
DBS-C01 Exam
Questions

AWS Certified Database - Specialty DBS-C01

Amazon (DBS-C01) Exam Questions And Answers page 14

What IAM policy should be used to allow reading items from a DynamoDB table while restricting access to a specific field?

Single Choice

A company uses the Amazon DynamoDB table contractDB in us-east-1 for its contract system with the following schema:

orderID (primary key)
timestamp (sort key)
contract (map)
createdBy (string)
customerEmail (string)

After a problem in production, the operations team has asked a database specialist to provide an IAM policy to read items from the database to debug the application. In addition, the developer is not allowed to access the value of the customerEmail field to stay compliant.

Which IAM policy should the database specialist use to achieve these requirements?

Database Deployment, Migration, and Management Database Security and Compliance

How to automate the creation of secure test databases with random credentials using AWS CloudFormation?

Single Choice

A company wants to automate the creation of secure test databases with random credentials to be stored safely for later use. The credentials should have sufficient information about each test database to initiate a connection and perform automated credential rotations. The credentials should not be logged or stored anywhere in an unencrypted form.
Which steps should a Database Specialist take to meet these requirements using an AWS CloudFormation template?

Create the database with the MasterUserName and MasterUserPassword properties set to the default values. Then, create the secret with the user name and password set to the same default values. Add a Secret Target Attachment resource with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database. Finally, update the secret s password value with a randomly generated string set by the GenerateSecretString property.

Add a Mapping property from the database Amazon Resource Name (ARN) to the secret ARN. Then, create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add the database with the MasterUserName and MasterUserPassword properties set to the user name of the secret.

Add a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property. Then, define the database user name in the SecureStringTemplate template. Create a resource for the database and reference the secret string for the MasterUserName and MasterUserPassword properties. Then, add a resource of type AWS::SecretsManagerSecretTargetAttachment with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database.

Create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add an SecretTargetAttachment resource with the SecretId property set to the Amazon Resource Name (ARN) of the secret and the TargetId property set to a parameter value matching the desired database ARN. Then, create a database with the MasterUserName and MasterUserPassword properties set to the previously created values in the secret.

Database Security and Compliance Database Monitoring and Troubleshooting

Which AWS database solution is the most cost-effective for a cloud-native invoicing service with high availability and low latency requirements?

Single Choice

A company wants to build a new invoicing service for its cloud-native application on AWS. The company has a small development team and wants to focus on service feature development and minimize operations and maintenance as much as possible. The company expects the service to handle billions of requests and millions of new records every day. The service feature requirements, including data access patterns are well-defined. The service has an availability target of 99.99% with a milliseconds latency requirement. The database for the service will be the system of record for invoicing data.

Which database solution meets these requirements at the LOWEST cost?

Amazon Neptune

Amazon Aurora PostgreSQL Serverless

Amazon RDS for PostgreSQL

Amazon DynamoDB

Planning and Designing Databases Database Deployment, Migration, and Management

Which AWS database solution is the most cost-effective for a cloud-native invoicing service with high availability and low latency requirements?

Single Choice

Amazon Neptune

Amazon Aurora PostgreSQL Serverless

Amazon RDS for PostgreSQL

Amazon DynamoDB

Planning and Designing Databases Database Deployment, Migration, and Management

What is the most effective approach to migrate an on-premises Oracle database to Amazon Aurora PostgreSQL with minimal downtime and performance impact?

Single Choice

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?

Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluster. Verify the datatype of the columns.

Use the table metrics of the AWS DMS task created for migrating the data to verify the statistics for the tables being migrated and to verify that the data definition language (DDL) statements are completed.

Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigration checklist to make sure there are no issues with the conversion.

Enable AWS DMS data validation on the task so the AWS DMS task compares the source and target records, and reports any mismatches.

Database Deployment, Migration, and Management Database High Availability and Disaster Recovery

What is the most effective approach to migrate an on-premises Oracle database to Amazon Aurora PostgreSQL with minimal downtime and impact on performance?

Single Choice

Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluster. Verify the datatype of the columns.

Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigration checklist to make sure there are no issues with the conversion.

Enable AWS DMS data validation on the task so the AWS DMS task compares the source and target records, and reports any mismatches.

Database Deployment, Migration, and Management Database High Availability and Disaster Recovery

What is the most effective approach to migrate an on-premises Oracle database to Amazon Aurora PostgreSQL with minimal downtime and impact on performance?

Single Choice

Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluster. Verify the datatype of the columns.

Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigration checklist to make sure there are no issues with the conversion.

Enable AWS DMS data validation on the task so the AWS DMS task compares the source and target records, and reports any mismatches.

Database Deployment, Migration, and Management Database High Availability and Disaster Recovery

What is the most cost-effective and operationally efficient solution for migrating a SQL Server database to AWS?

Single Choice

A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS. A deep review is performed and the AWS Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server Standard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL. The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.

What is the MOST cost-effective and operationally efficient solution?

Run SQL Server Enterprise Edition on Amazon EC2.

Run SQL Server Standard Edition on Amazon RDS.

Run SQL Server Enterprise Edition on Amazon RDS.

Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.

Database Deployment, Migration, and Management

What solution meets the requirements of encrypting databases at rest and sharing RDS DB instance snapshots across accounts?

Single Choice

A company wants to migrate its on-premises MySQL databases to Amazon RDS for MySQL. To comply with the company s security policy, all databases must be encrypted at rest. RDS DB instance snapshots must also be shared across various accounts to provision testing and staging environments.

Which solution meets these requirements?

Create an RDS for MySQL DB instance with an AWS Key Management Service (AWS KMS) customer managed CMK. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

Create an RDS for MySQL DB instance with an AWS managed CMK. Create a new key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

Create an RDS for MySQL DB instance with an AWS owned CMK. Create a new key policy to include the administrator user name of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

Create an RDS for MySQL DB instance with an AWS CloudHSM key. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

Database Deployment, Migration, and Management Database Security and Compliance

How can a database specialist address ProvisionedThroughputExceededException errors when importing data into Amazon DynamoDB?

Single Choice

A company with 500,000 employees needs to supply its employee list to an application used by human resources. Every 30 minutes, the data is exported using the LDAP service to load into a new Amazon DynamoDB table. The data model has a base table with Employee ID for the partition key and a global secondary index with Organization ID as the partition key.

While importing the data, a database specialist receives ProvisionedThroughputExceededException errors. After increasing the provisioned write capacity units (WCUs) to 50,000, the specialist receives the same errors. Amazon CloudWatch metrics show a consumption of 1,500 WCUs.

What should the database specialist do to address the issue?

Change the data model to avoid hot partitions in the global secondary index.

Enable auto scaling for the table to automatically increase write capacity during bulk imports.

Modify the table to use on-demand capacity instead of provisioned capacity.

Increase the number of retries on the bulk loading application.

Database High Availability and Disaster Recovery Database Security and Compliance

Previous Questions

Next Questions

Amazon (DBS-C01) Exam Questions And Answers page 14

What IAM policy should be used to allow reading items from a DynamoDB table while restricting access to a specific field?

Comments

How to automate the creation of secure test databases with random credentials using AWS CloudFormation?

Correct Answer:

Explanation:

References:

Comments

Which AWS database solution is the most cost-effective for a cloud-native invoicing service with high availability and low latency requirements?

Correct Answer:

Explanation:

References:

Comments

Which AWS database solution is the most cost-effective for a cloud-native invoicing service with high availability and low latency requirements?

Correct Answer:

Explanation:

References:

Comments

What is the most effective approach to migrate an on-premises Oracle database to Amazon Aurora PostgreSQL with minimal downtime and performance impact?

Correct Answer:

References:

Comments

What is the most effective approach to migrate an on-premises Oracle database to Amazon Aurora PostgreSQL with minimal downtime and impact on performance?

Correct Answer:

Explanation:

References:

Comments

What is the most effective approach to migrate an on-premises Oracle database to Amazon Aurora PostgreSQL with minimal downtime and impact on performance?

Correct Answer:

Explanation:

References:

Comments

What is the most cost-effective and operationally efficient solution for migrating a SQL Server database to AWS?

Correct Answer:

References:

Comments

What solution meets the requirements of encrypting databases at rest and sharing RDS DB instance snapshots across accounts?

Correct Answer:

References:

Comments

How can a database specialist address ProvisionedThroughputExceededException errors when importing data into Amazon DynamoDB?

Correct Answer:

Explanation:

References:

Comments

{{ exam.shortName }}

{{ exam.longName }}