An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.
Which settings will meet this requirement? (Choose three.)

• A.Set DeletionProtection to True
• B.Set MultiAZ to True
• C.Set TerminationProtection to True
• D.Set DeleteAutomatedBackups to False
• E.Set DeletionPolicy to Delete
• F.Set DeletionPolicy to Retain

Comment: *

Name: *

Email: *

Verification: *

Recently, an ecommerce business transferred one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition database instance. The corporation anticipates an increase in read traffic as a result of an approaching sale. To accommodate the projected read load, a database professional must establish a read replica of the database instance.
Which procedures should the database professional do prior to establishing the read replica? (Select two.)

• A.Identify a potential downtime window and stop the application calls to the source DB instance.
• B.Ensure that automatic backups are enabled for the source DB instance.
• C.Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
• D.Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).
• E.Modify the read replica parameter group setting and set the value to 1.

Comment: *

Name: *

Email: *

Verification: *

A worldwide digital advertising corporation collects browser information in order to provide targeted visitors with contextually relevant pictures, websites, and connections. A single page load may create many events, each of which must be kept separately. A single event may have a maximum size of 200 KB and an average size of 10 KB. Each page load requires a query of the user's browsing history in order to deliver suggestions for targeted advertising. The advertising corporation anticipates daily page views of more than 1 billion from people in the United States, Europe, Hong Kong, and India. The information structure differs according to the event. Additionally, browsing information must be written and read with a very low latency to guarantee that consumers have a positive viewing experience.
Which database solution satisfies these criteria?

• A.Amazon Aurora Global Database
• B.Amazon DynamoDB global table
• C.Amazon RDS Multi-AZ deployment
• D.Amazon DocumentDB

Comment: *

Name: *

Email: *

Verification: *

For expert must input millions of rows of test observations from an Amazon S3.csv file. The database professional uploaded the data to the Neptune DB instance through a series of API calls.
Which sequence of actions enables the database professional to upload the data most quickly? (Select three.)

• A.Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.
• B.Ensure the vertices and edges are specified in different .csv files with proper header column formatting.
• C.Use AWS DMS to move data from Amazon S3 to the Neptune Loader.
• D.Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.
• E.Ensure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket.
• F.Create an S3 VPC endpoint and issue an HTTP POST to the database's loader endpoint.

Comment: *

Name: *

Email: *

Verification: *

In one AWS account, a business runs a two-tier ecommerce application. An Amazon RDS for MySQL Multi-AZ database instance serves as the application's backend. A developer removed the database instance in the production environment by accident. Although the organization recovers the database, the incident results in hours of outage and financial loss.
Which combination of adjustments would reduce the likelihood that this error will occur again in the future?
(Select three.)

• A.Enable AWS CloudTrail logging and Enhanced Monitoring.
• B.Grant least privilege to groups, IAM users, and roles.
• C.Use an ACL policy to restrict users from DB instance deletion.
• D.Allow all users to restore a database from a backup.
• E.Enable deletion protection on existing production DB instances.

Comment: *

Name: *

Email: *

Verification: *