A company’s Security department established new requirements that state internal users must connect to an existing Amazon RDS for SQL Server DB instance using their corporate Active Directory (AD) credentials. A Database Specialist must make the modifications needed to fulfill this requirement.
Which combination of actions should the Database Specialist take? (Choose three.)

1. A. Disable Transparent Data Encryption (TDE) on the RDS SQL Server DB instance.
2. B. Modify the RDS SQL Server DB instance to use the directory for Windows authenticatio
3. C. Create appropriate new logins.
4. D. Use the AWS Management Console to create an AWS Managed Microsoft A
5. E. Create a trust relationship with the corporate AD.
6. F. Stop the RDS SQL Server DB instance, modify it to use the directory for Windows authentication, and start it agai
7. G. Create appropriate new logins.
8. H. Use the AWS Management Console to create an AD Connecto
9. I. Create a trust relationship with the corporate AD.
10. J. Configure the AWS Managed Microsoft AD domain controller Security Group.

Correct Answer: BCF
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerWinAuth.html

A large company has a variety of Amazon DB clusters. Each of these clusters has various configurations that adhere to various requirements. Depending on the team and use case, these configurations can be organized into broader categories.
A database administrator wants to make the process of storing and modifying these parameters more systematic. The database administrator also wants to ensure that changes to individual categories of configurations are automatically applied to all instances when required.
Which AWS service or feature will help automate and achieve this objective?

1. A. AWS Systems Manager Parameter Store
2. B. DB parameter group
3. C. AWS Config
4. D. AWS Secrets Manager

Correct Answer: B

A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available. Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.
What might account for this? (Choose two.)

1. A. The new minor version has not yet been designated as preferred and requires a manual upgrade.
2. B. Configuring automatic upgrades using the AWS CLI is not supporte
3. C. This must be enabled expressly using the AWS Management Console.
4. D. Applying minor version upgrades requires sufficient free space.
5. E. The AWS CLI command did not include an apply-immediately parameter.
6. F. Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.

Correct Answer: AD
"When Amazon RDS designates a minor engine version as the preferred minor engine version, each database that meets both of the following conditions is upgraded to the minor engine version automatically"
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Upgrading.html
Call the modify-db-instance Amazon CLI command. Specify the name of your DB instance for the
--db-instance-identifier option and true for the --auto-minor-version-upgrade option. Optionally, specify the
--apply-immediately option to immediately enable this setting for your DB instance. Run a separate modify-db-instance command for each DB instance in the cluster.
https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.Patching.html#

A retail company manages a web application that stores data in an Amazon DynamoDB table. The company is undergoing account consolidation efforts. A database engineer needs to migrate the DynamoDB table from the current AWS account to a new AWS account.
Which strategy meets these requirements with the LEAST amount of administrative work?

1. A. Use AWS Glue to crawl the data in the DynamoDB tabl
2. B. Create a job using an available blueprint to export the data to Amazon S3. Import the data from the S3 file to a DynamoDB table in the new account.
3. C. Create an AWS Lambda function to scan the items of the DynamoDB table in the current account and write to a file in Amazon S3. Create another Lambda function to read the S3 file and restore the items of a DynamoDB table in the new account.
4. D. Use AWS Data Pipeline in the current account to export the data from the DynamoDB table to a file in Amazon S3. Use Data Pipeline to import the data from the S3 file to a DynamoDB table in the new account.
5. E. Configure Amazon DynamoDB Streams for the DynamoDB table in the current accoun
6. F. Create an AWS Lambda function to read from the stream and write to a file in Amazon S3. Create another Lambda functionto read the S3 file and restore the items to a DynamoDB table in the new account.

Correct Answer: C
https://aws.amazon.com/premiumsupport/knowledge-center/dynamodb-cross-account-migration/ https://aws.amazon.com/premiumsupport/knowledge-center/data-pipeline-account-access-dynamodb-s3/

A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora DB cluster is appropriate for the peak workload.
The company is now looking at cutting costs for this DB cluster, but needs to have a sufficient number of nodes in the cluster to support the workload at different times. The workload has not changed since the previous benchmarking exercise.
How can a Database Specialist address these requirements with minimal user involvement?

1. A. Split up the DB cluster into two different clusters: one for OLTP and the other for reportin
2. B. Monitor and set up replication between the two clusters to keep data consistent.
3. C. Review all evaluate the peak combined workloa
4. D. Ensure that utilization of the DB cluster node is at an acceptable leve
5. E. Adjust the number of instances, if necessary.
6. F. Use the stop cluster functionality to stop all the nodes of the DB cluster during times of minimal workloa
7. G. The cluster can be restarted again depending on the workload at the time.
8. H. Set up automatic scaling on the DB cluste
9. I. This will allow the number of reader nodes to adjust automatically to the reporting workload, when needed.

Correct Answer: D