100% Free Real Updated DBS-C01 Questions & Answers Pass Your Exam Easily
Easily To Pass New DBS-C01 Verified & Correct Answers
The AWS Certified Database – Specialty (DBS-C01) is an exam designed for individuals who work in a database-focused environment. It validates the professional’s knowledge of databases, the principles of their deployment, design, migration, automation, security, monitoring, troubleshooting, and access. It also tests one’s skills in managing different features of AWS database services and analyzing the needs to design or choose proper solutions. By passing this test, one obtains the AWS Certified Database – Specialty certification.
The AWS Certified Database - Specialty exam covers a variety of topics related to AWS databases, including database design, deployment, migration, and management. It also includes topics such as data modeling, optimization, and troubleshooting. DBS-C01 exam is designed to test the candidate's ability to use AWS database services, such as Amazon RDS, Amazon DynamoDB, and Amazon Aurora, to design and implement highly available and scalable database solutions.
The DBS-C01 exam covers a wide range of topics, including database design, deployment, migration, and management on AWS. DBS-C01 exam also tests your knowledge of AWS database services such as Amazon RDS, Amazon Aurora, Amazon DynamoDB, Amazon ElastiCache, and Amazon Redshift. You will be required to demonstrate your proficiency in using these services to build scalable, highly available, and fault-tolerant databases on AWS.
NEW QUESTION # 103
A company is releasing a new mobile game featuring a team play mode. As a group of mobile device users play together, an item containing their statuses is updated in an Amazon DynamoDB table. Periodically, the other users' devices read the latest statuses of their teammates from the table using the BatchGetltemn operation.
Prior to launch, some testers submitted bug reports claiming that the status data they were seeing in the game was not up-to-date. The developers are unable to replicate this issue and have asked a database specialist for a recommendation.
Which recommendation would resolve this issue?
- A. Ensure the DynamoDB table is configured to be always consistent.
- B. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to true.
- C. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to false.
- D. Enable a stream on the DynamoDB table and subscribe each device to the stream to ensure all devices receive up-to-date status information.
Answer: B
Explanation:
Explanation
https://docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/API_BatchGetItem_v20111205.htm By default, BatchGetItem performs eventually consistent reads on every table in the request. If you want strongly consistent reads instead, you can set ConsistentRead to true for any or all tables.
NEW QUESTION # 104
A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS. A deep review is performed and the AWS Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server Standard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL. The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.
What is the MOST cost-effective and operationally efficient solution?
- A. Run SQL Server Standard Edition on Amazon RDS.
- B. Run SQL Server Enterprise Edition on Amazon RDS.
- C. Run SQL Server Enterprise Edition on Amazon EC2.
- D. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.
Answer: A
Explanation:
Explanation
This link seems to indicate that more information is required to determine if the Enterprise instance is a candidate for downgrading to Standard.
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/determine-whether-your-microsoft-sql-server-
https://calculator.aws/#/createCalculator/RDSSQLServer
NEW QUESTION # 105
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?
- A. Configure the table-level write throughput limit service quota to a higher value.
- B. Configure a DynamoDB Accelerator (DAX) cluster on each of the replicas.
- C. Configure all replica tables to use DynamoDB auto scaling.
- D. Configure the primary table to use DynamoDB auto scaling and the replica tables to use manually provisioned capacity.
Answer: C
Explanation:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/V2globaltables_reqs_bestpractices.html
NEW QUESTION # 106
A company has a database fleet that includes an Amazon RDS for MySQL DB instance. During an audit, the company discovered that the data that is stored on the DB instance is unencrypted.
A database specialist must enable encryption for the DB instance. The database specialist also must encrypt all connections to the DB instance.
Which combination of actions should the database specialist take to meet these requirements? (Choose three.)
- A. Enable SSH encryption on the DB instance.
- B. Use SSL/TLS from the application to encrypt a connection to the DB instance.
- C. Encrypt the read replica of the unencrypted DB instance by using an AWS Key Management Service (AWS KMS) key. Fail over the read replica to the primary DB instance.
- D. Require SSL connections for applicable database user accounts.
- E. Create a snapshot of the unencrypted DB instance. Encrypt the snapshot by using an AWS Key Management Service (AWS KMS) key. Restore the DB instance from the encrypted snapshot. Delete the original DB instance.
- F. In the RDS console, choose "Enable encryption" to encrypt the DB instance by using an AWS Key Management Service (AWS KMS) key.
Answer: B,E,F
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html#Overview.Encryption.Enabling
NEW QUESTION # 107
A company is using an Amazon Aurora MySQL database with Performance Insights enabled.
A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase:
'Performance Insights is unable to collect SQL Digest statistics on new queries'.
Which action will resolve this alert message?
- A. Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights.
- B. Set the value for the performance_schema parameter in the parameter group to 1.
- C. Truncate the events_statements_summary_by_digest table.
- D. Disable and reenable Performance Insights to be effective in the next maintenance window.
Answer: C
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.MySQL.html
NEW QUESTION # 108
A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-
1.rds.amazonaws.com endpoint listening on port 3306. The company's Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logging a "could not connect to server: Connection times out" error message to Amazon CloudWatch Logs.
What is the cause of this error?
- A. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.
- B. The user name and password the application is using are incorrect.
- C. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
- D. The user name and password are correct, but the user is not authorized to use the DB instance.
Answer: C
NEW QUESTION # 109
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?
- A. DynamoDB with on-demand capacity mode
- B. DynamoDB Streams
- C. DynamoDB with provisioned capacity mode with Auto Scaling
- D. DynamoDB with DynamoDB Accelerator
Answer: C
Explanation:
"On-demand is ideal for bursty, new, or unpredictable workloads whose traffic can spike in seconds or minutes" vs.
'DynamoDB released auto scaling to make it easier for you to manage capacity efficiently, and auto scaling continues to help DynamoDB users lower the cost of workloads that have a predictable traffic pattern."
https://aws.amazon.com/blogs/database/amazon-dynamodb-auto-scaling-performance-and-cost-optimization-at-any-scale/
NEW QUESTION # 110
A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table. TTL is enabled on one of the attributes. The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.
What is the MOST likely reason that the items are not being deleted?
- A. The TTL attribute's value is set with an expiration of 1 year.
- B. The TTL attribute's value is set as a Number data type.
- C. The TTL attribute's value is a timestamp in the Unix epoch time format in seconds.
- D. The TTL attribute's value is set as a Binary data type.
Answer: D
Explanation:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TTL.html#time-to-live-ttl-before-you-start-formatting
NEW QUESTION # 111
A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one medium- sized primary instance, one large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.
In the event of a primary failure, what will occur?
- A. Aurora will promote an Aurora Replica that is of the same size as the primary instance
- B. Aurora will promote an arbitrary Aurora Replica
- C. Aurora will promote the largest-sized Aurora Replica
- D. Aurora will not promote an Aurora Replica
Answer: C
Explanation:
Priority: If you don't select a value, the default is tier-1. This priority determines the order in which Aurora
https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html More than one Aurora Replica can share the same priority, resulting in promotion tiers. If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Backups.html#Aurora.Managing.FaultTolerance If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.AuroraHighAvailability.html
NEW QUESTION # 112
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?
- A. Include a query filter expression to ignore items with an expired TTL.
- B. Create a local secondary index on the TTL attribute.
- C. Use a client library that supports the TTL functionality for DynamoDB.
- D. Set the ConsistentRead parameter to true when querying the table.
Answer: A
Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/howitworks-ttl.html
NEW QUESTION # 113
A stock market analysis firm maintains two locations: one in the us-east-1 Region and another in the eu-west-2 Region. The business want to build an AWS database solution capable of providing rapid and accurate updates.
Dashboards with advanced analytical queries are used to present data in the eu-west-2 office. Because the corporation will use these dashboards to make purchasing choices, they must have less than a second to obtain application data.
Which solution satisfies these criteria and gives the MOST CURRENT dashboard?
- A. Use an Amazon Aurora global database. Deploy the primary DB cluster in us-east-1. Deploy the secondary DB cluster in eu-west-2. Configure the dashboard application to read from the secondary cluster.
- B. Use an Amazon DynamoDB global table in us-east-1 with replication into eu-west-2. Use multi-active replication to ensure that updates are quickly propagated to eu-west-2.
- C. Deploy an Amazon RDS for MySQL DB instance in us-east-1 with a read replica instance in eu-west-2. Configure the dashboard application to read from the read replica.
- D. Deploy an Amazon RDS DB instance in us-east-1 with a read replica instance in eu-west-2. Create an Amazon ElastiCache cluster in eu-west-2 to cache data from the read replica to generate the dashboards.
Answer: A
Explanation:
Amazon Aurora global databases span multiple AWS Regions, enabling low latency global reads and providing fast recovery from the rare outage that might affect an entire AWS Region. An Aurora global database has a primary DB cluster in one Region, and up to five secondary DB clusters in different Regions. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html
NEW QUESTION # 114
A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one medium- sized primary instance, one large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.
In the event of a primary failure, what will occur?
- A. Aurora will promote an Aurora Replica that is of the same size as the primary instance
- B. Aurora will promote an arbitrary Aurora Replica
- C. Aurora will promote the largest-sized Aurora Replica
- D. Aurora will not promote an Aurora Replica
Answer: C
Explanation:
Explanation
Priority: If you don't select a value, the default is tier-1. This priority determines the order in which Aurora
https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html More than one Aurora Replica can share the same priority, resulting in promotion tiers. If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Backups.html#Aurora.Ma If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.AuroraHighAvailability.html
NEW QUESTION # 115
A startup company in the travel industry wants to create an application that includes a personal travel assistant to display information for nearby airports based on user location. The application will use Amazon DynamoDB and must be able to access and display attributes such as airline names, arrival times, and flight numbers. However, the application must not be able to access or display pilot names or passenger counts.
Which solution will meet these requirements MOST cost-effectively?
- A. Use a proxy tier between the application and DynamoDB to regulate access to specific tables, items, and attributes.
- B. Configure an AWS Lambda function to extract only allowed attributes from tables based on user profiles.
- C. Use DynamoDB resource policies to regulate access to specific tables, items, and attributes.
- D. Use IAM policies with a combination of IAM conditions and actions to implement fine-grained access control.
Answer: D
Explanation:
https://aws.amazon.com/blogs/aws/fine-grained-access-control-for-amazon-dynamodb/
NEW QUESTION # 116
A major organization maintains a number of Amazon DB clusters. Each of these clusters is configured differently to meet certain needs. These configurations may be classified into wider groups based on the team and use case.
A database administrator wishes to streamline the process of storing and updating these settings. Additionally, the database administrator want to guarantee that changes to certain configuration categories are automatically implemented to all instances as necessary.
Which AWS service or functionality will assist in automating and achieving this goal?
- A. AWS Config
- B. AWS Secrets Manager
- C. AWS Systems Manager Parameter Store
- D. DB parameter group
Answer: D
Explanation:
Explanation
Database parameters specify how the database is configured. For example, database parameters can specify the amount of resources, such as memory, to allocate to a database.
NEW QUESTION # 117
A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.
What should the company do to achieve this in the shortest amount of time?
- A. Use RDS fault injection queries to simulate the primary node failure
- B. Use a blue-green deployment with a complete application-level failover test
- C. Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone
- D. Use the RDS console to reboot the DB instance by choosing the option to reboot with failover
Answer: A
NEW QUESTION # 118
A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database. After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower. The company has narrowed down the cause of this issue to the database and not the application.
Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?
- A. Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring toolthat will run reports based on the output error logs.
- B. Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify anyqueries that are related to spikes in the graph during the next slow period.
- C. Modify the logging database parameter to log all the queries related to locking in the database and thencheck the logs after the next slow period for this information.
- D. Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and diskspace consumption. Watch these dashboards during the next slow period.
Answer: B
NEW QUESTION # 119
A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds.
What should the database specialist do to accomplish this task?
- A. Connect to the MySQL database and run the SET SESSION wait_timeout=900 command.
- B. Create a custom DB parameter group and set the wait_timeout parameter value to 900. Associate the DB instance with the custom parameter group.
- C. Edit the my.cnf file and set the wait_timeout parameter value to 900. Restart the DB instance.
- D. Modify the default DB parameter group and set the wait_timeout parameter value to 900.
Answer: B
Explanation:
https://aws.amazon.com/fr/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-part-3-parameters-related-to-security-operational-manageability-and-connectivity-timeout/
"You can set parameters globally using a parameter group. Alternatively, you can set them for a particular session using the SET command." https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-part-1-parameters-related-to-performance/
NEW QUESTION # 120
......
Free DBS-C01 Exam Files Downloaded Instantly: https://www.passtorrent.com/DBS-C01-latest-torrent.html
Verified & Latest DBS-C01 Dump Q&As with Correct Answers: https://drive.google.com/open?id=1L471xlic8vlBz1Yqf5Poj0cPcUzamPpM