Quiz IT certification exam

Question 1

A database specialist is launching a test graph database using Amazon Neptune for the first time. The database specialist needs to insert millions of rows of test observations from a .csv file that is stored in Amazon S3. The database specialist has been using a series of API calls to upload the data to the Neptune DB instance.

Which combination of steps would allow the database specialist to upload the data faster? (Choose three.)

Become a Premium Member for full access

Unlock Premium Member

Accepted Answer

Ensure the vertices and edges are specified in different .csv files with proper header column formatting.

Accepted Answer

Ensure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket.

Accepted Answer

Create an S3 VPC endpoint and issue an HTTP POST to the database's loader endpoint.

Answer

Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.

Answer

Use AWS DMS to move data from Amazon S3 to the Neptune Loader.

Answer

Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.

Question 2

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 databases, and AWS Glue Data Catalog tables.Which combination of steps will meet these requirements with the MOST operational efficiency? (Choose three.)

Accepted Answer

Create external tables in the existing Redshift database to connect to the AWS Glue Data Catalog tables.

Accepted Answer

Use federated queries to access data in Amazon RDS.

Accepted Answer

Use data sharing to access data from the other Redshift clusters.

Answer

Take a snapshot of the required tables from the other Redshift clusters. Restore the snapshot into the existing Redshift cluster.

Answer

Unload the RDS tables and the tables from the other Redshift clusters into Amazon S3. Run COPY commands to load the tables into the existing Redshift cluster.

Answer

Use AWS Glue jobs to transfer the AWS Glue Data Catalog tables into Amazon S3. Create external tables in the existing Redshift database to access this data.

Question 3

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 business hours, and the tests generated additional database logs. As a result, free storage of the DB instance is low and is expected to be exhausted in 2 days.The company wants to recover the free storage that the additional logs consumed. The solution must not result in downtime for the database.Which solution will meet these requirements?

Accepted Answer

Modify the rds.log_retention_period parameter to 1440. Wait up to 24 hours for database logs to be deleted.

Answer

Modify the rds.log_retention_period parameter to 0. Reboot the DB instance to save the changes.

Answer

Modify the temp file_limit parameter to a smaller value to reclaim space on the DB instance.

Answer

Modify the rds.log_retention_period parameter to 1440. Reboot the DB instance to save the changes.

Question 4

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 complex T-SQL queries and stored procedures.The company wants to minimize database server maintenance and operating costs after the migration is completed. The company also wants to minimize the need to rewrite code as part of the migration effort.Which solution will meet these requirements?

Accepted Answer

Migrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.

Answer

Migrate the database to Amazon S3. Use Amazon Redshift Spectrum for query processing.

Answer

Migrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication.

Answer

Migrate the database to an Amazon EMR cluster that includes multiple primary nodes.

Question 5

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 the DB instances.The company's application team recently implemented a CI/CD pipeline. A database engineer needs to integrate the database deployment CloudFormation stack with the newly built CllCD platform. Updates to the CloudFormation stack must not update existing production database resources.Which CloudFormation stack policy action should the database engineer implement to meet these requirements?

Accepted Answer

Use a Deny statement for the Update:Replace action on the production database resources.

Answer

Use a Deny statement for the Update:Modify action on the production database resources.

Answer

Use a Deny statement for the action on the production database resources.

Answer

Use a Deny statement for the Update:Delete action on the production database resources.

Question 6

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.Which solution will meet these requirements in the MOST operationally efficient way?

Accepted Answer

Create a manual copy of the snapshot.

Answer

Export the contents of the snapshot to an Amazon S3 bucket.

Answer

Change the retention period of the snapshot to 45 days.

Answer

Create a native SQL Server backup. Save the backup to an Amazon S3 bucket.

Question 7

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 timeouts on the checkout page. A database specialist determined that increased load was causing locking contention on the database. The database specialist wants to automatically detect and diagnose database performance issues and to resolve bottlenecks faster.Which solution will meet these requirements?

Accepted Answer

