Interview Prep Hub

A clustered index determines the physical order of data rows in a database table. Because of this, a table can only have one clustered index. A non-clustered index is stored in a separate structure from the actual table data, acting as a pointer system (like an index at the back of a textbook). Tables can have multiple non-clustered indexes.

A CI/CD pipeline automates integration, testing, build phases, and deployment. This prevents human deployment errors, ensures tests are run on every commit, speeds up feedback loops, and guarantees consistent server configuration setups across environments.

1. Triage the alert to confirm it isn't a known false positive. 2. Scope the affected assets and user accounts involved. 3. Correlate timestamps across event sources (e.g. login attempts, firewall packets). 4. Isolate systems if active malware/exfiltration is discovered. 5. Document incident details and update detection rules.