DBS-C01 Exam Questions
368 real DBS-C01 exam questions with expert-verified answers and explanations. Page 1 of 8.
- Question #1
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...
- Question #2Database Security
The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the prod...
Aurora PostgreSQLDatabase Activity StreamsReal-time MonitoringDatabase Auditing - Question #3Management and Operations
A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple...
Aurora BacktrackDatabase RecoveryDowntime ReductionDevelopment Workflow - Question #4Database Security
A media company is using Amazon RDS for PostgreSQL to store user data. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Fol...
Database SecurityNetwork Access ControlRDS ConfigurationHybrid Cloud Connectivity - Question #5Management and Operations
A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an Amazon Aurora MySQL DB clust...
Amazon AuroraDatabase cloningTest environmentsOperational efficiency - Question #6Workload-Specific Database Design
A company with branch offices in Portland, New York, and Singapore has a three-tier web application that leverages a shared database. The database runs on Amazon RDS for MySQL and...
RDS Read ReplicasCross-Region PerformanceRead ScalingGeographic Data Distribution - Question #7Deployment and Migration
A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime using AWS DMS. A Database Spe...
AWS DMSData ValidationHeterogeneous MigrationDatabase Migration - Question #8Management and Operations
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 syst...
Amazon RDSRead ReplicasInstance ManagementOperational Procedures - Question #9Workload-Specific Database Design
A global digital advertising company captures browsing metadata to contextually display relevant images, pages, and links to targeted users. A single page load can generate multipl...
Global DatabaseNoSQLLow LatencyHigh Scalability - Question #10Management and Operations
A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a st...
RDS Parameter GroupsStatic ParametersDB Instance RebootMulti-AZ DB Instances - Question #11Workload-Specific Database Design
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 fo...
NoSQL DatabasesCachingPerformance OptimizationManaged Database Services - Question #12Management and Operations
A company is using an Amazon Aurora PostgreSQL DB cluster with an xlarge primary instance master and two large Aurora Replicas for high availability and read-only workload scaling....
Aurora FailoverInstance SizingHigh AvailabilityPerformance Optimization - Question #13Monitoring and Troubleshooting
A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment. The cause of a recent spike in CPU utilization was not deter...
RDS MonitoringPerformance TroubleshootingCPU UtilizationSQL Server - Question #14Workload-Specific Database Design
A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distribute...
DynamoDBServerless DatabasesCapacity ManagementKey-Value Databases - Question #15Workload-Specific Database Design
A gaming company is designing a mobile gaming app that will be accessed by many users across the globe. The company wants to have replication and full support for multi-master writ...
DynamoDB Global TablesMulti-RegionActive-Active ReplicationScalability - Question #16Management and Operations
A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB cluster. The Aurora DB cluster currently includes the primary instance and t...
Aurora FailoverHigh Availability (HA)TCP KeepaliveApplication Downtime - Question #17Deployment and Migration
A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero d...
Database MigrationAWS SCTHeterogeneous Database MigrationNear-Zero Downtime - Question #18Workload-Specific Database Design
A gaming company has recently acquired a successful iOS game, which is particularly popular during the holiday season. The company has decided to add a leaderboard to the game that...
DynamoDB Capacity ModesDynamoDB Auto ScalingCost OptimizationWorkload Management - Question #19Database Security
A company's Security department established new requirements that state internal users must connect to an existing Amazon RDS for SQL Server DB instance using their corporate Activ...
RDS SecurityActive DirectoryWindows AuthenticationAWS Directory Service - Question #20Monitoring and Troubleshooting
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 th...
Amazon AuroraTemporary StorageTroubleshootingInstance Sizing - Question #21Database Security
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 com...
RDS SecuritySSL/TLS EncryptionParameter GroupsAurora PostgreSQL - Question #22Management and Operations
A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database Administrator must provide Auditors wi...
RDS SnapshotsData RetentionAutomated Backup and RestoreOperational Efficiency - Question #23Database Security
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 abou...
Secrets ManagerCloudFormationDatabase SecurityCredential Management - Question #24Database Security
A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A Database Specialist needs to...
Database SecurityAccess ControlPostgreSQL PermissionsTable-level Security - Question #25Management and Operations
A Database Specialist is working with a company to launch a new website built on Amazon Aurora with several Aurora Replicas. This new website will replace an on-premises website co...
Aurora Fault InjectionDatabase Resiliency TestingAurora FailoverOperational Testing - Question #26Monitoring and Troubleshooting
A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database. After the migration, the company discovered there is a period of time every day around 3:00...
Database Performance TuningAmazon RDS Performance InsightsTroubleshootingAurora PostgreSQL - Question #27Management and Operations
A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when survey responses are being collected, a Database Specialist sees the ProvisionedThro...
DynamoDB CapacityProvisionedThroughputExceededExceptionWrite Capacity UnitsOn-Demand Capacity Mode - Question #28Database Security
A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly dele...
IAMDatabase SecurityLeast PrivilegeMFA - Question #29Workload-Specific Database Design
A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less...
Aurora ScalingDatabase ConnectionsInstance SizingPerformance Tuning - Question #30Database Security
A company is developing a multi-tier web application hosted on AWS using Amazon Aurora as the database. The application needs to be deployed to production and other non-production...
Database SecuritySecrets ManagementCloudFormationPassword Rotation - Question #31Workload-Specific Database Design
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...
High Write ScalabilityNoSQL DatabaseCachingConcurrent Writes - Question #32Deployment and Migration
A company has migrated a single MySQL database to Amazon Aurora. The production data is hosted in a DB cluster in VPC_PROD, and 12 testing environments are hosted in VPC_TEST using...
Aurora CloningDatabase RefreshTest Data ManagementCost Optimization - Question #33Management and Operations
A large ecommerce company uses Amazon DynamoDB to handle the transactions on its web portal. Traffic patterns throughout the year are usually stable; however, a large event is plan...
DynamoDB capacity managementProvisioned throughputAuto ScalingPlanned event scaling - Question #34Deployment and Migration
A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS. The application requires minimal downtime wh...
AWS DMSDatabase MigrationMinimal Downtime MigrationHeterogeneous Database Migration - Question #35Deployment and Migration
A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts. Post-migration, the company purged unwanted data f...
RDS MariaDBStorage DownsizingDatabase MigrationZero-downtime - Question #36Monitoring and Troubleshooting
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 f...
RDS ConnectionSSL/TLSTroubleshootingData Encryption in Transit - Question #37Management and Operations
A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window. Wha...
Amazon RDSHigh AvailabilityMulti-AZCost Optimization - Question #38Monitoring and Troubleshooting
A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query...
RDS Read ReplicasEBS Volume InitializationPerformance TroubleshootingMySQL Replication - Question #39Deployment and Migration
A company developed an AWS CloudFormation template used to create all new Amazon DynamoDB tables in its AWS account. The template configures provisioned throughput capacity using h...
CloudFormation ParametersDynamoDB CapacityTemplate DesignProvisioned Throughput - Question #40Workload-Specific Database Design
A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company's main workload consists of a mission-critical...
Aurora Global DatabaseCross-region data accessLow-latency readsHybrid OLTP/Analytical workloads - Question #41Management and Operations
A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is...
RDS Parameter GroupsRDS LoggingCloudWatch LogsDatabase Configuration - Question #42Monitoring and Troubleshooting
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...
Neptune Bulk LoaderS3 ConnectivityIAM RolesVPC Endpoints - Question #43Deployment and Migration
A media company is running a critical production application that uses Amazon RDS for PostgreSQL with Multi-AZ deployments. The database size is currently 25 TB. The IT Director wa...
Database MigrationAmazon Aurora PostgreSQLAmazon RDS for PostgreSQLMinimal Downtime Migration - Question #44Database Security
A medical company is planning to migrate its on-premises PostgreSQL database, along with application and web servers, to AWS. Amazon RDS for PostgreSQL is being considered as the t...
AWS RDSVPC NetworkingPrivate SubnetsDatabase Security - Question #45Monitoring and Troubleshooting
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.u...
RDS connectivitySecurity GroupsTroubleshootingNetwork Access Control - Question #46Management and Operations
An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudF...
CloudFormationRDSData ProtectionBackup and Recovery - Question #47Monitoring and Troubleshooting
A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the...
Aurora FailoverDNS CachingClient ConnectivityApplication Troubleshooting - Question #48Database Security
A company is deploying a solution in Amazon Aurora by migrating from an on-premises system. The IT department has established an AWS Direct Connect link from the company's data cen...
Aurora ConnectivitySSL/TLSClient ConfigurationDatabase Security - Question #49Workload-Specific Database Design
A company is concerned about the cost of a large-scale, transactional application using Amazon DynamoDB that only needs to store data for 2 days before it is deleted. In looking at...
DynamoDBTime to Live (TTL)Cost OptimizationData Lifecycle Management - Question #50Monitoring and Troubleshooting
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup....
RDS MonitoringEvent NotificationsDatabase Lifecycle ManagementAWS SNS