Quiz IT certification exam

Question 1

A company is running its customer feedback application on Amazon Aurora MySQL. The company runs a report every day to extract customer feedback, and a team reads the feedback to determine if the customer comments are positive or negative. It sometimes takes days before the company can contact unhappy customers and take corrective measures. The company wants to use machine learning to automate this workflow.

Which solution meets this requirement with the LEAST amount of effort?

Become a Premium Member for full access

Unlock Premium Member

Accepted Answer

Set up Aurora native integration with Amazon Comprehend. Use SQL functions to extract sentiment analysis.

Answer

Export the Aurora MySQL database to Amazon S3 by using AWS Database Migration Service (AWS DMS). Use Amazon Comprehend to run sentiment analysis on the exported files.

Answer

Export the Aurora MySQL database to Amazon S3 by using AWS Database Migration Service (AWS DMS). Use Amazon SageMaker to run sentiment analysis on the exported files.

Answer

Set up Aurora native integration with Amazon SageMaker. Use SQL functions to extract sentiment analysis.

Question 2

Recently, a financial institution created a portfolio management service. The application's backend is powered by Amazon Aurora, which supports MySQL.The firm demands a response time of five minutes and a response time of five minutes. A database professional must create a disaster recovery system that is both efficient and has a low replication latency.How should the database professional tackle these requirements?

Accepted Answer

Configure an Amazon Aurora global database and add a different AWS Region.

Answer

Configure AWS Database Migration Service (AWS DMS) and create a replica in a different AWS Region.

Answer

Configure a binlog and create a replica in a different AWS Region.

Answer

Configure a cross-Region read replica.

Question 3

For the first time, a database professional is establishing a test graph database on Amazon Neptune. Thedatabase expert must input millions of rows of test observations from an Amazon S3.csv file. Thedatabase professional uploaded the data to the Neptune DB instance through a series of API calls.Which sequence of actions enables the database professional to upload the data most quickly? (Select three.)

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 4

A financial services company has an application deployed on AWS that uses an Amazon Aurora PostgreSQL DB cluster. A recent audit showed that no log files contained database administrator activity. A database specialist needs to recommend a solution to provide database access and activity logs. The solution should use the least amount of effort and have a minimal impact on performance.Which solution should the database specialist recommend?

Accepted Answer

Enable Aurora Database Activity Streams on the database in asynchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Firehose destination to an Amazon S3 bucket.

Answer

Enable Aurora Database Activity Streams on the database in synchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Kinesis Data Firehose destination to an Amazon S3 bucket.

Answer

Create an AWS CloudTrail trail in the Region where the database runs. Associate the database activity logs with the trail.

Answer

Allow connections to the DB cluster through a bastion host only. Restrict database access to the bastion host and application servers. Push the bastion host logs to Amazon CloudWatch Logs using the CloudWatch Logs agent.

Question 5

A corporation is transitioning from an IBM Informix database to an Amazon RDS for SQL Server Multi- AZ implementation with Always On Availability Groups (AGs). SQL Server Agent tasks are scheduled to execute at 5-minute intervals on the Always On AG listener to synchronize data between the Informix and SQL Server databases. After a successful failover to the backup node with minimum delay, users endure hours of stale data.How can a database professional guarantee that consumers view the most current data after a failover?

Accepted Answer

Create the SQL Server Agent jobs on the secondary node from a script when the secondary node takes over after a failure.

Answer

Set TTL to less than 30 seconds for cached DNS values on the Always On AG listener.

Answer

Break up large transactions into multiple smaller transactions that complete in less than 5 minutes.

Answer

Set the databases on the secondary node to read-only mode.

Question 6

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?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 7

A financial institution uses AWS to host its online application. Amazon RDS for MySQL is used to host the application's database, which includes automatic backups.The program has corrupted the database logically, resulting in the application being unresponsive.The exact moment the corruption occurred has been determined, and it occurred within the backup retention period.How should a database professional restore a database to its previous state prior to 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 8

