Cloud Practice

#51 (Accuracy: 100% / 3 votes)

A company is using an Amazon Aurora MySQL database with Performance Insights enabled. A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase: `Performance Insights is unable to collect SQL Digest statistics on new queries`¦`
Which action will resolve this alert message?

A. Truncate the events_statements_summary_by_digest table.
B. Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights.
C. Set the value for the performance_schema parameter in the parameter group to 1.
D. Disable and reenable Performance Insights to be effective in the next maintenance window.

#52 (Accuracy: 100% / 1 votes)

An ecommerce company is running Amazon RDS for Microsoft SQL Server. The company is planning to perform testing in a development environment with production data. The development environment and the production environment are in separate AWS accounts. Both environments use AWS Key Management Service (AWS KMS) encrypted databases with both manual and automated snapshots. A database specialist needs to share a KMS encrypted production RDS snapshot with the development account.

Which combination of steps should the database specialist take to meet these requirements? (Choose three.)

A. Create an automated snapshot. Share the snapshot from the production account to the development account.
B. Create a manual snapshot. Share the snapshot from the production account to the development account.
C. Share the snapshot that is encrypted by using the development account default KMS encryption key.
D. Share the snapshot that is encrypted by using the production account custom KMS encryption key.
E. Allow the development account to access the production account KMS encryption key.
F. Allow the production account to access the development account KMS encryption key.

#53 (Accuracy: 100% / 4 votes)

A company has an ecommerce website that runs on AWS. The website uses an Amazon RDS for MySQL database. A database specialist wants to enforce the use of temporary credentials to access the database.
Which solution will meet this requirement?

A. Use MySQL native database authentication.
B. Use AWS Secrets Manager to rotate the credentials.
C. Use AWS Identity and Access Management (IAM) database authentication.
D. Use AWS Systems Manager Parameter Store for authentication.

#54 (Accuracy: 100% / 3 votes)

A company has an application that uses an Amazon DynamoDB table as its data store. During normal business days, the throughput requirements from the application are uniform and consist of 5 standard write calls per second to the DynamoDB table. Each write call has 2 KB of data.
For 1 hour each day, the company runs an additional automated job on the DynamoDB table that makes 20 write requests per second. No other application writes to the DynamoDB table. The DynamoDB table does not have to meet any additional capacity requirements.
How should a database specialist configure the DynamoDB table's capacity to meet these requirements MOST cost-effectively?

A. Use DynamoDB provisioned capacity with 5 WCUs and auto scaling.
B. Use DynamoDB provisioned capacity with 5 WCUs and a write-through cache that DynamoDB Accelerator (DAX) provides.
C. Use DynamoDB provisioned capacity with 10 WCUs and auto scaling.
D. Use DynamoDB provisioned capacity with 10 WCUs and no auto scaling.

#55 (Accuracy: 100% / 2 votes)

A company is using a Single-AZ Amazon RDS for MySQL DB instance for development. The DB instance is experiencing slow performance when queries run.
Amazon CloudWatch metrics indicate that the instance requires more I/O capacity.
Which actions can a database specialist perform to resolve this issue? (Choose two.)

A. Restart the application tool used to run queries.
B. Change to a database instance class with higher throughput.
C. Convert from Single-AZ to Multi-AZ.
D. Increase the I/O parameter in Amazon RDS Enhanced Monitoring.
E. Convert from General Purpose to Provisioned IOPS (PIOPS).

#56 (Accuracy: 100% / 4 votes)

A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table. TTL is enabled on one of the attributes. The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.
What is the MOST likely reason that the items are not being deleted?

A. The TTL attribute's value is set as a Number data type.
B. The TTL attribute's value is set as a Binary data type.
C. The TTL attribute's value is a timestamp in the Unix epoch time format in seconds.
D. The TTL attribute's value is set with an expiration of 1 year.

#57 (Accuracy: 91% / 3 votes)

An IT company wants to reduce its database operation costs in its development environment. The company's workflow creates an Amazon Aurora MySQL DB cluster for each development group. The DB clusters are used for only 8 hours a day. The DB clusters can be deleted at the end of a development cycle, which lasts 2 weeks.
Which solution will meet these requirements MOST cost-effectively?

A. Use AWS CloudFormation templates. Deploy a stack with a DB cluster for each development group. Delete the stack at the end of each development cycle.
B. Use the Aurora cloning feature. Deploy a single development and test Aurora DB instance. Create clone instances for the development groups. Delete the clones at the end of each development cycle.
C. Use Aurora Replicas. From the primary writer instance, create read replicas for each development group. Promote each read replica to a standalone DB cluster Delete the standalone DB cluster at the end of each development cycle.
D. Use Aurora Serverless. Restore a current Aurora snapshot to an Aurora Serverless cluster for each development group. Select the option to pause the compute capacity on the cluster after a specified amount of time with no activity. Delete the Aurora Serverless cluster at the end of each development cycle.

#58 (Accuracy: 100% / 3 votes)

A software company uses an Amazon RDS for MySQL Multi-AZ DB instance as a data store for its critical applications. During an application upgrade process, a database specialist runs a custom SQL script that accidentally removes some of the default permissions of the master user.
What is the MOST operationally efficient way to restore the default permissions of the master user?

A. Modify the DB instance and set a new master user password.
B. Use AWS Secrets Manager to modify the master user password and restart the DB instance.
C. Create a new master user for the DB instance.
D. Review the IAM user that owns the DB instance, and add missing permissions.

#59 (Accuracy: 100% / 5 votes)

A company has an AWS CloudFormation template written in JSON that is used to launch new Amazon RDS for MySQL DB instances. The security team has asked a database specialist to ensure that the master password is automatically rotated every 30 days for all new DB instances that are launched using the template.
What is the MOST operationally efficient solution to meet these requirements?

A. Save the password in an Amazon S3 object. Encrypt the S3 object with an AWS KMS key. Set the KMS key to be rotated every 30 days by setting the EnableKeyRotation property to true. Use a CloudFormation custom resource to read the S3 object to extract the password.
B. Create an AWS Lambda function to rotate the secret. Modify the CloudFormation template to add an AWS::SecretsManager::RotationSchedule resource. Configure the RotationLambdaARN value and, for the RotationRules property, set the AutomaticallyAfterDays parameter to 30.
C. Modify the CloudFormation template to use the AWS KMS key as the database password. Configure an Amazon EventBridge rule to invoke the KMS API to rotate the key every 30 days by setting the ScheduleExpression parameter to ***/30***.
D. Integrate the Amazon RDS for MySQL DB instances with AWS IAM and centrally manage the master database user password.

#60 (Accuracy: 100% / 2 votes)

A company uses Amazon DynamoDB to store its customer data. The DynamoDB table is designed with the user ID as the partition key value and multiple other non-key attributes. An external application needs to access data for specific user IDs. The external application must have access only to items with specific partition key values.

What should the database specialist do to meet these requirements?

A. Use the dynamodb:ReturnValues condition key in the external application's IAM policy to grant access.
B. Use a projection expression to select specific users from the DynamoDB table for the external application.
C. Use the ExecuteStatementAPI operation to select specific users from the DynamoDB table for the external application.
D. Use the dynamodb:LeadingKeys condition key in the external application's IAM policy to grant access.

There are 231 results