Turn on Performance Insights for the Aurora MySQL database. Configure and turn on Amazon DevOps Guru for RDS.

Answer

Create a CPU usage alarm. Select the CPU utilization metric for the DB instance. Create an Amazon Simple Notification Service (Amazon SNS) topic to notify the database specialist when CPU utilization is over 75%.

Answer

Use the Amazon RDS query editor to get the process ID of the query that is causing the database to lock. Run a command to end the process.

Answer

Use the SELECT INTO OUTFILE S3 statement to query data from the database. Save the data directly to an Amazon S3 bucket. Use Amazon Athena to analyze the files for long-running queries.

Question 8

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 storage. The application has experienced unpredictable surges in traffic that overwhelm the database with too many connection requests. The company needs to implement a scalable solution that is more resilient to database failures as quickly as possible.Which solution will meet these requirements MOST cost-effectively?

Accepted Answer

Migrate the Aurora MySQL database to Amazon Aurora Serverless by restoring a snapshot. Change the endpoint in the Lambda functions to use the new database.

Answer

Migrate the Aurora MySQL database to Amazon DynamoDB tables by using AWS Database Migration Service (AWS DMS). Change the endpoint in the Lambda functions to use the new database.

Answer

Create an Amazon EventBridge rule that invokes a Lambda function. Code the function to iterate over all existing connections and to call MySQL queries to end any connections in the sleep state.

Answer

Increase the instance class for the Aurora database with more memory. Set a larger value for the max_connections parameter.

Question 9

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?

Accepted Answer

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

Answer

Set the parameter to true in the database parameter group.

Answer

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

Answer

Disable audit logging on the Redshift cluster.

Question 10

A company is using an Amazon Aurora PostgreSQL DB cluster for the backend of its mobile application. The application is running continuously and a database specialist is satisfied with high availability and fast failover, but is concerned about performance degradation after failover.How can the database specialist minimize the performance degradation after failover?

Accepted Answer

Enable cluster cache management for the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-0

Answer

Enable cluster cache management tor the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-1

Answer

Enable Query Plan Management for the Aurora DB cluster and perform a manual plan capture

Answer

Enable Query Plan Management for the Aurora DB cluster and force the query optimizer to use the desired plan

Question 11

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 Service (AWS DMS) continuous replication task that uses change data capture (CDC). The company determines that this field is not needed by anyone who uses the target dat a. The company has manually removed the existing credit card data from the S3 bucket.What is the MOST operationally efficient way to prevent new credit card data from being written to the S3 bucket?

Accepted Answer

Add a transformation rule to the DMS task to ignore the column from the source data endpoint.

Answer

Add a transformation rule to the DMS task to mask the column by using a simple SQL query.

Answer

Configure the target S3 bucket to use server-side encryption with AWS KMS keys (SSE-KMS).

Answer

Remove the credit card number column from the data source so that the DMS task does not need to be altered.

Question 12

A company migrated an on-premises Oracle database to Amazon RDS for Oracle. A database specialist needs to monitor the latency of the database.Which solution will meet this requirement with the LEAST operational overhead?

Accepted Answer

Enable RDS Performance Insights to visualize the database load. Enable Enhanced Monitoring to view how different threads use the CPU

Answer

Publish RDS Performance insights metrics to Amazon CloudWatch. Add AWS CloudTrail filters to monitor database performance

Answer

Install Oracle Statspack. Enable the performance statistics feature to collect, store, and display performance data to monitor database performance.

Answer

Create a new DB parameter group that includes the AllocatedStorage, DBInstanceClassMemory, and DBInstanceVCPU variables. Enable RDS Performance Insights

Question 13

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, has created IAM and database credentials, and has distributed the credentials to the appropriate users.What should the database specialist do next to establish the credentials for the users to use to log in to the DB cluster?

Accepted Answer

Run the generate-db-auth-token command with the user names to generate a temporary password for the users.

Answer

Add the users' IAM credentials to the Aurora cluster parameter group.

Answer

Add the users' IAM credentials to the default credential profile, Use the AWS Management Console to access the DB cluster.

Answer

Use an AWS Security Token Service (AWS STS) token by sending the IAM access key and secret key as headers to the DB cluster API endpoint.

Question 14

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 that will be available across AWS Regions and include low-latency replication and failover capabilities for disaster recovery (DR). The company's security team requires the encryption of cross-Region data transfers.Which solution meets these requirements with the LEAST amount of operational effort?

Accepted Answer

Create a global datastore in ElastiCache for Redis. Then create replica clusters in two other Regions. Promote one of the replica clusters as primary when DR is required.

Answer

Enable cluster mode in ElastiCache for Redis. Then create multiple clusters across Regions and replicate the cache data by using AWS Database Migration Service (AWS DMS). Promote a cluster in the failover Region to handle production traffic when DR is required.

Answer

Disable cluster mode in ElastiCache for Redis. Then create multiple replication groups across Regions and replicate the cache data by using AWS Database Migration Service (AWS DMS). Promote a replication group in the failover Region to primary when DR is required.

Answer

Create a snapshot of ElastiCache for Redis in the primary Region and copy it to the failover Region. Use the snapshot to restore the cluster from the failover Region when DR is required.

Question 15

A company uses an Amazon Redshift cluster to run its analytical workloads. Corporate policy requires that the company's data be encrypted at rest with customer managed keys. The company's disaster recovery plan requires that backups of the cluster be copied into another AWS Region on a regular basis.How should a database specialist automate the process of backing up the cluster data in compliance with these policies?

Accepted Answer

Create a new AWS Key Management Service (AWS KMS) customer managed key in the destination Region. Create a snapshot copy grant in the destination Region specifying the new key. In the source Region, configure cross-Region snapshots for the Amazon Redshift cluster specifying the destination Region, the snapshot copy grant, and retention periods for the snapshot.

Answer

Copy the AWS Key Management Service (AWS KMS) customer managed key from the source Region to the destination Region. Set up an AWS Glue job in the source Region to copy the latest snapshot of the Amazon Redshift cluster from the source Region to the destination Region. Use a time-based schedule in AWS Glue to run the job on a daily basis.

Answer

Copy the AWS Key Management Service (AWS KMS) customer-managed key from the source Region to the destination Region. Create Amazon S3 buckets in each Region using the keys from their respective Regions. Use Amazon EventBridge (Amazon CloudWatch Events) to schedule an AWS Lambda function in the source Region to copy the latest snapshot to the S3 bucket in that Region. Configure S3 Cross-Region Replication to copy the snapshots to the destination Region, specifying the source and destination KMS key IDs in the replication configuration.

Answer

Use the same customer-supplied key materials to create a CMK with the same private key in the destination Region. Configure cross-Region snapshots in the source Region targeting the destination Region. Specify the corresponding CMK in the destination Region to encrypt the snapshot.

Question 16

A coffee machine manufacturer is equipping all of its coffee machines with 10T sensors. The 10T core application is writing measurements for each record to Amazon Timestream. The records have multiple dimensions and measures. The measures include multiple measure names and values.An analysis application is running queries against the Timestream database and is focusing on data from the current week. A database specialist needs to optimize the query costs of the analysis application.Which solution will meet these requirements?

Accepted Answer

Use time range, measure name, and dimensions in the WHERE clause of the query.

Answer

Ensure that queries contain whole records over the relevant time range.

Answer

Avoid canceling any query after the query starts running.

Answer

Implement exponential backoff in the application.

Question 17

A database specialist needs to replace the encryption key for an Amazon RDS DB instance. The database specialist needs to take immediate action to ensure security of the database.Which solution will meet these requirements?

Accepted Answer

Create a manual snapshot of the DB instance. Restore the snapshot to a new DB instance. Specify a new encryption key during the restoration process.

Answer

Modify the DB instance to update the encryption key. Perform this update immediately without waiting for the next scheduled maintenance window.

Answer

Export the database to an Amazon S3 bucket. Import the data to an existing DB instance by using the export file. Specify a new encryption key during the import process.

