Interview Query

Data Engineer | May 2020

Company: captec

Position: Data Engineer

Location: San Francisco Bay Area, CA

Level: nan

Outcome: Techncal Screen Rejected

How was the interview process? What was it like?

na

What technical questions were asked?

SQL / Pandas, Business Case and Estimation, Modeling and ML knowledge

What was one of your solutions?

The UNION operator combines and returns the result-set retrieved by two or more SELECT statements.
The MINUS operator in SQL is used to remove duplicates from the result-set obtained by the second SELECT query from the result-set obtained by the first SELECT query and then return the filtered results from the first.
The INTERSECT clause in SQL combines the result-set fetched by the two SELECT statements where records from one match the other and then returns this intersection of result-sets.

0 Comments

Sort By: Default

Edit Post

Tag your post (e.g. "Amazon", "Data Scientist" ...)

Preview