DBS-C01 Exam Questions
368 real DBS-C01 exam questions with expert-verified answers and explanations. Page 2 of 8.
- Question #51Database Security
A clothing company uses a custom ecommerce application and a PostgreSQL database to sell clothes to thousands of users from multiple countries. The company is migrating its applica...
Database SecurityCredential ManagementAWS Secrets ManagerRDS PostgreSQL - Question #52Database Security
A financial services company is developing a shared data service that supports different applications from throughout the company. A Database Specialist designed a solution to leve...
ElastiCache SecurityRedis AuthenticationData EncryptionNetwork Security Groups - Question #53Deployment and Migration
A company is running an Amazon RDS for PostgeSQL DB instance and wants to migrate it to an Amazon Aurora PostgreSQL DB cluster. The current database is 1 TB in size. The migration...
Database MigrationAWS DMSAurora PostgreSQLMinimal Downtime - Question #54Deployment and Migration
A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the...
AWS DMSDatabase MigrationPerformance OptimizationCross-Region Migration - Question #55Management and Operations
The Development team recently executed a database script containing several data definition language (DDL) and data manipulation language (DML) statements on an Amazon Aurora MySQL...
Aurora RecoveryPoint-in-Time Recovery (PITR)BacktrackDatabase Incident Response - Question #56Management and Operations
A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS. The Application team is making changes to deploy additional...
CloudFormationChange SetStack PolicyResource Protection - Question #57Management and Operations
A manufacturing company's website uses an Amazon Aurora PostgreSQL DB cluster. Which configurations will result in the LEAST application downtime during a failover? (Choose three.)
Aurora FailoverHigh AvailabilityConnection ManagementCluster Cache Management - Question #58Management and Operations
A company is hosting critical business data in an Amazon Redshift cluster. Due to the sensitive nature of the data, the cluster is encrypted at rest using AWS KMS. As a part of dis...
Amazon RedshiftCross-Region SnapshotsAWS KMSDisaster Recovery - Question #59Management and Operations
A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the...
Aurora Auto ScalingCost OptimizationWorkload ManagementRead Replicas - Question #60Database Security
A company is running a finance application on an Amazon RDS for MySQL DB instance. The application is governed by multiple financial regulatory agencies. The RDS DB instance is set...
RDS SecurityData in transit encryptionSSL/TLSRegulatory Compliance - Question #61Management and Operations
A Database Specialist is troubleshooting complaints from an application's users who are experiencing performance issues when saving data in an Amazon ElastiCache for Redis cluster...
ElastiCache RedisBackup performanceMemory managementReplication groups - Question #62Database Security
A company's Security department has mandated that their existing Amazon RDS for MySQL DB instance be encrypted at rest. What should a Database Specialist do to meet this requiremen...
RDS EncryptionData at Rest EncryptionDatabase SnapshotsDatabase Security Best Practices - Question #63Workload-Specific Database Design
An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases: - Update sco...
DynamoDBKey DesignPrimary KeyAccess Patterns - Question #64Deployment and Migration
A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to b...
RDS EncryptionData at Rest EncryptionAWS KMSRDS Snapshots - Question #65Management and Operations
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...
Amazon RDSRead ReplicasAutomated BackupsMySQL - Question #66Management and Operations
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 ser...
Serverless ComputingJob SchedulingDatabase Maintenance AutomationHigh Availability Best Practices - Question #67Management and Operations
A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To meet the company's disaster recovery policies, the database backup needs to be c...
RDS SnapshotsDisaster RecoveryCross-Region BackupAutomation - Question #68Monitoring and Troubleshooting
An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The R...
RDS Performance TuningInstance SizingNetwork BandwidthEBS Storage - Question #69Monitoring and Troubleshooting
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?
RDSSnapshotsSecurity GroupsConnectivityTroubleshooting - Question #70Workload-Specific Database Design
A gaming company has implemented a leaderboard in AWS using a Sorted Set data structure within Amazon ElastiCache for Redis. The ElastiCache cluster has been deployed with cluster...
ElastiCache for RedisScalingWrite PerformanceVertical Scaling - Question #71Workload-Specific Database Design
An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production dat...
Aurora ReplicasRead ScalingReportingCost Optimization - Question #72Workload-Specific Database Design
A retail company is about to migrate its online and mobile store to AWS. The company's CEO has strategic plans to grow the brand globally. A Database Specialist has been challenged...
DynamoDB Global TablesMulti-Region DatabasesDatabase PerformanceOperational Overhead - Question #73Monitoring and Troubleshooting
A company has a highly available production 10 TB SQL Server relational database running on Amazon EC2. Users have recently been reporting performance and connectivity issues. The...
MonitoringSQL ServerAmazon EC2CloudWatch Application Insights - Question #74Management and Operations
A company's ecommerce application stores order transactions in an Amazon RDS for MySQL database. The database has run out of available storage and the application is currently unab...
RDS Storage ScalingDatabase Instance ModificationOperational Procedures - Question #75Security operations
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 lan...
AWS loggingDatabase auditingCloudWatch LogsDocumentDB - Question #76Security operations
A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server. Due to escalating support and maintenance costs, the company is exploring the opti...
AWS database migrationSchema conversionAWS SCTAurora PostgreSQL - Question #77Security operations
An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application. The steady increase in the number of orders is resulting in increased DynamoDB co...
DynamoDB optimizationDAXAWS cost managementDatabase caching - Question #78Security operations
An IT company wants to reduce its database operation costs in its development environment. The company's workflow creates an Amazon Aurora MySQL DB cluster for each development gro...
Aurora cost optimizationDatabase cloningAWS database managementDevelopment environment - Question #79Security operations
A company has multiple applications serving data from a secure on-premises database. The company is migrating all applications and databases to the AWS Cloud. The IT Risk and Compl...
Database auditingAurora advanced auditingCompliance requirementsAWS security - Question #80Security operations
A company undergoing a security audit has determined that its Database Administrators are presently the company's Amazon Aurora deployment. To sharing an administrative database us...
IAM database authenticationAurora securityAWS access controlCompliance - Question #81Security operations
A global company wants to run an application in several AWS Regions to support a global user base. The application will need a database that can support a high volume of low-latenc...
DynamoDB Global TablesMulti-region architectureLow-latency databaseDatabase scaling - Question #82Security operations
A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The company requires fast responses for end-user queries when looking at data f...
Redshift data warehousingData storage optimizationQuery performanceAWS cost management - Question #83Deployment and Migration
A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to de...
CloudFormationStackSetsDynamoDB deploymentMulti-Region deployment - Question #84Monitoring and Troubleshooting
A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the p...
RDS for MySQLPerformance InsightsDatabase wait eventsPerformance monitoring - Question #85Management and Operations
A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulat...
RDS Multi-AZFailover testingDisaster RecoveryOracle - Question #86Management and Operations
A company maintains several databases using Amazon RDS for MySQL and PostgreSQL. Each RDS database generates log files with retention periods set to their default values. The compa...
RDS logsCloudWatch LogsLog retentionCentralized logging - Question #87Management and Operations
A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas for a highly intensive, business-critical application. The Au...
Aurora failoverAurora ReplicasPromotion tierHigh availability - Question #88Deployment and Migration
A company's customer relationship management application uses an Amazon RDS for PostgreSQL Multi-AZ database. The database size is approximately 100 GB. A Database Specialist has b...
RDS for PostgreSQLCross-Region DRRTO/RPOSnapshots - Question #89Deployment and Migration
An Operations team in a large company wants to centrally manage resource provisioning for its development teams across multiple accounts. When a new AWS account is created, the Dev...
RDS for MySQLAccount sharingDatabase provisioningManual snapshots - Question #90Workload-Specific Database Design
A company is using Amazon with Aurora Replicas for read-only workload scaling. A Database Specialist needs to split up two read-only applications so each application always connect...
Aurora ReplicasCustom endpointsWorkload separationRead scaling - Question #91Deployment and Migration
A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse solution. The company plans to use the AWS Schema Conversion Tool (AWS SCT)...
Data warehouse migrationAWS DMSAWS SCTRedshiftLarge-scale migration - Question #92Deployment and Migration
A company is looking to migrate a 1 TB Oracle database from on-premises to an Amazon Aurora PostgreSQL DB cluster. The company's Database Specialist discovered that the Oracle data...
AWS DMSLOB migrationHeterogeneous migrationMigration optimization - Question #93Database Security
A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table uses provisioned read/write capacity mode, global secondary indexe...
DynamoDB restoreIAM policiesTime To Live (TTL)Disaster Recovery - Question #94Deployment and Migration
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...
DynamoDB deploymentCloudWatch AlarmsSSM Parameter StoreConfiguration management - Question #95Management and Operations
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Tests were run on the database after work hours, which generated...
RDS for PostgreSQLLog retentionStorage managementParameter groups - Question #96Management and Operations
A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The databas...
RDS for MySQLStorage Auto ScalingStorage managementOperational efficiency - Question #97Deployment and Migration
A company is due for renewing its database license. The company wants to migrate its 80 TB transactional database system from on-premises to the AWS Cloud. The migration should inc...
On-premises migrationLarge-scale migrationAWS Snowball EdgeLeast downtime migration - Question #98Management and Operations
A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replica. The DB instance and the read replica are assigned to the default parameter group...
RDS for MySQLRead ReplicaParameter groupsRead-only mode - Question #99Workload-Specific Database Design
A company has a heterogeneous six-node production Amazon Aurora DB cluster that handles online transaction processing (OLTP) for the core business and OLAP reports for the human re...
Aurora DB clusterCustom endpointsWorkload separationOLTP/OLAP - Question #100Database Security
Developers have requested a new Amazon Redshift cluster so they can load new third-party marketing data. The new cluster is ready and the user credentials are given to the develope...
RedshiftS3 accessIAM rolesCOPY commandAccess denied