Amazon AWS Certified Database - Specialty
Prev

There are 231 results

Next
#31 (Accuracy: 90% / 6 votes)
A database specialist is launching a test graph database using Amazon Neptune for the first time. The database specialist needs to insert millions of rows of test observations from a .csv file that is stored in Amazon S3. The database specialist has been using a series of API calls to upload the data to the Neptune DB instance.
Which combination of steps would allow the database specialist to upload the data faster? (Choose three.)
  • A. Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.
  • B. Ensure the vertices and edges are specified in different .csv files with proper header column formatting.
  • C. Use AWS DMS to move data from Amazon S3 to the Neptune Loader.
  • D. Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.
  • 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.
  • F. Create an S3 VPC endpoint and issue an HTTP POST to the database's loader endpoint.
#32 (Accuracy: 100% / 3 votes)
A pharmaceutical company uses Amazon Quantum Ledger Database (Amazon QLDB) to store its clinical trial data records. The company has an application that runs as AWS Lambda functions. The application is hosted in the private subnet in a VPC.
The application does not have internet access and needs to read some of the clinical data records.
The company is concerned that traffic between the QLDB ledger and the VPC could leave the AWS network. The company needs to secure access to the QLDB ledger and allow the VPC traffic to have read-only access.
Which security strategy should a database specialist implement to meet these requirements?
  • A. Move the QLDB ledger into a private database subnet inside the VPC. Run the Lambda functions inside the same VPC in an application private subnet. Ensure that the VPC route table allows read-only flow from the application subnet to the database subnet.
  • B. Create an AWS PrivateLink VPC endpoint for the QLDB ledger. Attach a VPC policy to the VPC endpoint to allow read-only traffic for the Lambda functions that run inside the VPC.
  • C. Add a security group to the QLDB ledger to allow access from the private subnets inside the VPC where the Lambda functions that access the QLDB ledger are running.
  • D. Create a VPN connection to ensure pairing of the private subnet where the Lambda functions are running with the private subnet where the QLDB ledger is deployed.
#33 (Accuracy: 100% / 3 votes)
A company has deployed an application that uses an Amazon RDS for MySQL DB cluster. The DB cluster uses three read replicas. The primary DB instance is an
8XL-sized instance, and the read replicas are each XL-sized instances.

Users report that database queries are returning stale data.
The replication lag indicates that the replicas are 5 minutes behind the primary DB instance. Status queries on the replicas show that the SQL_THREAD is 10 binlogs behind the IO_THREAD and that the IO_THREAD is 1 binlog behind the primary.
Which changes will reduce the lag? (Choose two.)
  • A. Deploy two additional read replicas matching the existing replica DB instance size.
  • B. Migrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora Replicas.
  • C. Move the read replicas to the same Availability Zone as the primary DB instance.
  • D. Increase the instance size of the primary DB instance within the same instance class.
  • E. Increase the instance size of the read replicas to the same size and class as the primary DB instance.
#34 (Accuracy: 90% / 4 votes)
A company is launching a new Amazon RDS for MySQL Multi-AZ DB instance to be used as a data store for a custom-built application. After a series of tests with point-in-time recovery disabled, the company decides that it must have point-in-time recovery reenabled before using the DB instance to store production data.
What should a database specialist do so that point-in-time recovery can be successful?
  • A. Enable binary logging in the DB parameter group used by the DB instance.
  • B. Modify the DB instance and enable audit logs to be pushed to Amazon CloudWatch Logs.
  • C. Modify the DB instance and configure a backup retention period
  • D. Set up a scheduled job to create manual DB instance snapshots.
#35 (Accuracy: 100% / 3 votes)
A company is using Amazon DynamoDB global tables for an online gaming application. The game has players around the world. As the game has become more popular, the volume of requests to DynamoDB has increased significantly. Recently, players have reported that the game state is inconsistent between players in different countries. A database specialist observes that the ReplicationLatency metric for some of the replica tables is too high.
Which approach will alleviate the problem?
  • A. Configure all replica tables to use DynamoDB auto scaling.
  • B. Configure a DynamoDB Accelerator (DAX) cluster on each of the replicas.
  • C. Configure the primary table to use DynamoDB auto scaling and the replica tables to use manually provisioned capacity.
  • D. Configure the table-level write throughput limit service quota to a higher value.
#36 (Accuracy: 100% / 4 votes)
An online advertising company is implementing an application that displays advertisements to its users. The application uses an Amazon DynamoDB table as a data store. The application also uses a DynamoDB Accelerator (DAX) cluster to cache its reads. Most of the reads are from the GetItem query and the
BatchGetItem query.
Consistency of reads is not a requirement for this application.
Upon deployment, the application cache is not performing as expected.
Specific strongly consistent queries that run against the DAX cluster are taking many milliseconds to respond instead of microseconds.
How can the company improve the cache behavior to increase application performance?
  • A. Increase the size of the DAX cluster.
  • B. Configure DAX to be an item cache with no query cache
  • C. Use eventually consistent reads instead of strongly consistent reads.
  • D. Create a new DAX cluster with a higher TTL for the item cache.
#37 (Accuracy: 93% / 5 votes)
A bank plans to use an Amazon RDS for MySQL DB instance. The database should support read-intensive traffic with very few repeated queries.
Which solution meets these requirements?
  • A. Create an Amazon ElastiCache cluster. Use a write-through strategy to populate the cache.
  • B. Create an Amazon ElastiCache cluster. Use a lazy loading strategy to populate the cache.
  • C. Change the DB instance to Multi-AZ with a standby instance in another AWS Region.
  • D. Create a read replica of the DB instance. Use the read replica to distribute the read traffic.
#38 (Accuracy: 92% / 5 votes)
A company uses Amazon Aurora for secure financial transactions. The data must always be encrypted at rest and in transit to meet compliance requirements.
Which combination of actions should a database specialist take to meet these requirements? (Choose two.)
  • A. Create an Aurora Replica with encryption enabled using AWS Key Management Service (AWS KMS). Then promote the replica to master.
  • B. Use SSL/TLS to secure the in-transit connection between the financial application and the Aurora DB cluster.
  • C. Modify the existing Aurora DB cluster and enable encryption using an AWS Key Management Service (AWS KMS) encryption key. Apply the changes immediately.
  • D. Take a snapshot of the Aurora DB cluster and encrypt the snapshot using an AWS Key Management Service (AWS KMS) encryption key. Restore the snapshot to a new DB cluster and update the financial application database endpoints.
  • E. Use AWS Key Management Service (AWS KMS) to secure the in-transit connection between the financial application and the Aurora DB cluster.
#39 (Accuracy: 100% / 6 votes)
A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?
  • A. Configure RDS Storage Auto Scaling.
  • B. Configure RDS instance Auto Scaling.
  • C. Modify the DB instance allocated storage to meet the forecasted requirements.
  • D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
#40 (Accuracy: 100% / 4 votes)
A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has restored the latest backup to a new table.
To prepare the new table with identical settings, which steps should be performed? (Choose two.)
  • A. Re-create global secondary indexes in the new table
  • B. Define IAM policies for access to the new table
  • C. Define the TTL settings
  • D. Encrypt the table from the AWS Management Console or use the update-table command
  • E. Set the provisioned read and write capacity