An worldwide gaming company's development team is experimenting with using Amazon DynamoDB to store in-game events for three mobile titles. Maximum concurrent users for the most popular game is 500,000, while the least popular game is 10,000. The typical event is 20 KB in size, while the average user session generates one event each second. Each event is assigned a millisecond time stamp and a globally unique identification.The lead developer generated a single DynamoDB database with the following structure for the events:Partition key: game name Sort key: event identifier Local secondary index: player identifier Event time In a small-scale development setting, the tests were successful. When the application was deployed to production, however, new events were not being added to the database, and the logs indicated DynamoDB failures with the ItemCollectionSizeLimitExceededException issue code.Which design modification should a database professional offer 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 9

A business's mission-critical production workload is being operated on a 500 GB Amazon Aurora MySQL DB cluster. A database engineer must migrate the workload without causing data loss to a new Amazon Aurora Serverless MySQL DB cluster.Which approach will result in the LEAST amount of downtime and the LEAST amount of application impact?

Accepted Answer

Replicate the data between the existing DB cluster and a new Aurora Serverless DB cluster by using AWS Database Migration Service (AWS DMS) with change data capture (CDC) enabled.

Answer

Modify the existing DB cluster and update the Aurora configuration to Serverless.

Answer

Create a snapshot of the existing DB cluster and restore it to a new Aurora Serverless DB cluster.

Answer

Create an Aurora Serverless replica from the existing DB cluster and promote it to primary when the replica lag is minimal.

Question 10

A database professional is developing an application that will respond to single-instance requests.The program will query large amounts of client data and offer end users with results.These reports may include a variety of fields. The database specialist want to enable users to query the database using any of the fields offered.During peak periods, the database's traffic volume will be significant yet changeable. However, the database will see little activity over the rest of the day.Which approach will be the most cost-effective in meeting these requirements?

Accepted Answer

Amazon Aurora in a serverless mode

Answer

Amazon DynamoDB with provisioned capacity mode and auto scaling

Answer

Amazon DynamoDB with on-demand capacity mode

Answer

Amazon Aurora with auto scaling enabled

Question 11

A huge gaming firm is developing a centralized method for storing the status of various online games' user sessions. The workload requires low-latency key-value storage and will consist of an equal number of reads and writes. Across the games' geographically dispersed user base, data should be written to the AWS Region nearest to the user. The design should reduce the burden associated with managing data replication across Regions.Which solution satisfies these criteria?

Accepted Answer

Amazon DynamoDB global tables

Answer

Amazon RDS for MySQL with multi-Region read replicas

Answer

Amazon Aurora global database

Answer

Amazon RDS for Oracle with GoldenGate

Question 12

A business's production databases are housed on a 3 TB Amazon Aurora MySQL DB cluster. The database cluster is installed in the region us-east-1. For disaster recovery (DR) requirements, the company's database expert needs to fast deploy the DB cluster in another AWS Region to handle the production load with an RTO of less than two hours.Which approach is the MOST OPERATIONALLY EFFECTIVE in meeting these requirements?

Accepted Answer

Add a cross-Region read replica in the DR Region with the same instance type as the current primary instance. If the read replica in the DR Region needs to be used for production, promote the read replica to become a standalone DB cluster.

Answer

Implement an AWS Lambda function to take a snapshot of the production DB cluster every 2 hours, and copy that snapshot to an Amazon S3 bucket in the DR Region. Restore the snapshot to an appropriately sized DB cluster in the DR Region.

Answer

Create a smaller DB cluster in the DR Region. Configure an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) enabled to replicate data from the current production DB cluster to the DB cluster in the DR Region.

Answer

Create an Aurora global database that spans two Regions. Use AWS Database Migration Service (AWS DMS) to migrate the existing database to the new global database.

Question 13

