Activisionblizzard Interview Questions (6+ Questions)

Learn how to create an automated secret detection script using Linux Bash commands and pattern matching. This guide covers building validation logic, recursively scanning codebases for sensitive keywords, deduplicating results, and generating violation reports, essential for preventing credential leaks, enforcing security policies, and implementing pre-commit security checks in DevSecOps workflows.

Remediate accidental exposure of confidential information in unpushed Git commits by amending commit messages. Remove passwords, API keys, tokens, and sensitive data while preserving all file changes in a single commit. Use git commit --amend to update messages without creating new commits, verify clean history with git log, and prevent credential leaks before pushing to remote repositories. Essential for security hygiene, preventing secret exposure in version control, and following secure development practices.

Kubernetes API Extension & Custom Resources: widgets.mycompany.io extensions namespace. Extend the cluster's native capabilities by registering a new API resource type using CustomResourceDefinitions (CRDs). Challenge involves defining the API schema (Group, Version, Kind, Scope) and validating the extension by instantiating and managing a custom object (Widget) using standard kubectl commands. Essential for building Operators, defining platform-specific infrastructure, and creating domain-specific languages (DSLs) within Kubernetes.

Objective

To determine the median salary for each job title within a company, you need to write an SQL query that processes the data in the employees table. The median salary is defined as the middle value in a sorted list of salaries for each job title. If the number of salaries is even, the median is calculated as the average of the two middle numbers. The query should return a list of job titles along with their corresponding median salaries, rounded to two decimal places, and sorted in descending order of the median salary.

Additional Information:

• The employees table has the following schema:

  • id (INT): Unique identifier for each employee.
  • name (VARCHAR): Name of the employee.
  • job_title (VARCHAR): Job title of the employee.
  • salary (INT): Salary of the employee.

• Constraints:

  • The number of employees can range from 1 to 100,000.
  • Salary values are positive integers.

• Clarifications:

  • Ensure the median salary calculation is accurate based on the number of employees per job title.
  • Results should be sorted by median salary in descending order.
  • In case of a tie in median salary values, sort job titles alphabetically.

For example, if the table contains the following records:

The resulting table based on the median salary calculated should be:

This output is sorted first by the median salary in descending order and, in case of ties, alphabetically by job title.

This SQL query provides a critical insight into the compensation structure within the company, helping HR and management make data-driven decisions.

SQL Interview Question: Creating a Customer Age Group Purchase Summary Report

Objective

You have access to two tables: customer_demographics and purchases.

• The customer_demographics table contains details about customers, including their unique customer_id, age_group, `gender...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Objective

In this SQL query interview question, you are tasked with categorizing products based on their prices and stock availability. The classification of products will be done according to their Z-score, calculated using the average and standard deviation of prices of products that are cur...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →