Amazon DBS-C01 Exam Practice Test Instant Access

Question 1

A business is transferring a database from one AWS Region to another using an Amazon RDS for SQL Server DB instance. The organization wishes to keep database downtime to a minimum throughout the transfer.

Which migration strategy should the organization use for this cross-regional move?

ABack up the source database using native backup to an Amazon S3 bucket in the same Region. Then restore the backup in the target Region.

BBack up the source database using native backup to an Amazon S3 bucket in the same Region. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Region. Then restore the backup in the target Region.

CConfigure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target databases. Once the replication is in sync, terminate the DMS task.

DAdd an RDS for SQL Server cross-Region read replica in the target Region. Once the replication is in sync, promote the read replica to master.

Answer : C

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

With Amazon RDS, you can create a MariaDB, MySQL, Oracle, or PostgreSQL read replica in a different AWS Region from the source DB instance. Creating a cross-Region read replica isn't supported for SQL Server on Amazon RDS.

Question 2

A company has an AWS CloudFormation stack that defines an Amazon RDS DB instance. The company accidentally deletes the stack and loses recent data from the DB instance. A database specialist must change the CloudFormation template for the RDS resource to reduce the chance of accidental data loss from the DB instance in the future.

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

ASet the DeletionProtection property to True.

BSet the MultiAZ property to True.

CSet the TerminationProtection property to True.

DSet the DeleteAutomatedBackups property to False.

ESet the DeletionPolicy attribute to No.

FSet the DeletionPolicy attribute to Retain.

Answer : A, D, F

Question 3

A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL.

The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.

How should the Database Specialist edit the script to fix this issue?

AStop the source instances before stopping their read replicas

BDelete each read replica before stopping its corresponding source instance

CStop the read replicas before stopping their source instances

DUse the AWS CLI to stop each read replica and source instance at the same time

Answer : B

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

'The following are some limitations to stopping and starting a DB instance: You can't stop a DB instance that has a read replica, or that is a read replica.' So if you cant stop a db with a read replica, you have to delete the read replica first to then stop it??? https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MySQL.Replication.ReadReplicas.html#USER_MySQL.Replication.ReadReplicas.StartStop

Question 4

A major organization maintains a number of Amazon DB clusters. Each of these clusters is configured differently to meet certain needs. These configurations may be classified into wider groups based on the team and use case.

A database administrator wishes to streamline the process of storing and updating these settings. Additionally, the database administrator want to guarantee that changes to certain configuration categories are automatically implemented to all instances as necessary.

Which AWS service or functionality will assist in automating and achieving this goal?

AAWS Systems Manager Parameter Store

BDB parameter group

CAWS Config

DAWS Secrets Manager

Answer : B

Database parameters specify how the database is configured. For example, database parameters can specify the amount of resources, such as memory, to allocate to a database.

Question 5

A company has an Amazon Redshift cluster with database audit logging enabled. A security audit shows that raw SQL statements that run against the Redshift cluster are being logged to an Amazon S3 bucket. The security team requires that authentication logs are generated for use in an intrusion detection system (IDS), but the security team does not require SQL queries.

What should a database specialist do to remediate this issue?

ASet the parameter to true in the database parameter group.

BTurn off the query monitoring rule in the Redshift cluster's workload management (WLM).

CSet the enable_user_activity_logging parameter to false in the database parameter group.

DDisable audit logging on the Redshift cluster.

Answer : C

Question 6

A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table. TTL is enabled on one of the attributes. The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.

What is the MOST likely reason that the items are not being deleted?

AThe TTL attribute's value is set as a Number data type.

BThe TTL attribute's value is set as a Binary data type.

CThe TTL attribute's value is a timestamp in the Unix epoch time format in seconds.

DThe TTL attribute's value is set with an expiration of 1 year.

Answer : B

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TTL.html#time-to-live-ttl-before-you-start-formatting

Question 7

An online shopping company has a large inflow of shopping requests daily. As a result, there is a consistent load on the company's Amazon RDS database. A database specialist needs to ensure the database is up and running at all times. The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.

What should the database specialist do to achieve this? (Choose two.)

ACreate an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.

BSubscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.

CUse Amazon SES to send notifications based on configured Amazon CloudWatch Events events.

DConfigure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.

EEnable email notifications for AWS Trusted Advisor.

Answer : B, D

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