Answer

Create a manual snapshot of the DB instance. Create an encrypted copy of the snapshot by using a new encryption key. Create a new DB instance from the encrypted snapshot.

Question 18

A gaming company is building a mobile game that will have as many as 25,000 active concurrent users in the first 2 weeks after launch. The game has a leaderboard that shows the 10 highest scoring players over the last 24 hours. The leaderboard calculations are processed by an AWS Lambda function, which takes about 10 seconds. The company wants the data on the leaderboard to be no more than 1 minute old.Which architecture will meet these requirements in the MOST operationally efficient way?

Accepted Answer

Deliver the player data to an Amazon Timestream database. Create an Amazon ElastiCache for Redis cluster. Configure the Lambda function to store the results in Redis. Create a scheduled event with Amazon EventBridge to invoke the Lambda function once every minute. Reconfigure the game server to query the Redis cluster for the leaderboard data.

Answer

Deliver the player data to an Amazon Timestream database. Create an Amazon DynamoDB table. Configure the Lambda function to store the results in DynamoDB. Create a scheduled event with Amazon EventBridge to invoke the Lambda function once every minute. Reconfigure the game server to query the DynamoDB table for the leaderboard data.

Answer

Deliver the player data to an Amazon Aurora MySQL database. Create an Amazon DynamoDB table. Configure the Lambda function to store the results in MySQL. Create a scheduled event with Amazon EventBridge to invoke the Lambda function once every minute. Reconfigure the game server to query the DynamoDB table for the leaderboard data.

Answer

Deliver the player data to an Amazon Neptune database. Create an Amazon ElastiCache for Redis cluster. Configure the Lambda function to store the results in Redis. Create a scheduled event with Amazon EventBridge to invoke the Lambda function once every minute. Reconfigure the game server to query the Redis cluster for the leaderboard data.

Question 19

A retail company uses Amazon Redshift for its 1 PB data warehouse. Several analytical workloads run on a Redshift cluster. The tables within the cluster have grown rapidly. End users are reporting poor performance of daily reports that run on the transaction fact tables.A database specialist must change the design of the tables to improve the reporting performance. All the changes must be applied dynamically. The changes must have the least possible impact on users and must optimize the overall table size.Which solution will meet these requirements?

Accepted Answer

Run an explain plan to analyze the queries on the tables. Consider recommendations from Amazon Redshift Advisor. Identify the columns that are used in filter and group by conditions. Create a deep copy of the table with the identified columns as sort keys and compression for all columns as Zstandard (ZSTD) by using a bulk insert. Drop the original table. Give the copy table the same name that the original table had.

Answer

Use the STL SCAN view to understand how the tables are getting scanned. Identify the columns that are used in filter and group by conditions. Create a temporary table with the identified columns as sort keys and compression as Zstandard (ZSTD) by copying the data from the original table. Drop the original table. Give the temporary table the same name that the original table had.

Answer

Run an explain plan to analyze the queries on the tables. Consider recommendations from Amazon Redshift Advisor. Identify the columns that are used in filter and group by conditions. Convert the recommended columns from Redshift Advisor into sort keys with compression encoding set to RAW. Set the rest of the column compression encoding to AZ64.

Answer

Run an explain plan to analyze the queries on the tables. Consider recommendations from Amazon Redshift Advisor. Identify the columns that are used in filter and group by conditions. Convert the recommended columns from Redshift Advisor into sort keys with compression encoding set to I_ZO. Set the rest of the column compression encoding to Zstandard (ZSTD).

Question 20

A company uses an Amazon Redshift cluster to run its analytical workloads. Corporate policy requires that the company's data be encrypted at rest with customer managed keys. The company's disaster recovery plan requires that backups of the cluster be copied into another AWS Region on a regular basis.How should a database specialist automate the process of backing up the cluster data in compliance with these policies?

Accepted Answer

