DBS-C01 Exam Questions
368 real DBS-C01 exam questions with expert-verified answers and explanations. Page 7 of 8.
- Question #301Management and Operations
A database specialist observes several idle connections in an Amazon RDS for MySQL DB instance. The DB instance is using RDS Proxy. An application is configured to connect to the p...
RDS Proxyconnection poolingidle connectionsdatabase management - Question #302Workload-Specific Database Design
An online retailer uses Amazon DynamoDB for its product catalog and order data. Some popular items have led to frequently accessed keys in the data, and the company is using Dynamo...
DynamoDB Accelerator (DAX)cachingcache miss ratescaling - Question #303Monitoring and Troubleshooting
A financial services company is using AWS Database Migration Service (AWS DMS) to migrate its databases from on-premises to AWS. A database administrator is working on replicating...
AWS DMSCDC replicationmigration troubleshootingreplication latency - Question #304Workload-Specific Database Design
A database specialist needs to set up an Amazon DynamoDB table. The table must exist in multiple AWS Regions and must provide point-in-time recovery of data. Which combination of s...
DynamoDB Global Tablespoint-in-time recoverymulti-region databasesdata replication - Question #305Management and Operations
A company uses an Amazon Aurora MySQL DB cluster. A database specialist has configured the DB cluster to use the automated backup feature with a 10-day retention period. The compan...
Aurora MySQLautomated backupsbackup retentioncost optimization - Question #306Management and Operations
A company is running a mobile app that has a backend database in Amazon DynamoDB. The app experiences sudden increases and decreases in activity throughout the day. The company's o...
DynamoDB throttlingon-demand capacityperformance optimizationserverless databases - Question #307Deployment and Migration
A global company needs to migrate from an on-premises Microsoft SQL Server database to a highly available database solution on AWS. The company wants to modernize its application a...
database migrationSQL Server migrationAWS DMSAWS SCT - Question #308Database Security
A company is using an Amazon Aurora PostgreSQL DB cluster for a project. A database specialist must ensure that the database is encrypted at rest. The database size is 500 GB. What...
Aurora PostgreSQLencryption at restKMSdatabase security - Question #309Workload-Specific Database Design
A database specialist is designing the database for a software-as-a-service (SaaS) version of an employee information application. In the current architecture, the change history o...
database designimmutable ledgerAmazon QLDBhistorical data - Question #310Workload-Specific Database Design
A company is using Amazon Redshift. A database specialist needs to allow an existing Redshift cluster to access data from other Redshift clusters. Amazon RDS for PostgreSQL databas...
Amazon Redshiftdata integrationfederated queriesdata sharing - Question #311Deployment and Migration
A company is planning to migrate a 40 TB Oracle database to an Amazon Aurora PostgreSQL DB cluster by using a single AWS Database Migration Service (AWS DMS) task within a single r...
AWS DMS performancelarge-scale migrationfull load optimizationCDC optimization - Question #312Workload-Specific Database Design
A financial services company is running a MySQL database on premises. The database holds details about all customer interactions and the financial advice that the company provided....
database migration strategyread scalinghigh availabilityAurora MySQL - Question #313Management and Operations
A company has a Microsoft SQL Server 2017 Enterprise edition on Amazon RDS database with the Multi-AZ option turned on. Automatic backups are turned on and the retention period is...
RDS SQL Serverread replicasMulti-AZdatabase operations - Question #314Database Security
A company is using a 1 TB Amazon RDS for PostgreSQL DB instance to store user data. During a security review, a security engineer sees that the DB instance is not encrypted at rest...
RDS PostgreSQLencryption at restdowntime reductiondata security - Question #315Workload-Specific Database Design
An advertising company is developing a backend for a bidding platform. The company needs a cost-effective datastore solution that will accommodate a sudden increase in the volume o...
database selectionbursty writesreal-time data streamcost-effective - Question #316Management and Operations
An ecommerce company uses an Amazon Aurora MySQL DB cluster to process payments. The company's database specialist notices that Aurora performs database maintenance actions periodi...
Aurora maintenancemaintenance windowsoperational managementdowntime management - Question #317Deployment and Migration
A company wants to use AWS Organizations to create isolated accounts for different teams and functionality. The company's database administrator needs to copy a DB instance from th...
cross-account snapshotcross-region copyKMS encryptionRDS PostgreSQL snapshots - Question #318Monitoring and Troubleshooting
A database specialist is working with a company to launch a new website. The website accesses a database on an Amazon Aurora MySQL DB cluster that is configured with several Aurora...
Aurora MySQLresiliency testingfault injectiondatabase testing - Question #319Monitoring and Troubleshooting
A company needs to troubleshoot its Amazon Aurora Serverless MySQL database. The company selected a db.t3, medium instance class for the database's initial deployment. The database...
Aurora MySQLconnection limitsparameter groupsperformance tuning - Question #320Management and Operations
A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days....
RDS SQL Serverdatabase snapshotsbackup retentionoperational efficiency - Question #321Deployment and Migration
A company runs an Amazon Aurora MySQL DB instance for one of its critical applications. The company's marketing department sends promotional email messages to customers based on th...
Aurora MySQLsnapshot export to S3data lake integrationKMS encryption - Question #322Monitoring and Troubleshooting
A large financial services company is using AWS Database Migration Service (AWS DMS) to migrate databases from on-premises to the AWS Cloud. During the migration of one of the data...
AWS DMSreplication instance storagetroubleshootingresource management - Question #323Deployment and Migration
A company wants to implement a design that includes multiple AWS Regions to support disaster recovery for its application. The company currently has a static website that is hosted...
DynamoDB Global TablesCross-Region replicationDynamoDB StreamsDisaster Recovery - Question #324Management and Operations
A company provisioned a three-tier application by using AWS CloudFormation and an Amazon RDS DB instance. During a test, a database administrator accidentally deleted the CloudForm...
CloudFormation deletion policyRDS termination protectionAccidental deletion preventionResource protection - Question #325Deployment and Migration
A company that is located in the United States wants to expand its operations in Asia. The company's data in the us-west-2 Region is stored in an Amazon DynamoD8 table. The company...
DynamoDB Point-in-Time Recovery (PITR)Cross-Region data copyCost optimizationDevelopment environments - Question #326Management and Operations
A company uses multiple AWS accounts in AWS Organizations to separate development teams that work on different applications. Each AWS account contains multiple applications that ru...
AWS Resource Access Manager (RAM)Cross-account accessVPC sharingAurora PostgreSQL - Question #327Workload-Specific Database Design
A company hosts an online gaming application on AWS. A single Amazon DynamoDB table contains one item for each registered user. The partition key for each item is the user's ID. A...
DynamoDB Global Secondary Index (GSI)Query optimizationReportingDynamoDB performance - Question #328Workload-Specific Database Design
A company has an existing system that uses a single-instance Amazon DocumentDB (with MongoDB compatibility) cluster. Read requests account for 75% of the system queries. Write requ...
DocumentDB read replicasRead scalingMongoDB read preferencePerformance optimization - Question #329Database Security
A database specialist needs to enable IAM authentication on an existing Amazon Aurora PostgreSQL DB cluster. The database specialist already has modified the DB cluster settings, h...
Aurora PostgreSQL IAM authenticationTemporary authentication tokenIAM database access - Question #330Deployment and Migration
A database specialist is designing a disaster recovery (DR) strategy for a highly available application that is in development. The application uses an Amazon DynamoDB table as its...
DynamoDB Global TablesDisaster Recovery (DR)RTO/RPOCross-Region replication - Question #331Deployment and Migration
A company is using an Amazon RDS for MySQL DB instance for a production application. During the company's upcoming scheduled maintenance window, a database specialist will perform...
RDS major version upgradeRead replicasZero downtime deploymentRollback strategy - Question #332Deployment and Migration
A company uses an Amazon RDS for PostgreSQL database in the us-east-2 Region. The company wants to have a copy of the database available in the us-west-2 Region as part of a new di...
AWS DMS (Database Migration Service)PostgreSQL CDCLogical replicationwal_level - Question #333Management and Operations
A company has a 250 GB Amazon RDS Multi-AZ DB instance. The company's disaster recovery policy requires an RPO of 6 hours in a second AWS Region. Which solution will meet these req...
RDS SnapshotsAWS BackupCross-Region Disaster RecoveryRPOCost-effectiveness - Question #334Database Security
A database administrator is reviewing the deployment of an application that uses Amazon DynamoDB. A fleet of Amazon EC2 application instances accesses the database. The database ad...
DynamoDB VPC endpoint (Gateway)Private accessIAM policy conditionsNetwork security - Question #335Monitoring and Troubleshooting
A company recently created a snapshot of an Amazon RDS for PostgreSQL DB instance that hosts a production database. The company created a new DB instance from the snapshot to test...
PostgreSQL performance tuningVACUUM ANALYZERDS for PostgreSQLRead latency - Question #336Workload-Specific Database Design
A legal research company wants to build a recommendation engine on AWS that connects datasets to help lawyers create legal arguments. The recommendation engine will collect million...
Amazon NeptuneGraph databaseRecommendation engineUnstructured dataAmazon OpenSearch Service - Question #337Deployment and Migration
A database specialist needs to move a table from a database that is running on an Amazon Aurora PostgreSQL DB cluster into a new and distinct database cluster. The new table in the...
AWS DMS (Database Migration Service)LOB migrationInline LOB modeAurora PostgreSQL migration - Question #338Database Security
A company is using an Amazon Aurora PostgreSQL database for a project with a government agency. All database communications must be encrypted in transit. All non-SSL/TLS connection...
Aurora PostgreSQL encryption in transitSSL/TLS enforcementDB cluster parameter grouprds.force_ssl - Question #339Database Security
An ecommerce company is running Amazon RDS for Microsoft SQL Server. The company is planning to perform testing in a development environment with production data. The development e...
RDS snapshot sharingKMS encryptionCross-account accessIAM key policy - Question #340Workload-Specific Database Design
A news portal is looking for a data store to store 120 GB of metadata about its posts and comments. The posts and comments are not frequently looked up or updated. However, occasio...
DynamoDB Standard-IACost OptimizationDatabase SelectionAccess Patterns - Question #341Design Secure Architectures / Implement security controls for infrastructure-as-code deployments using CloudFormation stack policies to protect specific resources from unintended modifications.
A company is using AWS CloudFormation to provision and manage infrastructure resources, including a production database. During a recent CloudFormation stack update, a database spe...
AWS CloudFormationStack PoliciesInfrastructure ProtectionIAM Policy Syntax - Question #342Management and Operations
A company needs to deploy an Amazon Aurora PostgreSQL DB instance into multiple accounts. The company will initiate each DB instance from an existing Aurora PostgreSQL DB instance...
CloudFormation drift detectionConfiguration managementInfrastructure as CodeRepeatable deployments - Question #343Management and Operations
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. The company recently conducted tests on the database after busin...
RDS PostgreSQLlog retentionstorage managementzero-downtime - Question #344Deployment and Migration
A company runs an ecommerce application on premises on Microsoft SQL Server. The company is planning to migrate the application to the AWS Cloud. The application code contains comp...
SQL Server migrationRDS for SQL Servercode rewritemaintenance costs - Question #345Management and Operations
A company is running critical applications on AWS. Most of the application deployments use Amazon Aurora MySQL for the database stack. The company uses AWS CloudFormation to deploy...
CloudFormationstack policiesCI/CDresource protection - Question #346Monitoring and Troubleshooting
An online bookstore uses Amazon Aurora MySQL as its backend database. After the online bookstore added a popular book to the online catalog, customers began reporting intermittent...
Performance MonitoringDatabase DiagnosticsAurora MySQLAWS Performance Insights - Question #347Management and Operations
A company has a web application that uses Amazon API Gateway to route HTTPS requests to AWS Lambda functions. The application uses an Amazon Aurora MySQL database for its data stor...
Aurora MySQLconnection managementscalingcost-effectiveness - Question #348Database Security
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...
Redshiftaudit loggingsecurity audituser activity logging - Question #349Deployment and Migration
A company performs an audit on various data stores and discovers that an Amazon S3 bucket is storing a credit card number. The S3 bucket is the target of an AWS Database Migration...
AWS DMSdata migrationCDCtransformation rulessensitive data - Question #350Workload-Specific Database Design
A large financial services company uses Amazon ElastiCache for Redis for its new application that has a global user base. A database administrator must develop a caching solution t...
ElastiCache Redisglobal datastorecross-region replicationdisaster recovery