Q21. How do you handle missing data in an analysis?
First understand why data is missing, because the mechanism determines the right approach. - MCAR: missing completely at random, safe to drop rows with a small loss of po...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (142 available).
Active:
Tag: data ×
Q22. How do you handle late-arriving data in a pipeline?
Late data breaks the assumption that all events for a time window have arrived. Common strategies: - Watermarks: define how long to wait for late events before closing a ...
Q23. How do you handle metadata and SEO in the App Router?
You export a static metadata object or a generateMetadata async function from a layout or page. It can set title, description, canonical URL, Open Graph, Twitter cards an...
Q24. What are the possible values for a BOOLEAN field in MySQL?
MySQL doesn't have a native `BOOLEAN` type. It uses `TINYINT(1)` where `0` = false, `1` = true, and any non-zero value is treated as true in conditions. ```sql CREATE TAB...
Q25. How do you enforce data quality in a data pipeline?
Data quality checks should run as first-class pipeline steps, failing or quarantining bad data rather than silently loading it. Dimensions to test: - Completeness: no une...
Q26. Why does each microservice need its own database?
Owning its data is what makes a service independently deployable. With a shared database, a schema change in one service can break another, teams coordinate releases, and...
Q27. What are the different types of data binding in Angular?
Angular has several binding forms. Interpolation {{ value }} renders a component property into text. Property binding [property]="expr" sets a DOM property or directive i...
Q28. Which data type for distance rounded to the nearest mile?
When storing distance rounded to the nearest whole mile, an **integer data type** is the optimal choice: ```sql ALTER TABLE travel_logs ADD COLUMN distance_miles INT NOT ...
Q29. How do you keep your CRM data accurate and useful?
Accurate CRM data is what makes forecasting and handovers possible, so I treat updating it as part of the work, not as admin. After every call I log the key points within...
Q30. What does idempotency mean in data pipelines and why does it matter?
An idempotent operation produces the same result whether it runs once or many times. Pipelines retry on failure, run backfills and get replayed, so non-idempotent logic c...