Salesforce Interview Questions (13+ Questions)

Fix Secret mounting issues by properly configuring Secret volumes in pod specs. Mount secrets as files at /etc/creds/token, ensure correct file permissions, and enable applications to read decoded credential values. Essential for credential management, sensitive data protection, application authentication, and secure credential injection into containerized applications.

Learn how to create a Kubernetes Service that exposes multiple ports simultaneously. Configure a single Service resource to handle traffic on port 80 and port 8080, routing requests to pods using label selectors. Practice defining named ports and proper port mappings for applications serving multiple endpoints.

def network_delay_time(times: list[list[int]], n: int, k: int) -> int:
adj = defaultdict(list)
for u, v, w in times:
adj[u].append((v, w))

min_heap = [(0, k)]
visited = set()
total_time = 0

while min_heap:
    time, node = heapq.heappop(min_heap)
    
    if node in visited:
        continue
        
    visited.add(node)
    total_time = time
    
    for neighbor, weight in adj[node]:
        if neighbor not in visited:
            heapq.heappush(min_heap, (time + weight, neighbor))
            
return total_time if len(visited) == n else -1

Objective: SQL Query to Identify Overlapping Work Shifts for Employees

In this interview question, the task is to write an SQL query that identifies overlapping work shifts for employees on the same day. Your solution should return the employee IDs, shift dates, start and end times of their shi...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

SQL Query to Retrieve Customer Order Information

Objective

Write an SQL query that retrieves each customer's name, the number of orders they have placed, and the total amount they have spent. If a customer has not placed any orders, their order count should be 0 and their total spent shoul...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Join three DataFrames and create a combined customer name column.

We need to write a query to filter funded startups. This is a Snowflake question. Snowflake is a cloud-based data warehouse that simply uses SQL. We are given two tables, investors and startups. Our job is to find investors whose average funding across all their startups is strictly greater than their personal funding limit. Those cases when limit equals to average funding needs to be excluded. The output should include three columns: investor name, its ID, and average funding number. We are more interested in inner join because it returns only the rows where there is a match in both tables. Within funding column from startups table, we implement average and round functions. Since we need to find the average number for each of the investing companies separately, we need to use a GROUP BY clause. We will put a condition inside of HAVING clause that works with groups and filters them. We can't use WHERE clause for the condition because there is a strict rule that WHERE clause can only come before GROUP BY clause, not after.

WITH
weekly_touches AS (
SELECT DISTINCT
contact_id,
DATE_TRUNC('week', touch_date)::DATE AS week_start
FROM
marketing_touches
),
streaks AS (
SELECT
contact_id,
week_start - (
ROW_NUMBER() OVER (
PARTITION BY
contact_id
ORDER BY
week_start
) * 7
)::INT AS grp
FROM
weekly_touches
)
SELECT DISTINCT
m.email
FROM
marketing_touches m
WHERE
m.contact_id IN (
SELECT
contact_id
FROM
streaks
GROUP BY
contact_id,
grp
HAVING
COUNT(*) >= 3
)
AND m.contact_id IN (
SELECT DISTINCT
contact_id
FROM
marketing_touches
WHERE
touch_type = 'trial_request'
)
ORDER BY
m.email;

Collect data from all pages of a paginated REST API endpoint and combine the results into a single CSV file using Python requests and pandas.

In the realm of SQL queries, calculating weekly page views and the corresponding week-over-week growth percentage is a common yet essential task for data analysts who are striving to measure website performance over time. This type of analysis helps in identifying trends, understanding user behavior...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

How to Tackle the SQL Query Interview Question: Finding Top 3 Categories with Highest Average Price of Their Products

In this guide, we’ll delve into a common interview question for SQL roles. The aim is to write an SQL query that identifies the top 3 categories with the highest average price o...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Master image verification testing with Selenium. Learn basic image finding and broken image detection for beginners....

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Master element property checking with Selenium. Learn basic property validation and existence testing for beginners....

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →