DB Specialty - All Questions

A company is developing a new web-based application and wants to use a fully managed data store in AWS. The DevOps team has extensive experience with MySQL databases. Only by business leaders, who do not know SQL, will use the application during the normal workday. As part of their modernization initiative, the company requires new projects to use serverless solutions when possible and work to reduce costs wherever possible. Which AWS database service could be used for this purpose?

• Amazon Relational Database Service (Amazon RDS) with AWS Lambda functions called via Amazon API gateway
• Amazon Aurora with Lambda functions called via API Gateway
• Amazon DynamoDB with Lambda functions triggered by DynamoDB Streams
• Amazon Redshift with batch data loads occurring overnight

You are a solutions architect working for a company that has a fleet of web servers running an application that uses SQL Server as a backend. You have been asked to evaluate Amazon Relational Database Service (Amazon RDS) for SQL Server as a migration option. In the event of a database failure, your organization has a disaster recovery requirement for the database to automatically fail over. Which action could you take with Amazon RDS to meet this disaster recovery requirement?

• Create a read replica.
• Increase the Amazon RDS instance size.
• Create a Multi-AZ database.
• Take a snapshot of the database and recover the instance using the snapshot.

Your company is migrating an on-premises PostgreSQL database to AWS. The database is currently 16 TB and is expected to triple in size over the next 2 years. The company wants a solution that has automated backups and built-in fault tolerance. Which option will best meet the requirements?

• Migrate the database to Amazon Relational Database Service (Amazon RDS) for PostgreSQL
• Migrate the database to Amazon Aurora MySQL.
• Migrate the database to Amazon DynamoDB.
• Migrate the database to Amazon ElastiCache.

You are running a workload on Amazon DynamoDB. The workload has well-characterized, steady activity levels. Which action could help reduce operational costs?

• Project only the attributes needed for a single access pattern to each global secondary index.
• Filter the attributes read from a table.
• Adjust the primary key on one or more global secondary indexes to reduce the need for scans.
• Use on-demand mode with auto scaling.

Your team has developed an application to support a series of short-term events using an AWS CloudFormation template. During each event, participants create profiles, stored in Amazon Neptune, and upload high-quality images, which are stored in Amazon Simple Storage Service (Amazon S3). After each event, the AWS CloudFormation stack is terminated to save costs, but data gathered must remain available for future events. Which option will meet the requirements?

• Set the DeletionPolicy for the Neptune instance to Snapshot and then enable Amazon S3 bucket replication on the source.
• Set the DeletionPolicy to Retain on both the Neptune and Amazon S3 resource types in the AWS CloudFormation template.
• Set the DeletionPolicy on the Amazon S3 bucket resource to Snapshot.
• Set the DeletionPolicy on the Neptune resource to Snapshot and on the Amazon S3 bucket resource to Retain.

A company has a highly popular website offering real-time reporting based on user profile preferences. The OLTP database that is supporting the site is struggling to meet demand during popular events. The company is planning a migration to AWS. The primary considerations for the migration are high-performance reads and writes for real-time reporting with low latency, and highly durable storage for relational transaction histories. Which solution meets this requirement?

• Use Amazon DynamoDB for the real-time reporting and Amazon Aurora for the relational transaction histories.
• Use Aurora for both real-time reporting and relational transaction histories.
• Use Aurora for the real-time reporting and Amazon Redshift for the relational transaction histories.
• Use DynamoDB for real-time reporting and relational transaction histories.

You are planning the migration of a three-tier web application from on premises to AWS. The web application consists of a web server running Apache and PHP, and a database server running MongoDB. All servers are deployed using VMware virtual machines. Which option would satisfy the requirements of migrating the database to an AWS database service?

• Migrate the MongoDB database to an Amazon DynamoDB table using AWS DataSync.
• Use AWS Database Migration Service (AWS DMS) to replicate the MongoDB database to Amazon DocumentDB (with MongoDB compatibility).
• Use AWS Transfer for SFTP to migrate the MongoDB database to Amazon DocumentDB.
• Configure AWS Server Migration Service (AWS SMS) to identify and migrate the MongoDB database tables to DynamoDB.

An insurance company has a huge claims dataset that is updated hourly in Amazon Redshift. Dashboards showing key claims metrics, such as number of claims and total value of claims for the day, are updated every minute via fast SQL queries. Data scientists query the dataset intermittently to calculate risks of particular events; this analysis is used to set insurance premiums. Recently, your data scientists have complained of increasingly slow queries. What should you do to increase the performance of your Amazon Redshift cluster?

• Enable Amazon DynamoDB Accelerator (DAX) and update the dashboards to point to the DAX endpoint.
• Configure an Amazon ElastiCache cluster to store the data that the dashboards access most frequently, and update the dashboards to query ElastiCache rather than Amazon Redshift.
• Use Amazon CloudFront to cache the data at global edge locations, and update the origin of the CloudFront distribution to point to the Amazon Redshift cluster.
• Change the storage from magnetic to provisioned IOPS to increase the I/O of the underlying storage.

You have been asked to evaluate Amazon DynamoDB as a possible solution for a high-transaction user profile data store. Which statements are true of DynamoDB? (Choose TWO.)

• You can implement both on-demand and continuous backups.
• You cannot exclude secondary indexes from being restored with the table.
• DynamoDB on-demand backups are available at no additional cost.
• The on-demand backup and restore process will have an impact on the performance or availability of your applications.
• Backups are preserved regardless of table deletion.

The Amazon DynamoDB SDK provides interfaces allowing programmatic control over DynamoDB tables. Which is NOT a valid programmatic interface?

• Low-level interface
• Document interface
• Object persistence interface
• Environmental interface