Note! Following DBS-C01 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

DBS-C01 Exam Dumps - AWS Certified Database - Specialty

Go to page:

<< First
Prev
2
3
4
5
6
7
8
9
10
11
Next
Last >>

Question # 49

A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster. The database will be accessed by multiple applications across the company. The company has mandated that all communications to the database be encrypted and the server identity must be validated. Any non-SSL-based connections should be disallowed access to the database.

Which solution addresses these requirements?

Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=allow.

Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=disable.

Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-ca.

Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-full.

Full Access

Question # 50

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?

The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to modify the workload to load the data slowly.

The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to enable Aurora storage scaling.

The local storage used to store temporary tables is full. The Database Specialist needs to scale up the instance.

The local storage used to store temporary tables is full. The Database Specialist needs to enable local storage scaling.

Full Access

Question # 51

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.

Which migration method should a Database Specialist use?

Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.

Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.

Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.

Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

Full Access

Question # 52

A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load fata from Amazon S3 into the Neptune DB cluster using the Neptune bulk loader API. The Database Specialist receives the following error:

â€œUnable to connect to s3 endpoint. Provided source = s3://mybucket/graphdata/ and region = us-east-1. Please verify your S3 configuration.â€

Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)

Check that Amazon S3 has an IAM role granting read access to Neptune

Check that an Amazon S3 VPC endpoint exists

Check that a Neptune VPC endpoint exists

Check that Amazon EC2 has an IAM role granting read access to Amazon S3

Check that Neptune has an IAM role granting read access to Amazon S3

Full Access

Question # 53

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL.

How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.

Connect to the Aurora host and create cron jobs to run the maintenance jobs following the required schedule.

Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.

Create the maintenance job using the Amazon CloudWatch job scheduling plugin.

Full Access

Question # 54

A Database Specialist is designing a new database infrastructure for a ride hailing application. The application data includes a ride tracking system that stores GPS coordinates for all rides. Real-time statistics and metadata lookups must be performed with high throughput and microsecond latency. The database should be fault tolerant with minimal operational overhead and development effort.

Which solution meets these requirements in the MOST efficient way?

Use Amazon RDS for MySQL as the database and use Amazon ElastiCache

Use Amazon DynamoDB as the database and use DynamoDB Accelerator

Use Amazon Aurora MySQL as the database and use Auroraâ€™s buffer cache

Use Amazon DynamoDB as the database and use Amazon API Gateway

Full Access

Question # 55

A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists.

Which step should be taken to troubleshoot this issue?

Ensure that the database option group for the RDS DB instance allows ingress from the Developer machineâ€™s IP address

Ensure that the RDS DB instanceâ€™s subnet group includes a public subnet to allow the Developer to connect

Ensure that the RDS DB instance has not reached its maximum connections limit

Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listening for encrypted connections

Full Access

Question # 56

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?

The restored DB instance does not have Enhanced Monitoring enabled

The production DB instance is using a custom parameter group

The restored DB instance is using the default security group

The production DB instance is using a custom option group

Full Access