Accenture Interview Questions (10+ Questions)

We have a Docker file under this directory that builds a Python web app with extensive capabilities. That means that it runs as root user with UID zero and it has extensive Linux capabilities. It violates the principle of lease privilege and in most of the production environments that sort of Docker files needs to be hardened. We will create a non route user called app user and we'll also create a group for this user. We'll use this user by default, which will mean that once we harden the stocker container, the user won't be able to install packages. We'll use ID command, which will print us information about current user, but we'll execute this command inside Docker container. We create group with app user and ID that we've been asked. We create user, we add user to this group, then we give ownership of slash app directory where our app is located to this user. And then we switch to app user by default. We reduce privilege while maintaining full functionality of our application.

When we build our container from this file, it builds it in architecture of our host system. Our task is to change the setup to build it in multiple architectures. We'll use Docker build with an instance named Multi Arc and we will use buildx create. We'll list current builders by typing Docker buildx ls. We have only default that builds it in our current platform's underlying os. So add new builder. Docker buildx create and then name multi arc. Then we use driver network host and then use to have it as default builder. Now attempt to build for our multi architecture setup. We'll run Docker buildx build. Verify this by typing Docker images.

Create Kubernetes Namespace: Set Up an Isolated Environment for Application Workloads. Establish an isolated Kubernetes environment by creating a dedicated namespace for experimentation and application workloads. This improves cluster organization, enables cleaner multi-tenant setups, and lays the foundation for applying scoped RBAC, resource quotas, and policies per environment.

A common issue in containerized environments is when we are out of memory and our container gets killed. In this example we have a pod named OOM Demo. It has been killed by OOMKilled error. We'll do kubectl get pod oom demo in the namespace app and we will search by output that says last state terminated reason and reason is OOMKilled. We can try another way by typing describe, kubectl describe pods in namespace apps. Usually this means that we don't have enough memory. We see that limits memory is 20 megabytes. The question asks us to increase this limit from 20 to a hundred so that application then can run comfortably within this limits. We'll get this pod oom demo in the namespace apps with output yaml and we will save this as oom fix yaml. Find the line that says 20 Mi and change this to a hundred. Apply won't work in this case because we cannot update limits and resources on the spot, we'll use kubectl replace command for this reason. We'll use kubectl replace, this is the name of the file and we'll use force to replace it forcefully.

We need to set up new admin account for regular user. We've been asked to create IAM user named DevOps admin with console password access, and then we need to add the user to the admin group, which should have administrator access policy attached. In AWS, we can attach policies meaning access rights to certain user via two ways. First, we can attach this policy directly to the user, but this won't be very efficient. Instead, in AWS, we can use what's called groups. We can create an admin group and then attach administrator access directly to this group. Once this is done, we need to tag this user with a key that's equal to role and the value is equal to DevOps. We use tag to easily identify users. First we need to go to the IAM. This is where we'll create users. We need to provide console access, which means that this user will be able to access not only via CLI but also via UI. The policy name was Administrator Access. We could see that the action is wildcard, meaning everything, effect is allow and resource is also wildcard.

This SQL question is called Average Order Value. We have one table that is called Orders. This table records customers' purchases and has four columns: orders ID, date of transaction, reference to the customer by ID, and total amount spent. Our job here is to calculate for each customer the average amount they spent across all their orders. In the end, the average value should be rounded to two decimal places. The output should include customer ID and average order value, sorted by ID in ascending order. We start with FROM clause. Then we proceed with GROUP BY clause that separates individual orders into groups for each customer. In order to choose specific columns from a particular table, we use SELECT clause. We wrap the total amount column with Average inside of Round function as first argument, and two number as two decimal places. Finally, we order by customer ID.

Objective

Write an SQL query that calculates the monthly sales for each product, the sales from the previous month, and the percentage growth in sales from the previous month to the current month. The result should include the month, product name, current month's sales, previous month's sales, ...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Crafting an SQL Query to Summarize Sales Representatives' Performance

Objective

To accurately evaluate and summarize the performance of sales representatives, construct an SQL query that generates a detailed report featuring the following key metrics:

1. Representative's Name
2. Region
   3....

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

SELECT
ROUND(
SUM(
CASE
WHEN call_category = 'n/a'
OR call_category IS NULL THEN 1
ELSE 0
END
)::DECIMAL / COUNT(*) * 100,
1
) AS uncategorised_pct
FROM
callers;

Oracle Database handles enterprise-critical data for thousands of organizations worldwide. QA testing of Database REST APIs requires comprehensive validation of SQL queries, schema operations, data updates, and performance statistics to ensure reliable data management systems....

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →