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.

You have a controller, certain operator that manages resources in Kubernetes and you'd like to have a custom resource called widget. In order to apply this custom resource widget, you need to create a custom resource definition. Otherwise, you cannot apply something that is beyond known resources of Kubernetes. Our task is to create a custom resource definition and define group as my company io. The kind is going to be widget and the scope will be namespaced. The namespace scope means that we will apply this widget specifically inside the namespace. The version will be named v1, and then we'll need to create a custom resource of this type named simple widget in the extensions namespace. API version will be apiextensions.k8s.io kind custom resource definition. In the spec, we will type the group name, version, the name, scope, and names, plural widgets, singular widget, kind widget and short name is wd.

We'll write a query to calculate median salary for each job title. When all salaries are sorted in ascending order, the median value will be the one that is in the middle of them. If there is an even number of salaries, we take the average of the two middle values. A CTE is a temporary result set in SQL that you can reference within a single query. A window function performs a calculation across multiple rows while keeping every single row in the result. Inside of the window function, we are using partition by job title. Partition by divides the data into separate groups, and count will run independently inside each of these groups. We use row number that simply assigns a sequential number to each row. These formulas calculate the median position so that we know which row number represents the middle one. If the number of rows is an odd number, both of the formulas will give the same result. Using round function and double column numeric, we will convert the results to numeric type and then clean everything up to two decimal places.

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 →