Q: Left Join to Include All Records

SELECT c.customer_name, COUNT(o.order_id) AS order_count, COALESCE(SUM(o.order_amount), 0) AS total_spent FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id GROUP BY c.customer_name ORDER BY c.customer_name;... --- **🔒 Premium Content** This is a premium question with detailed explanations, step-by-step solutions, and additional insights. Upgrade to access the complete solution and advanced techniques. [Upgrade to Premium →](/premium)

Q: CRM Order Details

Join three DataFrames and create a combined customer name column.

Q: Filter Funded Startups

SELECT i.investor_id, i.investor_name, ROUND(AVG(s.funding), 2) AS avg_funding FROM {{ ref("investors") }} i INNER JOIN {{ ref("startups") }} s ON i.investor_id = s.investor_id GROUP BY i.investor_id, i.investor_name, i.funding_limit HAVING AVG(s.funding) > i.funding_limit

Question 1

Pod Failing Secret Mount

Accepted Answer

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.

Question 2

Multi-Port Service

Accepted Answer

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.

Question 3

Network Delay Time

Accepted Answer

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

Question 4

Overlapping Shift Detector

Accepted Answer

SELECT DISTINCT a.employee_id, a.shift_date, a.start_time, a.end_time, b.start_time AS overlapping_start, b.end_time AS overlapping_end FROM schedules a JOIN schedules b ON a.employee_id = b.employee_id AND a.shift_date = b.shift_date AND a.shift_id < b.shift_... --- **🔒 Premium Content** This is a premium question with detailed explanations, step-by-step solutions, and additional insights. Upgrade to access the complete solution and advanced techniques. [Upgrade to Premium →](/premium)

Question 5

Left Join to Include All Records

Accepted Answer

SELECT c.customer_name, COUNT(o.order_id) AS order_count, COALESCE(SUM(o.order_amount), 0) AS total_spent FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id GROUP BY c.customer_name ORDER BY c.customer_name;... --- **🔒 Premium Content** This is a premium question with detailed explanations, step-by-step solutions, and additional insights. Upgrade to access the complete solution and advanced techniques. [Upgrade to Premium →](/premium)

Question 6

CRM Order Details

Accepted Answer

Join three DataFrames and create a combined customer name column.

Question 7

Filter Funded Startups

Accepted Answer

SELECT
i.investor_id,
i.investor_name,
ROUND(AVG(s.funding), 2) AS avg_funding
FROM {{ ref("investors") }} i
INNER JOIN {{ ref("startups") }} s
ON i.investor_id = s.investor_id
GROUP BY i.investor_id, i.investor_name, i.funding_limit
HAVING AVG(s.funding) > i.funding_limit

Question 8

Consecutive Marketing Touches

Accepted Answer

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;

Question 9

Fetch and Combine Data from Paginated API Endpoint

Accepted Answer

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.

Question 10

Weekly Web Traffic Growth Query

Accepted Answer

WITH WeeklyStats AS ( SELECT date_trunc('week', date) AS week, SUM(page_views) AS total_views FROM TrafficStats GROUP BY date_trunc('week', date) ) SELECT curr.week, curr.total_views AS current_week_views, pr... --- **🔒 Premium Content** This is a premium question with detailed explanations, step-by-step solutions, and additional insights. Upgrade to access the complete solution and advanced techniques. [Upgrade to Premium →](/premium)

Question 11

Distinct Product Classification Count

Accepted Answer

WITH ProductStats AS ( SELECT category, COUNT(DISTINCT subcategory) AS subcategory_count, AVG(price) AS avg_price FROM products WHERE discontinued = FALSE GROUP BY category ), RankedCa... --- **🔒 Premium Content** This is a premium question with detailed explanations, step-by-step solutions, and additional insights. Upgrade to access the complete solution and advanced techniques. [Upgrade to Premium →](/premium)

Question 12

Image Attribute Verification

Accepted Answer

def test_image_verification(search_term): driver, wait = create_webdriver() driver.get('https://the-internet.herokuapp.com/broken_images') # Find all images images = driver.find_elements(By.TAG_NAME, 'img') total_images = len(images) # Look for image containing sear... --- **🔒 Premium Content** This is a premium question with detailed explanations, step-by-step solutions, and additional insights. Upgrade to access the complete solution and advanced techniques. [Upgrade to Premium →](/premium)

Question 13

Element Property Checking

Accepted Answer

def test_property_check(property_name): driver, wait = create_webdriver() driver.get('https://the-internet.herokuapp.com/login') # Find username input and check property username_input = driver.find_element(By.ID, 'username') property_value = username_input.get_property(prop... --- **🔒 Premium Content** This is a premium question with detailed explanations, step-by-step solutions, and additional insights. Upgrade to access the complete solution and advanced techniques. [Upgrade to Premium…

Salesforce Interview Questions (13+ Questions)

Table of Contents

💡 Pro Tips for Salesforce Interviews

Interview Questions & Answers

1. Pod Failing Secret Mount

2. Multi-Port Service

3. Network Delay Time

4. Overlapping Shift Detector

Objective: SQL Query to Identify Overlapping Work Shifts for Employees

5. Left Join to Include All Records

SQL Query to Retrieve Customer Order Information

Objective

6. CRM Order Details

7. Filter Funded Startups

8. Consecutive Marketing Touches

9. Fetch and Combine Data from Paginated API Endpoint

10. Weekly Web Traffic Growth Query

11. Distinct Product Classification Count

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

12. Image Attribute Verification

13. Element Property Checking

Ready to Practice More?