What are key differences between sql server and amazon redshift?
Answer / Rupali Sharma
Key differences include the architecture (Redshift uses column-oriented storage, SQL Server uses row-oriented), scalability (Redshift can scale horizontally by adding nodes, SQL Server mainly scales vertically), data types (Redshift does not support all SQL Server data types), and pricing model (Redshift is pay-as-you-go, SQL Server has various licensing options).
| Is This Answer Correct ? | 0 Yes | 0 No |
What are cluster in redshift?
How we can scale Reshift database?
Can we access the compute node of Redshift directly ?
What is Redshift Spectrum?
Is redshift can be used with AWS RDS?
Is AWS redshift is one of the RDS in AWS or is it Relation Database?
Why AWS redshift is named after Redshift?
How many types of nodes supported by Redshift and what are the functions of nodes?
How to stop/start redshift cluster?
What’s the use AWS redshift cluster Service?
What are the limitations of amazon redshift?
What problems have you faced while working with amazon redshift?