Database Specialty (Page 20)

A company uses an Amazon DynamoDB table to store data for an application.The application requires full access to the table.Some employees receive direct access to the table, but a security policy restricts their access to only certain fields.The company wants to begin using a DynamoDB Accelerator (DAX) cluster on top of the DynamoDB table.How can the company ensure that the security policy is maintained after the implementation of the DAX cluster?Read More →

A database administrator is working on transferring data from an on-premises Oracle instance to an Amazon RDS for Oracle DB instance through an AWS Database Migration Service (AWS DMS) task with ongoing replication only.The database administrator noticed that the migration task failed after running successfully for some time.The logs indicate that there was generic error.The database administrator wants to know which data definition language (DDL) statement caused this issue.What should the database administrator do to identify’ this issue in the MOST operationally efficient manner?Read More →

A company migrated an on-premises Oracle database to Amazon RDS for Oracle.A database specialist needs to monitor the latency of the database.Which solution will meet this requirement with the LEAST operational overhead?Read More →

A company is using an Amazon Aurora PostgreSQL DB cluster for a project.A database specialist must ensure that the database is encrypted at rest.The database size is 500 GB.What is the FASTEST way to secure the data through encryption at rest in the DB cluster?Read More →

A company uses an Amazon Redshift cluster to support its business intelligence (BI) team.The cluster has a maintenance window that overlaps with some business report jobs that run long-running queries on the cluster.During a recent maintenance window, the cluster went offline and restarted for an update.The BI team wants to know which queries were terminated during the maintenance window.What should a database specialist do to obtain this information?Read More →

A coffee machine manufacturer is equipping all of its coffee machines with IoT sensors.The IoT core application is writing measurements for each record to Amazon Timestream.The records have multiple dimensions and measures.The measures include multiple measure names and values.An analysis application is running queries against the Timestream database and is focusing on data from the current week.A database specialist needs to optimize the query costs of the analysis application.Which solution will meet these requirements?Read More →

A database specialist is planning to migrate a 4 TB Microsoft SQL Server DB instance from on premises to Amazon RDS for SQL Server.The database is primarily used for nightly batch processing.Which RDS storage option meets these requirements MOST cost-effectively?Read More →

A company has a 4 ׀¢׀’ on-premises Oracle Real Application Clusters (RAC) database.The company wants to migrate the database to AWS and reduce licensing costs.The company’s application team wants to store JSON payloads that expire after 28 hours.The company has development capacity if code changes are required.Which solution meets these requirements?Read More →

An IT consulting company wants to reduce costs when operating its development environment databases.The company’s workflow creates multiple AmazonAurora MySQL DB clusters for each development group.The Aurora DB clusters are only used for 8 hours a day.The DB clusters can then be deleted at the end of the development cycle, which lasts 2 weeks.Which of the following provides the MOST cost-effective solution?Read More →

A company’s development team needs to have production data restored in a staging AWS account.The production database is running on an Amazon RDS forPostgreSQL Multi-AZ DB instance, which has AWS KMS encryption enabled using the default KMS key.A database specialist planned to share the most recent automated snapshot with the staging account, but discovered that the option to share snapshots is disabled in the AWS Management Console.What should the database specialist do to resolve this?Read More →