18 Project Questions on Software, Data, Cloud and Marketing

These examples cover decisions that come up while building software, analyzing data or running a campaign.

Python Full Stack

How do I keep Django secrets out of Git?

Read secrets from environment variables or a secret manager. Commit only a sample configuration with placeholder values.

How do I handle a missing object in a Django view?

Use get_object_or_404 when a missing record should produce an HTTP 404. Apply ownership filters before looking up private records.

What is a Django QuerySet?

It represents a database query that you can refine with methods such as filter and order_by. Many QuerySets run only when you evaluate them.

Java Full Stack

What does Optional represent in Java?

It represents a value that may be absent. Use methods such as orElse or orElseThrow to handle absence deliberately.

What does HTTP 409 mean in an API?

It means the request conflicts with the current resource state. For example, an API might return it when a client tries to create a username that already exists.

Why use a service layer in Spring Boot?

It holds business operations that may be called from more than one controller. It also gives you a place to define the transaction boundary for an operation.

Data Analytics

What is a SQL common table expression?

A CTE names a query result within one statement using WITH. You can use it to split a long calculation into readable steps.

How should I report a percent change from zero?

The standard percent change formula divides by the starting value, so it is undefined when the start is zero. Show the absolute change or label the percentage unavailable.

Why reconcile counts before building a dashboard?

Comparing row counts and totals after each major step helps catch dropped records and inflated joins before they affect the report.

Data Science

What is the difference between a parameter and a hyperparameter?

The model learns parameters during fitting. Hyperparameters, such as a tree depth limit, configure the learning process and can be chosen using validation data.

What is regularization used for?

It constrains or penalizes model complexity to improve performance on unseen data. Choose its strength using validation results.

What is a residual in regression?

A residual is the observed value minus the predicted value for a fitted model. Plot residuals to see whether errors show a pattern.

Cloud AWS and DevOps

Why use a load balancer for a web app?

It distributes requests across healthy backends. This lets you replace or scale individual servers while keeping a stable entry point.

What does a Kubernetes readiness probe check?

It checks whether a container is ready to receive traffic. Kubernetes can remove an unready Pod from the set of Service endpoints available for normal traffic.

What is a rollback in deployment?

A rollback restores a prior release after a problem. Plan for database compatibility before deploying changes that may be hard to reverse.

Digital Marketing

What is a search query in Search Console?

It is a search term associated with your site’s appearance in Google Search. Review its impressions, clicks and position over a consistent date range.

How can I compare click-through rates fairly?

Compare similar queries and pages over comparable periods. Changes in ranking, device mix and branded searches can affect the rate.

What does cost per click tell me?

It shows average ad spend per click. Compare it with conversion rate and lead quality to understand whether the traffic is useful.

Start with the beginner Q&A guide for the fundamentals.