ExamGecko
Login
Home / Amazon / DBS-C01 / List of questions
Ask Question

Amazon DBS-C01 Practice Test - Questions Answers, Page 20

List of questions

Question 191

Report
Export
Collapse

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?

A VPC endpoint was not added to access DynamoDB.
A VPC endpoint was not added to access DynamoDB.
Strongly consistent reads are always passed through DAX to DynamoDB.
Strongly consistent reads are always passed through DAX to DynamoDB.
DynamoDB is scaling due to a burst in traffic, resulting in degraded performance.
DynamoDB is scaling due to a burst in traffic, resulting in degraded performance.
A VPC endpoint was not added to access CloudWatch.
A VPC endpoint was not added to access CloudWatch.
Suggested answer: B

Explanation:


https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DAX.concepts.html

"If the request specifies strongly consistent reads, DAX passes the request through to DynamoDB.

The results from DynamoDB are not cached in DAX. Instead, they are simply returned to the application."

asked 16/09/2024
San Min Oo
40 questions

Question 192

Report
Export
Collapse

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?

Increase the size of the DAX cluster.
Increase the size of the DAX cluster.
Configure DAX to be an item cache with no query cache
Configure DAX to be an item cache with no query cache
Use eventually consistent reads instead of strongly consistent reads.
Use eventually consistent reads instead of strongly consistent reads.
Create a new DAX cluster with a higher TTL for the item cache.
Create a new DAX cluster with a higher TTL for the item cache.
Suggested answer: C

Explanation:


asked 16/09/2024
Ranjan Gupta
33 questions

Question 193

Report
Export
Collapse

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?

Upload the data to Amazon S3 and use the Loader command to load the data from Amazon S3 into the Neptune database.
Upload the data to Amazon S3 and use the Loader command to load the data from Amazon S3 into the Neptune database.
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.
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.
Use the AWS CLI to load the data directly from the on-premises storage into the Neptune database.
Use the AWS CLI to load the data directly from the on-premises storage into the Neptune database.
Use AWS DataSync to load the data directly from the on-premises storage into the Neptune database.
Use AWS DataSync to load the data directly from the on-premises storage into the Neptune database.
Suggested answer: A

Explanation:


1.Copy the data files to an Amazon Simple Storage Service (Amazon S3) bucket.

2. Create an IAM role with Read and List access to the bucket.

3. Create an Amazon S3 VPC endpoint.

4. Start the Neptune loader by sending a request via HTTP to the Neptune DB instance.

5. The Neptune DB instance assumes the IAM role to load the data from the bucket.

asked 16/09/2024
olanrewaju malomo
31 questions

Question 194

Report
Export
Collapse

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?

Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.
Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.
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.
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.
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.
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.
Suggested answer: A

Explanation:


https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html

asked 16/09/2024
Thembinkosi Sibiya
34 questions

Question 195

Report
Export
Collapse

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?

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.
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.
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.
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.
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.
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.
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.
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.
Suggested answer: D

Explanation:


https://aws.amazon.com/blogs/database/optimizing-and-tuning-queries-in-amazon-rds-postgresqlbased-on-native-and-external-tools/

"AWS recently released a feature called Amazon RDS Performance Insights, which provides an easy-to-understand dashboard for detecting performance problems in terms of load." "AWS recently released a feature called Amazon RDS Performance Insights, which provides an easy-to-understand dashboard for detecting performance problems in terms of load."

asked 16/09/2024
Deshawn Sharpe
35 questions

Question 196

Report
Export
Collapse

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

Check that Amazon S3 has an IAM role granting read access to Neptune
Check that Amazon S3 has an IAM role granting read access to Neptune
Check that an Amazon S3 VPC endpoint exists
Check that an Amazon S3 VPC endpoint exists
Check that a Neptune VPC endpoint exists
Check that a Neptune VPC endpoint exists
Check that Amazon EC2 has an IAM role granting read access to Amazon S3
Check that Amazon EC2 has an IAM role granting read access to Amazon S3
Check that Neptune has an IAM role granting read access to Amazon S3
Check that Neptune has an IAM role granting read access to Amazon S3
Suggested answer: B, E

Explanation:


https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-tutorial-IAM.html

https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-data.html

“An IAM role for the Neptune DB instance to assume that has an IAM policy that allows access to the data files in the S3 bucket. The policy must grant Read and List permissions.” “An Amazon S3 VPC endpoint. For more information, see the Creating an Amazon S3 VPC Endpoint section.”

asked 16/09/2024
Jonas Weimar
45 questions

Question 197

Report
Export
Collapse

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?

Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
Provision a clone of the existing DB cluster for the new Application team.
Provision a clone of the existing DB cluster for the new Application team.
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).
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).
Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.
Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.
Suggested answer: D

Explanation:


asked 16/09/2024
Mohit Mohit
45 questions

Question 198

Report
Export
Collapse

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?

Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together
Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together
Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs
Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs
Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs
Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs
Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together
Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together
Suggested answer: C

Explanation:


https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPractices.LOBS,

"AWS DMS migrates LOB data in two phases:

1. AWS DMS creates a new row in the target table and populates the row with all data except the associated LOB value.

2.AWS DMS updates the row in the target table with the LOB data." This means that we would need two tasks, one per phase and use limited LOB mode for best performance.

asked 16/09/2024
Frederik Pardon
36 questions

Question 199

Report
Export
Collapse

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

Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
Edit and enable Aurora DB cluster cache management in parameter groups.
Edit and enable Aurora DB cluster cache management in parameter groups.
Set TCP keepalive parameters to a high value.
Set TCP keepalive parameters to a high value.
Set JDBC connection string timeout variables to a low value.
Set JDBC connection string timeout variables to a low value.
Set Java DNS caching timeouts to a high value.
Set Java DNS caching timeouts to a high value.
Suggested answer: A, C, E

Explanation:


https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.clustercache-mgmt.html

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html#AuroraPostgreSQL.BestPractices.FastFailover.TCPKeepalives

asked 16/09/2024
Vahit Erciyas
44 questions

Question 200

Report
Export
Collapse

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?

Create a cross-Region read replica of the DB instance. Promote the read replica at the time of failover.
Create a cross-Region read replica of the DB instance. Promote the read replica at the time of failover.
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.
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.
Use AWS Database Migration Service (AWS KMS) for ongoing replication of the DB instance in the disaster recovery Region.
Use AWS Database Migration Service (AWS KMS) for ongoing replication of the DB instance in the disaster recovery Region.
Take manual snapshots of the DB instance in the primary Region. Copy the snapshots to the disaster recovery Region.
Take manual snapshots of the DB instance in the primary Region. Copy the snapshots to the disaster recovery Region.
Suggested answer: C

Explanation:


https://aws.amazon.com/blogs/database/cross-region-disaster-recovery-of-amazon-rds-for-sqlserver/

asked 16/09/2024
Latonya Ganison
27 questions
Total 321 questions
Go to page: of 33
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora DB cluster is appropriate for the peak workload. The company is now looking at cutting costs for this DB cluster, but needs to have a sufficient number of nodes in the cluster to support the workload at different times. The workload has not changed since the previous benchmarking exercise. How can a Database Specialist address these requirements with minimal user involvement?
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup. The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company. Which solution will meet these requirements with minimal effort?
A Database Specialist is creating Amazon DynamoDB tables, Amazon CloudWatch alarms, and associated infrastructure for an Application team using a development AWS account. The team wants a deployment method that will standardize the core solution components while managing environment-specific settings separately, and wants to minimize rework due to configuration errors. Which process should the Database Specialist recommend to meet these requirements?
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?
An ecommerce company uses Amazon DynamoDB as the backend for its payments system. A new regulation requires the company to log all data access requests for financial audits. For this purpose, the company plans to use AWS logging and save logs to Amazon S3 How can a database specialist activate logging on the database?
A company needs to migrate Oracle Database Standard Edition running on an Amazon EC2 instance to an Amazon RDS for Oracle DB instance with Multi-AZ. The database supports an ecommerce website that runs continuously. The company can only provide a maintenance window of up to 5 minutes. Which solution will meet these requirements?
A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime using AWS DMS. A Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover. The migration must have minimal impact on the performance of the source database. Which approach will MOST effectively meet these requirements?
A company is about to launch a new product, and test databases must be re-created from production dat a. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort. What should the Database Specialist do to meet these requirements?
A company is due for renewing its database license. The company wants to migrate its 80 TB transactional database system from on-premises to the AWS Cloud. The migration should incur the least possible downtime on the downstream database applications. The company’s network infrastructure has limited network bandwidth that is shared with other applications. Which solution should a database specialist use for a timely migration?
A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users. How should the Database Specialist apply the parameter group change for the DB instance?