A business's production database is hosted on a single-node Amazon RDS for MySQL DB instance. The database instance is hosted in a United States AWS Region.A week before a significant sales event, a fresh database maintenance update is released. The maintenance update has been designated as necessary. The firm want to minimize the database instance's downtime and requests that a database expert make the database instance highly accessible until the sales event concludes.Which solution will satisfy these criteria?

Accepted Answer

Convert the DB instance into a Multi-AZ deployment. Apply the maintenance update.

Answer

Defer the maintenance update until the sales event is over.

Answer

Create a read replica with the latest update. Initiate a failover before the sales event.

Answer

Create a read replica with the latest update. Transfer all read-only traffic to the read replica during the sales event.

Question 14

A corporation intends to migrate a 500-GB Oracle database to Amazon Aurora PostgreSQL utilizing the AWS Schema Conversion Tool (AWS SCT) and AWS Data Management Service (AWS DMS). The database does not have any stored procedures, but does contain several huge or partitioned tables.Because the program is vital to the company, it is preferable to migrate with little downtime.Which measures should a database professional perform in combination to expedite the transfer process? (Select three.)

Accepted Answer

For the large tables, create a table settings rule with a parallel load option in AWS DMS, then perform a full load using DMS.

Accepted Answer

Use AWS DMS to set up change data capture (CDC) for continuous replication until the cutover date.

Accepted Answer

Use AWS SCT to convert the schema from Oracle to Aurora PostgreSQL.

Answer

Use the AWS SCT data extraction agent to migrate the schema from Oracle to Aurora PostgreSQL.

Answer

For the large tables, change the setting for the maximum number of tables to load in parallel and perform a full load using AWS DMS.

Answer

Use AWS DMS to convert the schema from Oracle to Aurora PostgreSQL and for continuous replication.

Question 15

A business need a data warehouse system that stores data consistently and in a highly organized fashion. The organization demands rapid response times for end-user inquiries including current-year data, and users must have access to the whole 15-year dataset when necessary. Additionally, this solution must be able to manage a variable volume of incoming inquiries. Costs associated with storing the 100 TB of data must be maintained to a minimum.Which solution satisfies these criteria?

Accepted Answer

Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling.

Answer

Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storage. Provision enough instances to support high demand.

Answer

Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Provision enough instances to support high demand.

Answer

Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Leverage Amazon Redshift elastic resize.

Question 16

A business is transferring its on-premises database workloads to the Amazon Web Services (AWS) Cloud. A database professional migrating an Oracle database with a huge table to Amazon RDS has picked AWS DMS. The database professional observes that AWS DMS is consuming considerable time migrating the data.Which activities would increase the pace of data migration? (Select three.)

Accepted Answer

Create multiple AWS DMS tasks to migrate the large table.

Accepted Answer

Increase the capacity of the AWS DMS replication server.

Accepted Answer

Establish an AWS Direct Connect connection between the on-premises data center and AWS.

Answer

Configure the AWS DMS replication instance with Multi-AZ.

Answer

Enable an Amazon RDS Multi-AZ configuration.

Answer

Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.

Question 17

An internet advertising firm stores its data in an Amazon DynamoDb table. Amazon DynamoDB Streams are enabled on the table, and one of the keys has a global secondary index. The table is encrypted using a customer-managed AWS Key Management Service (AWS KMS) key.The firm has chosen to grow worldwide and want to duplicate the database using DynamoDB global tables in a new AWS Region.An administrator observes the following upon review:No role with the dynamodb: CreateGlobalTable permission exists in the account.An empty table with the same name exists in the new Region where replication is desired.A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.Which settings will prevent you from creating a global table or replica in the new Region? (Select two.)

Accepted Answer

A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.

Accepted Answer

An empty table with the same name exists in the Region where replication is desired.

Answer

No role with the dynamodb:CreateGlobalTable permission exists in the account.

Answer

DynamoDB Streams is enabled for the table.

Answer

The table is encrypted using a KMS customer managed key.

Question 18

In North America, a business launched a mobile game that swiftly expanded to 10 million daily active players. The game's backend is hosted on AWS and makes considerable use of a TTL-configured Amazon DynamoDB table.When an item is added or changed, its TTL is set to 600 seconds plus the current epoch time. The game logic is reliant on the purging of outdated data in order to compute rewards points properly. At times, items from the table are read that are many hours beyond their TTL expiration.How should a database administrator resolve this issue?

Accepted Answer

Include a query filter expression to ignore items with an expired TTL.

Answer

Use a client library that supports the TTL functionality for DynamoDB.

Answer

Set the ConsistentRead parameter to true when querying the table.

Answer

Create a local secondary index on the TTL attribute.

Question 19

On a single Amazon RDS DB instance, a business hosts a MySQL database for its ecommerce application. Automatically saving application purchases to the database results in high-volume writes. Employees routinely create purchase reports for the company. The organization wants to boost database performance and minimize downtime associated with upgrade patching.Which technique will satisfy these criteria with the LEAST amount of operational overhead?

Accepted Answer

Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and add a read replica.

Answer

Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and enable Memcached in the MySQL option group.

Answer

Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and set up replication to a MySQL DB instance running on Amazon EC2.

Answer

Add a read replica and promote it to an Amazon Aurora MySQL DB cluster master. Then enable Amazon Aurora Serverless.

Question 20

A worldwide digital advertising corporation collects browser information in order to provide targeted visitors with contextually relevant pictures, websites, and connections. A single page load may create many events, each of which must be kept separately. A single event may have a maximum size of 200 KB and an average size of 10 KB. Each page load requires a query of the user's browsing history in order to deliver suggestions for targeted advertising. The advertising corporation anticipates daily page views of more than 1 billion from people in the United States, Europe, Hong Kong, and Indi a. The information structure differs according to the event. Additionally, browsing information must be written and read with a very low latency to guarantee that consumers have a positive viewing experience.Which database solution satisfies these criteria?

Accepted Answer

Amazon DynamoDB global table

Answer

Amazon DocumentDB

Answer

Amazon RDS Multi-AZ deployment

Answer

Amazon Aurora Global Database

Question 21

Recently, an ecommerce business transferred one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition database instance. The corporation anticipates an increase in read traffic as a result of an approaching sale. To accommodate the projected read load, a database professional must establish a read replica of the database instance.Which procedures should the database professional do prior to establishing the read replica? (Select two.)

Accepted Answer

Ensure that automatic backups are enabled for the source DB instance.

Accepted Answer

Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.

Answer

Identify a potential downtime window and stop the application calls to the source DB instance.

Answer

Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).

Answer

Modify the read replica parameter group setting and set the value to 1.

Question 22

AWS CloudFormation stack including an Amazon RDS database instance was mistakenly removed, resulting in the loss of recent dat a. A Database Specialist must apply RDS parameters to the CloudFormation template in order to minimize the possibility of future inadvertent instance data loss.Which settings will satisfy this criterion? (Select three.)

Accepted Answer

Set DeletionProtection to True

Accepted Answer

Set DeleteAutomatedBackups to False

Accepted Answer

Set DeletionPolicy to Retain

Answer

Set MultiAZ to True

Answer

Set TerminationProtection to True

Answer

Set DeletionPolicy to Delete

Question 23

On AWS, a business is developing a web application. The application needs that the database supports concurrent read and write activities in several AWS Regions. Additionally, the database must communicate data changes across Regions as they occur. The application must be highly available and have a latency of less than a few hundred milliseconds.Which solution satisfies these criteria?

Accepted Answer

Amazon DynamoDB global tables

Answer

Amazon DynamoDB streams with AWS Lambda to replicate the data

Answer

An Amazon ElastiCache for Redis cluster with cluster mode enabled and multiple shards

Answer

An Amazon Aurora global database

Question 24

A business uses Amazon EC2 instances in VPC A to serve an internal file-sharing application. This application is supported by an Amazon ElastiCache cluster in VPC B that is peering with VPC

Accepted Answer

Modify the ElastiCache security group by adding outbound rules that allow traffic to VPC CIDR blocks from the ElastiCache cluster.

Answer

The corporation migrates the instances of its applications from VPC A to VPC B. The file-sharing application is no longer able to connect to the ElastiCache cluster, as shown by the logs. What is the best course of action for a database professional to take in order to remedy this issue?

Answer

Create a second security group on the EC2 instances. Add an outbound rule to allow traffic from the ElastiCache cluster security group.

Answer

Delete the ElastiCache security group. Add an interface VPC endpoint to enable the EC2 instances to connect to the ElastiCache cluster.

Answer

Modify the ElastiCache security group by adding an inbound rule that allows traffic from the EC2 instances security group to the ElastiCache cluster.

Question 25

A ride-hailing application stores bookings in a persistent Amazon RDS for MySQL DB instance. This program is very popular, and the corporation anticipates a tenfold rise in the application's user base over the next several months. The application receives a higher volume of traffic in the morning and evening.This application is divided into two sections:✑ An internal booking component that takes online reservations in response to concurrent user queries.✑ A component of a third-party customer relationship management (CRM) system that customer service professionals utilize. Booking data is accessed using queries in the CRM.To manage this workload effectively, a database professional must create a cost-effective database system.Which solution satisfies these criteria?

Accepted Answer

Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.

Answer

Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.

Answer

Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.

Answer

Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.

Question 26

Amazon Neptune is being used by a corporation as the graph database for one of its products. During an ETL procedure, the company's data science team produced enormous volumes of temporary data by unintentionally. The Neptune DB cluster extended its storage capacity automatically to handle the added data, but the data science team erased the superfluous data.What should a database professional do to prevent incurring extra expenditures for cluster volume space that is not being used?

Accepted Answer

Export the cluster data into a new Neptune DB cluster.

Answer

Take a snapshot of the cluster volume. Restore the snapshot in another cluster with a smaller volume size.

Answer

Use the AWS CLI to turn on automatic resizing of the cluster volume.

Answer

Add a Neptune read replica to the cluster. Promote this replica as a new primary DB instance. Reset the storage space of the cluster.

Question 27

A bank intends to utilize Amazon RDS to host a MySQL database instance. The database should be able to handle high-volume read requests with extremely few repeated queries.Which solution satisfies these criteria?

Accepted Answer

Create a read replica of the DB instance. Use the read replica to distribute the read traffic.

Answer

Create an Amazon ElastiCache cluster. Use a write-through strategy to populate the cache.

Answer

Create an Amazon ElastiCache cluster. Use a lazy loading strategy to populate the cache.

Answer

Change the DB instance to Multi-AZ with a standby instance in another AWS Region.

Question 28

A database specialist is constructing an AWS CloudFormation stack using AWS CloudFormation. The database expert wishes to avoid the stack's Amazon RDS ProductionDatabase resource being accidentally deleted.Which solution will satisfy this criterion?

Accepted Answer

Create a stack policy to prevent updates. Include Effect, Deny, and Resource :ProductionDatabase in the policy.

Answer

Create a stack policy to prevent updates. Include “Effect” : “ProductionDatabase” and “Resource” : “Deny” in the policy.

Answer

Create an AWS CloudFormation stack in XML format. Set xAttribute as false.

Answer

Create an RDS DB instance without the DeletionPolicy attribute. Disable termination protection.

Question 29

Amazon DynamoDB global tables are being used by a business to power an online gaming game. The game is played by gamers from all around the globe. As the game became popularity, the amount of queries to DynamoDB substantially rose. Recently, gamers have complained about the game's condition being inconsistent between nations. A database professional notices that the ReplicationLatency metric for many replica tables is set to an abnormally high value.Which strategy will resolve the issue?

Accepted Answer

