For the first time, a database professional is establishing a test graph database on Amazon Neptune. The database 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: *

A company is using Amazon Aurora MySQL as the database for its retail application on AWS. The company receives a notification of a pending database upgrade and wants to ensure upgrades do not occur before or during the most critical time of year. Company leadership is concerned that an Amazon RDS maintenance window will cause an outage during data ingestion.
Which step can be taken to ensure that the application is not interrupted?

• A.Set up an Aurora Replica and promote it to primary at the time of patching.
• B.Disable weekly maintenance on the DB cluster.
• C.Clone the DB cluster and migrate it to a new copy of the database.
• D.Choose to defer the upgrade and then find an appropriate down time for patching.

Comment: *

Name: *

Email: *

Verification: *

A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.
Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

• A.Grant least privilege to groups, users, and roles
• B.Allow all users to restore a database from a backup that will reduce the overall downtime to restore the database
• C.Enable multi-factor authentication for sensitive operations to access sensitive resources and API operations
• D.Use policy conditions to restrict access to selective IP addresses
• E.Use AccessList Controls policy type to restrict users for database instance deletion
• F.Enable AWS CloudTrail logging and Enhanced Monitoring

Comment: *

Name: *

Email: *

Verification: *

An online advertising website uses an Amazon DynamoDB table with on-demand capacity mode as its data store. The website also has a DynamoDB Accelerator (DAX) cluster in the same VPC as its web application server. The application needs to perform infrequent writes and many strongly consistent reads from the data store by querying the DAX cluster.
During a performance audit, a systems administrator notices that the application can look up items by using the DAX cluster. However, the QueryCacheHits metric for the DAX cluster consistently shows 0 while the QueryCacheMisses metric continuously keeps growing in Amazon CloudWatch.
What is the MOST likely reason for this occurrence?

• A.A VPC endpoint was not added to access DynamoDB.
• B.Strongly consistent reads are always passed through DAX to DynamoDB.
• C.DynamoDB is scaling due to a burst in traffic, resulting in degraded performance.
• D.A VPC endpoint was not added to access CloudWatch.

Comment: *

Name: *

Email: *

Verification: *

A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days.
Which solution will meet these requirements in the MOST operationally efficient way?

• A.Create a manual copy of the snapshot.
• B.Export the contents of the snapshot to an Amazon S3 bucket.
• C.Change the retention period of the snapshot to 45 days.
• D.Create a native SQL Server backup. Save the backup to an Amazon S3 bucket.

Comment: *

Name: *

Email: *

Verification: *