A company has a data warehouse that contains a table that is named Sales.

Vendor: Amazon Web Services
Product: Data-Engineer-Associate
Update on: Jul 20, 2025
Questions: 187

Amazon Web Services Data-Engineer-Associate Question Answer

A company has a data warehouse that contains a table that is named Sales. The company stores the table in Amazon Redshift The table includes a column that is named city_name. The company wants to query the table to find all rows that have a city_name that starts with "San" or "El."

Which SQL query will meet this requirement?

Select * from Sales where city_name - '$(San|EI)";

Select * from Sales where city_name -, ^(San|EI) *';

Select * from Sales where city_name - '$(San&EI)";

Select * from Sales where city_name -, ^(San&EI)";