Create a new AWS Key Management Service (AWS KMS) customer managed key in the destination Region. Create a snapshot copy grant in the destination Region specifying the new key. In the source Region, configure cross-Region snapshots for the Amazon Redshift cluster specifying the destination Region, the snapshot copy grant, and retention periods for the snapshot.

Answer

Copy the AWS Key Management Service (AWS KMS) customer managed key from the source Region to the destination Region. Set up an AWS Glue job in the source Region to copy the latest snapshot of the Amazon Redshift cluster from the source Region to the destination Region. Use a time-based schedule in AWS Glue to run the job on a daily basis.

Answer

Copy the AWS Key Management Service (AWS KMS) customer-managed key from the source Region to the destination Region. Create Amazon S3 buckets in each Region using the keys from their respective Regions. Use Amazon EventBridge (Amazon CloudWatch Events) to schedule an AWS Lambda function in the source Region to copy the latest snapshot to the S3 bucket in that Region. Configure S3 Cross-Region Replication to copy the snapshots to the destination Region, specifying the source and destination KMS key IDs in the replication configuration.

Answer

Use the same customer-supplied key materials to create a CMK with the same private key in the destination Region. Configure cross-Region snapshots in the source Region targeting the destination Region. Specify the corresponding CMK in the destination Region to encrypt the snapshot.

Question 21

A media company hosts a highly available news website on AWS but needs to improve its page load time, especially during very popular news releases. Once a news page is published, it is very unlikely to change unless an error is identified. The company has decided to use Amazon ElastiCache.What is the recommended strategy for this use case?

Accepted Answer

Use ElastiCache for Memcached with write-through and long time to live (TTL)

Answer

Use ElastiCache for Redis with lazy loading and short time to live (TTL)

Answer

Use ElastiCache for Memcached with lazy loading and short time to live (TTL)

Answer

Use ElastiCache for Redis with write-through and long time to live (TTL)

Question 22

A development team at an international gaming company is experimenting with Amazon DynamoDB to store in-game events for three mobile games. The most popular game hosts a maximum of 500,000 concurrent users, and the least popular game hosts a maximum of 10,000 concurrent users. The average size of an event is 20 KB, and the average user session produces one event each second. Each event is tagged with a time in milliseconds and a globally unique identifier.The lead developer created a single DynamoDB table for the events with the following schema:Partition key: game nameSort key: event identifierLocal secondary index: player identifierEvent timeThe tests were successful in a small-scale development environment. However, when deployed to production, new events stopped being added to the table and the logs show DynamoDB failures with the ItemCollectionSizeLimitExceededException error code.Which design change should a database specialist recommend to the development team?

Accepted Answer

Create one table for each game. Use the player identifier as the partition key. Use the event time as the sort key.

Answer

Use the player identifier as the partition key. Use the event time as the sort key. Add a global secondary index with the game name as the partition key and the event time as the sort key.

Answer

Create two tables. Use the game name as the partition key in both tables. Use the event time as the sort key for the first table. Use the player identifier as the sort key for the second table.

Answer

Replace the sort key with a compound value consisting of the player identifier collated with the event time, separated by a dash. Add a local secondary index with the player identifier as the sort key.

Question 23

A company has a reporting application that runs on an Amazon EC2 instance in an isolated developer account on AWS. The application needs to retrieve data during non-peak company hours from an Amazon Aurora PostgreSQL database that runs in the companys production account The companys security team requires that access to production resources complies with AWS best security practicesA database administrator needs to provide the reporting application with access to the production database. The company has already configured VPC peering between the production account and developer account The company has also updated the route tables in both accounts With the necessary entries to correctly set up VPC peeringWhat must the database administrator do to finish providing connectivity to the reporting application?

Accepted Answer

Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432. Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432.

Answer

Add an outbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432. Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432.

Answer

Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on all TCP ports. Add an inbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432_

Answer

Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432_ Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on all TCP ports

Question 24

A company has an application environment that deploys Amazon Aurora PostgreSQL databases as part of its CI/CD process that uses AWS CloudFormatlon. The company's database administrator has received reports of performance Issues from the resulting database but has no way to investigate the issues.Which combination of changes must the database administrator make to the database deployment to automate the collection of performance data? (Select TWO.)