Configure all replica tables to use DynamoDB auto scaling.

Answer

Configure a DynamoDB Accelerator (DAX) cluster on each of the replicas.

Answer

Configure the primary table to use DynamoDB auto scaling and the replica tables to use manually provisioned capacity.

Answer

Configure the table-level write throughput limit service quota to a higher value.

Question 30

Recently, a gaming firm purchased a popular iOS game that is especially popular during the Christmas season. The business has opted to include a leaderboard into the game, which will be powered by Amazon DynamoDB. The application's load is likely to increase significantly throughout the Christmas season.Which solution satisfies these criteria at the lowest possible cost?

Accepted Answer

DynamoDB with provisioned capacity mode with Auto Scaling

Answer

DynamoDB Streams

Answer

DynamoDB with DynamoDB Accelerator

Answer

DynamoDB with on-demand capacity mode

Question 31

An online advertising website uses an Amazon DynamoDB table with on-demand capacity mode as its data store. The website also has a DynamoDB Accelerator (DAX) cluster in the same VPC as its web application server. The application needs to perform infrequent writes and many strongly consistent reads from the data store by querying the DAX cluster.During a performance audit, a systems administrator notices that the application can look up items by using the DAX cluster. However, the QueryCacheHits metric for the DAX cluster consistently shows 0 while the QueryCacheMisses metric continuously keeps growing in Amazon CloudWatch.What is the MOST likely reason for this occurrence?

Accepted Answer

Strongly consistent reads are always passed through DAX to DynamoDB.

Answer

A VPC endpoint was not added to access DynamoDB.

Answer

DynamoDB is scaling due to a burst in traffic, resulting in degraded performance.

Answer

A VPC endpoint was not added to access CloudWatch.

Question 32

A business that specializes in internet advertising is developing an application that will show adverts to its customers. The program stores data in an Amazon DynamoDB database. Additionally, the application caches its reads using a DynamoDB Accelerator (DAX) cluster. The majority of reads come via the GetItem and BatchGetItem queries. The application does not need consistency of readings.The application cache does not behave as intended after deployment. Specific extremely consistent queries to the DAX cluster are responding in several milliseconds rather than microseconds.How can the business optimize cache behavior in order to boost application performance?

Accepted Answer

Use eventually consistent reads instead of strongly consistent reads.

Answer

Increase the size of the DAX cluster.

Answer

Configure DAX to be an item cache with no query cache

Answer

Create a new DAX cluster with a higher TTL for the item cache.

Question 33

A database professional is tasked with the task of migrating 25 GB of data files from an on-premises storage system to an Amazon Neptune database.Which method of data loading is the FASTEST?

Accepted Answer

Upload the data to Amazon S3 and use the Loader command to load the data from Amazon S3 into the Neptune database.

Answer

Write a utility to read the data from the on-premises storage and run INSERT statements in a loop to load the data into the Neptune database.

Answer

Use the AWS CLI to load the data directly from the on-premises storage into the Neptune database.

Answer

Use AWS DataSync to load the data directly from the on-premises storage into the Neptune database.

Question 34

A single MySQL database was moved to Amazon Aurora by a business. The production data is stored in a database cluster in VPC PROD, whereas 12 testing environments are hosted in VPC TEST with the same AWS account. Testing has a negligible effect on the test dat a. The development team requires that each environment be updated nightly to ensure that each test database has daily production data.Which migration strategy will be the quickest and least expensive to implement?

Accepted Answer

Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.

Answer

Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.

Answer

Run the master in Amazon Aurora MySQL. Create 12 Aurora Replicas in VPC_TEST, and script the replicas to be deleted and re-created nightly.

Answer

Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.

Question 35

A business just transitioned from an on-premises Oracle database to Amazon Aurora PostgreSQL.Following the move, the organization observed that every day around 3:00 PM, the application's response time is substantially slower. The firm has determined that the problem is with the database, not the application.Which set of procedures should the Database Specialist do to locate the erroneous PostgreSQL query most efficiently?

