Database Specialty (Page 13)

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 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 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 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 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 company is using an Amazon Aurora PostgreSQL DB cluster for the backend of its mobile application.The application is running continuously and a database specialist is satisfied with high availability and fast failover, but is concerned about performance degradation after failover.How can the database specialist minimize the performance degradation after failover?Read More →

A database specialist is planning to migrate a MySQL database to Amazon Aurora.The database specialist wants to configure the primary DB cluster in the us-west-2 Region and the secondary DB cluster in the eu-west-1 Region.In the event of a disaster recovery scenario, the database must be available in eu-west-1 with an RPO of a few seconds.Which solution will meet these requirements?Read More →

A company is using Amazon Redshift as its data warehouse solution.The Redshift cluster handles the following types of workloads:✑ Real-time inserts through Amazon Kinesis Data Firehose✑ Bulk inserts through COPY commands from Amazon S3✑ Analytics through SQL queriesRecently, the cluster has started to experience performance issues.Which combination of actions should a database specialist take to improve the cluster’s performance? (Choose three.)Read More →

A company released a mobile game that quickly grew to 10 million daily active users in North America.The game’s backend is hosted on AWS and makes extensive use of an Amazon DynamoDB table that is configured with a TTL attribute.When an item is added or updated, its TTL is set to the current epoch time plus 600 seconds.The game logic relies on old data being purged so that it can calculate rewards points accurately.Occasionally, items are read from the table that are several hours past their TTL expiry.How should a database specialist fix this issue?Read More →

A company is planning to use Amazon RDS for SQL Server for one of its critical applications.The company’s security team requires that the users of the RDS forSQL Server DB instance are authenticated with on-premises Microsoft Active Directory credentials.Which combination of steps should a database specialist take to meet this requirement? (Choose three.)Read More →