Accepted Answer

Update the CloudFormatlon template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances.

Accepted Answer

Update the CloudFormatlon template to turn on Performance Insights for Aurora PostgreSQL.

Answer

Turn on Amazon DevOps Guru for the Aurora database resources in the CloudFormat10n template.

Answer

Turn on AWS CloudTraiI in each AWS account_

Answer

Turn on and contigure AWS Config tor all Aurora PostgreSQL databases.

Question 25

A database specialist needs to move an Amazon ROS DB instance from one AWS account to another AWS account.Which solution will meet this requirement with the LEAST operational effort?

Accepted Answer

Create a DB snapshot of the DB instance. Share the snapshot With the destination AWS account Create a new DB instance by restoring the snapshot in the destination AWS account

Answer

Use AWS Database Migration Service (AWS DMS) to migrate the DB instance from the source AWS account to the destination AWS account.

Answer

Create a Multi-AZ deployment tor the DB instance. Create a read replica tor the DB instance in the source AWS account. use the read replica to replicate the data into the DB instance in the destination AWS account

Answer

Use AWS DataSync to back up the DB instance in the source AWS account Use AWS Resource Access Manager (AWS RAM) to restore the backup in the destination AWS account.

Question 26

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 of write transactions. The database also needs to make data changes available in a near real-time data stream.Which solution will meet these requirements?

Accepted Answer

Amazon DynamoDB table with DynamoDB auto scaling

Answer

Amazon Aurora MySQL Multi-AZ DB cluster

Answer

Amazon Keyspaces (for Apache Cassandra)

Answer

Amazon DocumentDB (with MongoDB compatibility) cluster with a replica instance in a second Availability Zone

Question 27

A company has a hybrid environment in which a VPC connects to an on-premises network through an AWS Site-to-Site VPN connection. The VPC contains an application that is hosted on Amazon EC2 instances. The EC2 instances run in private subnets behind an Application Load Balancer (ALB) that is associated with multiple public subnets. The EC2 instances need to securely access an Amazon DynamoDB table.Which solution will meet these requirements?

Accepted Answer

Create a VPC endpoint for DynamoDB_ Assign the endpoint to the route table of the private subnets that contain the EC2 instances.

Answer

Use the internet gateway of the VPC to access the DynamoDB table. Use the ALB to route the traffic to the EC2 instances.

Answer

Add a NAT gateway in one of the public subnets of the VPC_ Configure the security groups of the EC2 instances to access the DynamoDB table through the NAT gateway

Answer

Use the Site-to-Site VPN connection to route all DynamoD8 network traffic through the on-premises network infrastructure to access the EC2 instances

Question 28

A web-based application uses Amazon DocumentDB (with MongoDB compatibility) as its underlying data store. Sufficient access control IS in place, but a database specialist wants to be able to review logs if the primary DocumentDB database is deletedWhich combination of steps Should the database specialist take to meet this requirement? (Select TWO_)

Accepted Answer

Set the audit_logs cluster parameter to enabled

Accepted Answer

Enable DocumentDB log export to Amazon CloudWatch Logs.

Answer

Enable Enhanced Monitoring tor DocumentDB.

Answer

Enable AWS CloudTrail for DocumentDB.

Answer

use AWS Config to monitor the state of DocumentDB.

Question 29

A company's application team needs to select an AWS managed database service to store application and user data. The application team is familiar with MySQL but is open to new solutions. The application and user data is stored in 10 tables and is de-normalized. The application will access this data through an API layer using an unique ID in each table. The company expects the traffic to be light at first, but the traffic Will Increase to thousands of transactions each second within the first year- The database service must support active reads and writes in multiple AWS Regions at the same time_ Query response times need to be less than 100 ms Which AWS database solution will meet these requirements?

Accepted Answer

Deploy an Amazon DynamoDB database with global tables

Answer

