Data Warehousing on AWS Training Data Warehousing on AWS: Trends, Network And Critical Thinking 2

Question 1

A company wants to isolate their Amazon Redshift cluster from the public internet. Which networking approach should they use?

Accepted Answer

Deploy the cluster in a VPC with private subnets and no internet gateway route

Answer

Deploying Redshift in a VPC with private subnets and no internet gateway route ensures the cluster is inaccessible from the public internet.

Question 2

Which Redshift feature forces all COPY and UNLOAD traffic to flow through the VPC rather than over the public internet?

Accepted Answer

Enhanced VPC Routing

Answer

Enhanced VPC Routing forces all data traffic between Redshift and Amazon S3 (or other services) to travel through the VPC, enabling VPC security controls.

Question 3

A data warehouse team notices their ETL jobs are slow due to network latency between their EC2 ETL servers and Redshift. What is the most effective network optimization?

Accepted Answer

Place EC2 instances and Redshift in the same Availability Zone within the same VPC

Answer

Co-locating EC2 ETL servers and Redshift in the same AZ within the same VPC minimizes network latency by avoiding cross-AZ data transfer.

Question 4

Modern data warehousing on AWS increasingly separates compute from storage. Which Redshift node type is designed specifically to support this architecture?

Accepted Answer

ra3.xlplus

Answer

RA3 nodes decouple compute and storage by using Redshift Managed Storage (RMS) backed by S3, allowing independent scaling of each layer.

Question 5

A company must ensure that data transferred between their on-premises systems and Amazon Redshift is encrypted in transit. Which approach satisfies this requirement?

Accepted Answer

Enable SSL/TLS on the Redshift cluster JDBC/ODBC connection

Answer

Enabling SSL/TLS on JDBC/ODBC connections encrypts data in transit between client applications and the Redshift cluster.

Data Warehousing on AWS Training Practice Test

Data Warehousing on AWS Training Practice Test

Data Warehousing on AWS Training Data Warehousing on AWS: Trends, Network And Critical Thinking 2