Amazon DBS-C01 Exam Questions Instant Access

Question 1

A social media company is using Amazon DynamoDB to store user profile data and user activity dat

a. Developers are reading and writing the data, causing the size of the tables to grow significantly. Developers have started to face performance bottlenecks with the tables.

Which solution should a database specialist recommend to read items the FASTEST without consuming all the provisioned throughput for the tables?

AUse the Scan API operation in parallel with many workers to read all the items. Use the Query API operation to read multiple items that have a specific partition key and sort key. Use the GetItem API operation to read a single item.

BUse the Scan API operation with a filter expression that allows multiple items to be read. Use the Query API operation to read multiple items that have a specific partition key and sort key. Use the GetItem API operation to read a single item.

CUse the Scan API operation with a filter expression that allows multiple items to be read. Use the Query API operation to read a single item that has a specific primary key. Use the BatchGetItem API operation to read multiple items.

DUse the Scan API operation in parallel with many workers to read all the items. Use the Query API operation to read a single item that has a specific primary key Use the BatchGetItem API operation to read multiple items.

Answer : B

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SQLtoNoSQL.ReadData.html

Question 2

A company is about to launch a new product, and test databases must be re-created from production dat

a. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.

What should the Database Specialist do to meet these requirements?

ARestore a snapshot from the production cluster into test clusters

BCreate logical dumps of the production cluster and restore them into new test clusters

CUse database cloning to create clones of the production cluster

DAdd an additional read replica to the production cluster and use that node for testing

Answer : C

https://aws.amazon.com/getting-started/hands-on/aurora-cloning-backtracking/

'Cloning an Aurora cluster is extremely useful if you want to assess the impact of changes to your database, or if you need to perform workload-intensive operations---such as exporting data or running analytical queries, or simply if you want to use a copy of your production database in a development or testing environment. You can make multiple clones of your Aurora DB cluster. You can even create additional clones from other clones, with the constraint that the clone databases must be created in the same region as the source databases.

Question 3

A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.

Which AWS services should the Database Specialist consider? (Choose two.)

AAmazon DynamoDB

BAmazon Redshift

CAmazon Neptune

DAmazon Elasticsearch Service

EAmazon ElastiCache

Answer : A, E

https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html#Strategies.WriteThrough

https://aws.amazon.com/products/databases/real-time-apps-elasticache-for-redis/

Question 4

A company uses the Amazon DynamoDB table contractDB in us-east-1 for its contract system with the following schema:

orderID (primary key) timestamp (sort key) contract (map) createdBy (string) customerEmail (string)

After a problem in production, the operations team has asked a database specialist to provide an IAM policy to read items from the database to debug the application. In addition, the developer is not allowed to access the value of the customerEmail field to stay compliant.

Which IAM policy should the database specialist use to achieve these requirements?

AOption A

BOption B

COption C

DOption C

Answer : A

Question 5

A database specialist is working on an Amazon RDS for PostgreSQL DB instance that is experiencing application performance issues due to the addition of new workloads. The database has 5 ' of storage space with Provisioned IOPS. Amazon CloudWatch metrics show that the average disk queue depth is greater than

200 and that the disk I/O response time is significantly higher than usual.

What should the database specialist do to improve the performance of the application immediately?

AIncrease the Provisioned IOPS rate on the storage.

BIncrease the available storage space.

CUse General Purpose SSD (gp2) storage with burst credits.

DCreate a read replica to offload Read IOPS from the DB instance.

Answer : A

Question 6

A development team asks a database specialist to create a copy of a production Amazon RDS for MySQL DB instance every morning. The development team will use the copied DB instance as a testing environment for development. The original DB instance and the copy will be hosted in different VPCs of the same AWS account. The development team wants the copy to be available by 6 AM each day and wants to use the same endpoint address each day.

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

ACreate a snapshot of the production database each day before the 6 AM deadline.

BCreate an RDS for MySQL DB instance from the snapshot. Select the desired DB instance size.

CUpdate a defined Amazon Route 53 CNAME record to point to the copied DB instance.

DSet up an AWS Database Migration Service (AWS DMS) migration task to copy the snapshot to the copied DB instance.

EUse the CopySnapshot action on the production DB instance to create a snapshot before 6 AM.

FUpdate a defined Amazon Route 53 alias record to point to the copied DB instance.

Answer : A, B, C

Question 7

After restoring an Amazon RDS snapshot from 3 days ago, a company's Development team cannot connect to the restored RDS DB instance. What is the likely cause of this problem?

AThe restored DB instance does not have Enhanced Monitoring enabled

BThe production DB instance is using a custom parameter group

CThe restored DB instance is using the default security group

DThe production DB instance is using a custom option group

Answer : C

https://aws.amazon.com/premiumsupport/knowledge-center/rds-cannot-connect/

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html

Amazon AWS Certified Database - Specialty DBS-C01 Exam Questions