Amazon DBS-C01 Practice Test - Questions Answers, Page 21
List of questions
Question 201
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A company runs hundreds of Microsoft SQL Server databases on Windows servers in its on-premises data center. A database specialist needs to migrate these databases to Linux on AWS.
Which combination of steps should the database specialist take to meet this requirement? (Choose three.)
Explanation:
https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/replatform-sql-server.html
https://d1.awsstatic.com/events/reinvent/2019/REPEAT_1_Leverage_automation_to_replatform_SQL_Server_to_Linux_WIN322-R1.pdf
Question 202
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A company is running a blogging platform. A security audit determines that the Amazon RDS DB instance that is used by the platform is not configured to encrypt the data at rest. The company must encrypt the DB instance within 30 days.
What should a database specialist do to meet this requirement with the LEAST amount of downtime?
Explanation:
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/encrypt-an-existing-amazonrds-for-postgresql-db-instance.html
When the new, encrypted copy of the DB instance becomes available, you can point your applications to the new database. However, if your project doesn’t allow for significant downtime for this activity, you need an alternate approach that helps minimize the downtime. This pattern uses the AWS Database Migration Service (AWS DMS) to migrate and continuously replicate the data so that the cutover to the new, encrypted database can be done with minimal downtime.
Question 203
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
An ecommerce company uses a backend application that stores data in an Amazon DynamoDB table.
The backend application runs in a private subnet in a VPC and must connect to this table.
The company must minimize any network latency that results from network connectivity issues, even during periods of heavy application usage. A database administrator also needs the ability to use a private connection to connect to the DynamoDB table from the application.
Which solution will meet these requirements?
Explanation:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/vpc-endpointsdynamodb.html
Question 204
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A company's database specialist is building an Amazon RDS for Microsoft SQL Server DB instance to store hundreds of records in CSV format. A customer service tool uploads the records to an Amazon S3 bucket.
An employee who previously worked at the company already created a custom stored procedure to map the necessary CSV fields to the database tables. The database specialist needs to implement a solution that reuses this previous work and minimizes operational overhead.
Which solution will meet these requirements?
Explanation:
Step 1: Download S3 Files Amazon RDS for SQL Server comes with several custom stored procedures and functions. These are located in the msdb database. The stored procedure to download files from S3 is "rds_download_from_s3". The syntax for this stored procedure is shown here: exec msdb.dbo.rds_download_from_s3 @s3_arn_of_file='arn:aws:s3:::<bucket_name>/<file_name>', @rds_file_path='D:\S3\<custom_folder_name>\<file_name>', @overwrite_file=1;
Question 205
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A company hosts a 2 TB Oracle database in its on-premises data center. A database specialist is migrating the database from on premises to an Amazon Aurora PostgreSQL database on AWS.
The database specialist identifies a problem that relates to compatibility Oracle stores metadata in its data dictionary in uppercase, but PostgreSQL stores the metadata in lowercase. The database specialist must resolve this problem to complete the migration.
What is the MOST operationally efficient solution that meets these requirements?
Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/dms-mapping-oracle-postgresql/
Question 206
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions.
The company needs to generate connection logs, user logs, and user activity logs. The company also must make these logs available for future analysis.
Which combination of steps should a database specialist take to meet these requirements? (Choose two.)
Explanation:
AWS CloudWatch Logs are stored indefinitely and CloudWatch Log Insights is used to analyze the logs and query upon them.
https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/AnalyzingLogData.html
https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/WhatIsCloudWatchLogs.html"
Log retention – By default, logs are kept indefinitely and never expire. You can adjust the retention policy for each log group, keeping the indefinite retention, or choosing a retention period between10 years and one day."
https://docs.aws.amazon.com/redshift/latest/mgmt/db-auditing.html
Question 207
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A company plans to migrate a MySQL-based application from an on-premises environment to AWS.
The application performs database joins across several tables and uses indexes for faster query response times. The company needs the database to be highly available with automatic failover.
Which solution on AWS will meet these requirements with the LEAST operational overhead?
Explanation:
Question 208
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A social media company is using Amazon DynamoDB to store user profile data and user activity dat a. Developers are reading and writing the data, causing the size of the tables to grow significantly.
Developers have started to face performance bottlenecks with the tables.
Which solution should a database specialist recommend to read items the FASTEST without consuming all the provisioned throughput for the tables?
Explanation:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SQLtoNoSQL.ReadData.html
Question 209
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A pharmaceutical company's drug search API is using an Amazon Neptune DB cluster. A bulk uploader process automatically updates the information in the database a few times each week. A few weeks ago during a bulk upload, a database specialist noticed that the database started to respond frequently with a ThrottlingException error. The problem also occurred with subsequent uploads.
The database specialist must create a solution to prevent ThrottlingException errors for the database. The solution must minimize the downtime of the cluster.
Which solution meets these requirements?
Explanation:
https://docs.aws.amazon.com/neptune/latest/userguide/manage-console-add-replicas.html
Neptune replicas connect to the same storage volume as the primary DB instance and support only read operations. Neptune replicas can offload read workloads from the primary DB instance.
Question 210
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A global company is developing an application across multiple AWS Regions. The company needs a database solution with low latency in each Region and automatic disaster recovery. The database must be deployed in an active-active configuration with automatic data synchronization between Regions.
Which solution will meet these requirements with the LOWEST latency?
Explanation:
Question