AWS-Certified-Database-Specialty Amazon Exam Questions and Free Practice Test

Question 7

A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made.
What should the database specialist do to meet these requirements? (Choose two.)

A. Create an RDS event subscription to the audit event type.

B. Enable auditing of CONNECT and QUERY_DML events.

C. SSH to the DB instance and review the database logs.

D. Publish the database logs to Amazon CloudWatch Logs.

E. Enable Enhanced Monitoring on the DB instance.

Correct Answer:BD
https://aws.amazon.com/blogs/database/configuring-an-audit-log-to-capture-database-activities-for-amazon-rds

Question 8

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?

A. Create an RDS for MySQL DB instance with an AWS Key Management Service (AWS KMS) customer managed CM

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

C. Create an RDS for MySQL DB instance with an AWS managed CM

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

E. Create an RDS for MySQL DB instance with an AWS owned CM

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

G. Create an RDS for MySQL DB instance with an AWS CloudHSM ke

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

Correct Answer:A
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ShareSnapshot.html

Question 9

A company is using a Single-AZ Amazon RDS for MySQL DB instance for development. The DB instance is experiencing slow performance when queries are executed. Amazon CloudWatch metrics indicate that the instance requires more I/O capacity.
Which actions can a database specialist perform to resolve this issue? (Choose two.)

A. Restart the application tool used to execute queries.

B. Change to a database instance class with higher throughput.

C. Convert from Single-AZ to Multi-AZ.

D. Increase the I/O parameter in Amazon RDS Enhanced Monitoring.

E. Convert from General Purpose to Provisioned IOPS (PIOPS).

Correct Answer:BE
https://aws.amazon.com/blogs/database/best-storage-practices-for-running-production-workloads-on-hosted-data "If you find the pattern of IOPS usage consistently going beyond more than 16,000, you should modify the DB instance and change the storage type from gp2 to io1.

Question 10

An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application.
The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts.
How should a Database Specialist address these requirements?

A. Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB

B. Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift

C. Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance

D. Use DynamoDB Accelerator to offload the reads

Correct Answer:D
https://docs.amazonaws.cn/en_us/amazondynamodb/latest/developerguide/DAX.html
"Applications that are read-intensive, but are also cost-sensitive. With DynamoDB, you provision the number of reads per second that your application requires. If read activity increases, you can increase your tables' provisioned read throughput (at an additional cost). Or, you can offload the activity from your application to a DAX cluster, and reduce the number of read capacity units that you need to purchase otherwise."

Question 11

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 = us-east-1. Please verify your S3 configuration.”
Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)

A. Check that Amazon S3 has an IAM role granting read access to Neptune

B. Check that an Amazon S3 VPC endpoint exists

C. Check that a Neptune VPC endpoint exists

D. Check that Amazon EC2 has an IAM role granting read access to Amazon S3

E. Check that Neptune has an IAM role granting read access to Amazon S3

Correct Answer:BD

Question 12

A large gaming company is creating a centralized solution to store player session state for multiple online games. The workload required key-value storage with low latency and will be an equal mix of reads and writes. Data should be written into the AWS Region closest to the user across the games’ geographically distributed user base. The architecture should minimize the amount of overhead required to manage the replication of data between Regions.
Which solution meets these requirements?

A. Amazon RDS for MySQL with multi-Region read replicas

B. Amazon Aurora global database

C. Amazon RDS for Oracle with GoldenGate

D. Amazon DynamoDB global tables

Correct Answer:A

START AWS-Certified-Database-Specialty EXAM