Free DBS-C01 Exam Braindumps

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.)

1. A. Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.
2. B. Ensure the vertices and edges are specified in different .csv files with proper header column formatting.
3. C. Use AWS DMS to move data from Amazon S3 to the Neptune Loader.
4. D. Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.
5. 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.
6. F. Create an S3 VPC endpoint and issue an HTTP POST to the database€™s loader endpoint.

Correct Answer: BEF
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-optimize.html

A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:
ERROR: cloud not write block 7507718 of temporary file: No space left on device
What is the cause of this error and what should the Database Specialist do to resolve this issue?

1. A. The scaling of Aurora storage cannot catch up with the data loadin
2. B. The Database Specialist needs to modify the workload to load the data slowly.
3. C. The scaling of Aurora storage cannot catch up with the data loadin
4. D. The Database Specialist needs to enable Aurora storage scaling.
5. E. The local storage used to store temporary tables is ful
6. F. The Database Specialist needs to scale up the instance.
7. G. The local storage used to store temporary tables is ful
8. H. The Database Specialist needs to enable local storage scaling.

Correct Answer: C

A company’s ecommerce website uses Amazon DynamoDB for purchase orders. Each order is made up of a Customer ID and an Order ID. The DynamoDB table uses the Customer ID as the partition key and the Order ID as the sort key.
To meet a new requirement, the company also wants the ability to query the table by using a third attribute named Invoice ID. Queries using the Invoice ID must be strongly consistent. A database specialist must provide this capability with optimal performance and minimal overhead.
What should the database administrator do to meet these requirements?

1. A. Add a global secondary index on Invoice ID to the existing table.
2. B. Add a local secondary index on Invoice ID to the existing table.
3. C. Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.
4. D. Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.

Correct Answer: C
as Local secondary index can only be created while creating the Dynamodb table. and query needs to use third attribute on top of primary and sort key, so Local Secondary index has primary and sort key as well as the third attribute. Global secondary index can be created without primary and sort key

A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.
What is the MOST cost-effective action that should be taken to avoid downtime?

1. A. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
2. B. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
3. C. Enable a read replicas and direct read traffic to it when Amazon RDS is down
4. D. Enable an Amazon RDS for MySQL Multi-AZ configuration

Correct Answer: D
https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/
To minimize downtime, modify the Amazon RDS DB instance to a Multi-AZ deployment. For Multi-AZ deployments, OS maintenance is applied to the secondary instance first, then the instance fails over, and then the primary instance is updated. The downtime is during failover. For more information, see Maintenance for Multi-AZ Deployments. https://aws.amazon.com/rds/faqs/ The availability benefits of Multi-AZ also extend to planned maintenance. For example, with automated backups, I/O activity is no longer suspended on your primary during your preferred backup window, since backups are taken from the standby. In the case of patching or DB instance class scaling, these operations occur first on the standby, prior to automatic fail over. As a result, your availability impact is limited to the time required for automatic failover to complete.

A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server. Due to escalating support and maintenance costs, the company is exploring the option of moving the workload to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?

1. A. Perform a logical dump from the Db2 database and restore it to an Aurora DB cluste
2. B. Identify the gaps and compatibility of the objects migrated by comparing row counts from source and target tables.
3. C. Run AWS DMS from the Db2 database to an Aurora DB cluste
4. D. Identify the gaps and compatibility of the objects migrated by comparing the row counts from source and target tables.
5. E. Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate the migration compatibility.
6. F. Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster.Create a migration assessment report to evaluate the migration compatibility.

Correct Answer: D