NEW
Font size
WorksheetsRedshift Immersion Day
Total questions: 10
Worksheet time: 5mins
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
