Amazon DBS-C01 Exam Practice Test Instant Access

Question 1

A company is planning to use Amazon RDS for SQL Server for one of its critical applications. The company's security team requires that the users of the RDS for

SQL Server DB instance are authenticated with on-premises Microsoft Active Directory credentials.

Which combination of steps should a database specialist take to meet this requirement? (Choose three.)

AExtend the on-premises Active Directory to AWS by using AD Connector.

BCreate an IAM user that uses the AmazonRDSDirectoryServiceAccess managed IAM policy.

CCreate a directory by using AWS Directory Service for Microsoft Active Directory.

DCreate an Active Directory domain controller on Amazon EC2.

ECreate an IAM role that uses the AmazonRDSDirectoryServiceAccess managed IAM policy.

FCreate a one-way forest trust from the AWS Directory Service for Microsoft Active Directory directory to the on-premises Active Directory.

Answer : C, E, F

Question 2

A company's database specialist is building an Amazon RDS for Microsoft SQL Server DB instance to store hundreds of records in CSV format. A customer service tool uploads the records to an Amazon S3 bucket.

An employee who previously worked at the company already created a custom stored procedure to map the necessary CSV fields to the database tables. The database specialist needs to implement a solution that reuses this previous work and minimizes operational overhead.

Which solution will meet these requirements?

ACreate an Amazon S3 event to invoke an AWS Lambda function. Configure the Lambda function to parse the .csv file and use a SQL client library to run INSERT statements to load the data into the tables.

BWrite a custom .NET app that is hosted on Amazon EC2. Configure the .NET app to load the .csv file and call the custom stored procedure to insert the data into the tables.

CDownload the .csv file from Amazon S3 to the RDS D drive by using an AWS msdb stored procedure. Call the custom stored procedure to insert the data from the RDS D drive into the tables.

DCreate an Amazon S3 event to invoke AWS Step Functions to parse the .csv file and call the custom stored procedure to insert the data into the tables.

Answer : C

Step 1: Download S3 Files

Amazon RDS for SQL Server comes with several custom stored procedures and functions. These are located in the msdb database. The stored procedure to download files from S3 is 'rds_download_from_s3'. The syntax for this stored procedure is shown here:

exec msdb.dbo.rds_download_from_s3

@s3_arn_of_file='arn:aws:s3:::<bucket_name>/<file_name>',

@rds_file_path='D:\S3\<custom_folder_name>\<file_name>',

@overwrite_file=1;

Question 3

A Database Specialist is creating Amazon DynamoDB tables, Amazon CloudWatch alarms, and associated infrastructure for an Application team using a development AWS account. The team wants a deployment

method that will standardize the core solution components while managing environment-specific settings separately, and wants to minimize rework due to configuration errors.

Which process should the Database Specialist recommend to meet these requirements?

AOrganize common and environmental-specific parameters hierarchically in the AWS Systems Manager Parameter Store, then reference the parameters dynamically from an AWS CloudFormation template. Deploy the CloudFormation stack using the environment name as a parameter.

BCreate a parameterized AWS CloudFormation template that builds the required objects. Keep separate environment parameter files in separate Amazon S3 buckets. Provide an AWS CLI command that deploys the CloudFormation stack directly referencing the appropriate parameter bucket.

CCreate a parameterized AWS CloudFormation template that builds the required objects. Import the template into the CloudFormation interface in the AWS Management Console. Make the required changes to the parameters and deploy the CloudFormation stack.

DCreate an AWS Lambda function that builds the required objects using an AWS SDK. Set the required parameter values in a test event in the Lambda console for each environment that the Application team can modify, as needed. Deploy the infrastructure by triggering the test event in the console.

Answer : A

https://aws.amazon.com/blogs/mt/integrating-aws-cloudformation-with-aws-systems-manager-parameter-store/

Question 4

A business is launching a new Amazon RDS for SQL Server database instance. The organization wishes to allow auditing of the SQL Server database.

Which measures should a database professional perform in combination to achieve this requirement? (Select two.)

ACreate a service-linked role for Amazon RDS that grants permissions for Amazon RDS to store audit logs on Amazon S3.

BSet up a parameter group to configure an IAM role and an Amazon S3 bucket for audit log storage. Associate the parameter group with the DB instance.

CDisable Multi-AZ on the DB instance, and then enable auditing. Enable Multi-AZ after auditing is enabled.

DDisable automated backup on the DB instance, and then enable auditing. Enable automated backup after auditing is enabled.

ESet up an options group to configure an IAM role and an Amazon S3 bucket for audit log storage. Associate the options group with the DB instance.

Answer : A, E

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.Audit.html

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/security_iam_service-with-iam.html

Question 5

A financial institution uses AWS to host its online application. Amazon RDS for MySQL is used to host the application's database, which includes automatic backups.

The program has corrupted the database logically, resulting in the application being unresponsive. The exact moment the corruption occurred has been determined, and it occurred within the backup retention period.

How should a database professional restore a database to its previous state prior to corruption?

AUse the point-in-time restore capability to restore the DB instance to the specified time. No changes to the application connection string are required.

BUse the point-in-time restore capability to restore the DB instance to the specified time. Change the application connection string to the new, restored DB instance.

CRestore using the latest automated backup. Change the application connection string to the new, restored DB instance.

DRestore using the appropriate automated backup. No changes to the application connection string are required.

Answer : B

When you perform a restore operation to a point in time or from a DB Snapshot, a new DB Instance is created with a new endpoint (the old DB Instance can be deleted if so desired). This is done to enable you to create multiple DB Instances from a specific DB Snapshot or point in time.'

Question 6

A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ DB instance. When using the AWS Management Console to conduct this task, the Database Specialist discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read replica cannot be created.

What is the most likely reason for this?

AThe source DB instance has to be converted to Single-AZ first to create a read replica from it.

BEnhanced Monitoring is not enabled on the source DB instance.

CThe minor MySQL version in the source DB instance does not support read replicas.

DAutomated backups are not enabled on the source DB instance.

Answer : D

>Your source DB instance must have backup retention enabled. https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstanceReadReplica.html

Question 7

A database specialist was alerted that a production Amazon RDS MariaDB instance with 100 GB of storage was out of space. In response, the database specialist modified the DB instance and added 50 GB of storage capacity. Three hours later, a new alert is generated due to a lack of free space on the same DB instance. The database specialist decides to modify the instance immediately to increase its storage capacity by 20 GB.

What will happen when the modification is submitted?

AThe request will fail because this storage capacity is too large.

BThe request will succeed only if the primary instance is in active status.

CThe request will succeed only if CPU utilization is less than 10%.

DThe request will fail as the most recent modification was too soon.

Answer : D

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

Amazon AWS Certified Database - Specialty DBS-C01 Exam Practice Test