Deloitte Power BI Developer Interview Questions and Answers for Experienced

Q1. What is the need of inactive relationship?
Add your answer
Q2. Explain various roles in power BI service
Add your answer

Q1. Sumx difference between sum
Ans. 
SUMX calculates the total of an expression evaluated for each row in a table, while SUM calculates the total of a column.
• SUMX is an iterator function in DAX that allows you to iterate over a table and perform calculations on each row.

• SUMX is commonly used to calculate a total based on a formula or expression applied to each row.

• SUM, on the other hand, simply calculates the total of a column without any iteration over r...read more
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

This test consists of two coding questions and some MCQ regarding computer fundamentals.

Q1. 
Kevin and His Cards Problem Statement
Kevin has two packs of cards. The first pack contains N cards, and the second contains M cards. Each card has an integer written on it. Determine two results: the tot...read more
Ans. 
Find total distinct card types and common card types between two packs of cards.
• Create a set to store distinct card types when combining both packs.

• Iterate through each pack and add card types to the set.

• Find the intersection of card types between the two packs to get common card types.
Answered by AI
Add your answer
Q2. 
Allocate Books Problem Statement
Given an array of integers arr, where arr[i] represents the number of pages in the i-th book, and an integer m representing the number of students, allocate all the books ...read more
Ans. 
Allocate books to students in a way that minimizes the maximum number of pages assigned to a student.
• Iterate through all possible allocations of books to students.

• Calculate the maximum number of pages assigned to a student for each allocation.

• Return the minimum of these maximums as the result.
Answered by AI
Add your answer

Round duration - 40 minutes
Round difficulty - Easy

It was a technical round that is based on DSA and computer fundamentals.

Q1. 
Reverse Linked List Problem Statement
Given a singly linked list of integers, return the head of the reversed linked list.
Example:
Initial linked list: 1 -> 2 -> 3 -> 4 -> NULL
Reversed link...read more
Ans. 
Reverse a singly linked list of integers and return the head of the reversed linked list.
• Iterate through the linked list and reverse the pointers to point to the previous node instead of the next node.

• Use three pointers - prev, current, and next to reverse the linked list in O(N) time and O(1) space complexity.

• Update the head of the reversed linked list as the last node encountered during the reversal process.
Answered by AI
Add your answer
Q2. 
Sort 0 1 2 Problem Statement
Given an integer array arr of size 'N' containing only 0s, 1s, and 2s, write an algorithm to sort the array.
Input:
The first line contains an integer 'T' representing the n...read more
Ans. 
Sort an array of 0s, 1s, and 2s in linear time complexity.
• Use three pointers to keep track of 0s, 1s, and 2s while traversing the array.

• Swap elements based on the values encountered to sort the array in-place.

• Time complexity should be O(N) and space complexity should be O(1).
Answered by AI
Add your answer

1. One question was given to be solved in 1 hour. Question was medium level based on strings.

Q1. 1. 1:1 interview, mostly discussion around OOPS concepts and some basic dynamic programming questions.
Add your answer

1. 3 questions were given out of which any 2 needed to be solved. 1 question related to Database design and query, 2 questions related to DSA, both DSA questions were medium-hard type based on Dynamic programming and graph.
I solved one Dynamic programming question and Database question.

Q1. 1. This round was the follow up of last case study round. Interviewer gave various use cases to test on the algorithms that I had written. Some discussion related to OOPS concepts and Database design quest...read more
Add your answer

Q1. It was final discussion, mostly around cultural fit and classic HR questions. It was easy one, I'd say.
Add your answer