AWS-Certified-Database-Specialty Free Practice Test

For the first time, a database professional is establishing a test graph database on Amazon Neptune. The database expert must input millions of rows of test observations from an Amazon S3.csv file. The database professional uploaded the data to the Neptune DB instance through a series of API calls.
Which sequence of actions enables the database professional to upload the data most quickly? (Select three.)

1. A. Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.
2. B. Ensure the vertices and edges are specified in different .csv files with proper header column formatting.
3. C. Use AWS DMS to move data from Amazon S3 to the Neptune Loader.
4. D. Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.
5. E. Ensure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket.
6. F. Create an S3 VPC endpoint and issue an HTTP POST to the database€™s loader endpoint.

Correct Answer: BEF
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-optimize.html

A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system. New compliance requirements specify that the database must be encrypted at rest.
Which action will meet these requirements?

1. A. Create an encrypted copy of manual snapshot of the DB instanc
2. B. Restore a new DB instance from the encrypted snapshot.
3. C. Modify the DB instance and enable encryption.
4. D. Restore a DB instance from the most recent automated snapshot and enable encryption.
5. E. Create an encrypted read replica of the DB instanc
6. F. Promote the read replica to a standalone instance.

Correct Answer: A
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/encrypt-an-existing-amazon-rds-for-postgresq You can enable encryption for an Amazon RDS DB instance when you create it, but not after it's created.
However, you can add encryption to an unencrypted DB instance by creating a snapshot of your DB instance, and then creating an encrypted copy of that snapshot. You can then restore a DB instance from the encrypted snapshot to get an encrypted copy of your original DB instance. The pattern uses AWS Database Migration Service (AWS DMS) to migrate data and AWS Key Management Service (AWS KMS) for encryption.

A database professional maintains a fleet of Amazon RDS database instances that are configured to utilize the default database parameter group. A database expert must connect a custom parameter group with certain database instances.
When will the instances be allocated to this new parameter group once the database specialist performs this change?

1. A. Instantaneously after the change is made to the parameter group
2. B. In the next scheduled maintenance window of the DB instances
3. C. After the DB instances are manually rebooted
4. D. Within 24 hours after the change is made to the parameter group

Correct Answer: C
When you associate a new DB parameter group with a DB instance, the modified static and dynamic parameters are applied only after the DB instance is rebooted.

A company’s ecommerce website uses Amazon DynamoDB for purchase orders. Each order is made up of a Customer ID and an Order ID. The DynamoDB table uses the Customer ID as the partition key and the Order ID as the sort key.
To meet a new requirement, the company also wants the ability to query the table by using a third attribute named Invoice ID. Queries using the Invoice ID must be strongly consistent. A database specialist must provide this capability with optimal performance and minimal overhead.
What should the database administrator do to meet these requirements?

1. A. Add a global secondary index on Invoice ID to the existing table.
2. B. Add a local secondary index on Invoice ID to the existing table.
3. C. Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.
4. D. Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.

Correct Answer: C
as Local secondary index can only be created while creating the Dynamodb table. and query needs to use third attribute on top of primary and sort key, so Local Secondary index has primary and sort key as well as the third attribute. Global secondary index can be created without primary and sort key

A ride-hailing application uses an Amazon RDS for MySQL DB instance as persistent storage for bookings. This application is very popular and the company expects a tenfold increase in the user base in next few months. The application experiences more traffic during the morning and evening hours.
This application has two parts:
An in-house booking component that accepts online bookings that directly correspond to simultaneous requests from users.
A third-party customer relationship management (CRM) component used by customer care representatives. The CRM uses queries to access booking data.
A database specialist needs to design a cost-effective database solution to handle this workload. Which solution meets these requirements?

1. A. Use Amazon ElastiCache for Redis to accept the booking
2. B. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
3. C. Use Amazon DynamoDB to accept the booking
4. D. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queu
5. E. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
6. F. Use Amazon ElastiCache for Redis to accept the booking
7. G. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
8. H. Use Amazon DynamoDB to accept the booking
9. I. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.

Correct Answer: D