AWS-Certified-Database-Specialty Premium Exam Engine - Download Free PDF Questions
Instant Download AWS-Certified-Database-Specialty Free Updated Test Dumps
Difficulty in Writing AWS Certified Database - Specialty
Mostly job holder candidates give a short time to their study and want to pass the exam with good marks. Thereby we have many ways to prepare and practice for exams in a very short time that help the candidates to ready for exams in a very short time without any tension. Candidates can easily prepare AWS Solutions Architect Associate exams from PassTestking because we are providing the best AMAZON DBS-C01 exam dumps which are verified by our experts.
In addition to our comprehensive study guide, we also offer exam dumps of AWS Solutions Architect Associate Exam, if you want a quick and exam-oriented preparation. Any information in this AWS Solutions Architect Associate exam dumps is valuable. Questions and answers from the AWS Solutions Architect Associate Exam include important topics from the AWS Solutions Architect Associate Program and provides easy-to-learn information for easy access.There are two main types of resources for preparation of AWS certification exams first there are the study guides and books that are detailed and suitable for building knowledge from ground up then there are video tutorials and lectures that can somehow ease the pain of through study and are comparatively less boring for some candidates yet these demand time and concentration from the learner.
Smart Candidates who want to build a solid foundation in all exam topics and related technologies usually combine video lectures with study guides to reap the benefits of both but there is one crucial preparation tool as often overlooked by most candidates the practice exams. Practice exams are built to make students comfortable with the real exam environment. Statistics have shown that most students fail not due to that preparation but due to exam anxiety the fear of the unknown.
PassTestking expert team recommends you to prepare some notes on these topics along with it don't forget to practice AMAZON DBS-C01 exam dumps which had been written by our expert team, Both these will help you a lot to clear this exam with good marks.
If you have minimal time, we are now certain that you can take the exams really easily and in a few hrs. Our exam dumps and pdf materials are valid, best, simple, as well as easy to understand. By utilizing our vendor AMAZON DBS-C01 practice exam, you will certainly pass your exams with great qualities. To obtain the certification it is a bit hard work but You do not require to take any kind of bother with it because these Practice exams had been composed by our Professionals Group. Which able you to pass your AWS Solutions Architect Associate Exam conveniently. As well as individuals and professionals passed their AWS Solutions Architect Associate exams by using our exam dumps.
We offer a superb research overview as well as exceptional options for all specialists who desire to pass the certification Exams in the initial attempt. By taking the technique product made by our experts, as well as after it you'll be able to pass your Exams in the very first attempt. We offer a 100% guarantee of success as well as we make certain you will prosper.
PassTestking offers everything you require to pass the certification Exam. If you are searching for certification and are not effective, it is time for you to try what we provide. When you begin getting ready for the certification exam, there is some standard however, powerful methods that permit you to recognize every little thing in your preparation.
What Is DBS-C01 Exam Outline?
The AWS DBS-C01 exam measures the candidates' knowledge of five domains. They are the following:
- Database Security.
- Troubleshooting & Monitoring;
- Workload-specific Database Design;
- Operations and Management;
- Migration as well as Deployment;
Each of the topics has different sections. Thus, the first domain is dedicated to selecting the appropriate database services for different types of workloads and data. Candidates will learn how to determine a proper strategy to ensure business continuity & high availability in case of disaster. Also, they will learn how to identify different design database solutions and ensure the highest level of scalability, compliance, and performance. Finally, applicants will be shown how to compare the costs of different database solutions and choose the most cost-effective one.
The second topic is dedicated to migration and deployment. Within this subdomain, candidates will learn how to automate different database solution deployments. They will also learn how to determine data preparation and how to develop migration strategies. Finally, this area includes intensive training on data migration validation and execution.
The third part handles the management and operations topics. The basic concepts targeted in this section focus on how to determine maintenance tasks and processes. You will also learn how to create restoration strategies and determine effective backup. Finally, you will understand more about how to ensure proper database solution operational environmental management.
The fourth section focuses on monitoring and troubleshooting. Thus, candidates will learn how to develop the most effective alerting and monitoring strategies. Also, they will become proficient in troubleshooting and resolving the most common database issues. The final subtopic included in this section handles database performance optimization.
Last but not least, the final segment is dedicated to database security. Examinees will understand more about data encryption at rest and in transit. Also, they will identify the most effective auditing solutions. You will learn how to determine proper access control and develop the right authentication mechanisms for your organization. At last, you will become skilled in recognizing potential security vulnerabilities using database solutions.
NEW QUESTION 113
A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server. Due to escalating support and maintenance costs, the company is exploring the option of moving the workload to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?
- A. Run AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing the row counts from source and target tables.
- B. Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster. Create a migration assessment report to evaluate the migration compatibility.
- C. Perform a logical dump from the Db2 database and restore it to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing row counts from source and target tables.
- D. Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate the migration compatibility.
Answer: B
NEW QUESTION 114
A Database Specialist is designing a new database infrastructure for a ride hailing application. The application data includes a ride tracking system that stores GPS coordinates for all rides. Real-time statistics and metadata lookups must be performed with high throughput and microsecond latency. The database should be fault tolerant with minimal operational overhead and development effort.
Which solution meets these requirements in the MOST efficient way?
- A. Use Amazon DynamoDB as the database and use Amazon API Gateway
- B. Use Amazon Aurora MySQL as the database and use Aurora's buffer cache
- C. Use Amazon RDS for MySQL as the database and use Amazon ElastiCache
- D. Use Amazon DynamoDB as the database and use DynamoDB Accelerator
Answer: A
NEW QUESTION 115
A banking company recently launched an Amazon RDS for MySQL DB instance as part of a proof-of-concept project. A database specialist has configured automated database snapshots. As a part of routine testing, the database specialist noticed one day that the automated database snapshot was not created.
Which of the following are possible reasons why the snapshot was not created? (Choose two.)
- A. The RDS DB instance is in the STORAGE_FULL state.
- B. A copy of the RDS automated snapshot for this DB instance is in progress within the same AWS Region.
- C. A copy of the RDS automated snapshot for this DB instance is in progress in a different AWS Region.
- D. RDS event notifications have not been enabled.
- E. The RDS maintenance window is not configured.
Answer: A,B
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html
NEW QUESTION 116
A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A Database Specialist needs to control the access privileges at the table level.
How can the Database Specialist meet these requirements?
- A. Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
- B. Define access privileges to the tables containing sensitive data in the pg_hba.conf file.
- C. Configure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.
- D. Use AWS IAM database authentication and restrict access to the tables using an IAM policy.
Answer: A
NEW QUESTION 117
A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation.
How can the Database Specialists accomplish this?
- A. Enable Amazon RDS Performance Insights and review the appropriate dashboard
- B. Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
- C. Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
- D. Enable Enhanced Monitoring will the appropriate settings
Answer: A
NEW QUESTION 118
A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster. The database will be accessed by multiple applications across the company. The company has mandated that all communications to the database be encrypted and the server identity must be validated. Any non-SSL-based connections should be disallowed access to the database.
Which solution addresses these requirements?
- A. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-full.
- B. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=disable.
- C. Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-ca.
- D. Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=allow.
Answer: A
Explanation:
Explanation
PostgreSQL: sslrootcert=rds-cert.pem sslmode=[verify-ca | verify-full]
NEW QUESTION 119
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. Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Periodically perform incremental backups of the source database to be shipped in another Snowball Edge appliance to handle syncing change data capture (CDC) data from the source to the target database.
- B. Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Use AWS DMS to migrate change data capture (CDC) data from the source database to Amazon S3. Use a second AWS DMS task to migrate all the S3 data to the target database.
- C. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS SCT to handle syncing change data capture (CDC) data from the source to the target database.
- D. Use AWS DMS to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS DMS to handle syncing change data capture (CDC) data from the source to the target database.
Answer: B
Explanation:
Explanation
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html Using Amazon S3 as a target for AWS Database Migration Service
NEW QUESTION 120
A Database Specialist is working with a company to launch a new website built on Amazon Aurora with several Aurora Replicas. This new website will replace an on-premises website connected to a legacy relational database. Due to stability issues in the legacy database, the company would like to test the resiliency of Aurora.
Which action can the Database Specialist take to test the resiliency of the Aurora DB cluster?
- A. Remove the DB cluster endpoint to simulate a master DB instance failure
- B. Stop the DB cluster and analyze how the website responds
- C. Use Aurora Backtrack to crash the DB cluster
- D. Use Aurora fault injection to crash the master DB instance
Answer: D
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.FaultInjectionQueries.html
"You can test the fault tolerance of your Amazon Aurora DB cluster by using fault injection queries. Fault injection queries are issued as SQL commands to an Amazon Aurora instance and they enable you to schedule a simulated occurrence of one of the following events: A crash of a writer or reader DB instance A failure of an Aurora Replica A disk failure Disk congestion When a fault injection query specifies a crash, it forces a crash of the Aurora DB instance. The other fault injection queries result in simulations of failure events, but don't cause the event to occur. When you submit a fault injection query, you also specify an amount of time for the failure event simulation to occur for."
NEW QUESTION 121
A company developed an AWS CloudFormation template used to create all new Amazon DynamoDB tables in its AWS account. The template configures provisioned throughput capacity using hard-coded values. The company wants to change the template so that the tables it creates in the future have independently configurable read and write capacity units assigned.
Which solution will enable this change?
- A. Add values for two Number parameters, rcuCount and wcuCount, to the template. Replace the hard-codedvalues with calls to the Ref intrinsic function, referencing the new parameters.
- B. Add values for the rcuCount and wcuCount parameters as outputs of the template. Configure DynamoDBto provision throughput capacity using the stack outputs.
- C. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template.
ConfigureDynamoDB to provision throughput capacity using the stack's mappings. - D. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template.
Replacethe hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.
Answer: A
NEW QUESTION 122
A company recently acquired a new business. A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account. The database specialist needs to minimize the amount of time required to migrate the database.
Which solution meets these requirements?
- A. Create a read replica of the DB instance. Give the destination account access to the read replica. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.
- B. Create a snapshot of the source DB instance in the source account. Share the snapshot with the destination account. In the target account, create a DB instance from the snapshot.
- C. Use mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.
- D. Use AWS Resource Access Manager to share the source DB instance with the destination account. Create a DB instance in the destination account using the shared resource.
Answer: B
Explanation:
Sharing an unencrypted manual DB snapshot enables authorized AWS accounts to directly restore a DB instance from the snapshot instead of taking a copy of it and restoring from that. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ShareSnapshot.html However Resource Access Manager could not share non-Aurora cluster. https://docs.aws.amazon.com/ram/latest/userguide/shareable.html
NEW QUESTION 123
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.)
- A. Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration.
- B. Use AWS Systems Manager Run Command to install and configure the AWS Schema Conversion Tool on the on-premises servers.
- C. On the AWS Management Console, set up Amazon RDS for SQL Server DB instances with Linux as the operating system. Install AWS Systems Manager Agent on the DB instances by using an options group.
- D. On the Amazon EC2 console, launch EC2 instances and select a Linux AMI that includes SQL Server. Install and configure AWS Systems Manager Agent on the EC2 instances.
- E. On the AWS Management Console, set up AWS Database Migration Service (AWS DMS) by entering details of the source SQL Server database and the destination SQL Server database on AWS. Start migration.
- F. Install AWS Systems Manager Agent on the on-premises servers. Use Systems Manager Run Command to install the Windows to Linux replatforming assistant for Microsoft SQL Server Databases.
Answer: A,D,F
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_re-platform_SQL_Server_to_Linux_WIN322-R1.pdf
NEW QUESTION 124
An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
Update scores in real time whenever a player is playing the game. Retrieve a player's score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?
- A. Create a composite primary key with game_id as the partition key and user_id as the sort key
- B. Create a global secondary index with game_id as the partition key
- C. Create a composite primary key with user_id as the partition key and game_id as the sort key
- D. Create a global secondary index with user_id as the partition key
Answer: C
Explanation:
Explanation
https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design-patterns/
"EA uses the user ID as the partition key and primary key (a 1:1 modeling pattern)."
https://aws.amazon.com/blogs/database/choosing-the-right-dynamodb-partition-key/
"Partition key and sort key: Referred to as a composite primary key, this type of key is composed of two attributes. The first attribute is the partition key, and the second attribute is the sort key."
NEW QUESTION 125
A software-as-a-service (SaaS) company is using an Amazon Aurora Serverless DB cluster for its production MySQL database. The DB cluster has general logs and slow query logs enabled. A database engineer must use the most operationally efficient solution with minimal resource utilization to retain the logs and facilitate interactive search and analysis.
Which solution meets these requirements?
- A. Use Amazon CloudWatch Logs Insights to search and analyze the logs when the logs are automatically uploaded by the DB cluster.
- B. Download the logs from the DB cluster and store them in Amazon S3 by using manual scripts. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.
- C. Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.
- D. Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Elasticsearch Service (Amazon ES) and Kibana to search and analyze the logs.
Answer: A
Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/aurora-serverless-logs-enable-view/
https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/AnalyzingLogData.html
NEW QUESTION 126
A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.
Which AWS services should the Database Specialist consider? (Choose two.)
- A. Amazon Redshift
- B. Amazon Elasticsearch Service
- C. Amazon DynamoDB
- D. Amazon Neptune
- E. Amazon ElastiCache
Answer: C,E
NEW QUESTION 127
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 provisioned capacity mode
- B. Create an Amazon DocumentDB cluster
- C. Create an Amazon Aurora Serverless DB cluster
- D. Create an Amazon DynamoDB table with on-demand capacity mode
Answer: D
Explanation:
Reference:
Key-value database -> DynamoDB Capable of dealing with unexpected application traffic -> on-demand capacity mode A key-value database is a type of nonrelational database that uses a simple key-value method to store data. A key-value database stores data as a collection of key-value pairs in which a key serves as a unique identifier. On-demand mode is a good option to create new tables with unknown workloads. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.ReadWriteCapacityMode.html#HowItWorks.OnDemand
NEW QUESTION 128
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?
- A. Create a new encrypted DB instance. Perform an initial data load, and set up logical replication between the two DB instances When the new DB instance is in sync with the source DB instance, update the endpoint that is used by the application. Delete the unencrypted DB instance.
- B. Convert the DB instance to an Amazon Aurora DB cluster, and enable encryption. When the DB cluster is available, update the endpoint that is used by the application to the cluster endpoint. Delete the unencrypted DB instance.
- C. Create a read replica of the DB instance, and enable encryption. When the read replica is available, promote the read replica and update the endpoint that is used by the application. Delete the unencrypted DB instance.
- D. Take a snapshot of the DB instance. Make an encrypted copy of the snapshot. Restore the encrypted snapshot. When the new DB instance is available, update the endpoint that is used by the application. Delete the unencrypted DB instance.
Answer: A
Explanation:
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/encrypt-an-existing-amazon-rds-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.
NEW QUESTION 129
A company has a production environment running on Amazon RDS for SQL Server with an in-house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries.
How should the company identify the source of the problem?
- A. Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.
- B. Create a support request and work with AWS Support to identify the source of the issue.
- C. Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
- D. Use AWS X-Ray deployed with Amazon RDS to track query system traces.
Answer: C
NEW QUESTION 130
A company is developing a new web application. An AWS CloudFormation template was created as a part of the build process.
Recently, a change was made to an AWS::RDS::DBInstance resource in the template. The CharacterSetName property was changed to allow the application to process international text. A change set was generated using the new template, which indicated that the existing DB instance should be replaced during an upgrade.
What should a database specialist do to prevent data loss during the stack upgrade?
- A. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack.
- B. Create a snapshot of the DB instance. Update the stack. Restore the database to a new instance.
- C. Modify the stack policy using the aws cloudformation update-stack command and the set-stack-policy command, then make the DB resource protected.
- D. Deactivate any applications that are using the DB instance. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack and reactivate the applications.
Answer: D
NEW QUESTION 131
A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and a MySQL database that is hosted in Amazon RDS.
After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company's database team needs to configure the database to require in-transit encryption for all connections.
Which solution will meet this requirement?
- A. Connect to the database, and use ALTER USER to enable the REQUIRE SSL option on the database user.
- B. Update the DB instance, and enable the Require Transport Layer Security option.
- C. Update the parameter group in use by the DB instance, and set the require_secure_transport parameter to ON.
- D. Update the security group in use by the DB instance, and remove port 80 to prevent unencrypted connections from being established.
Answer: C
Explanation:
https://aws.amazon.com/about-aws/whats-new/2022/08/amazon-rds-mysql-supports-ssl-tls-connections/
NEW QUESTION 132
A gaming company uses Amazon Aurora Serverless for one of its internal applications. The company's developers use Amazon RDS Data API to work with the Aurora Serverless DB cluster. After a recent security review, the company is mandating security enhancements. A database specialist must ensure that access to RDS Data API is private and never passes through the public internet.
What should the database specialist do to meet this requirement?
- A. Modify the Aurora Serverless cluster by selecting a VPC with private subnets.
- B. Create an interface VPC endpoint that uses AWS PrivateLink for RDS Data API.
- C. Create a gateway VPC endpoint for RDS Data API.
- D. Modify the Aurora Serverless cluster by unchecking the publicly accessible option.
Answer: B
Explanation:
https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-data-api-now-supports-aws-privatelink/
NEW QUESTION 133
A company has an application that uses an Amazon DynamoDB table to store user dat a. Every morning, a single-threaded process calls the DynamoDB API Scan operation to scan the entire table and generate a critical start-of-day report for management. A successful marketing campaign recently doubled the number of items in the table, and now the process takes too long to run and the report is not generated in time.
A database specialist needs to improve the performance of the process. The database specialist notes that, when the process is running, 15% of the table's provisioned read capacity units (RCUs) are being used.
What should the database specialist do?
- A. Set the Limit and Offset parameters before every call to the API.
- B. Use four threads and parallel DynamoDB API Scan operations.
- C. Enable auto scaling for the DynamoDB table.
- D. Double the table's provisioned RCUs.
Answer: B
NEW QUESTION 134
A business is transferring its on-premises database workloads to the Amazon Web Services (AWS) Cloud. A database professional migrating an Oracle database with a huge table to Amazon RDS has picked AWS DMS.
The database professional observes that AWS DMS is consuming considerable time migrating the data.
Which activities would increase the pace of data migration? (Select three.)
- A. Enable an Amazon RDS Multi-AZ configuration.
- B. Increase the capacity of the AWS DMS replication server.
- C. Configure the AWS DMS replication instance with Multi-AZ.
- D. Create multiple AWS DMS tasks to migrate the large table.
- E. Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.
- F. Establish an AWS Direct Connect connection between the on-premises data center and AWS.
Answer: B,D,F
Explanation:
Explanation
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.LOBSupport.html
NEW QUESTION 135
A company is migrating a mission-critical 2-TB Oracle database from on premises to Amazon Auror a. The cost for the database migration must be kept to a minimum, and both the on-premises Oracle database and the Aurora DB cluster must remain open for write traffic until the company is ready to completely cut over to Aurora.
Which combination of actions should a database specialist take to accomplish this migration as quickly as possible? (Choose two.)
- A. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS Kinesis Data Firehose stream to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.
- B. Use Oracle's Data Pump tool to export a copy of the source database schema and manually edit the schema in a text editor to make it compatible with Aurora.
- C. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Select the migration type to replicate ongoing changes to keep the source and target databases in sync until the company is ready to move all user traffic to the Aurora DB cluster.
- D. Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema. Then restore the converted schema to the target Aurora DB cluster.
- E. Create an AWS Glue job and related resources to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS DMS task to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.
Answer: A,D
NEW QUESTION 136
......
Free AWS-Certified-Database-Specialty Exam Braindumps Amazon Pratice Exam: https://www.passtestking.com/Amazon/AWS-Certified-Database-Specialty-practice-exam-dumps.html
Valid AWS-Certified-Database-Specialty FREE EXAM DUMPS QUESTIONS & ANSWERS: https://drive.google.com/open?id=1RCwf9skFZRaMUBhVvq1_faSd8Io4hREg