AWS-Certified-Database-Specialty Free Practice Test

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?

1. A. Create an Amazon Cloudwatch Events rule with the operations that need to be tracked on Amazon RD
2. B. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
3. C. Create an AWS Lambda function to trigger on AWS CloudTrail API call
4. D. Filter on specific RDS API calls and write the output to the tracking systems.
5. E. Create RDS event subscription
6. F. Have the tracking systems subscribe to specific RDS event system notifications.
7. G. Write RDS logs to Amazon Kinesis Data Firehos
8. H. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.

Correct Answer: C

An online advertising website uses an Amazon DynamoDB table with on-demand capacity mode as its data store. The website also has a DynamoDB Accelerator
(DAX) cluster in the same VPC as its web application server. The application needs to perform infrequent writes and many strongly consistent reads from the data store by querying the DAX cluster.
During a performance audit, a systems administrator notices that the application can look up items by using the DAX cluster. However, the QueryCacheHits metric for the DAX cluster consistently shows 0 while the QueryCacheMisses metric continuously keeps growing in Amazon CloudWatch.
What is the MOST likely reason for this occurrence?

1. A. A VPC endpoint was not added to access DynamoDB.
2. B. Strongly consistent reads are always passed through DAX to DynamoDB.
3. C. DynamoDB is scaling due to a burst in traffic, resulting in degraded performance.
4. D. A VPC endpoint was not added to access CloudWatch.

Correct Answer: B
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DAX.concepts.html
"If the request specifies strongly consistent reads, DAX passes the request through to DynamoDB. The results from DynamoDB are not cached in DAX. Instead, they are simply returned to the application."

A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse solution. The company plans to use the AWS Schema Conversion Tool (AWS SCT) and AWS DMS for the migration to AWS. The site network bandwidth is 500 Mbps. A Database Specialist wants to migrate the on- premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse. This move must take place during a 2-week period when source systems are shut down for maintenance. The data should stay encrypted at rest and in transit.
Which approach has the least risk and the highest likelihood of a successful data transfer?

1. A. Set up a VPN tunnel for encrypting data over the network from the data center to AW
2. B. Leverage AWS SCT and apply the converted schema to Amazon Redshif
3. C. Once complete, start an AWS DMS task to move the data from the source to Amazon S3. Use AWS Glue to load the data from Amazon S3 to Amazon Redshift.
4. D. Leverage AWS SCT and apply the converted schema to Amazon Redshif
5. E. Start an AWS DMS task with two AWS Snowball Edge devices to copy data from on-premises to Amazon S3 with AWS KMS encryptio
6. F. Use AWS DMS to finish copying data to Amazon Redshift.
7. G. Leverage AWS SCT and apply the converted schema to Amazon Redshif
8. H. Once complete, use a fleet of 10 TB dedicated encrypted drives using the AWS Import/Export feature to copy data from on-premises to Amazon S3 with AWS KMS encryptio
9. I. Use AWS Glue to load the data to Amazon redshift.
10. J. Set up a VPN tunnel for encrypting data over the network from the data center to AW
11. K. Leverage a native database export feature to export the data and compress the file
12. L. Use the aws S3 cp multi-port upload command to upload these files to Amazon S3 with AWS KMS encryptio
13. M. Once complete, load the data to Amazon Redshift using AWS Glue.

Correct Answer: B
https://aws.amazon.com/blogs/database/new-aws-dms-and-aws-snowball-integration-enables-mass-database-mi

A company is looking to migrate a 1 TB Oracle database from on-premises to an Amazon Aurora PostgreSQL DB cluster. The company’s Database Specialist discovered that the Oracle database is storing 100 GB of large binary objects (LOBs) across multiple tables. The Oracle database has a maximum LOB size of 500 MB with an average LOB size of 350 MB. The Database Specialist has chosen AWS DMS to migrate the data with the largest replication instances.
How should the Database Specialist optimize the database migration using AWS DMS?

1. A. Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together
2. B. Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs
3. C. Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs
4. D. Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together

Correct Answer: C

A major organization maintains a number of Amazon DB clusters. Each of these clusters is configured differently to meet certain needs. These configurations may be classified into wider groups based on the team and use case.
A database administrator wishes to streamline the process of storing and updating these settings. Additionally, the database administrator want to guarantee that changes to certain configuration categories are automatically implemented to all instances as necessary.
Which AWS service or functionality will assist in automating and achieving this goal?

1. A. AWS Systems Manager Parameter Store
2. B. DB parameter group
3. C. AWS Config
4. D. AWS Secrets Manager

Correct Answer: B
Database parameters specify how the database is configured. For example, database parameters can specify the amount of resources, such as memory, to allocate to a database.