Redshift Immersion Day

Which of the following statements about Redshift are incorrect?

• Redshift is a columnar database

• Redshift offers seamless integration with AWS services such as S3, Kinesis, IAM, etc.

• Redshift is the most popular cloud data warehouse

• None of the above

Which of the following is the recommended method for loading large volumes of data into Redshift?

• BULK INSERT

• COPY command

• LOAD command

• None of the above

Which of the following statements is true about Redshift Advisor?

• This is a preview feature that is expected to be generally available in one year

• This is accessible only as part of the AWS API

• This feature requires a special subscription

• This machine-learning based feature is freely available to all customers in their Redshift console

Which of the following are correct about Elastic resize?

• Typically takes 60-90 minutes for the cluster to be available

• Allows you to change your cluster size to/from 4 dense-compute nodes to 8 dense-compute nodes

• Allows you to pause & resume your Redshift cluster

• It’s the other name for concurrency scaling

Redshift supports the automatic scaling of compute capacity based on user workloads?

• True

• False

Redshift Spectrum is a feature of Redshift that allows users to query external tables in an S3 data lake similar to how local tables are queried via SQL?

• True

• False

Which of following use cases are applicable for Redshift?

• Real-time streaming persistence

• Reporting

• Analytics Warehouse

• Data Lake Analytics

• All of the above

Which of the following features reduce the effort required to manage a Redshift cluster?

• Auto Table Maintenance (Analyze, Vacuum)

• Concurrency Scaling

• Auto-Backup

• Auto Workload Management

• All of the above

Which of the following play a significant role for query performance in Redshift?

• Sort Keys, Distribution Style, and Data Compression

• Machine Learning

• Concurrency Scaling

• Auto Workload Management

• All of the above

Redshift Query Editor is a web-based querying tool available in the Redshift console that enables users to execute SQL queries on their Redshift cluster without setting up a JDBC driver?

• True

• False