Deploy an Amazon RDS for MySQL environment in each Region and leverage AWS Database Migration Service (AWS DMS) to set up a multi-Region bidirectional replication

Answer

Deploy an Amazon Aurora MySOL global database with write forwarding turned on

Answer

Deploy an Amazon DocumentDB global cluster across multiple Regions.

Question 30

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 companys operations team notices that DynamoDB read and write requests are being throttled at different times, resulting in a negative customer experienceWhich solution will solve the throttling issue without requiring changes to the app?

Accepted Answer

use on-demand capacity mode tor the DynamoDB table.

Answer

Add a DynamoD3 table in a secondary AWS Region. Populate the additional table by using DynamoDB Streams.

Answer

Deploy an Amazon ElastiCache cluster in front of the DynamoDB table.

Answer

use DynamoDB Accelerator (DAX).

Question 31

A social media company recently launched a new feature that gives users the ability to share live feeds of their daily activities with their followers. The company has an Amazon RDS forMySOL DB instance that stores data about follower engagementAfter the new feature launched, the company noticed high CPU utilization and high database latency during reads and writes. The company wants to implement a solution that will identify the source of the high CPU utilization.Which solution will meet these requirements with the LEAST administrative oversight?

Accepted Answer

Use Amazon DevOps Guru insights_

Answer

Use AWS CloudTrail

Answer

Use Amazon CloudWatch Logs

Answer

Use Amazon Aurora Database Activity Streams

Question 32

A financial company is hosting its web application on AWS. The application's database is hosted on Amazon RDS for MySQL with automated backups enabled.The application has caused a logical corruption of the database, which is causing the application to become unresponsive. The specific time of the corruption has been identified, and it was within the backup retention period.How should a database specialist recover the database to the most recent point before corruption?

Accepted Answer

Use 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.

Answer

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

Answer

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

Answer

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

Question 33

A financial services company is using AWS Database Migration Service (AWS OMS) to migrate Its databases from on-premises to AWS. A database administrator is working on replicating a database to AWS from on-premises using full load and change data capture (CDC). During the CDC replication, the database administrator observed that the target latency was high and slowly increasing-What could be the root causes for this high target latency? (Select TWO.)

Accepted Answer

There was no primary key or index in the target database.

Accepted Answer

There were resource bottlenecks in the replication instance

Answer

There was ongoing maintenance on the replication instance

Answer

The source endpoint was changed by modifyng the task

Answer

Loopback changes had affected the source and target instances-

Question 34

A marketing company is developing an application to track responses to email message campaigns. The company needs a database storage solution that is optimized to work with highly connected data. The database needs to limit connections and programmatic access to the data by using IAM policies.Which solution will meet these requirements?

Accepted Answer

Amazon Neptune DB cluster

Answer

Amazon ElastiCache for Redis cluster

Answer

Amazon Aurora MySQL DB cluster

Answer

Amazon DynamoDB table

Question 35

A database specialist needs to reduce the cost of an application's database. The database is running on a Multi-AZ deployment of an Amazon ROS for Microsoft SQL Server DB instance. The application requires the database to support stored procedures, SQL Server Wire Protocol (TDS), and T-SQC The database must also be highly available. The database specialist is using AWS Database Migration Service (AWS DMS) to migrate the database to a new data store.Which solution will reduce the cost of the database with the LEAST effort?

Accepted Answer

Use AWS Database Migration Service (DMS) to migrate the database to Amazon Aurora PostgreSOL_ Turn on Babelfish for Aurora PostgreSOL_ Update the application to use the Babelfish TDS port.

Answer

Use AWS Database Migration Service (DMS) to migrate to an RDS for MySQL Multi-AZ database. Update the application code to use the features of MySQL that correspond to SQL Server. Update the application to use the MySQL port.

Answer

use AWS Database Migration Serve (OMS) to migrate to an RDS for PostgreSQL Multi-AZ database. Turn on the SQL_COMPAT optional extension within the database to allow the required features. Update the application to use the PostgreSQL port

Answer

