Autodesk Interview Questions (4+ Questions)

We have a deployment workflow with two jobs, staging and production. The problem here is that both the jobs run automatically on every push in parallel, without any ordering. That means that unstable code could hit the production before staging even finishes. We need to fix this so that the staging stage runs first, and production only runs after staging succeeds and requires approval. By default, jobs in GitHub Actions workflow run in parallel. The needs keyword here will create a dependency between the jobs. If we say that job B needs job A, then job B won't start until and unless job A has completed successfully. An environment in GitHub Actions is a named deployment target that have protection rules attached to it. It will enforce rules like requiring manual approval from specific team members. Needs will ensure that we get the right order, and environment will add an additional gate which someone has to approve.

We have two services, web server and API server, and we need to create health checks for those services. If we create health checks in Route 53, that health check will periodically request the health of that server and store it in its database. Before DNS resolver responds to us with IP address, it checks with the database of the Route 53 Health Check to see if this endpoint is healthy or not. If it's healthy, it'll point us to our primary endpoint. If not, we'll be pointed to the failover endpoint, a secondary endpoint that we will configure. By using Health Check, we could be confident that our user will always end up at the working website instead of receiving an error. Additionally, health checks could be used to publish some data about that endpoint and that data could be pushed to the CloudWatch. Go to Route 53, open a menu here and select health checks. This is an Endpoint health check. You need to click Advanced Configurations to fill details that are provided in the table of the question.

Objective

In a SQL interview, you might be tasked with demonstrating your SQL querying skills. One common question is: How would you write a query to retrieve each product's name and its profit, formatted as a string with exactly two decimal places, from a sales table? The results should only ...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →