[Aug 21, 2023] Amazon SAA-C03 Exam Dumps Files, Q70/231: A company is moving its on-premises Oracle database to Amazon Aurora PostgreSQL. The database has several

Join the discussion

Question 70/231

A company is moving its on-premises Oracle database to Amazon Aurora PostgreSQL. The database has several applications that write to the same tables. The applications need to be migrated one by one with a month in between each migration. Management has expressed concerns that the database has a high number of reads and writes. The data must be kept in sync across both databases throughout the migration.
What should a solutions architect recommend?

A. Use the AWS Schema Conversion Tool with AWS Database Migration Service (AWS DMS) using a compute optimized replication instance. Create a full load plus change data capture (CDC) replication task and a table mapping to select the largest tables.

B. Use AWS DataSync for the initial migration. Use AWS Database Migration Service (AWS DMS) to create a change data capture (CDC) replication task and a table mapping to select all tables.

C. Use the AWS Schema Conversion Tool with AWS Database Migration Service (AWS DMS) using a memory optimized replication instance. Create a full load plus change data capture (CDC) replication task and a table mapping to select all tables.

D. Use AWS DataSync for the initial migration. Use AWS Database Migration Service (AWS DMS) to create a full load plus change data capture (CDC) replication task and a table mapping to select all tables.

Add Comments

Other Question (231q): Q1. A company wants to manage Amazon Machine Images (AMIs). The company currently copies AMIs ...; Q2. A company runs its two-tier ecommerce website on AWS. The web tier consists of a load bala...; Q3. An Amazon EC2 administrator created the following policy associated with an IAM group cont...; Q4. A company plans to develop a custom messaging service that will also be used to train thei...; Q5. A company is migrating a distributed application to AWS The application serves variable wo...; Q6. A company has applications that run on Amazon EC2 instances in a VPC. One of the applicati...; Q7. A company is running an SMB file server in its data center. The file server stores large f...; Q8. A company is designing an application where users upload small files into Amazon S3. After...; Q9. A company performs monthly maintenance on its AWS infrastructure. During these maintenance...; Q10. A company runs an ecommerce application on Amazon EC2 instances behind an Application Load...; Q11. A company has an application that runs on Amazon EC2 instances and uses an Amazon Aurora d...; Q12. A software company has resources hosted in AWS and on-premises servers. You have been requ...; Q13. A company has deployed a Java Spring Boot application as a pod that runs on Amazon Elastic...; Q14. A company has a web application that is based on Java and PHP The company plans to move th...; Q15. A company has a web application hosted over 10 Amazon EC2 instances with traffic directed ...; Q16. A company runs an on-premises application that is powered by a MySQL database The company ...; Q17. A global news network created a CloudFront distribution for their web application. However...; Q18. A company needs to collect gigabytes of data per second from websites and social media fee...; Q19. An organization needs to control the access for several S3 buckets. They plan to use a gat...; Q20. A solutions architect must design a highly available infrastructure for a website. The web...; Q21. A tech startup has recently received a Series A round of funding to continue building thei...; Q22. A company has both on-premises data center as well as AWS cloud infrastructure. They store...; Q23. A company is preparing to store confidential data in Amazon S3 For compliance reasons the ...; Q24. A survey company has gathered data for several years from areas the United States. The com...; Q25. The company that you are working for has a highly available architecture consisting of an ...; Q26. A company wants to migrate its 1 PB on-premises image repository to AWS. The images will b...; Q27. There is a new compliance rule in your company that audits every Windows and Linux EC2 ins...; Q28. A solutions architect is using Amazon S3 to design the storage architecture of a new digit...; Q29. A popular mobile game uses CloudFront, Lambda, and DynamoDB for its backend services. The ...; Q30. A company is using Amazon CloudFront with lis website. The company has enabled logging on ...; Q31. A company needs to transfer 600 TB of data from its on-premises network-attached storage (...; Q32. A pharmaceutical company has resources hosted on both their on-premises network and in AWS...; Q33. A company has an application that collects data from loT sensors on automobiles. The data ...; Q34. At part of budget planning. management wants a report of AWS billed dams listed by user. T...; Q35. A company is running a popular social media website. The website gives users the ability t...; Q36. A company has an AWS Glue extract. transform, and load (ETL) job that runs every day at th...; Q37. A company is reviewing a recent migration of a three-tier application to a VPC. The securi...; Q38. A company wants to measure the effectiveness of its recent marketing campaigns. The compan...; Q39. A company needs to retain application logs files for a critical application for 10 years. ...; Q40. A company plans to design an application that can handle batch processing of large amounts...; Q41. A company has a multi-tier application deployed on several Amazon EC2 instances in an Auto...; Q42. A company has a production workload that runs on 1,000 Amazon EC2 Linux instances. The wor...; Q43. A multi-tiered application hosted in your on-premises data center is scheduled to be migra...; Q44. A solutions architect is designing the cloud architecture for a new application being depl...; Q45. An IAM user made several configuration changes to AWS resources m their company's account ...; Q46. A company is using Amazon S3 to store frequently accessed data. The S3 bucket is shared wi...; Q47. There was an incident in your production environment where the user data stored in the S3 ...; Q48. A company needs to launch an Amazon EC2 instance with persistent block storage to host its...; Q49. A company needs to store its accounting records in Amazon S3. The records must be immediat...; Q50. A leading e-commerce company is in need of a storage solution that can be simultaneously a...; Q51. A company has a dynamic web app written in MEAN stack that is going to be launched in the ...; Q52. A bicycle sharing company is developing a multi-tier architecture to track the location of...; Q53. A company is running a batch job on an EC2 instance inside a private subnet. The instance ...; Q54. A Solutions Architect is designing a monitoring application which generates audit logs of ...; Q55. A company has a Microsoft NET application that runs on an on-premises Windows Server Trie ...; Q56. A company has a mulli-tier application that runs six front-end web servers in an Amazon EC...; Q57. A company provides an API to its users that automates inquiries for tax computations based...; Q58. A solutions architect is creating a new Amazon CloudFront distribution for an application....; Q59. An online trading platform with thousands of clients across the globe is hosted in AWS. To...; Q60. A company has an AWS Lambda function that needs read access to an Amazon S3 bucket that is...; Q61. A company is planning to deploy a High Performance Computing (HPC) cluster in its VPC that...; Q62. A company wants to migrate its on-premises data center to AWS. According to the company's ...; Q63. A company has an application that ingests incoming messages. These messages are then quick...; Q64. A company has a web application hosted on a fleet of EC2 instances located in two Availabi...; Q65. A company wants to use Amazon S3 for the secondary copy of its on-premises dataset. The co...; Q66. A company is using AWS to design a web application that will process insurance quotes User...; Q67. A company has several EC2 Reserved Instances in their account that need to be decommission...; Q68. An application is loading hundreds of JSON documents into an Amazon S3 bucket every hour w...; Q69. A company wants to move a multi-tiered application from on premises to the AWS Cloud to im...; Q70. A company is moving its on-premises Oracle database to Amazon Aurora PostgreSQL. The datab...; Q71. A company's application integrates with multiple software-as-a-service (SaaS) sources for ...; Q72. A company has a web application hosted in AWS cloud where the application logs are sent to...; Q73. A company is migrating applications to AWS. The applications are deployed in different acc...; Q74. A company uses Amazon EC2 instances and AWS Lambda functions to run its application. The c...; Q75. A company maintains a searchable repository of items on its website. The data is stored in...; Q76. A company recently started using Amazon Aurora as the data store for its global ecommerce ...; Q77. A manufacturing company launched a new type of IoT sensor. The sensor will be used to coll...; Q78. A newly hired Solutions Architect is checking all of the security groups and network acces...; Q79. The company you are working for has a set of AWS resources hosted in ap-northeast-1 region...; Q80. A company is storing backup files by using Amazon S3 Standard storage. The files are acces...; Q81. A company hosts a multi-tier web application that uses an Amazon Aurora MySQL DB cluster f...; Q82. A company is planning to store data on Amazon RDS DB instances. The company must encrypt t...; Q83. An ecommerce company needs to run a scheduled daily job to aggregate and filler sales reco...; Q84. An image-hosting company stores its objects in Amazon S3 buckets. The company wants to avo...; Q85. A company plans to use Amazon ElastiCache for its multi-tier web application. A solutions ...; Q86. An organization is currently using a tape backup solution to store its application data on...; Q87. Organizers for a global event want to put daily reports online as static HTML pages. The p...; Q88. A company has hundreds of Amazon EC2 Linux-based instances in the AWS Cloud. Systems admin...; Q89. A company has a custom application with embedded credentials that retrieves information fr...; Q90. A computer animation film studio has a web application running on an Amazon EC2 instance. ...; Q91. A data analytics company is setting up an innovative checkout-free grocery store. Their So...; Q92. An online retail company has more than 50 million active customers and receives more than ...; Q93. A tech startup is launching an on-demand food delivery platform using Amazon ECS cluster w...; Q94. A company is experiencing sudden increases in demand. The company needs to provision large...; Q95. A company is building a web-based application running on Amazon EC2 instances in multiple ...; Q96. A solution architect is designing a company's disaster recovery (DR) architecture. The com...; Q97. A company's website uses an Amazon EC2 instance store for its catalog of items. The compan...; Q98. A company wants to use high performance computing (HPC) infrastructure on AWS for financia...; Q99. A popular augmented reality (AR) mobile game is heavily using a RESTful API which is hoste...; Q100. A company has several microservices that send messages to an Amazon SQS queue and a backen...; Q101. A company recently migrated its entire IT environment to the AWS Cloud. The company discov...; Q102. A company hosts a serverless application on AWS. The application uses Amazon API Gateway, ...; Q103. A media company is evaluating the possibility ot moving rts systems to the AWS Cloud The c...; Q104. A company runs its Infrastructure on AWS and has a registered base of 700.000 users for re...; Q105. A company needs guaranteed Amazon EC2 capacity in three specific Availability Zones in a s...; Q106. A Solutions Architect created a new Standard-class S3 bucket to store financial reports th...; Q107. A disaster recovery team is planning to back up on-premises records to a local file server...; Q108. An application is hosted in an Auto Scaling group of EC2 instances and a Microsoft SQL Ser...; Q109. A company wants to run an in-memory database for a latency-sensitive application that runs...; Q110. An application is using a Lambda function to process complex financial data that run for 1...; Q111. A company's dynamic website is hosted using on-premises servers in the United States. The ...; Q112. A company has an application that is backed ny an Amazon DynamoDB table. The company's com...; Q113. A company is implementing a new business application. The application runs on two Amazon E...; Q114. A company runs an applcalion on a large Heel of Amazon EC2 ratances. The application leads...; Q115. A media company needs to configure an Amazon S3 bucket to serve static assets for the publ...; Q116. A company is preparing to deploy a new serverless workload. A solutions architect must use...; Q117. A solutions architect observes that a nightly batch processing job is automatically scaled...; Q118. A company is designing a shared storage solution for a gaming application that is hosted i...; Q119. A company is migrating a distributed application to AWS The application serves variable wo...; Q120. A company is developing a real-time multiplayer game that uses UDP for communications betw...; Q121. A company is developing a two-tier web application on AWS. The company's developers have d...; Q122. A company wants to direct its users to a backup static error page if the company's primary...; Q123. A company has two applications: a sender application that sends messages with payloads to ...; Q124. A company has an On-Demand EC2 instance located in a subnet in AWS that hosts a web applic...; Q125. A local bank has an in-house application that handles sensitive financial data in a privat...; Q126. An online learning company is migrating to the AWS Cloud. The company maintains its studen...; Q127. A company runs multiple Windows workloads on AWS. The company's employees use Windows file...; Q128. A Solutions Architect needs to create a publicly accessible EC2 instance by using an Elast...; Q129. A company has deployed a server less application that invokes an AWS Lambda function when ...; Q130. A company has implemented a self-managed DNS solution on three Amazon EC2 instances behind...; Q131. A company has an Amazon S3 data lake that is governed by AWS Lake Formation The company wa...; Q132. A company has an AWS account used for software engineering. The AWS account has access to ...; Q133. A company launched an EC2 instance in the newly created VPC. They noticed that the generat...; Q134. A company has a three-tier application on AWS that ingests sensor data from its users' dev...; Q135. A company has multiple AWS Site-to-Site VPN connections placed between their VPCs and thei...; Q136. A company has created an image analysis application in which users can upload photos and a...; Q137. A company has a custom application with embedded credentials that retrieves information fr...; Q138. There are a few, easily reproducible but confidential files that your client wants to stor...; Q139. A solutions architect needs to securely store a database user name and password that an ap...; Q140. A company has a requirement to move 80 TB data warehouse to the cloud. It would take 2 mon...; Q141. A company is preparing to store confidential data in Amazon S3 For compliance reasons the ...; Q142. An application runs on an Amazon EC2 instance that has an Elastic IP address in VPC A. The...; Q143. A company plans to launch an Amazon EC2 instance in a private subnet for its internal corp...; Q144. A technical lead of the Cloud Infrastructure team was consulted by a software developer re...; Q145. A company decided to change its third-party data analytics tool to a cheaper solution. The...; Q146. A company has thousands of edge devices that collectively generate 1 TB of status alerts e...; Q147. An application runs on Amazon EC2 instances in private subnets. The application needs to a...; Q148. A technology company has a suite of container-based web applications and serverless soluti...; Q149. A solutions architect is designing the architecture of a new application being deployed to...; Q150. A web application is hosted on an EC2 instance that processes sensitive financial informat...; Q151. A company is using a SQL database to store movie data that is publicly accessible. The dat...; Q152. A company installed sensors to track the number of people who visit the park. The data is ...; Q153. A company has applications that run on Amazon EC2 instances in a VPC. One of the applicati...; Q154. A company selves a dynamic website from a flee! of Amazon EC2 instances behind an Applicat...; Q155. A company recently migrated a message processing system to AWS. The system receives messag...; Q156. A company deployed a fleet of Windows-based EC2 instances with IPv4 addresses launched in ...; Q157. A company is running a batch applicalton on Amazon EC2 instances. The application consists...; Q158. A new employee has joined a company as a deployment engineer. The deployment engineer will...; Q159. A company s order system sends requests from clients to Amazon EC2 instances The EC2 insta...; Q160. A company developed a meal planning application that provides meal recommendations for the...; Q161. A company has an ecommerce checkout workflow that writes an order to a database and calls ...; Q162. A solutions architect is designing a new hybrid architecture to extend a company s on-prem...; Q163. A company is designing an application. The application uses an AWS Lambda function to rece...; Q164. A company is hosting EC2 instances that are on non-production environment and processing n...; Q165. A tech company is currently using Auto Scaling for their web application. A new AMI now ne...; Q166. A company has a production workload that runs on 1,000 Amazon EC2 Linux instances. The wor...; Q167. A company wants to migrate its MySQL database from on premises to AWS. The company recentl...; Q168. A company runs a global web application on Amazon EC2 instances behind an Application Load...; Q169. An online retail company has more than 50 million active customers and receives more than ...; Q170. A company needs to move data from an Amazon EC2 instance to an Amazon S3 bucket. The compa...; Q171. A company runs an application using Amazon ECS. The application creates esi/ed versions of...; Q172. A company has an on-premises application that generates a large amount of time-sensitive d...; Q173. A customer is transitioning their ActiveMQ messaging broker service onto the AWS cloud in ...; Q174. A company wants to improve its ability to clone large amounts of production data into a te...; Q175. A development team runs monthly resource-intensive tests on its general purpose Amazon RDS...; Q176. An application that is hosted on Amazon EC2 instances needs to access an Amazon S3 bucket ...; Q177. A solutions architect is managing an application that runs on a Windows EC2 instance with ...; Q178. A company uses 50 TB of data for reporting. The company wants to move this data from on pr...; Q179. A company runs a web-based portal that provides users with global breaking news, local ale...; Q180. For data privacy, a healthcare company has been asked to comply with the Health Insurance ...; Q181. A company has stored 200 TB of backup files in Amazon S3. The files are in a vendor-propri...; Q182. A company is in the process of migrating their applications to AWS. One of their systems r...; Q183. A company recently created a disaster recovery site in a Different AWS Region.The company ...; Q184. A company has an application architecture that stores both the access key ID and the secre...; Q185. A company's facility has badge readers at every entrance throughout the building. When bad...; Q186. An image-processing company has a web application that users use to upload images. The app...; Q187. A data analytics company wants to migrate its batch processing system to AWS. The company ...; Q188. A solutions architect is developing a multiple-subnet VPC architecture. The solution will ...; Q189. A web application hosted in an Auto Scaling group of EC2 instances in AWS. The application...; Q190. A company has developed public APIs hosted in Amazon EC2 instances behind an Elastic Load ...; Q191. A medical research lab produces data that is related to a new study. The lab wants to make...; Q192. A company runs an application that receives data from thousands of geographically disperse...; Q193. A company collects temperature, humidity, and atmospheric pressure data in cities across m...; Q194. A startup is building a microservices architecture in which the software is composed of sm...; Q195. An Amazon EC2 administrator created the following policy associated with an IAM group cont...; Q196. A Solutions Architect is working for a multinational telecommunications company. The IT Ma...; Q197. A company recently launched a variety of new workloads on Amazon EC2 instances in its AWS ...; Q198. A company recently started using Amazon Aurora as the data store for its global ecommerce ...; Q199. A production MySQL database hosted on Amazon RDS is running out of disk storage. The manag...; Q200. A company has a web application with sporadic usage patterns There is heavy usage at the b...; Q201. A company needs to implement a solution that will process real-time streaming data of its ...; Q202. A company launched a website that accepts high-quality photos and turns them into a downlo...; Q203. A solutions architect is designing a two-tiered architecture that includes a public subnet...; Q204. A Solutions Architect is managing a company's AWS account of approximately 300 IAM users. ...; Q205. A startup launched a fleet of on-demand EC2 instances to host a massively multiplayer onli...; Q206. A solutions architect has created two IAM policies: Policy1 and Policy2. Both policies are...; Q207. A company recently launched Linux-based application instances on Amazon EC2 in a private s...; Q208. A company hosts a containerized web application on a fleet of on-premises servers that pro...; Q209. An investment bank is working with an IT team to handle the launch of the new digital wall...; Q210. A company has an On-Demand EC2 instance with an attached EBS volume. There is a scheduled ...; Q211. A company wants to run its critical applications in containers to meet requirements tor sc...; Q212. A company runs an on-premises application that is powered by a MySQL database The company ...; Q213. A company is planning to use an Amazon DynamoDB table for data storage. The company is con...; Q214. A company is building a containerized application on premises and decides to move the appl...; Q215. A Solutions Architect needs to set up the required compute resources for the application w...; Q216. A company has a production web application in which users upload documents through a web i...; Q217. A company has a hybrid cloud architecture that connects their on-premises data center and ...; Q218. A company runs an application on a large fleet of Amazon EC2 instances. The application re...; Q219. A company recently launched a variety of new workloads on Amazon EC2 instances in its AWS ...; Q220. A fast food company is using AWS to host their online ordering system which uses an Auto S...; Q221. An ecommerce company hosts its analytics application in the AWS Cloud. The application gen...; Q222. A company runs a highly available image-processing application on Amazon EC2 instances in ...; Q223. A company launched a cryptocurrency mining server on a Reserved EC2 instance in us-east-1 ...; Q224. A company has a regional subscription-based streaming service that runs in a single AWS Re...; Q225. A company is preparing to store confidential data in Amazon S3 For compliance reasons the ...; Q226. A company has a website hosted on AWS The website is behind an Application Load Balancer (...; Q227. A company uses a payment processing system that requires messages for a particular payment...; Q228. A corporation has recruited a new cloud engineer who should not have access to the Company...; Q229. A survey company has gathered data for several years from areas m\ the United States. The ...; Q230. A large media company hosts a web application on AWS. The company wants to start caching c...; Q231. A solutions architect is designing a new hybrid architecture to extend a company s on-prem...

Join the discussion

Question 70/231

Add Comments

Download PDF File