Use AWS Database Migration Service (OMS) to migrate to an RDS for SQL Server Single-AZ database. Update the application to use the new database endpoint

Question 36

A company uses a large, growing, and high performance on-premises Microsoft SQL Server instance With an Always On availability group cluster size of 120 TIE. The company uses a third-party backup product that requires system-level access to the databases. The company will continue to use this third-party backup product in the future.The company wants to move the DB cluster to AWS with the least possible downtime and data loss. The company needs a 2 Gbps connection to sustain Always On asynchronous data replication between the company's data center and AWS.Which combination of actions should a database specialist take to meet these requirements? (Select THREE.)

Accepted Answer

Establish an AWS Direct Connect hosted connection between the companfs data center and AWS

Accepted Answer

Deploy a new SQL Server Always On availability group DB cluster on Amazon EC2 Configure Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster_ Fail over to the AWS DB cluster when it is time to migrate.

Accepted Answer

Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2.

Answer

Create an AWS Site-to-Site VPN connection between the companVs data center and AWS over the internet

Answer

Use AWS Database Migration Service (AWS DMS) to migrate the on-premises SQL Server databases to Amazon RDS for SQL Server Configure Always On availability groups for SQL Server.

Answer

Grant system-level access to the third-party backup product to perform backups of the Amazon RDS for SQL Server DB instance.

Question 37

A manufacturing company stores its inventory details in an Amazon DynamoDB table in the us-east-2 Region. According to new compliance and regulatory policies, the company is required to back up all of its tables nightly and store these backups in the us-west-2 Region for disaster recovery for 1 yearWhich solution MOST cost-effectively meets these requirements?

Accepted Answer

Use AWS Backup to create a backup plan. Configure cross-Region replication in the plan and assign the DynamoDB table to this plan

Answer

Convert the existing DynamoDB table into a global table and create a global table replica in the us-west-2 Region.

Answer

Create an on-demand backup of the DynamoDB table and restore this backup in the us-west-2 Region.

Answer

Enable Amazon S3 Cross-Region Replication (CRR) on the S3 bucket where DynamoDB on-demand backups are stored.

Question 38

A company has more than 100 AWS accounts that need Amazon RDS instances. The company wants to build an automated solution to deploy the RDS instances with specific compliance parameters. The data does not need to be replicated. The company needs to create the databases within 1 dayWhich solution will meet these requirements in the MOST operationally efficient way?

Accepted Answer

Create RDS resources by using AWS CloudFormation. Share the CloudFormation template with each account.

Answer

Create an RDS snapshot. Share the snapshot With each account Deploy the snapshot into each account

Answer

use AWS CloudFormation to create RDS instances in each account. Run AWS Database Migration Service (AWS DMS) replication to each ot the created instances.

Answer

Create a script by using the AWS CLI to copy the ROS instance into the other accounts from a template account.

Question 39

A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available. Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.What might account for this? (Choose two.)

Accepted Answer

The new minor version has not yet been designated as preferred and requires a manual upgrade.

Accepted Answer

The AWS CLI command did not include an apply-immediately parameter.

Answer

Configuring automatic upgrades using the AWS CLI is not supported. This must be enabled expressly using the AWS Management Console.

Answer

Applying minor version upgrades requires sufficient free space.

Answer

Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.

Question 40

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 requests are expected to increase by 50% after an upcoming global release. A database specialist needs to design a solution that improves the overall database performance without creating additional application overhead.Which solution will meet these requirements?

Accepted Answer

Add one read replica instance. Set the read preference to secondary preferred.

Answer

Recreate the cluster with a shared cluster volume. Add two instances to serve both read requests and write requests.

Answer

Add one read replica instance. Activate a shared cluster volume. Route all read queries to the read replica instance.

Answer

Add one read replica instance. Update the application to route all read queries to the read replica instance.

Amazon DBS-C01 Practice Test 8

Amazon DBS-C01 Practice Tests

Amazon DBS-C01 Practice Test 8

Question

Amazon DBS-C01 Practice Tests

Practice Tests