Question 1

Write a Python function to check if a string is a palindrome.

Accepted Answer

**Architectural logic**: A palindrome reads the same forwards and backwards. We need to normalize (case, non-alphanumeric) and compare. **Approach 1 (string ops)**: `cleaned = "".join(c.lower() for c in s if c.isalnum()); return cleaned == cleaned[::-1]`—O(n) time, O(n) space. **Approach 2 (two-pointer)**: Compare from both ends; O(n) time, O(1) space if not normalizing....

Question 2

How would you configure workload management (WLM) queues for heavy queries?

Accepted Answer

**WLM:** Separate queue for heavy queries—higher concurrency or memory. Query groups to route. Timeout. Priority for critical. **Redshift:** wlm_json; multiple queues. **Why:** Isolate workload. **Production:** Monitor queue wait....

Question 3

How would you decide between using DISTKEY and SORTKEY?

Accepted Answer

**DISTKEY:** Distribution; co-locate rows. Choose join/filter column. **SORTKEY:** Order in partition; range queries; compression. **Best:** DISTKEY on join; SORTKEY on range. **Example:** fact DISTKEY date, SORTKEY (date, user_id)....

Capco Python Interview Questions

Companies asking these questions

All 3 Questions

More Interview Prep Guides

Get All Answers in PDF Format

Capco Python Interview Questions

Companies asking these questions

All 3 Questions

More Interview Prep Guides

Get All Answers in PDF Format