A Company Wants to Migrate a 30 TB Oracle Data

question 262

Multiple Choice

A company wants to migrate a 30 TB Oracle data warehouse from on premises to Amazon Redshift. The company used the AWS Schema Conversion Tool (AWS SCT) to convert the schema of the existing data warehouse to an Amazon Redshift schema. The company also used a migration assessment report to identify manual tasks to complete. The company needs to migrate the data to the new Amazon Redshift cluster during an upcoming data freeze period of 2 weeks. The only network connection between the on-premises data warehouse and AWS is a 50 Mbps internet connection. Which migration strategy meets these requirements?

• A) Create an AWS Database Migration Service (AWS DMS) replication instance. Authorize the public IP address of the replication instance to reach the data warehouse through the corporate firewall. Create a migration task to run at the beginning of the fata freeze period.
• B) Install the AWS SCT extraction agents on the on-premises servers. Define the extract, upload, and copy tasks to send the data to an Amazon S3 bucket. Copy the data into the Amazon Redshift cluster. Run the tasks at the beginning of the data freeze period.
• C) Install the AWS SCT extraction agents on the on-premises servers. Create a Site-to-Site VPN connection. Create an AWS Database Migration Service (AWS DMS) replication instance that is the appropriate size. Authorize the IP address of the replication instance to be able to access the on-premises data warehouse through the VPN connection.
• D) Create a job in AWS Snowball Edge to import data into Amazon S3. Install AWS SCT extraction agents on the on-premises servers. Define the local and AWS Database Migration Service (AWS DMS) tasks to send the data to the Snowball Edge device. When the Snowball Edge device is returned to AWS and the data is available in Amazon S3, run the AWS DMS subtask to copy the data to Amazon Redshift.

Comprehend the conceptual difference between regression and correlation analysis and their respective applications.

Understand the impact of perceived control on stress and well-being.

Comprehend the physiological and psychological stress responses, including the fight-or-flight reaction.

Identify types of coping mechanisms and their relevance in stress management.

---

Definitions:

Time Utilities

The value added to products or services by making them available when they are needed or wanted by consumers.

Place Utilities

The value added to products by having them available at locations where they are needed or wanted by consumers.

Performance Expectations

The anticipated level of performance or outcome that individuals or organizations aim to achieve.

Purchasing Manager

A professional responsible for overseeing the acquisition of goods and services for their organization, ensuring both quality and cost-effectiveness.