Instant Access Amazon.DBS-C01.v2023-12-26.q241 Actual Practice Test Engine for Free (Page 36)

40%off

DBS-C01 Premium Dumps

Latest DBS-C01 Exam Premium Dumps provide by TrainingQuiz.com to help you Passing DBS-C01 Exam! TrainingQuiz.com offers the updated DBS-C01 exam dumps, the TrainingQuiz.com DBS-C01 exam questions has been updated to correct Answer. Get the latest TrainingQuiz.com DBS-C01 pdf dumps with Exam Engine here:

(325 Q&As Dumps, 40%OFF Special Discount: DumpsDB)

Question 171

A company's application development team wants to share an automated snapshot of its Amazon RDS database with another team. The database is encrypted with a custom AWS Key Management Service (AWS KMS) key under the "WeShare" AWS account. The application development team needs to share the DB snapshot under the "WeReceive" AWS account.
Which combination of actions must the application development team take to meet these requirements? (Choose two.)

A.Add access from the "WeReceive" account to the custom AWS KMS key policy of the sharing team.
B.Make a copy of the DB snapshot, and set the encryption option to disable.
C.Share the DB snapshot by setting the DB snapshot visibility option to public.
D.Make a copy of the DB snapshot, and set the encryption option to enable.
E.Share the DB snapshot by using the default AWS KMS encryption key.

Question 172

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?

A.Migrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.
B.Migrate the database to Amazon S3. Use Amazon Redshift Spectrum for query processing.
C.Migrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication.
D.Migrate the database to an Amazon EMR cluster that includes multiple primary nodes.

Correct Answer: A

Explanation from Amazon documents:
Amazon Aurora PostgreSQL is a fully managed relational database service that is compatible with PostgreSQL. Aurora PostgreSQL offers up to three times better performance than standard PostgreSQL, as well as high availability, scalability, security, and durability. Aurora PostgreSQL also supports Babelfish, which is a new feature that enables Aurora to understand queries from applications written for Microsoft SQL Server. Babelfish allows you to migrate your SQL Server databases to Aurora PostgreSQL with minimal or no code changes, and run complex T-SQL queries and stored procedures on Aurora PostgreSQL.
Migrating the database to Amazon Aurora PostgreSQL and turning on Babelfish will meet the requirements of minimizing database server maintenance and operating costs, and minimizing the need to rewrite code as part of the migration effort. This solution will allow the company to benefit from the performance, reliability, and cost-efficiency of Aurora PostgreSQL, while preserving the compatibility and functionality of SQL Server.
The company will also avoid the hassle and expense of managing and licensing SQL Server on premises or on AWS.
Therefore, option A is the correct solution to meet the requirements. Option B is not suitable because Amazon S3 is an object storage service that is not designed for OLTP workloads. Amazon Redshift Spectrum is a feature that allows you to query data in S3 using Amazon Redshift, but it is not compatible with SQL Server or T-SQL. Option C is not optimal because Amazon RDS for SQL Server is a managed relational database service that supports SQL Server, but it does not offer the same performance, scalability, or cost savings as Aurora PostgreSQL. Kerberos authentication is a security feature that does not affect the migration effort or the operating costs. Option D is not suitable because Amazon EMR is a big data processing service that runs Apache Hadoop and Spark clusters, not relational databases. EMR does not support SQL Server or T-SQL, and it is not optimized for OLTP workloads.

Question 173

A company has multiple applications serving data from a secure on-premises database. The company is migrating all applications and databases to the AWS Cloud. The IT Risk and Compliance department requires that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as the migration target, and leveraging the Advanced Auditing feature in Aurora.
Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements? (Choose three.)

A.QUERY
B.QUERY_DML
C.QUERY_DCL
D.QUERY_DDL
E.TABLE
F.CONNECT

Question 174

A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made.
What should the database specialist do to meet these requirements? (Choose two.)

A.SSH to the DB instance and review the database logs.
B.Create an RDS event subscription to the audit event type.
C.Enable auditing of CONNECT and QUERY_DML events.
D.Enable Enhanced Monitoring on the DB instance.
E.Publish the database logs to Amazon CloudWatch Logs.

Question 175

A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost-effective and able to handle unpredictable application traffic.
What should a Database Specialist recommend for this user?

A.Create an Amazon DynamoDB table with on-demand capacity mode
B.Create an Amazon Aurora Serverless DB cluster
C.Create an Amazon DocumentDB cluster
D.Create an Amazon DynamoDB table with provisioned capacity mode