Accepted Answer

Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify any queries that are related to spikes in the graph during the next slow period.

Answer

Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumption. Watch these dashboards during the next slow period.

Answer

Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring tool that will run reports based on the output error logs.

Answer

Modify the logging database parameter to log all the queries related to locking in the database and then check the logs after the next slow period for this information.

Question 36

A Database Specialist is constructing a new Amazon Neptune DB cluster and tries to load data from Amazon S3 using the Neptune bulk loader API. The Database Specialist is confronted with the following error message:€Unable to establish a connection to the s3 endpoint. The source URL is s3:/mybucket/graphdata/ and the region code is us-east-1. Kindly confirm your Configuration S3.Which of the following activities should the Database Specialist take to resolve the issue? (Select two.)

Accepted Answer

Check that an Amazon S3 VPC endpoint exists

Accepted Answer

Check that Neptune has an IAM role granting read access to Amazon S3

Answer

Check that Amazon S3 has an IAM role granting read access to Neptune

Answer

Check that a Neptune VPC endpoint exists

Answer

Check that Amazon EC2 has an IAM role granting read access to Amazon S3

Question 37

A database specialist has been entrusted by an ecommerce firm with designing a reporting dashboard that visualizes crucial business KPIs derived from the company's primary production database running on Amazon Auror a. The dashboard should be able to read data within 100 milliseconds after an update.The Database Specialist must conduct an audit of the Aurora DB cluster's present setup and provide a cost-effective alternative. The solution must support the unexpected read demand generated by the reporting dashboard without impairing the DB cluster's write availability and performance.Which solution satisfies these criteria?

Accepted Answer

Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.

Answer

Turn on the serverless option in the DB cluster so it can automatically scale based on demand.

Answer

Provision a clone of the existing DB cluster for the new Application team.

Answer

Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).

Question 38

A corporation wishes to move a 1 TB Oracle database from its current location to an Amazon Aurora PostgreSQL DB cluster. The database specialist at the firm noticed that the Oracle database stores 100 GB of large binary objects (LOBs) across many tables. The Oracle database supports LOBs up to 500 MB in size and an average of 350 MB. AWS DMS was picked by the Database Specialist to transfer the data with the most replication instances.How should the database specialist improve the transfer of the database to AWS DMS?

Accepted Answer

Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs

Answer

Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together

Answer

Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs

Answer

Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together

Question 39

The website of a manufacturing firm makes use of an Amazon Aurora PostgreSQL database cluster.Which settings will result in the LEAST amount of downtime for the application during failover?(Select three.)

Accepted Answer

Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.

Accepted Answer

Edit and enable Aurora DB cluster cache management in parameter groups.

Accepted Answer

Set JDBC connection string timeout variables to a low value.

Answer

Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.

Answer

Set TCP keepalive parameters to a high value.

Answer

Set Java DNS caching timeouts to a high value.

Question 40

A company recently migrated its line-of-business (LOB) application to AWS. The application uses an Amazon RDS for SQL Server DB instance as its database engine.The company must set up cross-Region disaster recovery for the application. The company needs a solution with the lowest possible RPO and RTO.Which solution will meet these requirements?

Accepted Answer

Use AWS Database Migration Service (AWS KMS) for ongoing replication of the DB instance in the disaster recovery Region.

Answer

Create a cross-Region read replica of the DB instance. Promote the read replica at the time of failover.

Answer

Set up SQL replication from the DB instance to an Amazon EC2 instance in the disaster recovery Region. Promote the EC2 instance as the primary server.

Answer

Take manual snapshots of the DB instance in the primary Region. Copy the snapshots to the disaster recovery Region.

Amazon DBS-C01 Practice Test 5

Amazon DBS-C01 Practice Tests

Amazon DBS-C01 Practice Test 5

Question

Amazon DBS-C01 Practice Tests

Practice Tests