DBS-C01 Practice Test

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

A.

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

B.

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

C.

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

D.

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

A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for
MySQL Multi-AZ DB instance is part of this deployment with a
database-1.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com endpoint listening on port 3306. The company’s
Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error
message. The application servers are logging a “could not connect to server: Connection times out” error
message to Amazon CloudWatch Logs.
What is the cause of this error?

A.

The user name and password the application is using are incorrect.

B.

The security group assigned to the application servers does not have the necessary rules to allow
inbound connections from the DB instance

C.

The security group assigned to the DB instance does not have the necessary rules to allow inbound
connections from the application servers.

D.

The user name and password are correct, but the user is not authorized to use the DB instance.

A company wants to automate the creation of secure test databases with random credentials to be stored safely
for later use. The credentials should have sufficient information about each test database to initiate a
connection and perform automated credential rotations. The credentials should not be logged or stored
anywhere in an unencrypted form.
Which steps should a Database Specialist take to meet these requirements using an AWS CloudFormation
template?

A.

Create the database with the Ma sterUserName and MasterUserPassword properties set to the default values. Then, create the secret with the user name and password set to the same default values. Add a
Secret Target Attachment resource with the SecretId and TargetId properties set to the Amazon
Resource Names (ARNs) of the secret and the database. Finally, update the secret’s password value with
a randomly generated string set by the GenerateSecretString property.

B.

Add a Mapping property from the database Amazon Resource Name (ARN) to the secret ARN. Then,
create the secret with a chosen user name and a randomly generated password set by the
GenerateSecretString property. Add the database with the MasterUserName and MasterUserPassword
properties set to the user name of the secret.

C.

Add a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property.
Then, define the database user name in the SecureStringTemplate template. Create a resource for the
database and reference the secret string for the MasterUserName and MasterUserPassword properties.
Then, add a resource of type AWS::SecretsManagerSecretTargetAttachment with the SecretId and
TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database.

D.

Create the secret with a chosen user name and a randomly generated password set by the
GenerateSecretString property. Add an SecretTargetAttachment resource with the SecretId property set
to the Amazon Resource Name (ARN) of the secret and the TargetId property set to a parameter value
matching the desired database ARN. Then, create a database with the MasterUserName and
MasterUserPassword properties set to the previously created values in the secret.

A marketing company is using Amazon DocumentDB and requires that database audit logs be enabled. A
Database Specialist needs to configure monitoring so that all data definition language (DDL) statements
performed are visible to the Administrator. The Database Specialist has set the audit_logs parameter to
enabled in the cluster parameter group.
What should the Database Specialist do to automatically collect the database logs for the Administrator?

A.

Enable DocumentDB to export the logs to Amazon CloudWatch Logs

B.

Enable DocumentDB to export the logs to AWS CloudTrail

C.

Enable DocumentDB Events to export the logs to Amazon CloudWatch Logs

D.

Configure an AWS Lambda function to download the logs using the download-db-log-file-portion operationand store the logs in Amazon S3

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. Theschema 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?

A.

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

B.

Connect to the Aurora host and create cron jobs to run the maintenance jobs following the
requiredschedule

C.

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

D.

Create the maintenance job using the Amazon CloudWatch job scheduling plugin